LittlerDatala liga new buyers
Updated 2022-12-07
999
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with allday_buyers as (
select
min(block_timestamp) as arrival
,buyer
from flow.core.ez_nft_sales
where nft_collection = 'A.e4cf4bdc1751c65d.AllDay'
group by 2
),
allday as (
select
'All Day' as nft_collection
,date_trunc('day',arrival) as date_arrival
,count(buyer) as buyers
,sum(buyers) over (order by date_arrival) as cum_buyers
,row_number () over (order by date_arrival) as rn
from allday_buyers
group by 1, 2
order by 2 asc
limit 9
),
topshot_buyers as (
select
min(block_timestamp) as arrival
,buyer
from flow.core.ez_nft_sales
where nft_collection = 'A.0b2a3299cc857e29.TopShot'
group by 2
),
topshot as (
select
'TopShot' as nft_collection
,date_trunc('day',arrival) as date_arrival
,count(buyer) as buyers