BlockBT rewrites dbt-core for blockchain-native ELT. Live RPC ingestion, cross-chain SQL transforms, and verifiable analytics—no warehouses needed.
-- models/cross_chain_market_share.sql
SELECT
chain,
sum(gas_used * gas_price / 1e18 * eth_usd_price)
AS total_volume_usd
FROM (
SELECT 'ethereum' AS chain, gas_used, gas_price, eth_usd_price
FROM {{ source('ethereum', 'swaps') }}
UNION ALL
SELECT 'solana' AS chain, gas_used, gas_price, sol_usd_price
FROM {{ source('solana', 'swaps') }}
)
GROUP BY chain;Built for blockchain-native analytics
Fetch live data from 100+ chains using lightweight adapters. Works with any RPC or Subgraph endpoint.
Unified model for swaps, transfers, liquidity — write one query, run across all chains.
BlockBT's Block-Hash Log detects and reverses reorg effects automatically.
Powered by Polars + DuckDB — vectorized SQL at 10× typical ETL speed.
Compare Ethereum fees, Solana swaps, and Base gas costs — in a single query.
Real-world use cases for Web3 analytics
Track fees, TVL, and swap volumes across chains without mirrors.
Generate transparent, on-chain accounting dashboards.
Build proof-of-reserve or compliance reports from live data.
Stream live on-chain signals for high-frequency trading.
Build Dune-style dashboards that refresh every minute — no warehouse.
From SQL to insights in seconds
Define transformations using familiar dbt syntax with {{ source() }} and {{ ref() }} macros.
BlockBT fetches data directly from RPC endpoints. Ethereum via Infura, Solana via public RPC, and more.
Automatically resolves dependencies and executes models in the correct order. Parallel execution coming soon.
DuckDB executes your SQL queries on in-memory DataFrames. Fast analytical queries with cross-chain joins.
Get results as JSON with embedded metadata. Optional proof generation and push to Dune Analytics.
Real-world analytics for Web3
Compare Ethereum vs Solana volume and transaction market share
bbt run --select cross_chain_market_share --target eth_sol
Track transaction fees across chains with 7-day rolling averages
bbt run --select cross_chain_7d_trends --target eth_sol
Monitor last 30 minutes of blockchain activity per minute
bbt run --select cross_chain_recent_30min --target eth_sol
Process only new blocks with hash-based state tracking
bbt run --select eth_incremental_fees --target eth
git clone https://github.com/yourusername/blockbt.git
cd blockbt
pip install -e .# Windows CMD
set INFURA_KEY=your_infura_key
set SOLANA_API_KEY=your_solana_key
# Or use public RPCs (no key needed for Solana)bbt run --select cross_chain_market_share --target eth_sol --proveBuilt for performance and reliability
Click-based command interface. Parse arguments, validate inputs, orchestrate execution.
YAML-based configuration. Source definitions, project settings, variable substitution.
Modular RPC adapters. Ethereum (web3.py), Solana (JSON-RPC), Polymarket (REST). Hash-based state tracking.
DAG resolution (NetworkX), macro resolution, DuckDB SQL execution. Cross-chain joins.
Mock proofs (MVP). Real ZK proofs coming in Beta (SP1/RISC0).
JSON core format. Optional pushes to Dune Analytics, Snowflake, IPFS, or on-chain contracts.