MufasaTop Most Popular tokens to swap to by DAU's
Updated 2022-10-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with activity as(
select count(distinct trunc(block_timestamp, 'day')) as date, tx_from as no_of_users,
case when date >= 30 then 'Active'
when date >= 15 and date < 30 then 'Casual'
when date < 15 then 'Not active'
end as category
from osmosis.core.fact_transactions
where to_date(block_timestamp) > CURRENT_DATE - 60
and TX_STATUS = 'SUCCEEDED'
group by no_of_users
order by date desc
),
dau as (select no_of_users, date
from activity
where category = 'Active')
-- liquidity as (
-- SELECT trunc(BLOCK_TIMESTAMP, 'day') as date,
-- count(DISTINCT TX_ID) as transactions_lp
-- from osmosis.core.fact_liquidity_provider_actions
-- where ACTION = 'pool_joined'
-- and TX_STATUS = 'SUCCEEDED'
-- and LIQUIDITY_PROVIDER_ADDRESS in (SELECT no_of_users from dau)
-- and to_date(block_timestamp) > CURRENT_DATE - 60
-- group by date
-- order by transactions_lp desc),
-- swapping_activity as(
-- select trunc(BLOCK_TIMESTAMP, 'day') as date, count(distinct TX_ID) as transactions_swappers
-- from osmosis.core.fact_swaps
-- where TX_STATUS = 'SUCCEEDED'
-- and TRADER in (SELECT no_of_users from dau)
-- and to_date(block_timestamp) > CURRENT_DATE - 60
-- group by date
-- order by transactions_swappers desc
-- ),
-- voting_activity as (
-- select trunc(BLOCK_TIMESTAMP, 'day') as date, count(distinct TX_ID) as transactions_votes
Run a query to Download Data