Query editor
with t1 as (selectCAST(from_iso8601_timestamp(date_at) AS DATE) as date_at,'protocol fee' as referral,cast(amount_fee as double) as feefrom dune.near.dataset_near_intents_protocol_feesUNION ALLselectCAST(from_iso8601_timestamp(date_at) AS DATE) as date_at,referral,cast(fee as double) as feefrom dune.near.dataset_near_intents_feesWHERE CAST(from_iso8601_timestamp(date_at) AS DATE)<current_date),t2 as (selectdate_at,sum(cast(fee as double)) as feesfrom t1group by date_at)selectdate_at,fees,sum(fees) over (order by date_at) as cumulative_feesfrom t2order by date_at desc