LTirrellNew user issue!!
    Updated 2022-11-29
    WITH solana_wallets AS (
    SELECT
    signers [0] AS address,
    MIN(DATE(block_timestamp)) AS creation_date
    FROM
    solana.core.fact_transactions
    GROUP BY
    address
    ),
    solana_new_wallets AS (
    SELECT
    address,
    creation_date
    FROM
    solana_wallets
    WHERE
    creation_date = '2022-11-17'
    )
    SELECT
    DISTINCT e.program_id AS program_id,
    t.signers [0] :: STRING AS signers
    FROM
    solana.core.fact_events e
    JOIN solana.core.fact_transactions t
    ON (
    e.tx_id = t.tx_id
    AND e.block_timestamp :: DATE = t.block_timestamp :: DATE
    )
    WHERE
    e.block_timestamp :: DATE = '2022-11-17'
    AND e.program_id = 'TokenVbSaLatYMStMWat8wXSi4tZg6uSnm8foP9zA2V'
    AND t.signers [0]::string IN (
    SELECT
    address
    FROM
    solana_new_wallets
    Run a query to Download Data