AA as(

select block_timestamp, event_type, platform_name, price_usd as volume from ethereum.nft.ez_nft_sales union all

select block_timestamp, event_type, platform_name, price_usd as volume from arbitrum.nft.ez_nft_sales union all

select block_timestamp, event_type, platform_name, price_usd as volume from optimism.nft.ez_nft_sales union all

select block_timestamp, event_type, platform_name, price_usd as volume from base.nft.ez_nft_sales union all

select block_timestamp, event_type, platform_name, price_usd as volume from avalanche.nft.ez_nft_sales union all

select block_timestamp, event_type, platform_name, price_usd as volume from bsc.nft.ez_nft_sales union all

select block_timestamp, event_type, platform_name, price_usd as volume from polygon.nft.ez_nft_sales

),

A as(

select block_timestamp as date, volume

from AA

where date(block_timestamp) >= '2021-12-01'),

B as( select sum(volume) as volume

from A

where date BETWEEN '2022-12-18' and '2023-12-18' ),

C as( select sum(volume) as volume

from A

where date BETWEEN '2021-12-18' and '2022-12-18'),

D as( select date_trunc('month',date) as date, sum(volume) as volume

from A

where date >= '2022-12-18'

GROUP by 1)

select *,

(select * from B) as volume_2023,