KaskoazulLP Size Distribution Top 10
    Updated 2022-05-03
    with add_LP as (
    select pool_name,
    sum(rune_amount) as total_add_rune,
    sum(rune_amount_usd) as total_add_rune_usd,
    sum(asset_amount) as total_add_asset,
    sum(asset_amount_usd) as total_add_asset_usd
    from thorchain.liquidity_actions
    where lp_action = 'add_liquidity'
    group by 1
    ),

    remove_LP as (
    select pool_name,
    sum(rune_amount) as total_rem_rune,
    sum(rune_amount_usd) as total_rem_rune_usd,
    sum(asset_amount) as total_rem_asset,
    sum(asset_amount_usd) as total_rem_asset_usd
    from thorchain.liquidity_actions
    where lp_action = 'remove_liquidity'
    group by 1
    ),

    prices as (
    select *
    from thorchain.prices
    where block_id = 5380898 -- '2022-05-02 00:55:01.986'
    ),

    --thorchain.prices!
    calculate as (
    select split_part (a.pool_name, '-', 1) as pool,
    a.total_add_rune,
    --a.total_add_rune_usd,
    a.total_add_asset,
    --a.total_add_asset_usd,
    Run a query to Download Data