Query editor
select date_trunc('day', block_time) as time, sum(virtual_add_pool) as virtual_add_pool, sum(sum(virtual_add_pool)) over (order by date_trunc('day', block_time) asc) as sum_virtual_add_pool, sum(fee) as fee, sum(sum(fee)) over (order by date_trunc('day', block_time) asc) as sum_fee, count(*) as pairs_created, sum(count(*)) over (order by date_trunc('day', block_time) asc) as pairs_cumulativefrom query_4241130group by 1order by 1 desc