group by block_timestamp::date)

, total_inflow as (select sum(rune_amount) from thorchain.transfers where to_address='thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6')

, outflow as (select sum(rune_amount),block_timestamp::date from thorchain.transfers where from_address='thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6'

group by block_timestamp::date)

,total_outflow as (select sum(rune_amount) from thorchain.transfers where from_address='thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6')

select * from total_inflow