Bit Primitive

Bit Primitive builds open-source tools that collect raw data, organise it into clean, tested tables in your own warehouse, and turn it into answers, and publishes open datasets.

Bit Primitive builds open-source tools that collect raw data, organise it into clean, tested tables in a warehouse you own, and turn it into answers. You run them yourself; nothing passes through us.

How it works

1. Collect (cryo · dlt · JSON-RPC): From blockchains, exchanges, news and public data sources, through their own APIs, gently and within their terms.
2. Organise (dbt · DuckDB · Postgres): Into documented tables with tested keys and joins, in a warehouse on your own machine or server.
3. Analyse (SQL · statistics): Query it in SQL, in your warehouse or right here in the browser, and with sigstar, explain moves, forecast them and alert on your own rules.
4. Publish (Parquet · CC BY): Open datasets with full schemas, sources, checksums and licences, free to download and preview.

Try chainstar live: query its real output in your browser.

Projects

• chainstar: Raw blockchain data to clean dimensional tables in your own warehouse, from one command.
• sigstar: Collect market, on-chain, news and macro data, and explain, forecast and alert on crypto price moves from every angle.
• Whittle: Describe a part in plain words and get a verified, printable file. Runs fully local and offline.

Public data

• Base ERC-20 transfers (100-block sample): Every ERC-20 Transfer event in 100 consecutive Base mainnet blocks, decoded, with each token's symbol, name and decimals joined in.
• Bitcoin transaction outputs (3-block sample): Every output of every transaction in 3 consecutive Bitcoin blocks: who received how much, the output's script type, and the sender when every input came from a single address. OP_RETURN and other outputs without an address are kept, with no address.
• ERC-20 token directory (Ethereum and Base): Every ERC-20 contract seen in the Ethereum and Base transfer samples, with the name, symbol and decimals it reports and how many transfers it had. Useful for decoding amounts.
• Ethereum ERC-20 transfers (200-block sample): Every ERC-20 Transfer event in 200 consecutive Ethereum mainnet blocks, decoded, with each token's symbol, name and decimals joined in. A sample of what chainstar produces from a single command.
• Ethereum transaction fees (200-block sample): The execution fee of every transaction in the same 200 Ethereum blocks: gas used, the price paid and the base fee, in wei and in ETH. Blob fees are not included.
• Solana DEX swaps (300-slot sample): Every swap in 300 consecutive Solana slots through Raydium, Orca Whirlpool, Meteora DLMM, Jupiter, Pump.fun or PumpSwap: what the signer gave and got, with a USD value from prices derived from the same on-chain swaps.
• Solana token and SOL transfers (20-slot sample): Every SPL, Token-2022 and native SOL transfer in the successful transactions of 20 consecutive Solana slots, inner instructions included, with each mint's standard and decimals.
• Solana token prices from on-chain swaps (300-slot sample): Hourly and daily USD prices for every Solana mint traded in the same 300 slots, derived only from on-chain swaps against USD stablecoins and SOL: outliers rejected, each price with its method, observations, volume and confidence. Low-confidence prices are left NULL, with the observed median kept.