Open source · Apache-2.0 · Self-hosted

Traceeverynumber.

BlockJuice loads balances, transfers, trades and prices for the wallets and tokens you list into your own Postgres. You can trace any number it gives you back to raw rows, and rebuild it.

For analysts who advise funds, treasuries and protocol teams.

The demo needs only uv and Docker. No keys, no Claude.

LatestHow RN1's Bot Works, Read From 911,860 FillsRead →
01 / Why

Own the query.

If you advise funds, treasuries or protocol teams, you know where on-chain work gets awkward. Explorers are fine for a quick look. Shared analytics platforms work until you need to own the query, the join or how long the data is kept.

  1. 01

    You keep the data

    Raw rows, marts, run logs and answers live in a warehouse and repo you run. When an auditor or a client asks how a number was built, you can show them the model and the run that produced it.

  2. 02

    You can ask in plain language

    The repo’s Claude Code skill (/bj <question>) maps the question onto marts, the finished tables you query, and builds any that are missing. It runs the analysis through bj, the BlockJuice command line, and writes answers/<slug>/ with the value, the checks and the method. From there it can make a PDF, a spreadsheet or a Google Doc.

  3. 03

    Adding coverage doesn’t mean building a platform

    To follow another wallet list, EVM chain or protocol, copy a source with bj new-source, add it to dbt and turn on a schedule. The shared library resumes where each run stopped and keeps failed calls to retry, so you spend your time on the question.

  4. 04

    When something breaks, you can see it

    bj doctor checks your settings and services before you debug. Grafana shows loading and dbt runs side by side. Failed calls are kept and retried, not dropped.

02 / One answer

Back to the rows.

3529

How many Uniswap v3 swaps traded UNI on Ethereum on 2026-10-15, and what was their volume in UNI?

UNI
The Uniswap token on Ethereum, 0x1f9840a85d5af5bf1d1762f925bdaddc4201f984.
swap
One Swap event of a Uniswap v3 pool whose token0 or token1 is UNI, as a row of dex_trades with version v3.
volume
The sum of each swap’s absolute UNI amount, bought or sold, in UNI. Not USD.

A real answer this repo produced: answers/uni-v3-uni-swaps-2026-10-15/

  1. Answer3529 swaps · 812,886.52 UNI · 21 pools
  2. Martanalytics.dex_trades
  3. Sourceevm-uniswap-v3
  4. RowsEthereum blocks 26194189 to 26201364, the first and last blocks of 2026-10-15 UTC.
A longer read · Reconstruction

How RN1's Bot Works, Read From 911,860 Fills

RN1’s 911,860 fills, and samples of the orders it signed, rebuild the program behind them. Three decisions are measured on chain and fifteen are judged from the evidence; the signed orders for the full window would settle more of them than any other input still to be had.

03 / Modules

12 modules. 22 tables.

Each module is a set of mart tables in the analytics schema, built by one pipeline. A source reads only the wallets, tokens, feeds and contracts you list in its addresses.json. Pick a module to see its columns.

M-01 · balances pipeline

Balances

Each wallet’s latest balance of each asset, in base units: wei, lamports, satoshis or token units.

Tables
  • analytics.latest_balances
Sources
  • evm-eth-balances
  • evm-erc20-balances
  • solana-sol-balances
  • solana-spl-balances
  • bitcoin-btc-balances
Chains
Ethereum, Solana, Bitcoin
chain
text
ethereum, solana or bitcoin.
wallet
text
The address whose balance was read.
asset_type
text
native, erc20 or spl.
asset
text
eth, sol or btc, or the token or mint address.
block_number
bigint
The block, or Solana slot, the balance was read at.
balance
numeric
The amount in the asset’s base units.
04 / Coverage

What it reads.

Each table covers the wallets, tokens and contracts you list, not the whole chain. Polymarket covers every market by default. A lit glyph means the module covers that chain. Hover or tap a column.

