rw2023UW unlock schedule Analysor falla
    Updated 2023-04-17
    -- forked from analysoor / 2023-02-27 05:26 AM @ https://flipsidecrypto.xyz/analysoor/q/2023-02-27-05-26-am-AfcUA3

    WITH
    unstake as (
    SELECT
    instruction:accounts[8]::string as mint,
    block_timestamp,
    'unstake' as status,
    TX_ID
    FROM
    solana.core.fact_events
    WHERE
    PROGRAM_ID = 'abcsvVSGQZxDKR1gw6cDqvTdHTj8YGWy73LyzJAesvT'
    AND SUCCEEDED = TRUE
    AND instruction:data = 'G7jGGZx8TVS'
    AND TX_ID NOT IN (
    SELECT
    TX_ID
    FROM
    solana.core.fact_events
    WHERE
    PROGRAM_ID = 'abcsvVSGQZxDKR1gw6cDqvTdHTj8YGWy73LyzJAesvT'
    AND SUCCEEDED = TRUE
    AND instruction:data = '43ybUtGBQFF5'
    AND block_timestamp > '2023-01-23'
    )
    order by
    2 desc
    ),
    last_unstake as (
    SELECT
    mint,
    max(BLOCK_TIMESTAMP) + interval '21 day' as unlock_date
    from
    unstake
    GROUP BY
    Run a query to Download Data