adriaparcerisasMFL Player Drop Day 19/2/25: Stats 2
Updated 2025-02-24
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
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with
stats as (
SELECT
'Regular Purchase' as purchase_type,
case when price=14.99 then 'Kickoff pack'
when price=49.99 then 'Standard pack'
when price=159.99 then 'Rare pack'
--when price=599.99 then 'Legendary pack'
end as pack_type,
-- price,
COUNT(DISTINCT x.tx_id) AS packs_sold,
case when pack_type = 'Kickoff pack' then 300 when pack_type = 'Standard pack' then 300
else 150 end as total_available,
COUNT(DISTINCT buyer) AS users
--total_available*price as volume
-- SUM(case when pack_type = 'Kickoff pack' then 9.99
--when pack_type = 'Standard pack' then 24.99 else 89.99 end ) AS volume
FROM flow.nft.ez_nft_sales x
WHERE nft_collection ilike '%mfl%' and nft_collection ilike '%pack%'
and x.block_timestamp between '2025-02-19 22:00' and '2025-02-20 08:00'
group by 1,2
having pack_type is not null
),
stats2 as(
SELECT
'$MFL Purchase' as purchase_type,
pack_type as pack_type,
-- case when pack_type='Kickoff pack' then 8000
--when pack_type='Standard pack' then 20000
--else 72000 end as price,
case when pack_type='Kickoff pack' then total_available-packs_sold else total_available-packs_sold end AS packs_sold,
case when pack_type = 'Kickoff pack' then 300 when pack_type = 'Standard pack' then 300 when pack_type = 'Rare pack' then 150
end as total_available,
total_available-packs_sold AS users,
-- SUM(case when pack_type = 'Kickoff pack' then 8000
--when pack_type = 'Standard pack' then 20000 else 80000 end) AS volume
QueryRunArchived: QueryRun has been archived