Balances
Transfers
DEX trades
Bridges
Labels
Tokens
Exchange prices
Oracle prices
Polymarket
Accounts
Deployments
CoW ETH Flow
22
Tables in analytics.* · hover a chain
  • Ethereum13 tables
  • Arbitrum08 tables
  • Base08 tables
  • Polygon05 tables
  • Solana01 tables
  • Bitcoin01 tables
  • Binance, Coinbase01 tables
05 / Get started

Get started.

Try it first

Builds the real balance models from made-up rows in a throwaway Postgres, answers a saved question, checks the answer and writes an XLSX. Needs uv and Docker. No keys, no Node, no Claude.

git clone https://github.com/iankressin/block-juice
cd block-juice

Run every command on this page from the block-juice folder.

uv run --project orchestration bj demo

Run your own

Needs Node 24, pnpm 10.17 (mise install sets both), uv, and Docker with Compose. About 5 GB free: 1 GB for the checkout, 3.3 GB for the images. Start from the clone above.

  1. Set up the checkout.

    uv run --project orchestration bj install

    Copies each missing .env, installs the Node packages and runs dbt parse. Never overwrites an .env, starts nothing. No value in .env is required.

  2. Start the stack and Dagster. Leave it running.

    uv run --project orchestration bj dev

    Starts the Docker stack, runs bj doctor, then Dagster at http://localhost:3000.

  3. In a second terminal, load your first mart.

    uv run --project orchestration bj run tokens

    Loads the names, symbols and decimals of the tokens the default lists name. Schedules start stopped, so nothing loads until you run a pipeline or turn its schedule on.

These ports must be free: 3000, 3001, 4000, 4001, 5432, 8082, 8545, 9090, 9091. To move one, set its *_PORT in .env. Dagster stays on 3000.

/bj needs Claude Code. Start it with claude in the repo, with the stack running. Google Doc reports also need Google credentials in .env.

Apache-2.0 · In active development · Questions and bugs: GitHub issues

06 / Transparent by design

See through it.

BlockJuice runs in your environment. It loads chain data into your Postgres, transforms it with dbt and schedules the work with Dagster. Balances, transfers, trades and labels sit next to the rest of your data, under keys and policies you set.

The result is a pipeline an analyst can read, change and hand to a client. Every step is in the repo for anyone to check.

Layer 01 · Extract + load · TypeScript sources · ingestion/

raw.*

Read chains, APIs and SQD Portal; write raw JSON rows into raw.<chain>_<table>, such as raw.ethereum_uniswap_v3.

23sources
  • evm-eth-balances
  • evm-erc20-balances
  • solana-sol-balances
  • solana-spl-balances
  • bitcoin-btc-balances
  • evm-erc20-transfers
  • evm-uniswap-v2
  • evm-uniswap-v3
  • evm-uniswap-v4
  • arbitrum-token-bridge
  • evm-op-standard-bridge
  • evm-address-code
  • evm-erc20-metadata
  • binance-candles
  • coinbase-candles
  • evm-chainlink-price-feeds
  • polymarket-markets
  • polygon-polymarket-ctf
  • polygon-polymarket-ctf-exchange-v2
  • evm-wallet-transactions
  • evm-account-state
  • evm-contract-deployments
  • evm-cow-ethflow
  1. 01 / 05Extract + loadTypeScript sourcesingestion/

    Read chains, APIs and SQD Portal; write raw JSON rows into raw.<chain>_<table>, such as raw.ethereum_uniswap_v3.

  2. 02 / 05StorePostgresinfra/postgres/

    Your warehouse. Raw rows, marts and the ops.* run log.

  3. 03 / 05Transformdbttransformation/

    Staging views, then mart tables in the analytics schema.

  4. 04 / 05OrchestrateDagsterorchestration/

    One job per pipeline. Turn on its schedule and it rebuilds each day at 06:00 UTC.

  5. 05 / 05WatchPrometheus + Grafanainfra/

    Ingestion and dbt side by side.

07 / Terminal

Try the commands.

A scripted shell, built from the README and one real answer. Nothing runs here. Type a bj command, or tap one below.

bj · ~/block-juiceScripted