Eman-Raz$LAVA Swaps & Swappers Over Time
Updated 2024-08-14
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select date_trunc('{{Time_Frame}}',block_timestamp) as "Date",
count(distinct tx_hash) as "Swap Count",
count(distinct origin_from_address) as "Swapper Count",
sum(amount_in_usd) as "Swap Volume ($USD)"
from arbitrum.defi.ez_dex_swaps
where
(token_in=lower('0x11e969e9B3f89cB16D686a03Cd8508C9fC0361AF')
or token_out=lower('0x11e969e9B3f89cB16D686a03Cd8508C9fC0361AF'))
and block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'
group by 1
order by 1
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived