MahrooUntitled Query
    Updated 2022-11-02
    select origin_to_address,
    case when origin_to_address = '0x600000000a36f3cd48407e35eb7c5c910dc1f7a8' then 'GOO Token'
    when origin_to_address = '0x60bb1e2aa1c9acafb4d34f71585d7e959f387769' then 'Art Gobblers: GOBBLER Token'
    when origin_to_address = '0xb9aa14b6774dbc9f84b15e7ff659c0dba0d9ddf5' then 'uniswap'
    when origin_to_address = '0x6af1a16fde7346e7729fa921ad2ddf6a462061e2' then 'MEV Bot 1'
    when origin_to_address = '0xe8c060f8052e07423f71d445277c61ac5138a2e5' then 'MEV Bot 2'
    when origin_to_address = '0x9008d19f58aabd9ed0d60971565aa8510560ab41' then 'Cow Protocol'
    when origin_to_address = '0x617dee16b86534a5d792a4d7a62fb491b544111e' then 'MetaAggregationRouter'
    else label end as destination_label,
    count (distinct tx_hash) as TX_Count,
    count (distinct origin_from_address) as Users_Count
    from ethereum.core.fact_event_logs t1 left outer join ethereum.core.dim_labels t2 on t1.origin_to_address = t2.address
    where contract_address = '0x600000000a36f3cd48407e35eb7c5c910dc1f7a8'
    group by 1,2
    order by 4 desc
    limit 10
    Run a query to Download Data