maybeyonasthorstop_swaps
    Updated 2021-11-27
    with swaps as (
    select
    block_timestamp,
    tx_id,
    from_asset,
    to_asset,
    from_amount_usd as usd_vol,
    case
    when from_asset = 'THOR.RUNE' then 'sell'
    else 'buy' end as swap
    from thorchain.swaps
    ),
    before_stop as (
    select
    date(block_timestamp) as date,
    swap,
    count(tx_id) as txs,
    sum(usd_vol) as usd_vol
    from swaps
    where
    block_timestamp >= '2021-11-02' and block_timestamp <= '2021-11-12'
    group by 1,2
    ),
    after_stop as (
    select
    date(block_timestamp) as date,
    swap,
    count(tx_id) as txs,
    sum(usd_vol) as usd_vol
    from swaps
    where
    block_timestamp >= '2021-11-17' and block_timestamp <= '2021-11-27'
    group by 1,2
    )


    Run a query to Download Data