roketo2
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
--credit : https://app.flipsidecrypto.com/velocity/queries/b8d37b49-806c-4cc4-b374-f88fb20bd1c8
with maintable as (
select date_trunc (day,mindate) as date,
count (distinct tx_from) as New_Users,
sum (new_users) over (order by date) as Total_Users
from (
select tx_from,
min (block_timestamp) as mindate
from osmosis.core.fact_transactions
group by 1)
group by 1)
select avg (new_users) as Average_Daily_New_Users
from maintable
Run a query to Download Data