with a as

( select

ethereum.BLOCK_TIMESTAMP

,ethereum.NFT_FROM_ADDRESS

,ethereum.NFT_TO_ADDRESS as bridge_addr

,ethereum.NFT_ADDRESS as nft_contract_addr_l1

,optimism.CONTRACT_ADDRESS as nft_contract_addr_l2

,TOKENID as token_id

,PROJECT_NAME as name

,ethereum.TX_HASH

,TX_FEE as gas_paid_eth

,datediff(MINUTE, ethereum.block_timestamp, optimism.block_timestamp) as time_lag

from ethereum.core.ez_nft_transfers as ethereum

join ethereum.core.fact_transactions as t

on ethereum.TX_HASH = t.TX_HASH

left join optimism.core.fact_event_logs as optimism

on optimism.EVENT_INPUTS:"to" = ethereum.NFT_FROM_ADDRESS

and ethereum.TOKENID = optimism.EVENT_INPUTS:"tokenId"

where lower(NFT_TO_ADDRESS) =lower('0x5a7749f83b81b301cab5f48eb8516b986daef23d') and time_lag <20

avg( gas_paid_eth ) as avg_gas_fee_usd

,avg( time_lag ) as avg_time_lag

from a --group by 1