Date | Volume / Hour | Particle Accelerator (ATLAS) | |
|---|---|---|---|
1 | 2025-06-18 14:00 | 312,500 | 0.03875 |
2 | 2025-06-18 11:00 | 305,152 | 0.0385 |
3 | 2025-06-17 12:00 | 1,515,100 | 0.03695923 |
4 | 2025-06-13 10:00 | 1,721,469 | 0.03598589 |
5 | 2025-06-13 04:00 | 261,840 | 0.03586 |
6 | 2025-06-11 04:00 | 1,512,200 | 0.03335049 |
7 | 2025-06-10 21:00 | 75,000 | 0.03299298 |
8 | 2025-06-09 21:00 | 30,000 | 0.033 |
9 | 2025-06-08 19:00 | 50,000 | 0.03255555 |
10 | 2025-06-05 22:00 | 10,000 | 0.03111109 |
11 | 2025-06-04 21:00 | 30,000 | 0.03336965 |
12 | 2025-06-04 17:00 | 1,300 | 0.03336966 |
13 | 2025-06-02 04:00 | 515,000 | 0.03443107 |
14 | 2025-06-01 17:00 | 60,000 | 0.034 |
15 | 2025-05-30 20:00 | 20,000 | 0.03467497 |
16 | 2025-05-30 13:00 | 100,000 | 0.03467499 |
17 | 2025-05-29 02:00 | 663,000 | 0.03246633 |
18 | 2025-05-29 00:00 | 1,229,541 | 0.0304929 |
19 | 2025-05-27 22:00 | 50,000 | 0.030495 |
20 | 2025-05-26 20:00 | 40,000 | 0.030991 |
DatarunnerParticle Accelerator
Updated 20 hours ago
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
›
⌄
--Particle Accelerator
WITH
tx_list AS (
SELECT
TO_VARCHAR(DATE_TRUNC('HOUR', block_timestamp), 'YYYY-MM-DD HH24:MI') AS date,
--TO_VARCHAR(DATE_TRUNC('DAY', block_timestamp), 'YYYY-MM-DD HH24:MI:SS') AS date,
inner_instruction:instructions[0]:parsed:info:tokenAmount:uiAmount AS total_des_frais,
inner_instruction:instructions[1]:parsed:info:tokenAmount:uiAmount AS total_hf,
inner_instruction:instructions[2]:parsed:info:tokenAmount:uiAmount AS volume_total,
total_hf + total_des_frais AS montant_total,
inner_instruction:instructions[0]:parsed:info:mint::string = 'ATLASXmbPQxBUYbxPsV97usA3fPQYEqzQBUHgiFCUsXx' AS ATLAS,
inner_instruction:instructions[0]:parsed:info:mint::string = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' AS USDC,
inner_instruction:instructions[2]:parsed:info:mint::string = 'PTCLSWbwZ3mqZqHAporphY2ofio8acsastaHfoP87Dc' AS Particle_Accelerator,
CASE
WHEN ATLAS THEN (total_hf + total_des_frais) / NULLIF(volume_total, 0)
END AS prix_unitaire_ATLAS,
CASE
WHEN USDC THEN (total_hf + total_des_frais) / NULLIF(volume_total, 0)
END AS prix_unitaire_USDC,
CASE
WHEN ATLAS THEN 'ATLAS'
WHEN USDC THEN'USDC'
END AS devise
FROM
solana.core.fact_events
WHERE
program_id = 'traderDnaR5w6Tcoi3NFm53i48FTDNbGjBSZwWXDRrg'
AND succeeded = 'true'
AND block_timestamp >= DATEADD(DAY, -90, CURRENT_TIMESTAMP())
AND Particle_Accelerator
AND devise IN ('USDC', 'ATLAS')
),
final AS (
Last run: about 20 hours agoAuto-refreshes every 12 hours
64
3KB
5s