HOUR_DAY | DEPLOYED_TOKEN | CUMULATIVE_DEPLOYED_TOKEN | |
|---|---|---|---|
1 | 2024-11-06 00:00:00.000 | 10 | 10 |
2 | 2024-11-07 00:00:00.000 | 147 | 157 |
3 | 2024-11-08 00:00:00.000 | 137 | 294 |
4 | 2024-11-09 00:00:00.000 | 102 | 396 |
5 | 2024-11-10 00:00:00.000 | 77 | 473 |
6 | 2024-11-11 00:00:00.000 | 173 | 646 |
7 | 2024-11-12 00:00:00.000 | 125 | 771 |
8 | 2024-11-13 00:00:00.000 | 182 | 953 |
9 | 2024-11-14 00:00:00.000 | 68 | 1021 |
10 | 2024-11-15 00:00:00.000 | 206 | 1227 |
11 | 2024-11-16 00:00:00.000 | 123 | 1350 |
12 | 2024-11-17 00:00:00.000 | 158 | 1508 |
13 | 2024-11-18 00:00:00.000 | 203 | 1711 |
14 | 2024-11-19 00:00:00.000 | 196 | 1907 |
15 | 2024-11-20 00:00:00.000 | 133 | 2040 |
16 | 2024-11-21 00:00:00.000 | 164 | 2204 |
17 | 2024-11-22 00:00:00.000 | 169 | 2373 |
18 | 2024-11-23 00:00:00.000 | 158 | 2531 |
19 | 2024-11-24 00:00:00.000 | 196 | 2727 |
20 | 2024-11-25 00:00:00.000 | 171 | 2898 |
dethectivePumpfun creation trendline
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
›
⌄
WITH creation_by_address 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'
AND creator_address = '{{creator_address}}'
)
SELECT
DATE_TRUNC('hour', datetime) AS hour_day,
COUNT(token_address) AS deployed_token,
SUM(COUNT(token_address)) OVER (ORDER BY DATE_TRUNC('hour', datetime)) AS cumulative_deployed_token
FROM creation_by_address
GROUP BY hour_day
ORDER BY hour_day
Last run: 3 months ago
...
141
5KB
0s