BLOCK_TIMESTAMP :: date date,

count(DISTINCT tx_hash) as "total sale",

count(DISTINCT SELLER_ADDRESS) as "unique seller",

count(DISTINCT buyer_address) as "unique buyer",

sum(PRICE_USD) as "total volume sale",

sum("total sale") over (

order by

date

) as grow_Sale_tx,

sum("unique seller") over (

order by

date

) as "grow seller",

sum("unique buyer") over (

order by

date

) as growth_buyer,

sum("total volume sale") over (

order by

date

) as growth_vol

from

ethereum.core.ez_nft_sales

where

PROJECT_NAME = 'azuki'

and event_type = 'sale'

group by

1