crypto_edgarWhite Hat Claimed Wallets
    Updated 2024-02-02
    select
    instruction:accounts [4] as WALLET_CLAIMED_FOR,
    AMOUNT,
    BLOCK_TIMESTAMP,
    solana.core.fact_transfers.TX_ID
    from
    solana.core.fact_events
    inner join solana.core.fact_transfers using(block_timestamp, tx_id)
    where
    succeeded
    and block_timestamp >= '2024-01-31 14:00:00'
    and block_id >= 245286497
    and program_id = 'meRjbQXFNf5En86FXT2YPz1dQzLj4Yb3xK8u1MVgqpb'
    and mint = 'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN'
    and TX_TO = 'HF88dwazGWNq7XuiTPh36DLh6ABnXzp6uqyg7PyeN4ZJ'
    order by amount desc
    Last run: about 1 year ago
    WALLET_CLAIMED_FOR
    AMOUNT
    BLOCK_TIMESTAMP
    TX_ID
    1
    4rypSJu34LMg3sfjFZY9w67KW8UbDmEh6KVnmmmwDF9M
    202002024-01-31 16:00:25.000
    2X7qdausfwyduqzW1kkBHcX8TyN1uVA1j7DmkfFWVg3aUpVC8746aGpzNWbMroejr2C97QFg...
    2
    8Gm72oF3898f6uirCxd1Lsppz76JEEtqSPkLQVxP8k2j
    37002024-01-31 15:35:42.000
    53gxysVyefSTrnduwBLvNdhujYY9tkwbsSW5AUhTGcN5FUXgDhkHSdzpD7NtPsC2XFhwvRY1...
    3
    BUeHZ7XVP9FubCJdvip9EuRm9XSE5fvR2JDErj56jLmg
    37002024-01-31 15:47:54.000
    3xjZRSYKfgGtKeccJiDmbi1uzD8jUC1vxrob5V2veyMio4p1jQYDfTD6CuJHQTxdSx4ZdZef...
    4
    896pzK7BDRdkKMVfvAYYb7fMNP7pY4cKE6Kf1KZu2HWX
    37002024-01-31 15:24:37.000
    2r1dz4KkGWqRdApCmiafb9WWFP7uTdNCTvhZe3j36aoP1ms4VTNosmuWzpX3xuZ9LiBXEDwA...
    5
    3cBJVSo8DhexxyRHQTJaxtWPNGrQYukrMDG2vDkHADiT
    37002024-01-31 15:11:01.000
    L52ZFoqNw7EvRCFPhVPmArJrHtCHdu3wvi3mr3gskCyCgwG7NUKHBjj1Djknc5Jwht5MqRG3...
    6
    Be2Ec9REaFYRcuHhtLN9hfsniFWe19LEmy3xFnkrSmv5
    34502024-01-31 15:35:20.000
    63CLcV5UzPKkZMAWycUyLhtjCLKAmWeRtLEhnUWmWNk3nda7uTyeuee5csVvDSP4KHen8YEA...
    7
    99dj2ZpEXJ199gKxjm4WMumbEpd7kWwEXV36HCheDKET
    34502024-01-31 15:48:03.000
    35UhZ3sAgkcfKm1EmMfvvS6kb7eypp5Chg1tcpVZu3RQsiFMC613GAT2kTyZBBVxswz76k8S...
    8
    9D6g8RNjhMbYoWWcdr2PxMBrDujWfjrUHHTHmdB3joQh
    34502024-01-31 15:48:11.000
    3fzZfwn4b1i2ZtJ9C7kYj1tWMjeA5NEhutbvqFAqCAxYY22csJDei6HkAky73ovfB4GEvWLQ...
    9
    CbddEcFZNny3yvt788zR7jvZ9jHyF4dpbUVhvVSyAgew
    34502024-01-31 15:24:36.000
    3AvXHntMByun8fCgF2G6u3QP5vmnaomuSYizUsG8JaZnChUwmKabNVM3KoHTDnrFhUoq892H...
    10
    8VxPo4fuqsgi7R5n4cir9rNfScg7TNfYKUbAj2A8Voef
    34502024-01-31 15:24:36.000
    2vL8gKVMWFSi8KCq1jR5jAhDrmo3wVxAvBpnZYMdErDc3YBtNfvuW6raNaZLgn1TB9kRfm8X...
    11
    DhVF9mfH8v522GY4uK7D1oQRPg7QjBfRTiDmk4dJ6GaY
    34502024-01-31 15:54:47.000
    TgAvfFma6MuKR6p5m51JRETfXv4TnrUrn8AEZ3Y3GVYREM9XnTgVhkKvtV1wZJnKxrHJ47TB...
    12
    3FxuavEH7C34ngz9tozeACEtAaEUMUvDbxQzxtZRpxJo
    34502024-01-31 15:54:47.000
    3HNxfWhwfrUFNmKcDY7Rumnw43dQJybK9jBKmiCpErqfXe86yHBSWLuo162m41XfYAfp6X2j...
    13
    HrDrvnVn2mnAmGjU2EKVw4ZdkZnQgADFjv3teHX84ssk
    34502024-01-31 15:48:02.000
    5eKg8dWCpt4pcKGLp9BihLN2xibFaYjyJzamtMe8sSA17ATWyYeLouc3Zr9vowdieV3C3WEE...
    14
    Hu4TMzrzugVQhbXBD5Dx8TGTmNi84ZiRhW5pavDLD8Gy
    32002024-01-31 15:14:07.000
    4W56n469b9wkyBeGXkmTnZyBGmz4VWNsS7fyLxqSQLJugxxwL6BsDcZi1e75qbysZrFY8o9E...
    15
    9jriZrCrkVqAwkKzAVeq9mYyEo2eYrcx1sJwfK7KnDKX
    32002024-01-31 15:47:56.000
    5DmSQRnhUJXDiQE6agK7uSokTdEehdfrMVLff7wxf29MnBKmpjwVcoFozBRDZwqHkqR246ik...
    16
    4dY9LuCKuBFsHHiFZ6UPFJzc9HZoxSvKnQaxMb8FiQMR
    32002024-01-31 15:32:16.000
    BYryUbLgZ7kmQP6icoqsVdpno1jkdZRCcCR8aCQTLNAXkapjKjwxNfWCrBCJj2nVnp7sWvdX...
    17
    CiFrFhpR8wDTsZfPqjsbxK4R6Axi5u4UWfgRxJjk5BhS
    32002024-01-31 15:33:56.000
    5tDfsU3cQxdWUfMPQjQsyBA2APAAFaNMYan6eQGyosSXPq72P2zfHcr9bPuwhd6hduNGdnG8...
    18
    AJrSjmGkrscQmuWw6AfPM4rWP4Rep8poDEbNQhvjnz12
    32002024-01-31 16:30:49.000
    574JWi7cBuMq5Gq6BHAxfWPuSrfKN3oyL4c8tqJJN7bPRGsqMtqnL76EVCy4sSgXQ5wbKgqC...
    19
    ETmQhLesD8phhTdeXgUDnsqULjMcTai3u9Ht2wyGxZSq
    32002024-01-31 15:48:01.000
    51z9SV7NqXfT4Sd4E4orfmX8Rj5hsBo9jfpgt5W83fRcbo7TxyGZ5JyNhfFPQHH7mfpSersv...
    20
    Arpg2wqnWZ76UX4Tka1WhanufGKkfaK2gktjDYocNtN6
    32002024-01-31 15:10:55.000
    4L3PWNnrgt2cJeXorbbfBKw8br4Vkmsk6TRZKcZrMKRhroY58efeezotWvihx21jfPYcN2Hv...
    ...
    2379
    395KB
    8s