select
block_timestamp::date as "Date",
count(distinct tx_from) as "Values"
from
evmos.core.fact_transactions
where
block_timestamp::date >= (current_date - 7)
and tx_succeeded = true
group by
"Date"
qualify
"Date" < last_value("Date") over (order by "Date")
order by
"Date" desc