Eman-RazAXL Swap Over Time
Updated 2024-12-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with swap_data as (select block_timestamp, tx_hash as swap, amount_in as swap_amount_axl, amount_in_usd as swap_amount_usd,
origin_from_address as swapper
from ethereum.defi.ez_dex_swaps
where token_in='0x467719ad09025fcc6cf6f8311755809d45a5e5f3'
union all
select block_timestamp, tx_hash as swap, amount_out as swap_amount_axl, amount_out_usd as swap_amount_usd,
origin_from_address as swapper
from ethereum.defi.ez_dex_swaps
where token_out='0x467719ad09025fcc6cf6f8311755809d45a5e5f3')
select date_trunc('{{Time_Frame}}',block_timestamp) as "Date", count(distinct swap) as "Swap Count",
sum(swap_amount_axl) as "Swap Volume ($AXL)", sum(swap_amount_USD) as "Swap Volume ($USD)",
sum("Swap Count") over (order by "Date" asc) as "Total Swap Count", count(distinct swapper) as "Swapper Count"
from swap_data
where 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