freemartianLPer - 10000
    Updated 2022-04-25
    WITH whale_adresses AS (
    SELECT FROM_ADDRESS AS address, SUM(asset_amount_usd + rune_amount_usd) AS amount
    FROM thorchain.liquidity_actions
    WHERE FROM_ADDRESS IS NOT NULL
    GROUP BY FROM_ADDRESS
    ORDER BY amount DESC
    ),
    addresses AS (
    SELECT date_trunc('month', block_timestamp::date) as DATE,
    address,
    row_number() over (PARTITION BY address ORDER BY block_timestamp ASC) as row_number
    FROM thorchain.liquidity_actions
    INNER JOIN whale_adresses
    ON FROM_ADDRESS = address
    WHERE amount >= 10000
    ),

    firs AS (
    SELECT DATE, COUNT(address) as first_liq
    FROM addresses
    WHERE row_number = 1
    GROUP BY DATE
    ORDER BY DATE ASC
    ),
    not_first as (
    SELECT DATE, COUNT(address) as non_first_liq
    FROM addresses
    WHERE row_number > 1
    GROUP BY DATE
    ORDER BY DATE ASC
    ),
    final AS (
    SELECT firs.DATE AS MONTH, first_liq, non_first_liq
    FROM firs
    INNER JOIN not_first
    ON firs.DATE = not_first.DATE
    Run a query to Download Data