Skip to content
Dune Analytics

@hagaetc / Sample query ERC20 transfers

SQL query

1SELECT topic2 AS sender, topic3 AS receiver, bytea2numeric(data)/1e18 AS value
2FROM ethereum.logs
3WHERE topic1='\xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef' -- Transfer
4AND contract_address = '\x0d8775f648430679a709e98d2b0cb6250d2887ef' -- BAT
5LIMIT 10

SQL query results

Loading