select block_timestamp,

tx_id,

--marketplace, --A.4eb8a10cb9f87357.NFTStorefront

--currency, --A.ead892083b3e2c6c.DapperUtilityCoin

nft_id,

buyer,

seller,

price,

tokenflow,

counterparties

from flow.core.ez_nft_sales

where nft_collection = 'A.e4cf4bdc1751c65d.AllDay'

and tx_succeeded = TRUE

select block_timestamp::date as fecha,

sum (price) as daily_volume,

count (tx_id) as daily_sales,

sum (daily_volume) over (order by fecha) as acc_volume,

sum (daily_sales) over (order by fecha) as acc_sales

from allday_raw_sales

group by fecha

order by fecha desc