with base as (
select
--block_timestamp::date as date,
count(distinct tx_id) as number_tx,
count(distinct buyer) as buyers,
sum(price) as amount_sell
from flow.core.ez_nft_sales
where nft_collection ilike '%allday%'
and tx_succeeded = TRUE
and block_timestamp >= current_date - 7
--group by 1
)
select
--date,
number_tx as "Number Sell",
buyers as "Buyer",
amount_sell as "Amount Sell"
from base
group by 1,2,3