HadisehHop In the Pool 6
Updated 2022-11-28Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
PROJECT_NAME,
count (distinct trader) as total_swapper,
count (distinct tx_id) as total_swap
from osmosis.core.fact_swaps inner join osmosis.core.dim_labels
on from_currency=address
where tx_status = 'SUCCEEDED'
and TO_CURRENCY like '%pool%' or TO_CURRENCY is null
and from_decimal is not null
and PROJECT_NAME != 'MEME'
and block_timestamp::date >= CURRENT_DATE - 90
group by 1
order by 2 desc
limit 15
Run a query to Download Data