binhachonUntitled Query
Updated 2022-01-19
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
coalesce(origin_label_type, 'Others') as from_type,
coalesce(to_label_type, 'Others') as to_type,
sum(amount) as amount
from ethereum.udm_events
where contract_address = '0x6b175474e89094c44da98b954eedeac495271d0f'
and from_address != '0x0000000000000000000000000000000000000000'
and to_address != '0x0000000000000000000000000000000000000000'
and block_timestamp > getdate() - interval'30 days'
group by from_type, to_type
order by amount desc
limit 1000
Run a query to Download Data