mlhTopShot
Updated 2022-12-06Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
select day,
collection_name,
case when purchases = 1 then 'purchase 1 time'
when purchases > 1 and purchases <= 5 then 'purchase 2 to 5 times'
when purchases > 5 and purchases <= 10 then 'purchased 6 to 10 times'
else 'purhase more than 10 times'
end as purchase_count,
count(distinct(wallet)) as wallet_count,
sum(price) as USD_volume
from (select date_trunc('day', block_timestamp) as day,
case when nft_collection = 'A.0b2a3299cc857e29.TopShot' then 'NBA TopShot'
end as collection_name,
buyer as wallet,
price,
count(distinct(tx_id)) as purchases
from flow.core.ez_nft_sales
where tx_succeeded = 'TRUE'
and nft_collection in ('A.0b2a3299cc857e29.TopShot')
group by 1,2, 3, 4
)
where day <= '2020-10-20'
group by 1,2, 3
Run a query to Download Data