date_trunc('day',block_timestamp) as dt,

case

when program_id='M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K' then 'Magic Eden'

when program_id='SPf5WqNywtPrRXSU5enq5z9bPPhREaSYf2LhN5fUxcj' then 'Solport'

end as market,

count(tx_id) as no_sale,

sum(sales_amount) as volume_sale,

count(distinct purchaser) as unq_wllts

from solana.fact_nft_sales

where dt>='2022-03-12'

and mint in (select mint from solana.dim_nft_metadata where contract_name='Taiyo Robotics')

and succeeded='TRUE'

group by 1,2 having market is not null