Ali3NDaily USDC & USDT Swaps Activity
Updated 2023-02-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select block_timestamp::Date as date,
case when date = '2022-12-09' then 'Coinbase Advise to Switch USDT to USDC'
when date in ('2022-12-12','2022-12-13') then 'Binance News'
else 'Other Days' end as timespan,
case when token_in in ('0xdac17f958d2ee523a2206206994597c13d831ec7') then 'Swap From USDT'
when token_in in ('0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48') then 'Swap From USDC'
when token_out in ('0xdac17f958d2ee523a2206206994597c13d831ec7') then 'Swap To USDT'
when token_out in ('0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48') then 'Swap To USDC'
else null end as swap_type,
count (distinct tx_hash) as TX_Count,
count (distinct origin_from_address) as Users_Count,
sum (amount_in_usd) as Volume,
avg (amount_in_usd) as Average_Volume
from ethereum.core.ez_dex_swaps
where (token_in in ('0xdac17f958d2ee523a2206206994597c13d831ec7','0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48')
or token_out in ('0xdac17f958d2ee523a2206206994597c13d831ec7','0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'))
and block_Timestamp >= CURRENT_DATE - 14
and swap_type is not null
group by 1,2,3
Run a query to Download Data