binhachonUntitled Query
Updated 2022-01-23
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select contract_address, sum(amount) from ethereum.udm_events
where contract_address in ('0x6a091a3406e0073c3cd6340122143009adac0eda', '0x397ff1542f962076d0bfe58ea045ffa2d347aca0', '0x055475920a8c93cffb64d039a8205f7acc7722d3')
and to_address = '0xc2edad668740f1aa35e4d8f227fb8e17dca888cd'
and from_address = '0x0000000000000000000000000000000000000000'
group by contract_address
union all
select contract_address, -sum(amount) from ethereum.udm_events
where contract_address in ('0x6a091a3406e0073c3cd6340122143009adac0eda', '0x397ff1542f962076d0bfe58ea045ffa2d347aca0', '0x055475920a8c93cffb64d039a8205f7acc7722d3')
and from_address = '0xc2edad668740f1aa35e4d8f227fb8e17dca888cd'
and to_address = '0x0000000000000000000000000000000000000000'
group by contract_address
Run a query to Download Data