block_timestamp as days, price, price_usd, token_id

from ethereum.nft_events

where contract_address in ('0x059edd72cd353df5106d2b9cc5ab83a52287ac3a', '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270')

and event_type = 'sale'),

project as (select

token_metadata:collection_name::string as Project, token_id

from ethereum.nft_metadata

where contract_address in ('0x059edd72cd353df5106d2b9cc5ab83a52287ac3a', '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270')

group by 1,2)

select date_trunc('day', A.days), sum(A.price), sum(A.price_usd), B.project

from vol A

join project B on A.token_id = B.token_id

group by 1,4