DT | COST_L1_GWEI | COST_L1_ETH | |
|---|---|---|---|
1 | 2023-07-04 00:00:00.000 | 986074462.690089 | 0.9860744627 |
2 | 2023-07-05 00:00:00.000 | 130012985.532522 | 0.1300129855 |
3 | 2023-07-06 00:00:00.000 | 1314935560.30584 | 1.31493556 |
4 | 2023-07-07 00:00:00.000 | 1490501690.9998 | 1.490501691 |
5 | 2023-07-08 00:00:00.000 | 901032981.671829 | 0.9010329817 |
6 | 2023-07-09 00:00:00.000 | 818081161.636722 | 0.8180811616 |
7 | 2023-07-10 00:00:00.000 | 1007492946.22265 | 1.007492946 |
8 | 2023-07-11 00:00:00.000 | 1012768819.23975 | 1.012768819 |
9 | 2023-07-12 00:00:00.000 | 1246600532.56422 | 1.246600533 |
10 | 2023-07-13 00:00:00.000 | 1451586015.68727 | 1.451586016 |
11 | 2023-07-14 00:00:00.000 | 1104120293.13069 | 1.104120293 |
12 | 2023-07-15 00:00:00.000 | 649284377.959346 | 0.649284378 |
13 | 2023-07-16 00:00:00.000 | 729250973.704724 | 0.7292509737 |
14 | 2023-07-17 00:00:00.000 | 1013061254.56129 | 1.013061255 |
15 | 2023-07-18 00:00:00.000 | 1371822470.5945 | 1.371822471 |
16 | 2023-07-19 00:00:00.000 | 1151907863.74418 | 1.151907864 |
17 | 2023-07-20 00:00:00.000 | 1226840733.64063 | 1.226840734 |
18 | 2023-07-21 00:00:00.000 | 1315132105.39408 | 1.315132105 |
19 | 2023-07-22 00:00:00.000 | 878022953.341423 | 0.8780229533 |
20 | 2023-07-23 00:00:00.000 | 927220984.131127 | 0.9272209841 |
10Blockchain2. Calculer le coût payé sur Ethereum (L1)
Updated 2025-02-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH daily_l1 AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS dt,
-- On suppose que effective_gas_price est en gwei et gas_used en gas units.
-- Donc le produit se retrouve en gwei (car gwei * gas).
SUM(gas_used * effective_gas_price) AS cost_l1_gwei
FROM ethereum.core.fact_transactions
WHERE from_address = LOWER('0x2f40D796917ffB642bD2e2bdD2C762A5e40fd749')
GROUP BY 1
)
SELECT
dt,
cost_l1_gwei,
-- 1 gwei = 1e-9 ETH
(cost_l1_gwei / 1e9) AS cost_l1_eth
FROM daily_l1
ORDER BY dt;
Last run: 2 months ago
...
599
34KB
16s