Transfers

5 tables in this category.

Tables

View Name	Database	Source	ORDER BY
`agent.ethereum_transfers`	`agent`	`tokens_ethereum.transfers`	`contract_address, block_number, tx_hash, evt_index`
`agent.base_transfers`	`agent`	`tokens_base.transfers`	`contract_address, block_number, tx_hash, evt_index`
`agent.arbitrum_transfers`	`agent`	`tokens_arbitrum.transfers`	`contract_address, block_number, tx_hash, evt_index`
`agent.bsc_transfers`	`agent`	`tokens_bsc.transfers`	`—`
`agent.tron_transfers`	`agent`	`tokens_tron.transfers`	`contract_address, block_number, tx_hash, evt_index`

agent.arbitrum_prices_day
agent.base_prices_day
agent.ethereum_erc20
agent.ethereum_prices_day

Sample Queries

1. Largest USDC transfers today

SELECT block_time, `from`, `to`, amount, amount_usd
FROM agent.ethereum_transfers
WHERE symbol = 'USDC'
  AND block_date = today() - 1
ORDER BY amount_usd DESC
LIMIT 20

Table Schemas

`agent.ethereum_transfers`

ERC-20 Transfer events plus native token (ETH/BNB/TRX) trace-based transfers. Includes WETH wrap/unwrap. Enriched with tx_from, tx_to, tx_index from transaction lookup. One row per transfer event or trace. Engine: MergeTree | Partition: toYYYYMM(block_date) | ORDER BY: contract_address, block_number, tx_hash, evt_index

Column	Type	Description
`blockchain`	`String`	Blockchain network name
`block_month`	`Date`	UTC block month (partition key)
`block_date`	`Date`	UTC block date
`block_time`	`DateTime64(3)`	UTC block timestamp
`block_number`	`UInt64`	Block number
`tx_hash`	`String`	Transaction hash
`evt_index`	`UInt32`	Event log index in transaction
`trace_address`	`Array(Int64)`	Non-empty for native trace-based transfers. Empty string for event-based ERC-20 transfers.
`token_standard`	`String`	’erc20’ for ERC-20 Transfer events, ‘native’ for ETH/BNB/TRX trace transfers.
`tx_from`	`String`	Transaction sender (EOA that signed the tx). From transaction lookup.
`tx_to`	`String`	Transaction recipient (first-level contract called). From transaction lookup.
`tx_index`	`UInt32`	Transaction index in block
`from`	`String`	Transfer sender address.
`to`	`String`	Transfer recipient address.
`contract_address`	`String`	Token contract address. Zero address (0x0000…0000) for native token transfers.
`symbol`	`String`	Token symbol
`amount_raw`	`UInt256`	Raw uint256 transfer amount. Divide by 10^decimals for human-readable value.
`amount`	`Float64`	Amount in display units (decimal-adjusted)
`price_usd`	`Float64`	USD price at transfer time
`amount_usd`	`Nullable(Float64)`	USD value of transfer

These tables are VERY large (billions of rows) — always filter on block_date first
token_standard is ‘erc20’ or ‘native’ — filter accordingly
amount_raw is uint256 before decimal adjustment — divide by 10^decimals for human-readable amounts
JOIN with ethereum_erc20 on contract_address for symbol and decimals
For net flows: SUM(amount_raw) WHERE to=addr minus SUM(amount_raw) WHERE from=addr

No USD amounts — join with prices tables for valuation
Native transfers from trace data may include internal contract-to-contract transfers
Does not include ERC-721 (NFT) or ERC-1155 (multi-token) transfers
amount_raw is raw — you must know the token’s decimals to interpret correctly

`agent.base_transfers`

Column	Type	Description
`blockchain`	`String`	Blockchain network name
`block_month`	`Date`	UTC block month (partition key)
`block_date`	`Date`	UTC block date
`block_time`	`DateTime64(3)`	UTC block timestamp
`block_number`	`UInt64`	Block number
`tx_hash`	`String`	Transaction hash
`evt_index`	`UInt32`	Event log index in transaction
`trace_address`	`Array(Int64)`	Non-empty for native trace-based transfers. Empty string for event-based ERC-20 transfers.
`token_standard`	`String`	’erc20’ for ERC-20 Transfer events, ‘native’ for ETH/BNB/TRX trace transfers.
`tx_from`	`String`	Transaction sender (EOA that signed the tx). From transaction lookup.
`tx_to`	`String`	Transaction recipient (first-level contract called). From transaction lookup.
`tx_index`	`UInt32`	Transaction index in block
`from`	`String`	Transfer sender address.
`to`	`String`	Transfer recipient address.
`contract_address`	`String`	Token contract address. Zero address (0x0000…0000) for native token transfers.
`symbol`	`String`	Token symbol
`amount_raw`	`UInt256`	Raw uint256 transfer amount. Divide by 10^decimals for human-readable value.
`amount`	`Float64`	Amount in display units (decimal-adjusted)
`price_usd`	`Float64`	USD price at transfer time
`amount_usd`	`Nullable(Float64)`	USD value of transfer

This table has 7.5B+ rows — ALWAYS use tight block_date filters
token_standard is ‘erc20’ or ‘native’ — filter accordingly
amount_raw is uint256 before decimal adjustment — divide by 10^decimals
Base native token is ETH (bridged), same decimals as Ethereum ETH

