Tokens

token.transfers is the first canonical dataset: normalized ERC-20 Transfer events with scaled amounts and lineage back to arc.logs.

What is included

Every well-formed Transfer log on Arc. amount_raw is always present. amount is present when decimals are known. Unknown decimals stay null — we do not assume 18.

What is not included

Native value transfers live on arc.transactions.value. NFT transfers are out of scope for this table. Mint and burn are still Transfer rows; activity labels arrive with the semantic layer.

SELECT token_address, count() AS transfers
FROM token.transfers
WHERE block_number > 2900000
GROUP BY token_address
ORDER BY transfers DESC
LIMIT 20;