chainstar live demo

Query the star schema chainstar builds from real Ethereum, Base, Bitcoin and Solana data, live in your browser with DuckDB. Transfers, fees, wallets and tokens; no install needed.

Query the star schema chainstar builds from real Ethereum, Base, Bitcoin and Solana data, live in your browser with DuckDB. Transfers, fees, wallets and tokens; no install needed.

Tables

• fct_transfers: 27,139 rows
• fct_fees: 18,545 rows
• dim_wallets: 22,240 rows
• dim_tokens: 795 rows
• dim_contracts: 608 rows
• dim_dates: 1 rows

How they were made

chainstar run --chain ethereum --blocks 26239900:26239920 --target duckdb:site.duckdb --chunk-size 10 --requests-per-second 5

$ chainstar run --chain ethereum --blocks 26239900:26239920 --target duckdb:site.duckdb --chunk-size 10 --requests-per-second 5
chainstar 0.1.0.dev0
chain    ethereum (chain id 1)
blocks   26239900:26239920 (20 blocks, end exclusive)
rpc      https://ethereum-rpc.publicnode.com
target   duckdb:site.duckdb

extract  erc20_transfers  9,577 rows                            1.3s
extract  blocks           20 rows                               1.3s
extract  transactions     4,923 rows                            1.1s
decode   erc20_metadata   353 tokens (0 new, 353 cached)        0.0s
load     chainstar_raw    4 tables, 14,873 rows                 0.2s
model    dbt build        22 models, 52 tests passed            5.5s

done in 9.5s

tables   duckdb:site.duckdb (schema chainstar, all chains)
  fct_transfers        9,577
  fct_fees             4,923
  dim_wallets         10,399
  dim_tokens             353
  dim_contracts          353
  dim_dates                1
parquet  data/ethereum

chainstar run --chain base --blocks 52892500:52892520 --target duckdb:site.duckdb --chunk-size 10 --requests-per-second 15

$ chainstar run --chain base --blocks 52892500:52892520 --target duckdb:site.duckdb --chunk-size 10 --requests-per-second 15
chainstar 0.1.0.dev0
chain    base (chain id 8453)
blocks   52892500:52892520 (20 blocks, end exclusive)
rpc      https://base-rpc.publicnode.com
target   duckdb:site.duckdb

extract  erc20_transfers  9,160 rows                            1.7s
extract  blocks           20 rows                               1.2s
extract  transactions     3,839 rows                            1.2s
decode   erc20_metadata   255 tokens (0 new, 255 cached)        0.0s
load     chainstar_raw    4 tables, 13,274 rows                 0.2s
model    dbt build        22 models, 52 tests passed            3.6s

done in 7.9s

tables   duckdb:site.duckdb (schema chainstar, all chains)
  fct_transfers       18,737
  fct_fees             8,762
  dim_wallets         17,997
  dim_tokens             608
  dim_contracts          608
  dim_dates                1
parquet  data/base

chainstar run --chain bitcoin --blocks 972460:972461 --target duckdb:site.duckdb --chunk-size 1 --requests-per-second 2

$ chainstar run --chain bitcoin --blocks 972460:972461 --target duckdb:site.duckdb --chunk-size 1 --requests-per-second 2
chainstar 0.1.0.dev0
chain    bitcoin (network main)
blocks   972460:972461 (1 blocks, end exclusive)
rpc      https://bitcoin-rpc.publicnode.com
target   duckdb:site.duckdb

extract  blocks           1 rows                                0.1s
extract  transactions     2,676 rows
extract  inputs           4,028 rows
extract  outputs          5,439 rows
load     chainstar_raw    4 tables, 12,144 rows                 0.2s
model    dbt build        22 models, 52 tests passed            3.9s

done in 4.1s

tables   duckdb:site.duckdb (schema chainstar, all chains)
  fct_transfers       24,176
  fct_fees            11,437
  dim_wallets         19,874
  dim_tokens             609
  dim_contracts          608
  dim_dates                1
parquet  data/bitcoin

chainstar run --chain solana --blocks 459564290:459564300 --target duckdb:site.duckdb --chunk-size 10 --requests-per-second 2

$ chainstar run --chain solana --blocks 459564290:459564300 --target duckdb:site.duckdb --chunk-size 10 --requests-per-second 2
chainstar 0.1.0.dev0
chain    solana (network 5eykt4UsFv8P8NJdTREpY1vzqKqZKvdpKuc147dw2N9d)
slots    459564290:459564300 (10 slots, end exclusive)
rpc      https://solana-rpc.publicnode.com
target   duckdb:site.duckdb

extract  blocks           7 rows                                0.1s
extract  transactions     7,108 rows
extract  transfers        3,561 rows
load     chainstar_raw    3 tables, 10,676 rows                 0.2s
model    dbt build        22 models, 52 tests passed            4.8s

done in 5.0s

tables   duckdb:site.duckdb (schema chainstar, all chains)
  fct_transfers       27,139
  fct_fees            18,545
  dim_wallets         22,240
  dim_tokens             795
  dim_contracts          608
  dim_dates                1
parquet  data/solana