zakkisyedRUNE Movement
    Updated 2022-06-21

    select date_trunc(week,block_timestamp) as date, movement, sum(rune_amount) as RUNE, sum(rune_amount_usd) as USD

    from

    (
    select block_timestamp, from_address, to_address, rune_amount, RUNE_AMOUNT_USD,
    CASE WHEN from_address = 'thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6' then 'Outflow'
    else 'Inflow'
    end as movement
    from flipside_prod_db.thorchain.transfers
    where from_address = 'thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6'
    or to_address = 'thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6'

    )

    group by 1,2
    order by 1 desc
    Run a query to Download Data