block_timestamp::date as day,

count(distinct tx_id) as txns_count,

count(distinct token_id) as nfts_count,

count(distinct minter) as wallets_count,

sum(iff(mint_price is null, 0, mint_price)/ pow(10, 6)) as fee,

sum(txns_count) over (order by day) as cumulative_txns_count,

sum(nfts_count) over (order by day) as cumulative_nfts_count,

sum(wallets_count) over (order by day) as cumulative_wallets_count,

sum(fee) over (order by day) as cumulative_fee

from terra.core.fact_nft_mints

where year(block_timestamp) >= 2023

group by day

order by day