siavashjflow all day Total One Week
    Updated 2022-12-05
    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