year(block_timestamp) || '-' || month(block_timestamp) as date,

event_type,

count(ethereum.nft_metadata.token_id) as token_count

from ethereum.nft_events

left join ethereum.nft_metadata on ethereum.nft_events.token_id = ethereum.nft_metadata.token_id

and ethereum.nft_events.contract_address = ethereum.nft_metadata.contract_address

where ethereum.nft_events.contract_address in ('0x059edd72cd353df5106d2b9cc5ab83a52287ac3a','0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270')

and token_metadata:collection_name is not null

and price is not null

group by date, event_type

order by date, event_type