SWAP | SWAPPERS | VOLUME | AVG_VOLUME | POOL_COUNT | |
|---|---|---|---|---|---|
1 | 10359429 | 783525 | 1644929249.26 | 115.005271192 | 506 |
fidamAggegate
Updated 2024-10-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
With Settle as (
Select Block_timestamp, Tx_hash,
Origin_From_Address,Amount_In_USD,symbol_In,Symbol_Out,POOL_NAME,
From optimism.defi.ez_dex_swaps
Where platform ='velodrome'
)
Select
Count(DISTINCT Tx_hash) as Swap,
Count(Distinct Origin_From_Address) as Swappers,
Sum(Amount_In_USD) as Volume,
Avg(Amount_In_USD) as Avg_volume,
Count(DISTINCT POOL_NAME) as pool_count,
From Settle
Last run: about 2 months ago
1
51B
7s