superflyUntitled Query
Updated 2022-08-11Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
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