select sum(sales_amount),date(block_timestamp) as date from solana.fact_nft_sales
where
MARKETPLACE='magic eden v2'
and date >= '2022-03-12'
and mint in (select distinct mint from solana.dim_nft_metadata where CONTRACT_NAME='Taiyo Robotics')
group by date