flipside

    Grass Largest Unstakers
    0xgabeGrass Largest Unstakers
    Updated 1 day ago
    SELECT
    DATE_TRUNC('day', block_timestamp) as withdrawal_day,
    DATE_TRUNC('day', block_timestamp) + INTERVAL '7 days' as available_to_claim_day,
    signers[0] as unstaker,


    ROUND(SUM(utils.udf_hex_to_int(
    to_char(reverse(to_binary(RIGHT(utils.udf_base58_to_hex(PARSE_JSON(instruction):data::string), 16))))
    ) / POW(10, 9)),2) as total_token_amount,



    FROM solana.core.fact_events
    WHERE program_id = 'EyxPPowqBRTpZpiDb2ixUR6XUU1VJwTCNgJdK8eyc6kc'
    AND succeeded = TRUE
    AND inner_instruction is NULL
    AND index = 1
    AND block_timestamp >= CURRENT_DATE - INTERVAL '7 days'
    GROUP BY 1, 2, 3
    ORDER BY 4 DESC
    Last run: 1 day ago
    WITHDRAWAL_DAY
    AVAILABLE_TO_CLAIM_DAY
    UNSTAKER
    TOTAL_TOKEN_AMOUNT
    1
    		2025-05-30 00:00:00.0002025-06-06 00:00:00.000
    9q3hbBS1v3TshwVvsSrGBBQAQye1HAvyanbTQLvHHANi
    		1986470.54
    2
    		2025-06-02 00:00:00.0002025-06-09 00:00:00.000
    2YmAKrUECyvwMnwDED2h9ayxRCBPmiwSCTSygFRTm8Db
    		50304.63
    3
    		2025-06-02 00:00:00.0002025-06-09 00:00:00.000
    5bVNWctTfG4DUAUNMFmiCq8VuakqyJz9hL5varG6QKC2
    		21875
    4
    		2025-06-02 00:00:00.0002025-06-09 00:00:00.000
    BippHMRgBm9vMtqJV8CHxk8VCbcdfxFP3cwhsHnFH9wC
    		12273.1
    5
    		2025-05-31 00:00:00.0002025-06-07 00:00:00.000
    2CrnZHYWLAmnEanoVNKoQQ11xDPYjxXV585tsEXjYN53
    		9000
    6
    		2025-05-30 00:00:00.0002025-06-06 00:00:00.000
    ATNYVbHCyM1VCp8e5HBXcJYmeH4Tp3FZm9fqcRSNYsSb
    		7486.35
    7
    		2025-05-31 00:00:00.0002025-06-07 00:00:00.000
    GjQUGG2iL3azSSQZGrzUHv339wQssjt7yewk8QzzjV8j
    		3896.9
    8
    		2025-05-28 00:00:00.0002025-06-04 00:00:00.000
    7fsvGJQf7mYyBPjNLV87EhCMUTV91sU1GcVcLzCPp9a6
    		3000
    9
    		2025-05-29 00:00:00.0002025-06-05 00:00:00.000
    2R8GRZZNSZ4T9EmCKiCoAcmr58zNfzJsmwkm6ESKSuRx
    		2398.94
    10
    		2025-06-02 00:00:00.0002025-06-09 00:00:00.000
    6pE8XXRC4tXn8diKRTWJevRknEgQBSBcugYxaypmqnbR
    		2000
    11
    		2025-05-28 00:00:00.0002025-06-04 00:00:00.000
    6wxGmH6saWyTdhxV8MMhwwbNqSo3iZ5RHJ9GEu2nsYr1
    		1740
    12
    		2025-05-27 00:00:00.0002025-06-03 00:00:00.000
    6QG9yXVjUUY3ExFjReBVHLbDXXCXJWgdeNozXo9k2qek
    		1520
    13
    		2025-05-28 00:00:00.0002025-06-04 00:00:00.000
    D1ivYYzYb1FZUcdDcR3NF6AoP9Tg2RFAFfH1fa1s1nhb
    		1371.61
    14
    		2025-05-31 00:00:00.0002025-06-07 00:00:00.000
    AxkpbnNGf3fJ6EqPExxLgBVbx3LAGV4m3BqisgVbEv2Y
    		1275.96
    15
    		2025-05-28 00:00:00.0002025-06-04 00:00:00.000
    93EYQNxXtJFDShgFFd1pmJTroCnecNCNPZjvzXHu74VA
    		1252.92
    16
    		2025-05-28 00:00:00.0002025-06-04 00:00:00.000
    Akqe9WnaNPqoHw3oxmKKPjuuDbzhFTJr4FfCFXQZcaYR
    		1241.44
    17
    		2025-05-27 00:00:00.0002025-06-03 00:00:00.000
    EWnYxLz2x12SEWJu2uCPnviXv5JoP2oguLKq5DmwBGdr
    		1166.64
    18
    		2025-05-28 00:00:00.0002025-06-04 00:00:00.000
    2fPeFh4M6e6R1tjwUG2UAQNhczP8DLMpLEznGkkijGF9
    		1000
    19
    		2025-05-27 00:00:00.0002025-06-03 00:00:00.000
    36KkrE7zXMff7rDQV8qAQVP3kqNsChitKikodtfLkbMF
    		1000
    20
    		2025-05-31 00:00:00.0002025-06-07 00:00:00.000
    Fnmjk4HYre39xmwzr4Ubi65PrR6nR1MfomXRRyVdux4V
    		987.42
    ...
    339
    35KB
    5s