CREATOR_ADDRESS | TOTAL_COUNT | |
|---|---|---|
1 | MNhBbrscBPmeid54buiqSgyWa4D8PY6uKHoK2wJsTJN | 27682 |
2 | 6d22FozaKK239PoBYVffkYKA1QPQZE8fC7AQkpmHQfjp | 24841 |
3 | 36DWP52MVRDooYNrcRVDyoCh2R1fPXCYqKJQYg9pFQoE | 17122 |
4 | 4RePs4EchMosyRENfkUFwZcjgMsdTt9SzYMZomtvRQEi | 15779 |
5 | BwaVFCDJ4HfRfFWq1S23LHkk5VF4GKEw9oz7F1PxgcHv | 15661 |
6 | FiYwf895W6ntoitNvhVwBLS4uwKZmMhsxiQmYY44488U | 14869 |
7 | 83QQFLxcEzuJZaejBnzAiW5tyfyaRHMLZnkhJbRPRWtf | 14788 |
8 | B8xTCohpTmuR57pJ8ucKPZfBjdw3Lfkvii4deXRRrL4H | 14054 |
9 | C88rn1cz1PcRJFh44TuynaWbnRis4xuBRi65sD1Nwxog | 13123 |
10 | 9ZCrb9iKawp1e5Gw3r2BpHpCZQbHFg6DLguzQ5SkP2Eg | 13122 |
11 | 5Hyf6srdbrrD1HLjqxcFbXJRFBHgnwoZc7aZRj8vDuk5 | 13088 |
12 | Dq3fi8ZmBhkrwHFBChLk2pqV8iAGW9uuJP7coshGzqT6 | 12218 |
13 | 5UZ6SFoRbZb3Wesbxb8xai5416CGuY8SDFFg6DJGX74Y | 11163 |
14 | BfAgS1vsK2Wja56zxcBrMMdn6sFgTnMmZu3wi4XwiAt3 | 8317 |
15 | D3sovmjANgA8V27e5rnQft8kV3mocSH8gw9zwth3Ba9g | 8294 |
16 | 35WDroEZ7Kqwvxsy4XV2hmHBg25dyBUFWTXV8wn6Mm7U | 8073 |
17 | DUKVDysvzUK5tdfe1Y3kShdEtgHy7j92caUHSHHrECiW | 7465 |
18 | 3rYj2dThkPHXxX8UNyT6361dqpeQaAU2g3mpZrEwRbnM | 7243 |
19 | B9Zbs2W9VK22AHnCWiK4PqBueDFzN17RNAFu5uFozLMJ | 6995 |
20 | 5WuTSCsQ4dhSPLVsiZFyZMWQfRxvZaXxXsJ34bvvYapB | 6558 |
dethectiveAll creator
Updated 2025-03-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
WITH deploy_actions as (
select
date(block_timestamp) as datetime,
tx_id,
decoded_instruction:args:symbol :: varchar as symbol,
Decoded_instruction:accounts [0] :pubkey :: string as token_address,
signers [0] as creator_address
from
solana.core.fact_decoded_instructions
where
program_id = '6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P'
and event_type = 'create'
)
SELECT
CREATOR_ADDRESS,
COUNT(*) AS TOTAL_COUNT
FROM
deploy_actions
GROUP BY
CREATOR_ADDRESS
ORDER BY
total_count desc
Last run: 3 months ago
...
100000
5MB
12s