Eman-RazActive Traders Count Over time
Updated 2024-03-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
with tab3 as (with tab1 as (select date_trunc('{{Time_Frame}}',block_timestamp) as date, symbol_in as token, origin_from_address as trader
from base.defi.ez_dex_swaps
where
token_in='0x50c5725949a6f0c72e6c4a641f24049a917db0cb' or -- DAI
token_in='0x833589fcd6edb6e08f4c7c32d4f71b54bda02913' or --USDC **
token_in='0x4a3a6dd60a34bb2aba60d73b4c88315e9ceb6a3d' or -- MIM
token_in='0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca' or -- USDbc
token_in='0xeb466342c4d449bc9f53a865d5cb90586f405215'), -- axlUSDC
tab2 as (select date_trunc('{{Time_Frame}}',block_timestamp) as date, symbol_out as token, origin_from_address as trader
from base.defi.ez_dex_swaps
where token_out='0x50c5725949a6f0c72e6c4a641f24049a917db0cb' or -- DAI
token_out='0x833589fcd6edb6e08f4c7c32d4f71b54bda02913' or --USDC **
token_out='0x4a3a6dd60a34bb2aba60d73b4c88315e9ceb6a3d' or -- MIM
token_out='0xd9aaec86b65d86f6a7b5b1b0c42ffa531710b6ca' or -- USDbc
token_out='0xeb466342c4d449bc9f53a865d5cb90586f405215') -- axlUSDC
select * from tab1 union all
select * from tab2)
select date as "Date", count(distinct trader) as "Trader Count", token as "Stablecoin"
from tab3
group by 1,3
order by 1
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived