lagandispenserTop Active LP Liquiduity
    Updated 2022-06-28
    WITH
    all_liquidity_actions as (
    SELECT
    from_address,
    COUNT(from_address) as tx_count
    FROM thorchain.liquidity_actions
    GROUP BY from_address
    ORDER BY tx_count DESC
    ),

    targeted_addresses as (
    SELECT
    *
    FROM all_liquidity_actions
    ORDER BY tx_count DESC
    --WHERE tx_count > 100 AND tx_count < 10000
    LIMIT 20
    ),

    top_human as (
    SELECT
    *,
    date(block_timestamp) as dates
    FROM thorchain.liquidity_actions
    WHERE from_address in (SELECT from_address FROM targeted_addresses)
    )
    SELECT
    from_address,
    lp_action,
    count(from_address) as number
    FROM top_human
    GROUP BY from_address, lp_action
    order by 3 desc


    Run a query to Download Data