farid-c9j0VMInflow vs Outflow (rune amount)
    Updated 2022-06-21
    with inflow as (
    select
    block_timestamp::date as day
    ,sum(RUNE_AMOUNT) as amount
    from flipside_prod_db.thorchain.transfers
    where FROM_ADDRESS = 'thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6'
    and TO_ADDRESS LIKE 'thor%'
    group by 1
    )
    , outflow as (
    select
    block_timestamp::date as day
    ,sum(RUNE_AMOUNT) as amount
    from flipside_prod_db.thorchain.transfers
    where TO_ADDRESS = 'thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6'
    and FROM_ADDRESS LIKE 'thor%'
    group by 1
    )
    select 'inflow' as Type,* from inflow
    union all
    select 'outflow' as Type,* from outflow


    Run a query to Download Data