flipside

    Hourly Transactions Overview (Avalanche Octane Upgrade April 2025)
    Ali3NHourly Transactions Overview (Avalanche Octane Upgrade April 2025)
    Updated 19 minutes ago
    select date_trunc (day,block_timestamp) as date,
    case when block_timestamp < '2025-04-08 15:00:00.000' then 'Before Upgrade'
    else 'After Upgrade' end as timespan,
    count (distinct tx_hash) as TX_Count,
    count (distinct from_address) as Users_Count,
    sum (tx_fee) as Fees,
    avg (tx_fee) as Average_Fee,
    median (tx_fee) as Median_Fee,
    min (tx_fee) as Minimum_Fee,
    max (Tx_fee) as Maximum_Fee,
    count (case when not tx_succeeded then 1 end) as Failed_TX,
    count (case when tx_succeeded then 1 end) as Success_TX,
    (Success_TX / (Success_TX + Failed_TX)) * 100 as Success_Rate
    from avalanche.core.fact_transactions
    where block_timestamp >= '2025-04-01'
    group by 1,2
    order by 1



    Last run: 19 minutes agoAuto-refreshes every 1 hour
    DATE
    TIMESPAN
    TX_COUNT
    USERS_COUNT
    FEES
    AVERAGE_FEE
    MEDIAN_FEE
    MINIMUM_FEE
    MAXIMUM_FEE
    FAILED_TX
    SUCCESS_TX
    SUCCESS_RATE
    1
    		2025-04-01 00:00:00.000Before Upgrade26485133798293.4903382030.0011081337740.000180330.0000211.39061492387124098090.987
    2
    		2025-04-02 00:00:00.000Before Upgrade28378630747630.4094885680.0022214256110.00028319677890.00002113.0043075943282425096288.4335
    3
    		2025-04-03 00:00:00.000Before Upgrade28751144319327.3568240370.0011385888680.0002224969210.0000210.84433880572543126208091.1548
    4
    		2025-04-04 00:00:00.000Before Upgrade25777831430354.366178850.0013746951980.00025723392760.0000211.24849622572623205290.0201
    5
    		2025-04-05 00:00:00.000Before Upgrade17337626063148.6600240080.00085744292180.00020476803160.0000210.2123958751016216321494.1388
    6
    		2025-04-06 00:00:00.000Before Upgrade26775727631546.4776143050.0020409461350.00031959839760.0000211.8107926623117523658288.357
    7
    		2025-04-07 00:00:00.000Before Upgrade384431320982008.3188246710.0052241333940.00055410907730.00002110.9956847826543531899682.9787
    8
    		2025-04-08 00:00:00.000After Upgrade12565213852132.7188912680.0010562417730.000061528089644.2e-140.59287373681682210883086.6122
    9
    		2025-04-08 00:00:00.000Before Upgrade15150719183263.6130779250.0017399399230.00026047750.0000214.1086430091705713445088.7418
    10
    		2025-04-09 00:00:00.000After Upgrade37772831932853.7499643230.0022602241940.000101958753.53808e-104.2449577865614432158485.1364
    11
    		2025-04-10 00:00:00.000After Upgrade30612932112275.525471560.00090003061310.0000621711.9215e-92.079956683606827006188.218
    12
    		2025-04-11 00:00:00.000After Upgrade30082538750306.3593688480.0010183973040.000075432126387.96496358e-73.9771541423627726454887.9408
    13
    		2025-04-12 00:00:00.000After Upgrade26271728099289.2938830470.0011011616420.000099479843610.0000015126144391.0352977812977523294288.6665
    14
    		2025-04-13 00:00:00.000After Upgrade26760631044218.7415175490.00081740139440.000070471922920.0000014836368540.47493157862650524110190.0955
    15
    		2025-04-14 00:00:00.000After Upgrade27387328863270.6994685070.00098841239740.000074604739750.0000015720102091.5590326033239524147888.1715
    16
    		2025-04-15 00:00:00.000After Upgrade27469030765229.6112945580.00083589244080.000090035474340.0000016472246490.78609682542242925226191.8348
    17
    		2025-04-16 00:00:00.000After Upgrade27096129760297.2182364840.0010969041170.000093273508540.0000016687216351.7587402972649624446590.2215
    18
    		2025-04-17 00:00:00.000After Upgrade25374632061189.4726596060.00074670205480.000075635493210.0000016994625691.0736752551967623407092.2458
    19
    		2025-04-18 00:00:00.000After Upgrade21285531104205.0178361270.00096318073870.00007220414670.0000017305119724.8095046711185920099694.4286
    20
    		2025-04-19 00:00:00.000After Upgrade21364828587146.7240898490.00068675620580.000074038876260.0000017115867720.49701906561292420072493.9508
    60
    9KB
    78s