MilesFinch# of Unique Program IDs Interacting with Token copy
Updated 2023-02-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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