0xgabedivine-red
    Updated 2024-10-29
    WITH airdrop_claims as (

    SELECT
    tx_to,
    sum(amount) as total_amount

    FROM solana.core.fact_transfers
    WHERE MINT = 'Grass7B4RdKfBCjTKgSqnXkqjwiGvQyFbuSCUJr3XXjs'
    AND block_timestamp >= '2024-10-28 13:30'
    -- These are the original wallets that receive Grass from the deployer 31rYart
    AND tx_from in (
    '2T3oQLrTRnnx6rYBUnAx6kThfvWwkczbUJ64jAeejHr8',
    '5yPiqkiKQa9Q4DsFnTat3pkKZCzA1eFeiXx9TFCn9KnX',
    '6op4vvD7he9Nqs6eXCQvRmDtGYzMkRoDYcFUfF7pK5YS',
    '7GVHcNVYWsobVjb9kHtdzg34bDoAKMd7sJ513bNEYL9o',
    '8fxxfjUmFznBaK2xucnu68CiVXGHvZpryt7jpDZsLMr7',
    '9RKdvUKziPrCQJd14m375JeYY9BQgGpNoc3w9hHgbdjb',
    'BK9e4rUTBFXqxrJzcv6YA4JG3eTeWjWkZ1LJjdprQsxa',
    'Bi8y3ZF5JvUwMgLEvM7j72sLX9gD3sMucmX8hrDmE7Hr',
    'Bq9b3RsjiqnH1Y7nzvGXKMzSLzKcwuGGSuBrrPY6rcHS',
    'C3qi9Lc5AvwXp1VwFQMk8wLEFFYvG4N92tCZ35g75Rjr',
    'CTiDpM4X4bc5C3EcGZYdiD2kTY6vFBgAKzNa9rB3hG79',
    'CvxWhuzrwmXe1m1TKfhWa3nF54N77vfSCQiLh3W8DrH',
    'DJzmmuQLuKXoBC9idZn9MwNTattwv5qCceDjVKNWETXL',
    'E5mLwjzSChZUW3MVNDkdkESGeLZv1ck3ndowQkc2rwqM',
    'Eb9ZQcM2yagrocMLZpcb9b4K2HzdfBEYtqpL55RSp5pN',
    'Epb8icWaRatgh33vyAHYZ8j1Yx4GRD65EZL5Xu2FzicC',
    'G5B6Fegg1zWf3u2DoKGJ9Epqo7GfXba21wVrZrzQJQ6m',
    'Gt4bqEXrcCPGvhxtvu4NQN4jRjSMGHN8NqCyfJmAWQPd',
    'J4VkdzwowLt5BaJw1QWNFQ94wERZKkKPrJdeEKpphvdS',
    'NSPDfsQFPV692vGUkEb9kMtuFJg4GKVLk9VJZ4LTS4x',
    'e81v16WDLgMeEPPUsmZmiRmAAtYBjSW3jgTHQgPZyM1',
    'uCX9hMtztotWJq4LLpdBZqwqJFL62BoKua1425gDoVo',
    'BoQ2RkkY5VqsgJ1nhs4eMrQqiZyqq9dfQMJJCZcNx9ic',
    '2nJWSpaiikN5xGeZjv9j3aToLjA16cyZZiFg15nzmjrE'
    QueryRunArchived: QueryRun has been archived