SocioCrypto2023-05-01 03:13 PM
Updated 2023-05-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
SELECT date_trunc('day',block_timestamp) as date,
CASE when nft_collection = 'A.0b2a3299cc857e29.TopShot' then 'NBA Top Shot'
when
end as collect_name,
count(DISTINCT buyer) as n_buyers
FROM flow.core.ez_nft_sales
WHERE nft_collection in ('A.0b2a3299cc857e29.TopShot', 'A.e4cf4bdc1751c65d.AllDay',
'A.4eded0de73020ca5.CricketMoments', 'A.87ca73a41bb50ad5.Golazos')
AND date >= current_date - 90
GROUP BY 1,2
--- Number of new users
SELECT buyer,
nft_collection,
count(DISTINCT tx_id) n_purchase
FROM flow.core.ez_nft_sales
WHERE nft_collection in ('A.0b2a3299cc857e29.TopShot', 'A.e4cf4bdc1751c65d.AllDay',
'A.4eded0de73020ca5.CricketMoments', 'A.87ca73a41bb50ad5.Golazos')
AND block_timestamp::date >= current_date - 90
GROUP BY 1,2 -- Long --> wide Buyer/nba topshot / nfl all day/ 3 / 4
Run a query to Download Data