ramishoowUntitled Query
Updated 2022-10-19
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with ramishoow as (select count(*), tx_from from (select count(distinct block_timestamp::date), date_trunc('week', block_timestamp) , tx_from
from osmosis.core.fact_transactions group by 2,3 having count(distinct block_timestamp::date) > 4) group by 2 )
, Daily_Active_User_transfer_to as (select count(*) as tocount , block_timestamp::date as todate, sum(tocount) over (order by todate) as cum_tocount from osmosis.core.fact_transfers
where RECEIVER in (select tx_from from ramishoow) group by todate) , Daily_Active_User_transfer_to_top5 as (select count(*) as tocount , RECEIVER from osmosis.core.fact_transfers
where RECEIVER in (select tx_from from ramishoow) group by RECEIVER order by tocount desc limit 10)
, Daily_active_user_transfer_to_top5tokens as (select DISTINCT project_name,count(*) as tocount from osmosis.core.fact_transfers join osmosis.core.dim_labels on currency=address
where receiver in (select tx_from from ramishoow) group by project_name order by tocount DESC limit 10)
, Daily_Active_User_transfer_from as (select count(*) as fcount , block_timestamp::date as fdate, sum(fcount) over (order by fdate) as cum_fcount from osmosis.core.fact_transfers
where sender in (select tx_from from ramishoow) group by fdate) , Daily_Active_User_transfer_from_top5 as (select count(*) as tocount , sender from osmosis.core.fact_transfers
where sender in (select tx_from from ramishoow) group by sender order by tocount desc limit 10) select * from Daily_active_user_transfer_to_top5tokens
Run a query to Download Data