Eman-RazSwap Volume Over Time
Updated 2024-08-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with tab1 as (select date_trunc('{{Time_Frame}}',block_timestamp) as "Date", amount_in_usd as amount_usd, amount_in as amount
from arbitrum.defi.ez_dex_swaps
where token_in=lower('0x11e969e9B3f89cB16D686a03Cd8508C9fC0361AF')
and block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'
union
select date_trunc('{{Time_Frame}}',block_timestamp) as "Date", amount_out_usd as amount_usd, amount_out as amount
from arbitrum.defi.ez_dex_swaps
where token_out=lower('0x11e969e9B3f89cB16D686a03Cd8508C9fC0361AF')
and block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}')
select "Date", sum(amount) as "Swap Volume ($LAVA)", sum(amount_USD) as "Swap Volume ($USD)"
FROM TAB1
group by 1
QueryRunArchived: QueryRun has been archived