-- forked from NDuv / User - Daily New User + Cummlative User - NDuv311 @ https://flipsidecrypto.xyz/NDuv/q/GVpDp2YrMQB9/user---daily-new-user-cummlative-user---nduv311
with tb1 as (
select block_timestamp,
from_address user
from thorchain.core.fact_transfers
)
,tb2 as (
select
min(block_timestamp) min,
user
from tb1
group by 2
)
select date_trunc('day',min) daily,
count(distinct(user)) as "New User",
sum("New User")over(order by daily) as "Cumulative User"
from tb2
where min::date >= current_date - 30
group by 1