l.tx_hash, contract_address, address_name, sum(amount) as volume,

date_trunc('day', l.block_timestamp::date) as TIME

from optimism.core.fact_event_logs l

inner join optimism.core.ez_eth_transfers t on t.tx_hash = l.tx_hash

inner join optimism.core.dim_labels la on la.address = l.contract_address

where l.origin_to_address in (

'0x20975da6eb930d592b9d78f451a9156db5e4c77b',

'0x065e8a87b8f11aed6facf9447abe5e8c5d7502b6',

'0x3f9da045b0f77d707ea4061110339c4ea8ecfa70')

and l.event_name = 'Transfer'

and l.event_inputs:tokenId is not null

and address_name like '%mirror%'

group by 1, 2,3, TIME

order by volume desc