trunc(block_timestamp,'minute') as minute,

case when price=14.99 then 'Kickoff pack'

when price=49.99 then 'Standard pack'

when price=159.99 then 'Rare pack'

end as type,

COUNT(DISTINCT tx_id) AS packs_sold,

COUNT(DISTINCT buyer) AS users,

SUM(price) AS volume

FROM flow.nft.ez_nft_sales

WHERE nft_collection ilike '%mfl%' and nft_collection ilike '%pack%'

and block_timestamp>='2025-01-29 22:00' and block_timestamp<='2025-01-29 22:30'

group by 1,2

having type is not null

order by 1 asc, 2 asc