date_part(hour, a.block_timestamp) as hours,

b.project_name,

sum(a.sales_amount) as sales_amount,

count(DISTINCT a.purchaser) as n_unique_wallets,

count(DISTINCT a.tx_id) as count_sales

FROM solana.core.fact_nft_sales a

LEFT JOIN solana.core.dim_nft_metadata b

ON b.mint = a.mint

WHERE (a.program_id = 'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K' or a.program_id = 'MEisE1HzehtrDpAAT8PnLHjpSSkRYakotTuJRPjTpo8')

AND a.succeeded = 'TRUE'

AND a.block_timestamp >= CURRENT_DATE-30

group by hours,project_name