debut as (

select min(block_timestamp) as debut

FROM flow.nft.ez_nft_sales

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

and block_timestamp>='2025-02-01 22:00'

SELECT

TRUNC(block_timestamp, 'hour') AS hour,

case when block_timestamp>='2025-02-19 22:00' then 'After Drop Day 2/19/25'

else 'Before Drop Days' end as period,

nft_collection as type,

COUNT(DISTINCT buyer) AS users,

SUM(price) AS volume,

COUNT(DISTINCT tx_id) AS sales,

AVG(price) AS avg_sales_price,

MIN(price) AS min_price,

MAX(price) AS max_price

FROM flow.nft.ez_nft_sales

WHERE nft_collection ilike '%mfl%'

and nft_collection not ilike '%pack%'

and block_timestamp>=current_date-interval '1 week'

GROUP BY 1,2,3 order by 1 desc, 2 asc