ramishoowwallets
Updated 2023-01-05
9
1
2
3
4
›
⌄
with ramishoow as ( select date_trunc('week', block_timestamp) as weekly, count(distinct tx_sender) as active_count, avg(active_count) over (order by weekly, weekly rows between 6 preceding and current row) as ma7_active_count,
(select count(distinct tx_sender) from terra.core.fact_transactions) as total_active_wallet from terra.core.fact_transactions group by 1 ), avg_info as ( select avg(active_count) as avg_active_count from ramishoow
--(select count(distinct tx_sender) from terra.core.fact_transactions) as total_active_wallet from terra.core.fact_transactions group by 1 ), avg_info as ( select avg(active_count) as avg_active_count from ramishoow
) select * from ramishoow, avg_info
Run a query to Download Data