with a as( SELECT date_trunc('day',BLOCK_TIMESTAMP) as date,
sum(RUNE_AMOUNT) as Output_value, sum(RUNE_AMOUNT_USD) as Output_value_USD from flipside_prod_db.thorchain.transfers
where FROM_ADDRESS='thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6'
group by 1 order by 1 asc)
select * from a