block_timestamp::date as date,

status as type,

count(distinct tx_hash) as n_txns,

sum(gas_used) as gas_used_gwei,

sum(gas_used_gwei) over (partition by type order by date asc rows between unbounded preceding and current row) as cum_gas_used_gwei

from ethereum_core.fact_transactions

where

to_address = '0x23581767a106ae21c074b2276d25e5c3e136a68b' -- Moonbirds'

and block_timestamp::date >= '2022-04-16' -- https://twitter.com/moonbirds_xyz/status/1507465280401948674?s=20&t=yGFmzLNWV1FUCtDNBa3YBg

group by date, type