MilesFinch# of Unique Program IDs Interacting with Token copy
    Updated 2023-02-06


    WITH t0 AS (
    SELECT tx_id
    , block_timestamp
    , mint
    FROM solana.core.fact_transfers
    WHERE block_timestamp >= '2023-01-01'
    AND mint IN (
    'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    , 'Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB'
    , 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263'
    , 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'
    , '4k3Dyjzvzp8eMZWUXbBCjEvwSkkk59S5iCNLY3QrkX6R'
    , '7dHbWXmci3dT8UFYWYZweBLXgycu7Y3iL6trKn1Y7ARj'
    , '7xKXtg2CW87d97TXJSDpbD5jBkheTqA83TZRuJosgAsU'
    , '7vfCXTUXx5WJV5JADk17DUJ4ksgau7utNKj4b963voxs'
    , 'SRMuApVNdxXokk5GT7XD5cUUgXMBCoAz2LHeuAoKWRt'
    , 'MNDEFzGvMt87ueuHvVU9VcTqsAP5b3fTGPsHuuPA5ey'
    , 'DUSTawucrTsGU8hcqRdHDCbuYhCPADMLM2VcCb8VnFnQ'
    , 'orcaEKTdK7LKz57vaAYr9QeNsVEPfiu6QeMU1kektZE'
    , 'SHDWyBxihqiCj6YekG2GUr7wqKLeLAMK1gHZck9pL6y'
    , 'USDH1SM1ojwWUga67PGrgFWUHibbjqMvuMaDkRJTgkX'
    , 'HZRCwxP2Vq9PCpPXooayhJ2bxTpo5xfpQrwB1svh332p'
    )
    GROUP BY 1, 2, 3
    ), t1 AS (
    SELECT tx_id
    , block_timestamp
    , program_id
    FROM solana.core.fact_events
    WHERE block_timestamp >= '2023-01-01'
    GROUP BY 1, 2, 3
    ), t3 AS (
    SELECT mint
    , COUNT(DISTINCT program_id) AS n
    Run a query to Download Data