with inflow as (
select
block_timestamp::date as day
,sum(RUNE_AMOUNT_USD) as amount
from flipside_prod_db.thorchain.transfers
where FROM_ADDRESS = 'thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6'
group by 1
order by 1
)
, outflow as (
select
block_timestamp::date as day
,sum(RUNE_AMOUNT_USD) as amount
from flipside_prod_db.thorchain.transfers
where TO_ADDRESS = 'thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6'
group by 1
order by 1
)
select 'inflow' as Type,* from inflow
union all
select 'outflow' as Type,* from outflow