select
block_timestamp::date as "Date",
count(distinct tx_id) as "Values"
from
evmos.core.fact_transactions
where
-- block_timestamp::date >= (current_date - 5)
block_timestamp::date >= '2022-01-01'
group by
"Date"
qualify
"Date" < last_value("Date") over (order by "Date")
order by
"Date"