Date | Volume / Hour | Copper Ore (ATLAS) | |
|---|---|---|---|
1 | 2025-04-15 04:00 | 16,929,979 | 0.00078111 |
2 | 2025-04-13 08:00 | 13,025,324 | 0.00078108 |
3 | 2025-04-11 06:00 | 5,364,202 | 0.00081499 |
4 | 2025-04-09 05:00 | 1,000,000 | 0.000815 |
5 | 2025-04-08 00:00 | 2,000,000 | 0.00082855 |
6 | 2025-04-06 17:00 | 35,830,046 | 0.00075111 |
7 | 2025-04-06 14:00 | 981,749 | 0.00074108 |
8 | 2025-04-04 18:00 | 1,069,999 | 0.00075111 |
9 | 2025-04-04 04:00 | 9,700,150 | 0.00078999 |
10 | 2025-04-01 18:00 | 10,000,000 | 0.00082 |
11 | 2025-03-31 07:00 | 344,915 | 0.0007987 |
12 | 2025-03-31 06:00 | 5,000,000 | 0.00082 |
13 | 2025-03-30 20:00 | 82,328 | 0.00079 |
14 | 2025-03-30 04:00 | 5,703,124 | 0.00078781 |
15 | 2025-03-24 21:00 | 1,000,000 | 0.00089995 |
16 | 2025-03-24 18:00 | 15,415,616 | 0.00089997 |
17 | 2025-03-23 16:00 | 1,000,000 | 0.00092899 |
18 | 2025-03-23 09:00 | 2,000,000 | 0.00092899 |
19 | 2025-03-22 20:00 | 1,000,000 | 0.00092899 |
20 | 2025-03-22 12:00 | 11,000,000 | 0.00084 |
DatarunnerCopper Ore
Updated 2 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
›
⌄
--Copper Ore
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 = 'CUore1tNkiubxSwDEtLc3Ybs1xfWLs8uGjyydUYZ25xc' AS Copper_Ore,
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 Copper_Ore
AND devise IN ('USDC', 'ATLAS')
),
final AS (
Last run: about 2 hours agoAuto-refreshes every 12 hours
...
135
6KB
36s