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