flipside

    Eth Valuation 1
    Pine AnalyticsEth Valuation 1
    Updated 2025-02-17
    with tab1 as (
    SELECT
    date(hour) as day,
    median(price) as eth_price
    FROM
    ethereum.price.ez_prices_hourly
    WHERE
    token_address LIKE lower('0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2')
    GROUP by
    1
    )
    SELECT
    --*
    date_trunc('month', block_timestamp) as month,
    CASE
    when tx_type = 0 then 'Legacy transactions'
    when tx_type = 1 then 'Access List transactions'
    when tx_type = 2 then 'EIP-1559 transactions'
    when tx_type = 3 then 'Blob transactions'
    end as tx_type,
    sum(tx_fee) as fees_eth,
    count(DISTINCT tx_hash) as events,
    sum(tx_fee * eth_price) as fees_usd,
    FROM
    ethereum.core.fact_transactions
    LEFT outer join tab1 on day = date(block_timestamp)
    WHERE
    block_timestamp > '2022-03-13' --WHERE from_address like '0x5050f69a9786f081509234f1a7f4684b5e5b76c9'
    --AND block_timestamp > '2024-01-15'
    --GROUP BY 1
    --LIMIT 100
    --WHERE TX_TYPE = 3
    GROUP BY
    1,
    2
    Last run: 2 months ago
    MONTH
    TX_TYPE
    FEES_ETH
    EVENTS
    FEES_USD
    1
    		2023-08-01 00:00:00.000Legacy transactions8623.988003466453201715150153.9382741
    2
    		2024-11-01 00:00:00.000Legacy transactions4898.397837246508586615350896.7789783
    3
    		2025-01-01 00:00:00.000Legacy transactions3516.424512559501048711748651.8381268
    4
    		2023-12-01 00:00:00.000EIP-1559 transactions129827.41986959529842204291344250.928831
    5
    		2023-05-01 00:00:00.000Access List transactions1819.134105019899813360341.49924363
    6
    		2024-05-01 00:00:00.000Blob transactions242.2225907169994865310.396394559
    7
    		2023-11-01 00:00:00.000Access List transactions734.7595434731328471461492.32660511
    8
    		2024-03-01 00:00:00.000Blob transactions297.8872521891062101086135.92027233
    9
    		2024-07-01 00:00:00.000Legacy transactions2165.65314308252103687119758.21948964
    10
    		2024-07-01 00:00:00.000Access List transactions154.830668522195665510654.572904585
    11
    		2025-01-01 00:00:00.000Blob transactions308.1091514712635131029194.33989185
    12
    		2023-06-01 00:00:00.000Legacy transactions8605.400921485485159015649881.0467754
    13
    		2023-07-01 00:00:00.000Access List transactions677.985151743904601285777.25851821
    14
    		2023-08-01 00:00:00.000Access List transactions508.55910800594862895634.932274851
    15
    		2022-03-01 00:00:00.000Access List transactions60.7156819247371182989.001754064
    16
    		2023-04-01 00:00:00.000Access List transactions351.61456903349623674189.970374598
    17
    		2024-12-01 00:00:00.000Access List transactions193.17981064225149717810.546294551
    18
    		2023-02-01 00:00:00.000EIP-1559 transactions89522.64131483125411328145559555.839335
    19
    		2024-01-01 00:00:00.000EIP-1559 transactions79811.74646609330416350190342819.498328
    20
    		2024-11-01 00:00:00.000Blob transactions482.7992255042958831501345.38147618
    ...
    120
    11KB
    654s