SELECT

block_timestamp,

tx_to,

CASE

WHEN block_timestamp BETWEEN '2025-01-01 23:56:00' AND '2025-01-01 23:59:59'

THEN 'Late Night Buyers'

WHEN block_timestamp >= '2025-01-02 00:00:00'

THEN 'Early Morning Buyers'

END AS buyer_category

FROM

solana.core.fact_transfers

WHERE

mint = '6XFudZ7DDQq633Wad8cQmV7vTN5SdkE82GG6JDUzpump'

SELECT

block_timestamp,

tx_to AS "Buyer Address",

buyer_category

FROM (

SELECT

block_timestamp,

tx_to,

buyer_category,

ROW_NUMBER() OVER (PARTITION BY buyer_category ORDER BY block_timestamp ASC) AS row_num

FROM

FilteredTransactions

) filtered

WHERE

(buyer_category = 'Late Night Buyers' AND row_num <= 5)

OR (buyer_category = 'Early Morning Buyers' AND row_num <= 10)

ORDER BY

block_timestamp ASC;