AVG_SWAP_VOLUME_USD | MEDIAN_SWAP_VOLUME_USD | MAX_SWAP_VOLUME_USD | |
|---|---|---|---|
1 | 15656.945066255 | 36.92 | 256505124.75 |
Pine AnalyticsSwap Distributions 2
Updated 2025-04-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with tab1 as (
select
origin_from_address,
sum(case when TOKEN_IN ILIKE '0x940181a94A35A4569E4529A3CDfB74e38FD98631' then Amount_in_USD else
Amount_out_USD end) as Swap_Volume_USD
from base.defi.ez_dex_swaps
where (TOKEN_IN ILIKE '0x940181a94A35A4569E4529A3CDfB74e38FD98631' OR
TOKEN_OUT ILIKE '0x940181a94A35A4569E4529A3CDfB74e38FD98631')
group by 1
order by 2 desc
)
select
avg(Swap_Volume_USD) as Avg_Swap_volume_usd,
median(Swap_Volume_USD) as Median_swap_volume_usd,
max(Swap_Volume_USD) as Max_swap_volume_usd
from tab1
Last run: 15 days ago
1
38B
41s