fidamsilly-salmon
Updated 2024-10-20
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
With Synthetix 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 ='synthetix'
)
Select Origin_From_Address as Swappers,
Count(DISTINCT Tx_Hash) as Swap_Count
From Synthetix
Group by Origin_From_Address
Order By Swap_Count DESC
LIMIT 20;
QueryRunArchived: QueryRun has been archived