rezarwzBlast Economy
    Updated 2025-04-10
    with Compute_Costs as (
    SELECT
    date_trunc('{{interval}}', 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('{{interval}}', 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('{{interval}}', 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
    DATE
    Tx Fees
    Cumulative Tx Fees
    Blast Onchain Costs
    Cumulative Onchain Costs
    Revenue
    Cumulative Revenue
    1
    2025-03-01 00:00:00.00022.648221126059.226499113-3.051985702-2678.45611005819.5962354183380.770389055
    2
    2024-05-01 00:00:00.000926.0100557474270.360575897-347.653841982-2518.070886145578.3562137651752.289689753
    3
    2024-06-01 00:00:00.0001055.7336339185326.094209815-84.179447864-2602.250334009971.5541860542723.843875807
    4
    2024-11-01 00:00:00.00074.4853270635887.582480461-13.98901264-2631.42173137160.4963144223256.16074909
    5
    2024-12-01 00:00:00.00062.045539295949.628019751-22.469736675-2653.89146804639.5758026153295.736551705
    6
    2025-04-01 00:00:00.0001.1544528956060.380952008-1.458624071-2679.91473413-0.30417117653380.466217878
    7
    2024-04-01 00:00:00.000979.196999733344.35052015-639.944376395-2170.417044163339.2526233341173.933475987
    8
    2024-09-01 00:00:00.00075.8935953195751.261442586-1.589999561-2614.69806616274.3035957573136.563376424
    9
    2024-07-01 00:00:00.000179.1629138165505.257123631-7.609028186-2609.859362195171.553885632895.397761436
    10
    2024-10-01 00:00:00.00061.8357108125813.097153398-2.734652568-2617.4327187359.1010582433195.664434668
    11
    2024-08-01 00:00:00.000170.1107236365675.367847268-3.248704406-2613.108066601166.8620192313062.259780667
    12
    2024-02-01 00:00:00.000233.608478329233.608478329-323.543147623-323.543147623-89.934669294-89.934669294
    13
    2025-02-01 00:00:00.00039.0440386096036.578277993-5.480720215-2675.40412435633.5633183943361.174153636
    14
    2025-01-01 00:00:00.00047.9062196325997.534239383-16.031936095-2669.92340414131.8742835383327.610835243
    15
    2024-03-01 00:00:00.0002131.5450420912365.15352042-1206.929520145-1530.472667768924.615521947834.680852653
    15
    2KB
    41s