maybeyonasasset_user_out_vol
    Updated 2021-10-24
    with in_thor as(
    select
    block_timestamp,
    blockchain,
    from_asset,
    from_address,
    from_amount,
    from_amount_usd,
    'in' as direction
    from thorchain.swaps
    where from_asset != 'THOR.RUNE'
    ),
    out_thor as(
    select
    block_timestamp,
    blockchain,
    to_asset,
    from_address,
    to_amount,
    to_amount_usd,
    'out' as direction
    from thorchain.swaps
    where to_asset != 'THOR.RUNE'
    ),
    in_out as(
    select * from in_thor
    union all
    select * from out_thor
    )

    -- select * from out_thor
    -- order by block_timestamp desc
    -- limit 100

    select
    to_char(block_timestamp, 'yyyy-mm-dd') as date,
    Run a query to Download Data