count(DISTINCT tx_HASH) as "# Transactions",

count(DISTINCT seller_address) as "# Sellers",

count(distinct buyer_address) as "# Buyers",

sum(price_USD) as "TOTAL Sales Volume",

percentile_cont(0.25) within group (order by price_usd) as "25%",

percentile_cont(0.5) within group (order by price_usd) as "50%",

percentile_cont(0.75) within group (order by price_usd) as "75%",

avg(price_usd) as "Avg Price",

'Optimism' as "Network"

from optimism.core.ez_nft_sales

where 1=1

and PRICE_USD is not null

and EVENT_TYPE = 'sale'

and block_timestamp >= '2022-04-14'

union ALL

select

count(DISTINCT tx_HASH) as "# Transactions",

count(DISTINCT seller_address) as "# Sellers",

count(distinct buyer_address) as "# Buyers",

sum(price_USD) as "TOTAL Sales Volume",

percentile_cont(0.25) within group (order by price_usd) as "25%",

percentile_cont(0.5) within group (order by price_usd) as "50%",

percentile_cont(0.75) within group (order by price_usd) as "75%",

avg(price_usd) as "Avg Price",

'Ethereum' as "Network"

from ethereum.core.ez_nft_sales

where 1=1

and PRICE_USD is not null

and EVENT_TYPE = 'sale'

and block_timestamp >= '2022-04-14'