shreexDimension X 3
Updated 2023-03-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with users as (
select
distinct txs.tx_id as txs,
proposer,
txs.block_timestamp::date as min_date
from flow.core.fact_transactions txs left join flow.core.fact_events et on et.tx_id=txs.tx_id
where event_contract='A.e3ad6030cbaff1c2.DimensionX'
)
select
date_trunc('month',min_date) as date ,
count(distinct proposer) as users,
sum(users) over (order by date) as user_growth
from users
GROUP BY date