defianalystOverview DEX Stats
Updated 2024-09-13Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- forked from Alex_Dyan / Overview DEX Stats @ https://flipsidecrypto.xyz/Alex_Dyan/q/0VGecKS9ryq5/overview-dex-stats
with A as (
select
sum(abs(AMOUNT_IN_USD)) as total_dex_volume,
count(distinct TX_HASH) as total_dex_txn,
count (distinct ORIGIN_FROM_ADDRESS) as total_dex_users
from
polygon.defi.ez_dex_swaps
)
select
total_dex_volume,
total_dex_txn,
total_dex_users,
total_dex_volume / total_dex_txn as avg_volume_per_swap
from
A
QueryRunArchived: QueryRun has been archived