with prices as (

select

hour::date as date,

avg(price) as ETH_price

from optimism.core.fact_hourly_token_prices

where symbol = 'WETH'

group by 1

),

tab_1 as (

select

BLOCK_TIMESTAMP,

tx_HASH,

PLATFORM_NAME,

SELLER_ADDRESS,

BUYER_ADDRESS,

NFT_ADDRESS,

TOKENID,

CURRENCY_SYMBOL,

PRICE_USD/ETH_price as ETH_Volume

from optimism.core.ez_nft_sales s join prices p on s.BLOCK_TIMESTAMP::date = p.date

where 1=1

and CURRENCY_SYMBOL is not NULL

and CURRENCY_SYMBOL = 'OP'

and PRICE_USD is not null

union ALL

select

BLOCK_TIMESTAMP,

tx_HASH,

PLATFORM_NAME,

SELLER_ADDRESS,

BUYER_ADDRESS,

NFT_ADDRESS,

TOKENID,