avg(price) as token_price

from ethereum.core.fact_hourly_token_prices

where symbol = 'WETH'

and hour >= '2022-06-01'

group by 1)

,

optimism as ( select trunc(block_timestamp,'day') as day,

tx_hash,

seller_address,

buyer_address,

price_usd as volume

from optimism.core.ez_nft_sales

where block_timestamp >= '2022-06-01')

,

arbitrum as ( select trunc(block_timestamp,'day') as day,

tx_hash,

event_inputs:from::string as seller_address,

origin_from_address as buyer_address

from arbitrum.core.fact_event_logs

where origin_from_address = event_inputs:to and event_inputs:tokenId is not null

and tx_hash in ( select tx_hash from arbitrum.core.fact_event_logs

where contract_address in ( '0x998ef16ea4111094eb5ee72fc2c6f4e6e8647666',

'0x00000000006c3852cbef3e08e8df289169ede581',

,

arbi_nft as ( select day,

a.tx_hash,

seller_address,

buyer_address,

eth_value as amt

from arbitrum a join arbitrum.core.fact_transactions b on a.tx_hash = b.tx_hash )

,

arbi_volume as ( select a.day,

tx_hash,

seller_address,