Query editor
-- this table gives the high-level stats at a daily resolutionwithdaily_summary as (SELECTdate_trunc('day', evt_block_time) as day,SUM(counts) as daily_counts,SUM(tx_fee_eth) as daily_tx_fee_eth,SUM(tx_fee_usd) as daily_tx_fee_usd,SUM(tx_sourceAmount_usd) as daily_sourceAmount_usd,--sum(tx_sourceAmount_bnt) as daily_sourceAmount_bnt,SUM(tx_rewardAmount_usd) as daily_rewardAmount_usd,--sum(tx_rewardAmount_bnt) as daily_rewardAmount_bnt,SUM(tx_protocolAmount_usd) as daily_protocolAmount_usd--,--sum(tx_protocolAmount_bnt) as daily_protocolAmount_bntFROM query_3421183GROUP BY 1)SELECT *,SUM(daily_counts) OVER (order by day) as total_cuml_counts,SUM(daily_tx_fee_eth) OVER (order by day) as total_cuml_tx_fee_eth,SUM(daily_tx_fee_usd) OVER (order by day) as total_cuml_tx_fee_usd,SUM(daily_sourceAmount_usd) OVER (order by day) as cuml_sourceAmount_usd,--sum(daily_sourceAmount_bnt) OVER (order by day) as cuml_sourceAmount_bnt,SUM(daily_rewardAmount_usd) OVER (order by day) as cuml_rewardAmount_usd,--sum(daily_rewardAmount_bnt) OVER (order by day) as cuml_rewardAmount_bnt,SUM(daily_protocolAmount_usd) OVER (order by day) as cuml_protocolAmount_usd--,--sum(daily_protocolAmount_bnt) OVER (order by day) as cuml_protocolAmount_bntFROM daily_summaryORDER BY day DESC