asset_id,

SUM(amount) AS total_amount

-- DATE_TRUNC(

-- 'hour',

-- block_timestamp

-- ) AS TIME,

--COUNT(asset_id) AS nft_sold

FROM flipside_prod_db.algorand.transfers

WHERE asset_sender ILIKE 'MS7TKJ3MXE6CQ5IZW2ZQC2KT3NWJFQPRSDAFTZPGYPFCZZ43PL7UPBTZXE'

AND receiver ILIKE 'CCNFTNFTSXVYGCGP5EU7AMUTQLUZI6TXRS4XMW2LP4XARZH3LB6RZPUOQM'

--OR receiver ILIKE 'VWZBFLBUN6O5A5W6IWHMDUVP5NH2LPV4ZYFMAHP4FQBBYP627MP6WPOEG4'

--AND asset_id = '571576867'

AND block_timestamp >= '2022-07-06 19:00:00'

GROUP BY asset_id