Total Onchain Costs | Total Revenue | |
|---|---|---|
1 | 2679.91473413 | 3380.466217878 |
rezarwzkey blast
Updated 2025-04-10
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
›
⌄
with Compute_Costs as (
SELECT
date_trunc('month', BLOCK_TIMESTAMP) as date,
- sum(tx_fee) as "Compute Costs"
FROM
ethereum.core.fact_transactions
where
from_address = '0x082b616ec99167b2fedee053f07db6795d4da821'
group by
1
),
overhead_costs as (
SELECT
date_trunc('month', BLOCK_TIMESTAMP) as date,
- sum(tx_fee) as "Overhead Costs"
FROM
ethereum.core.fact_transactions
where
to_Address in (
'0x364289230b8cc7d9120ef962af37ebcfe23ce883',
'0x4f72ee94b8ba3be7f886565d3583a7f636c58b05'
)
group by
1
),
total_tx_fee as (
SELECT
date_trunc('month', BLOCK_TIMESTAMP) as date,
sum(tx_fee) as "Tx Fees"
FROM
blast.core.fact_transactions
group by
1
),
call_data_costs as (
SELECT
Last run: 17 days ago
1
32B
59s