freemartianSwap Count
Updated 2022-11-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
block_timestamp::date as day,
from_currency,
to_currency,
project_name,
count(distinct tx_id) as swap_count
from osmosis.core.fact_swaps s inner join osmosis.core.dim_labels l on l.address = s.to_currency or l.address = s.from_currency
where block_timestamp > CURRENT_DATE - 60
and tx_status = 'SUCCEEDED'
group by 1, 2, 3, 4
having swap_count > 50
Run a query to Download Data