rain_syndicaBERN Airdrop Recipients FluxBeam Net Trade Activity 7 Days copy
    Updated 2023-06-21
    WITH

    dates AS (
    SELECT
    date, auto_wallet_type
    FROM
    (
    VALUES
    ( 'T', 'Holder' ),
    ( 'T+1', 'Holder' ),
    ( 'T+2', 'Holder' ),
    ( 'T+3', 'Holder' ),
    ( 'T+4', 'Holder' ),
    ( 'T+5', 'Holder' ),
    ( 'T+6', 'Holder' ),
    ( 'T+7', 'Holder' )
    ) AS dates_temp ( date, auto_wallet_type )
    ),

    airdrop AS (
    SELECT
    tx_to AS recipient,
    MIN(block_timestamp) AS block_timestamp
    FROM solana.core.fact_transfers
    WHERE mint = 'CKfatsPMUf8SkiURsDXs7eK6GWb4Jsd6UDbs7twMCWxo'
    AND tx_from = '7MyTjmRygJoCuDBUtAuSugiYZFULD2SWaoUTmtjtRDzD'
    AND block_timestamp >= '2023-05-25'
    AND block_timestamp <= '2023-05-31'
    GROUP BY 1
    ),

    airdrop_recipients AS (
    SELECT *
    FROM airdrop a CROSS JOIN dates b
    ORDER BY recipient, date
    ),
    Run a query to Download Data