Query editor
WITHtemp AS (select time,provider,sum(vecrv) as vecrv from (SELECTdate_trunc('day',evt_block_time) as time,CASE providerWHEN 0xf147b8125d2ef93fb6965db97d6746952a133934 THEN 'yearn'WHEN 0x989aeb4d175e16225e39e87d0d97a3360524ad80 THEN 'convex'WHEN 0x52f541764e6e90eebc5c21ff570de0e2d63766b6 THEN 'stakedao'ELSE 'other'END AS provider,sum(value / 1e18) AS vecrvFROMcurvefi_ethereum.voting_escrow_evt_Depositgroup by 1,2UNION ALLSELECTdate_trunc('day',evt_block_time) as time,CASE providerWHEN 0xf147b8125d2ef93fb6965db97d6746952a133934 THEN 'yearn'WHEN 0x989aeb4d175e16225e39e87d0d97a3360524ad80 THEN 'convex'WHEN 0x52f541764e6e90eebc5c21ff570de0e2d63766b6 THEN 'stakedao'ELSE 'other'END AS provider,- sum(value / 1e18) AS vecrvFROMcurvefi_ethereum.voting_escrow_evt_Withdrawgroup by 1,2)group by 1,2),days AS (SELECTdate_trunc('day',date_column) AS time,provider,0 as vecrvFROM (VALUES(SEQUENCE(CAST('2020-08-14' AS timestamp), CAST(DATE_TRUNC('day', CURRENT_TIMESTAMP) AS timestamp), INTERVAL '1' DAY))) AS t1(date_array)CROSS JOIN UNNEST(date_array) AS t2(date_column)CROSS JOIN (select distinct provider from temp))select t1.time,t1.provider,sum(coalesce(t2.vecrv, t1.vecrv)) over(partition by t1.provider order by t1.time asc) as vecrvfrom days as t1left join temp as t2 on t1.time=t2.time and t1.provider=t2.providerorder by time desc, provider asc-- SELECT-- time,-- provider,-- SUM(vecrv) OVER (