date_trunc('week',block_timestamp) as date,

sum(price) as "Volume ETH",

sum(price_usd) as "Volume USD",

sum(tx_fee) as "Total fee used",

count(distinct tx_hash) as "number of NFT sales",

count(distinct seller_address) as "Unique sellers",

count(distinct buyer_address) as "Unique buyers"

from ethereum.core.ez_nft_sales

where platform_name like 'x2y2'

and event_type like 'sale'

and Block_timestamp >='2022-01-01'

group by date order by date asc),

opensea as (select

date_trunc('week',block_timestamp) as date,

sum(price) as "Volume ETH",

sum(price_usd) as "Volume USD",

sum(tx_fee) as "Total fee used",

count(distinct tx_hash) as "number of NFT sales",

count(distinct seller_address) as "Unique sellers",

count(distinct buyer_address) as "Unique buyers"

from ethereum.core.ez_nft_sales

where platform_name like 'opensea'

and event_type like 'sale'

and Block_timestamp >='2022-01-01'

group by date order by date asc)

select * from x2y2