with nfts as (

select *

from optimism.core.ez_nft_sales

where

platform_name ilike '%quixotic%'

),

change as (

select

date_trunc('day', block_timestamp) as "Day",

sum(price_usd) as "Current Sales Volume",

count(distinct seller_address) as "Current Unique Sellers",

count(distinct buyer_address) as "Current Unique Buyers",

count(distinct tx_hash) as "Current Sales Count",

lag("Current Sales Volume",1) over(order by "Day") as "Previous Sales Volume",

lag("Current Unique Sellers",1) over(order by "Day") as "Previous Unique Sellers",

lag("Current Unique Buyers",1) over(order by "Day") as "Previous Unique Buyers",

lag("Current Sales Count",1) over(order by "Day") as "Previous Sales Count",

(("Current Sales Volume" - "Previous Sales Volume") / "Previous Sales Volume") * 100 as "change (%) Sales Volume",

(("Current Unique Sellers" - "Previous Unique Sellers") / "Previous Unique Sellers") * 100 as "change (%) Unique Sellers",

(("Current Unique Buyers" - "Previous Unique Buyers") / "Previous Unique Buyers") * 100 as "change (%) Unique Buyers",

(("Current Sales Count" - "Previous Sales Count") / "Previous Sales Count") * 100 as "change (%) Sales Count"

from nfts

where "Day" < current_date

group by 1

select *

from change

where "Day" = current_date - 1