al as (select date_trunc('week', block_timestamp) as weekl, 'TopShot' as Marketplace,

count(distinct tx_id) as "TX Count",

count (distinct buyer) as "Number of buyers",

count (distinct seller) as "Number of sellers",

sum (price*1.013) as "Amount swapped",

avg(price*1.013) as "Avg amount swapped",

median(price*1.013) as "Median amount swapped",

max(price*1.013) as "Max amount swapped",

sum ("TX Count") over(order by weekl) as "Cumulative tx count",

sum ("Number of buyers") over(order by weekl) as "Cumulative number of buyers",

sum ("Number of sellers") over (order by weekl) as "Cumulative number of sellers"

from flow.core.ez_nft_sales

where block_timestamp>='2023-01-01'

and MARKETPLACE like '%TopShot%'

group by 1,2),

b as (select date_trunc('week', block_timestamp) as week, 'OpenSea' as Marketplace,

count(distinct tx_hash) as "TX Count",

count (distinct buyer_address) as "Number of buyers",

count (distinct seller_address) as "Number of sellers",

sum (price_usd) as "Amount swapped",

avg(price_usd) as "Avg amount swapped",

median(price_usd) as "Median amount swapped",

max(price_usd) as "Max amount swapped",

sum ("TX Count") over(order by week) as "Cumulative tx count",

sum ("Number of buyers") over(order by week) as "Cumulative number of buyers",

sum ("Number of sellers") over (order by week) as "Cumulative number of sellers"

from ethereum.core.ez_nft_sales

where block_timestamp>='2023-01-01'

and platform_name like '%opensea%'

group by 1,2),