flipside

    All PSG1 NFT holders
    piperAll PSG1 NFT holders
    Updated 2025-01-10
    WITH all_PSG1_holder AS (
    SELECT
    DISTINCT(INSTRUCTION:accounts[4]) AS wallets
    FROM
    solana.core.fact_events
    WHERE
    SUCCEEDED = TRUE
    AND BLOCK_TIMESTAMP >= '2024-10-14'
    AND PROGRAM_ID = 'CoREENxT6tW1HoK8ypY1SxRMZTcVPm7R94rH4PZNhX7d'
    AND INSTRUCTION:accounts[3] = 'PSG1TGSniaZTFdzcxz8G5JaQ4oa8k2cSa9YZiqKTGu6'
    ),

    all_SEEKER_PSG1_holder AS
    (
    SELECT

    -- and program_id = 'TokenzQdBNbLqP5VEhdkAS6EPFLC1PHnBqCXEpPxuEb'
    -- and instruction :parsed :info :mint = '2DMMamkkxQ6zDMBtkFp8KH7FoWzBMBA1CGTYwom4QH6Z'

    ),

    all_SAGA_PSG1_holder AS (

    solana.core.fact_transfers.block_timestamp >= '2024-01-16'
    AND solana.core.fact_transfers.mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    AND solana.core.fact_transfers.tx_to = '5EiuwvpjXx44QRi5ro48DwBkUeaQ3VHNKVtkLdZJy9P3'
    AND solana.core.fact_transfers.amount between 440 AND 460
    AND solana.core.fact_transfers.index = '2'

    )
    Last run: 2 months ago
    WALLETS
    1
    9jdCY1uQSSe7Ykk9jr9h8Qfy537ZNRpu5JG3bs7LwiTd
    2
    B8Xbx8Sg7Jf57X4dDwvWbygT1n4ve2gGqkLqTrDkWAe9
    3
    EQfNfmnF1wjaSGsAa8TFBEzXVea3WukowtDNasjm6qKK
    4
    AdAhPGUUj6gAt47tyKZ5fYx7d7kt3y2P2Q8TKoMeSL3C
    5
    A7pXFD6v5K6SWtn8HwyJGcgejXJqb126R3RYbDTRFHJs
    6
    6p8gdUjWyygcMfVdH5eHX7nJFidmD4K2YXTucHTM2Hz7
    7
    7Y2pcSM9DcL5KDTMHgy5cYZ7c23xH3v5PZ6YepFzMw8k
    8
    D5yMjG9A69npcUrQqHqouLnysH5a8F672keM7pu4gqVK
    9
    9ygWhJFXFuxxHmnRuuRkA2eRi1t8SAiMakJDQzq97ybM
    10
    EaykVr3P7eCAtrEMDJQr9Pq6TXcMuAWdHTAQ5RRXk8ME
    11
    Cz3WBSeXy5aK2eR4WfFwSWNcseart5Fg3spmx2X5WUeJ
    12
    AbcMEYwq6gUHLiFVEVsUm3LT5B1ghiioS1oBr6Pv3r8z
    13
    ApTM4NsEVTV9HTTtL7TtiR33MeH4FV5X2wXAr1ba8s5B
    14
    7XvcGseZEt8C4z1jG3pkLQevJkWkEUAZnZXWF2E6HydL
    15
    DqHpahFvsThvo9Lf4TKjX8TcJ7e3G38cTva3SqQ3f1jz
    16
    64BX1McVSowQqGkWnz64uyvNGViiuP3HNCr6yCwjpYtd
    17
    AXyTNw2ECjSwRNctRgLNopC8nnLgETRsGNNMPzj23jFh
    18
    o5XKsycXsEHYqSQnUDKYNBZVqDQKjeCcS8PwitjQinY
    19
    4gieArZVMVUTE5J7DnqKZ4Ft2gv9rFYNzvGvYE617DWD
    20
    21b33Xgw9Jygae8a74jGfU6cHLcnef1SjQ2TmoGMFmBX
    ...
    3582
    171KB
    3s