shreexCumulative User Growth Of NFL All Day
Updated 2023-03-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
With wallets as (
select
distinct buyer as nfl_all_day_wallets,
min(block_timestamp) as min_date
from flow.core.ez_nft_sales where nft_collection='A.e4cf4bdc1751c65d.AllDay' and tx_succeeded='TRUE'
GROUP BY nfl_all_day_wallets
UNION
select
distinct seller as nfl_all_day_wallets,
min(block_timestamp) as min_date
from flow.core.ez_nft_sales where nft_collection='A.e4cf4bdc1751c65d.AllDay' and tx_succeeded='TRUE'
GROUP BY nfl_all_day_wallets
HAVING count(nfl_all_day_wallets) = 1
)
select
date_trunc('day',min_date) as date,
count(distinct nfl_all_day_wallets) as user_growth,
sum(user_growth) over (order by date) AS cumulative_user_growth
from wallets
GROUP BY date
ORDER BY date
Run a query to Download Data