last_Month as (

select

avg("Sales Volume ($)") as "Avg Sales Volume ($)-30d",

avg("# Sales") as "Avg # Sales-30d"

from

(

select

date_trunc(day, BLOCK_TIMESTAMP) as date,

sum(PRICE_USD) as "Sales Volume ($)",

count(DISTINCT TX_HASH) as "# Sales"

from

ethereum.core.ez_nft_sales

where

1 = 1

and PRICE_USD is not NULL

and PRICE_USD > 0

and PLATFORM_NAME is not NULL

and event_type in ('sale', 'bid_won')

and BLOCK_TIMESTAMP::date >= current_date - 30

group by

1

)

),

last_ThreeMonths as (

select

avg("Sales Volume ($)") as "Avg Sales Volume ($)-90d",

avg("# Sales") as "Avg # Sales-90d"

from

(

select

date_trunc(day, BLOCK_TIMESTAMP) as date,

sum(PRICE_USD) as "Sales Volume ($)",

count(DISTINCT TX_HASH) as "# Sales"

from

ethereum.core.ez_nft_sales