superflyUntitled Query
    Updated 2022-08-11
    select
    case
    when origin_to_address = '0x1111111254fb6c44bac0bed2854e76f90643097d' then '1inch'
    when origin_to_address = '0x7f90122bf0700f9e7e1f688fe926940e8839f353' then 'Curve USDC/USDT'
    when origin_to_address = '0x3b6067d4caa8a14c63fdbe6318f27a0bbc9f9237' then 'DODO Router'
    when origin_to_address = '0x88cbf433471a0cd8240d2a12354362988b4593e5' then 'DODO Proxy 2'
    when origin_to_address = '0xc30141b657f4216252dc59af2e7cdb9d8792e1b0' then 'Socket Registry'
    when address_name is null then origin_to_address
    else address_name
    end as label,
    count(distinct origin_from_address) as total
    from
    arbitrum.core.fact_token_transfers a left join arbitrum.core.dim_labels b on a.origin_to_address = b.address
    where
    block_timestamp::date >= CURRENT_DATE - 30
    and
    contract_address = '0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9'
    and
    origin_to_address != '0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9'
    group by 1 order by 2 desc limit 10
    Run a query to Download Data