cte_opensea AS (

SELECT

date_trunc('day', block_timestamp) as sale_date,

SUM(price) as opensea_volume,

SUM(price_usd) as opensea_volume_usd

FROM

ethereum.core.ez_nft_sales

WHERE

block_timestamp >= '2022-10-19'

AND platform_name = 'opensea'

AND currency_symbol = 'ETH'

GROUP BY

1

),

cte_blur AS (

SELECT

date_trunc('day', block_timestamp) as sale_date,

SUM(price) as blur_volume,

SUM(price_usd) as blur_volume_usd

FROM

ethereum.core.ez_nft_sales

WHERE

block_timestamp >= '2022-10-19'

AND platform_name = 'blur'

AND currency_symbol = 'ETH'

GROUP BY

1

),

cte_x2y2 AS (

SELECT

date_trunc('day', block_timestamp) as sale_date,

SUM(price) as x2y2_volume,

SUM(price_usd) as x2y2_volume_usd

FROM

ethereum.core.ez_nft_sales