No USD amounts — join with prices tables for valuation
Native transfers from trace data may include internal contract-to-contract transfers
Does not include ERC-721 (NFT) or ERC-1155 (multi-token) transfers
amount_raw is raw — you must know the token’s decimals to interpret correctly

`agent.arbitrum_transfers`

Column	Type	Description
`blockchain`	`String`	Blockchain network name
`block_month`	`Date`	UTC block month (partition key)
`block_date`	`Date`	UTC block date
`block_time`	`DateTime64(3)`	UTC block timestamp
`block_number`	`UInt64`	Block number
`tx_hash`	`String`	Transaction hash
`evt_index`	`UInt32`	Event log index in transaction
`trace_address`	`Array(Int64)`	Non-empty for native trace-based transfers. Empty string for event-based ERC-20 transfers.
`token_standard`	`String`	’erc20’ for ERC-20 Transfer events, ‘native’ for ETH/BNB/TRX trace transfers.
`tx_from`	`String`	Transaction sender (EOA that signed the tx). From transaction lookup.
`tx_to`	`String`	Transaction recipient (first-level contract called). From transaction lookup.
`tx_index`	`UInt32`	Transaction index in block
`from`	`String`	Transfer sender address.
`to`	`String`	Transfer recipient address.
`contract_address`	`String`	Token contract address. Zero address (0x0000…0000) for native token transfers.
`symbol`	`String`	Token symbol
`amount_raw`	`UInt256`	Raw uint256 transfer amount. Divide by 10^decimals for human-readable value.
`amount`	`Float64`	Amount in display units (decimal-adjusted)
`price_usd`	`Float64`	USD price at transfer time
`amount_usd`	`Nullable(Float64)`	USD value of transfer

These tables are VERY large (billions of rows) — always filter on block_date first
token_standard is ‘erc20’ or ‘native’ — filter accordingly
amount_raw is uint256 before decimal adjustment — divide by 10^decimals for human-readable amounts
JOIN with ethereum_erc20 on contract_address for symbol and decimals
For net flows: SUM(amount_raw) WHERE to=addr minus SUM(amount_raw) WHERE from=addr

No USD amounts — join with prices tables for valuation
Native transfers from trace data may include internal contract-to-contract transfers
Does not include ERC-721 (NFT) or ERC-1155 (multi-token) transfers
amount_raw is raw — you must know the token’s decimals to interpret correctly

`agent.bsc_transfers`

BSC transfer tables can be very large — always filter on block_date first
Native token is BNB, not ETH — 18 decimals
amount_raw is uint256 before decimal adjustment

No USD amounts — join with prices tables for valuation
Native transfers from trace data may include internal contract-to-contract transfers
Does not include ERC-721 (NFT) or ERC-1155 (multi-token) transfers
amount_raw is raw — you must know the token’s decimals to interpret correctly

`agent.tron_transfers`

Column	Type	Description
`blockchain`	`String`	Blockchain network name
`block_month`	`Date`	UTC block month (partition key)
`block_date`	`Date`	UTC block date
`block_time`	`DateTime64(3)`	UTC block timestamp
`block_number`	`UInt64`	Block number
`tx_hash`	`String`	Transaction hash
`evt_index`	`UInt32`	Event log index in transaction
`trace_address`	`Array(Int64)`	Non-empty for native trace-based transfers. Empty string for event-based ERC-20 transfers.
`token_standard`	`String`	’erc20’ for ERC-20 Transfer events, ‘native’ for ETH/BNB/TRX trace transfers.
`tx_from`	`String`	Transaction sender (EOA that signed the tx). From transaction lookup.
`tx_to`	`String`	Transaction recipient (first-level contract called). From transaction lookup.
`tx_index`	`UInt32`	Transaction index in block
`from`	`String`	Transfer sender address.
`to`	`String`	Transfer recipient address.
`contract_address`	`String`	Token contract address. Zero address (0x0000…0000) for native token transfers.
`symbol`	`String`	Token symbol
`amount_raw`	`UInt256`	Raw uint256 transfer amount. Divide by 10^decimals for human-readable value.
`amount`	`Float64`	Amount in display units (decimal-adjusted)
`price_usd`	`Nullable(Float64)`	USD price at transfer time
`amount_usd`	`Nullable(Float64)`	USD value of transfer

4.6B rows — ALWAYS filter on block_date
Tron addresses use base58 format (T…) not hex
Native token is TRX (6 decimals for energy, but TRX transfers use sun = 1e-6)
USDT on Tron is extremely high volume — can dominate results if not filtered

No USD amounts — join with prices tables for valuation
Native transfers from trace data may include internal contract-to-contract transfers
Does not include ERC-721 (NFT) or ERC-1155 (multi-token) transfers
amount_raw is raw — you must know the token’s decimals to interpret correctly

Overview

Categories

Tables

Sample Queries

1. Largest USDC transfers today

Table Schemas

`agent.ethereum_transfers`

`agent.base_transfers`

`agent.arbitrum_transfers`

`agent.bsc_transfers`

`agent.tron_transfers`

Overview

Categories

​Tables

​Related Tables

​Sample Queries

​1. Largest USDC transfers today

​Table Schemas

​agent.ethereum_transfers

​agent.base_transfers

​agent.arbitrum_transfers

​agent.bsc_transfers

​agent.tron_transfers

Tables

Related Tables

Sample Queries

1. Largest USDC transfers today

Table Schemas

`agent.ethereum_transfers`

`agent.base_transfers`

`agent.arbitrum_transfers`

`agent.bsc_transfers`

`agent.tron_transfers`