kiichiUntitled Query
    Updated 2022-06-20
    with pa1 as (
    SELECT
    date_trunc(day,block_timestamp) as date,
    sum(rune_amount) as inflow
    from flipside_prod_db.thorchain.transfers
    where to_address=(lower('thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6'))
    group by date
    ),
    pa2 as (
    SELECT
    date_trunc(day,block_timestamp) as date,
    sum(rune_amount) as outflow
    from flipside_prod_db.thorchain.transfers
    where from_address=(lower('thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6'))
    group by date
    )
    SELECT
    a.inflow,
    b.outflow,
    a.date
    from pa1 a
    left join pa2 b
    on a.date=b.date
    Run a query to Download Data