date_trunc('day',block_timestamp) as block_day,

event_type,

sum(price_usd) as Volume,

avg(price_usd) as Avg_Price,

count (distinct tx_id) as tx_count

from ethereum.nft_events

where contract_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270' and event_type = 'sale' and block_day between '2021-06-12' and '2021-07-31'

and token_id in (select distinct token_id

from ethereum.nft_metadata

where contract_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270'

and lower(token_name) LIKE '%fidenza%')

group by 1,2