lagandispenserTop 10 Protocol To Interact With USDT
Updated 2022-08-31Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
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_Interact
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 >= '2022-07-01'
and contract_address = '0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9' -- 'USDT'
and origin_to_address != '0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9'
group by 1 order by 2 desc limit 10
Run a query to Download Data