Base Transfers

One Parquet table with 24 columns: every native ETH and token transfer on Base, one row each, with the amount, the token's details, the transaction it settled in and the fee. ETH moved by contracts in internal calls is included, and so are NFTs.

About 17.8 billion rows over 40 months, roughly 690 GB as Parquet, estimated from the sample files. The last 24 months hold about 15.4 billion rows and the last 12 months about 7.7 billion. Row counts come from the live table; exact figures arrive with the delivery manifest. Base history is short, so the 24-month window holds about 87% of all rows.

To the start of indexed history: from 15 June 2023, at block 4,877, the first block with a transfer. The Full window runs from there to yesterday.

The export applies no filter of its own: spam tokens, lookalike tokens, zero-value rows and failed transactions all stay in, and the columns let you drop them. Value credited outside a transaction or a contract call has no row, the genesis state for one, so check native ETH balances rebuilt from these rows against the chain. Token balances hold, rebasing tokens aside.

Base has no price history of its own, so ETH, WETH, USDC, the bridged USDbC, USDT and DAI are valued on Ethereum's series: bridged ETH is ETH, and using the real series keeps a de-peg visible. Other tokens carry 0. In a recent six-hour window that priced about 56% of rows. The free sample shows 12%, because 76% of its rows come from one spam campaign spread over two token contracts and it leaves native ETH unpriced; delivered files price native ETH. A value of 0 means either a $0 transfer or no price; the column cannot tell them apart.

Decoded from Base by our own indexer, which reads token transfer events and traces internal calls for ETH. Before release we read the sample back: 97,954 rows over blocks 41,339,000 to 41,339,049, every amount carrying exactly its token's decimals. The live table now returns 97,944 rows for those blocks, after 10 were deleted from it.

The amount column is decimal adjusted. Multiply it by 10 to the power of the token's decimals for the raw on-chain integer. We ship the adjusted value because decimals differ per token and the raw figure is wrong without them.

Amounts are decimal strings, so casting to float loses precision on large values. Symbols and names repeat, and lookalike tokens copy them, so join on the contract address. Failed transactions are kept; filter TransactionStatus_Success for settled flow. Zero-value rows, 0.4% of the sample, move nothing, so drop them before counting activity. Transaction_Type 126 marks deposits bridged in from Ethereum.

Filter Transfer_Currency_SmartContract to the token's contract, lower case with 0x. For native ETH alone, filter Transfer_Currency_Native to true; its contract column holds the string 0x.

One line in DuckDB: SELECT * FROM read_parquet('transfers/*.parquet') LIMIT 10. Pandas works too: pandas.read_parquet(path). The sample file opens without credentials.

Refreshed daily with T+1 latency, so a purchase made today includes everything to yesterday. Delivered as Parquet named by block range, 50 blocks per file and sorted ascending, under a stable layout with a JSON manifest listing every file and its sha256. We prepare the files within 7 business days of purchase and email you the location. You choose at checkout where to collect them: a Requester Pays S3 bucket, downloaded with your own AWS account, or a Cloudflare R2 bucket with a read-only API key and no egress fees. Files stay available for 7 days from delivery. Enterprise orders can be delivered into your own S3, GCS or R2 bucket.