ramishoowUntitled Query
Updated 2022-11-16
9
1
2
3
4
›
⌄
SELECT "TIME", count(DISTINCT TRADER) as "Swappers " FROM ( SELECT date_trunc('week', day) as "TIME",
TRADER, count(*) as actvie_days FROM ( SELECT date_trunc('day', block_timestamp) as day, TRADER
--TRADER, count(*) as actvie_days FROM ( SELECT date_trunc('day', block_timestamp) as day, TRADER
fROM osmosis.core.fact_swaps GROUP BY 1,2 )GROUP BY 1,2 ) WHERE actvie_days >= 4 GROUP BY 1
Run a query to Download Data