Chiefdistinct tokens faster copy
    Updated 2023-05-30
    -- forked from distinct tokens faster @ https://flipsidecrypto.xyz/edit/queries/46e6d0a1-b768-49d0-bf68-76032b04de8a

    WITH events AS (
    SELECT
    tx_id
    FROM
    solana.core.fact_events
    WHERE
    program_id = 'E1XRkj9fPF2NQUdoq41AHPqwMDHykYfn5PzBXAyDs7Be'
    AND block_timestamp >= current_date - 30
    -- AND block_timestamp >= '2022-11-05'
    AND succeeded
    ),
    trades AS (
    SELECT
    mint.VALUE:mint::STRING AS mint,
    mint.value:owner as owner
    FROM
    solana.core.fact_transactions t,
    LATERAL FLATTEN(INPUT => t.pre_token_balances) mint
    WHERE
    block_timestamp >= current_date - 30
    -- block_timestamp >= '2022-11-05'
    AND tx_id IN (
    SELECT
    tx_id
    FROM
    events
    )
    )
    -- mints as (
    SELECT
    distinct mint
    FROM
    trades
    WHERE
    Run a query to Download Data