TRANSACTIONS | CREATORS | TOKENS_CREATED | |
|---|---|---|---|
1 | 8128922 | 3795950 | 8128989 |
Afonso_DiazTotal
Updated 2025-02-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
main as (
select
tx_id,
signers[0] as creator,
decoded_instruction:args:symbol as symbol,
decoded_instruction:accounts[0]:pubkey as token_address
from
solana.core.fact_decoded_instructions
where
year(block_timestamp) >= 2024
and program_id = '6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P'
and event_type = 'create'
)
select
count(distinct tx_id) as transactions,
count(distinct creator) as creators,
count(distinct token_address) as tokens_created
from
main
Last run: 2 months ago
1
27B
28s