maybeyonasthor_slip_swap_swap
    Updated 2022-01-29
    with
    swaps as (
    select
    block_timestamp,
    split(pool_name,'-')[0]::string as pool,
    round(from_amount_usd,-2) as from_amount_usd,
    swap_slip_bp/100 as slippage
    from thorchain.swaps
    )
    select
    from_amount_usd,
    -- pool,
    log(10,count(block_timestamp)) as log_swaps,
    avg(slippage) as avg_slip,
    max(slippage) as max_slip,
    min(slippage) as min_slip,
    mode(slippage) as mode_slip
    from swaps
    group by 1--,2

    Run a query to Download Data