fidamMonthly trend
Updated 2024-10-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
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 Date_trunc('month',Block_timestamp) as date,
Count(DISTINCT Tx_hash) as Swap,
Count(Distinct Origin_From_Address) as Swappers,
Sum(Amount_In_USD) as Volume,
--SUM(Amount_In_USD) OVER (ORDER BY DATE_TRUNC('month', Block_timestamp)) AS Cummulated_Volume,
Avg(Amount_In_USD) as Avg_volume,
Count(DISTINCT POOL_NAME) as pool_count
From Settle
Group by Date_trunc('Month', Block_timestamp)
Order by date DESC
Limit 40
QueryRunArchived: QueryRun has been archived