binhachonUntitled Query
    Updated 2022-01-19
    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