binhachon19. [Easy] Whale activity - number of lper
    Updated 2021-11-07
    with wealth_distribution as(
    select to_address as address, sum(rune_amount) as balance from thorchain.transfers
    group by address
    )
    select case when position('-', pool_name, 1) = 0 then pool_name else
    substr(pool_name, 1, position('-', pool_name, 1) - 1) end as pool_name, count(distinct from_address) as number_of_lpers, sum(rune_amount_usd+asset_amount_usd) as amount_usd from thorchain.liquidity_actions
    where from_address in (select address from wealth_distribution where balance > 10000)
    and lp_action = 'add_liquidity'
    group by pool_name
    order by number_of_lpers desc

    Run a query to Download Data