select day,

block_rewards,

sum (block_rewards) over (order by day) as cum_rewards

from thorchain.block_rewards

where day < CURRENT_DATE

order by 1 desc

),

liq_fees as (

select day,

sum(rune_liquidity_fees) as fees,

sum(fees) over (order by day) as cum_fees

from thorchain.pool_block_fees

where day < CURRENT_DATE

group by 1

order by 1 desc

),

swap_fees as (

select block_timestamp::date as fecha,

sum(liq_fee_in_rune_e8)/pow(10,8) as fees,

sum(fees) over (order by fecha) as cum_fees

from thorchain.swap_events

where fecha < CURRENT_DATE

group by 1

order by 1 desc

select r.day,

r.block_rewards,

lf.fees as liq_fees,

sf.fees as swap_fees,

r.cum_rewards,

lf.cum_fees as cum_liq_fees,

sf.cum_fees as cum_swap_fees