block_timestamp :: date as date,

count(distinct from_address) as address_count,

sum(address_count) over (order by date) as "Users Over Day",

'Optimisim Active Users' as type

from

optimism.core.fact_transactions

where

block_timestamp >= CURRENT_DATE - 90

group by

1