from ethereum.nft_events

where event_type = 'sale' and

contract_address in ('0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270', '0x059edd72cd353df5106d2b9cc5ab83a52287ac3a') and date_trunc('day',block_timestamp) = CURRENT_DATE - 1)

select sum(price_usd)

from ass