Eman-RazSwap over time
Updated 2024-10-26
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 swapper) as "Swapper Count", sum(amount_in_usd) as "Swap Volume",
avg(amount_in_usd) as "Avg Swap Volume", median(amount_in_usd) as "Median Swap Volume",
round(sum(amount_in_usd)/count(distinct swapper)) as "Volume per Swapper",
round(count(distinct tx_hash)/count(distinct swapper)) as "Swap per Swapper",
count(distinct token_in) as "Token_in Count", count(distinct token_out) as "Token_out Count"
from aptos.defi.ez_dex_swaps
where platform='liquidswap'
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