tubaecciProfits 3
    Updated 2025-01-06
    -- forked from Profits 2 @ https://flipsidecrypto.xyz/studio/queries/08b8e543-9558-4498-9c62-be4abeecda3a

    -- forked from Profits @ https://flipsidecrypto.xyz/studio/queries/ea81bd2b-e51d-4a31-83bf-c442f88d32e4

    WITH revenues AS(
    WITH optimism AS(
    WITH op AS(
    SELECT
    block_timestamp,
    to_address,
    tx_hash,
    tx_fee
    FROM optimism.core.fact_transactions
    WHERE block_timestamp >= TIMESTAMP '2024-01-01'
    )
    SELECT
    DATE_TRUNC ('{{period}}', block_timestamp) AS date,
    'optimism' AS chain,
    ROUND(SUM(tx_fee), 0) AS revenue_eth,
    ROUND(SUM(tx_fee * price), 0) AS revenue_usd,
    COUNT(*) AS transactions
    FROM op AS a
    LEFT JOIN optimism.price.ez_prices_hourly AS p ON DATE_TRUNC('hour', block_timestamp) = p.hour AND symbol = 'ETH'
    GROUP BY 1
    )
    SELECT *
    FROM optimism
    ),
    costs AS(
    WITH optimism AS(
    WITH op AS(
    SELECT
    block_timestamp,
    to_address,
    tx_hash,
    l1_fee
    Last run: about 1 month ago
    DATE
    CHAIN
    TRANSACTIONS
    PROFIT_ETH
    PROFIT_USD
    1
    2024-04-01 00:00:00.000optimism477368875.19251387.46
    2
    2024-09-16 00:00:00.000optimism514566473.47179367.44
    3
    2024-05-06 00:00:00.000optimism3797414118.66355721.09
    4
    2024-05-27 00:00:00.000optimism372153475.35288872.14
    5
    2024-01-29 00:00:00.000optimism261736787.7201865.15
    6
    2024-12-09 00:00:00.000optimism755065158.79227901.45
    7
    2024-05-13 00:00:00.000optimism361273173.74217469.19
    8
    2024-05-20 00:00:00.000optimism4175361144.36533849.02
    9
    2024-09-02 00:00:00.000optimism491974664.58152915.22
    10
    2025-01-06 00:00:00.000optimism3895760.955041.01
    11
    2024-01-01 00:00:00.000optimism2712078148.18344340.31
    12
    2024-01-22 00:00:00.000optimism294747542.9796766.14
    13
    2024-06-10 00:00:00.000optimism390271169.43248701.67
    14
    2024-12-30 00:00:00.000optimism571395613.1546816.58
    15
    2024-08-26 00:00:00.000optimism455281561.82157427.64
    16
    2024-06-24 00:00:00.000optimism347997972.78246835.76
    17
    2024-04-22 00:00:00.000optimism4861927130.38414946.63
    18
    2024-03-04 00:00:00.000optimism296396689.36331621.72
    19
    2024-10-07 00:00:00.000optimism572128230.2973926.26
    20
    2024-07-08 00:00:00.000optimism355530972.67224054.29
    54
    3KB
    33s