trunc(block_timestamp,'minute') as minute,

case when price=9.99 then 'Starter pack'

when price=34.99 then 'Standard pack'

when price=119.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>='2024-11-27 22:00' and block_timestamp<='2024-11-27 22:13'

group by 1,2

having type is not null

order by 1 asc, 2 asc