token_name, token_id

from ethereum.nft_metadata

where contract_address = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270'

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

sales as (SELECT

block_timestamp, token_id, price, event_from

from nft_events

where event_type = 'sale')