rain_syndicaSAMO Airdrop Recipients
    WITH

    airdrops AS (
    SELECT
    *
    FROM solana.core.fact_transfers
    WHERE block_timestamp < '2021-05-30'
    AND block_timestamp >= '2021-04-23'
    AND tx_from = 'samohexDip23Xe39eKrndWG25QWSnnckUa2Yc3iEe9v'
    AND mint = '7xKXtg2CW87d97TXJSDpbD5jBkheTqA83TZRuJosgAsU'
    -- ORDER BY block_timestamp DESC
    )

    SELECT
    date_trunc(day, block_timestamp) AS day,
    SUM(amount) AS amount,
    COUNT(DISTINCT tx_to) AS num_recipients
    FROM airdrops
    WHERE day = TO_DATE('2021-04-23')
    GROUP BY 1
    ORDER BY 1