maybeyonasthorchain_swap_cost
    Updated 2021-12-24
    with multi_swaps_txs as (
    select tx_id from (
    select
    tx_id,
    count(tx_id) as swaps
    from thorchain.swaps
    group by 1
    )
    where swaps > 1
    ),
    native_swaps as (
    select
    block_timestamp,
    tx_id,
    split(from_asset,'-')[0]::string as from_asset,
    split(to_asset,'-')[0]::string as to_asset,
    split(from_asset,'.')[0]::string as from_chain,
    split(to_asset,'.')[0]::string as to_chain,
    split(from_asset,'-')[0]::string || ' to ' || split(to_asset,'-')[0]::string as asset_route,
    from_chain || ' to ' || to_chain as chain_route,
    case when from_chain=to_chain then 'Same chain'
    else 'Different chain' end as swap_type,
    from_amount,
    to_amount,
    from_amount_usd,
    to_amount_usd,
    liq_fee_rune,
    liq_fee_asset,
    liq_fee_rune_usd,
    liq_fee_asset_usd,
    (liq_fee_asset_usd+liq_fee_rune_usd)*100/from_amount_usd as lp_fee_percent
    -- count(tx_id) as swaps,
    -- sum(from_amount) as from_amount,
    -- sum(to_amount) as to_amount,
    -- sum(from_amount_usd) as from_amount_usd,
    -- sum(to_amount_usd) as to_amount_usd
    Run a query to Download Data