Sbhn_NPTop 10 Destinations of GOO Token (By TX Count)
    Updated 2022-11-03
    --credit : alik110
    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'
    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'
    and destination_label is not null
    group by 1,2
    order by 3 desc
    limit 10
    Run a query to Download Data