rezarwzFEES ANALYSE
    Updated 2025-04-10
    SELECT
    date_trunc('day', block_timestamp) AS date,
    AVG(tx_fee) AS average_tx_fee,
    STDDEV(tx_fee) AS tx_fee_stddev,
    MAX(tx_fee) AS max_tx_fee,
    MIN(tx_fee) AS min_tx_fee,
    AVG(gas_price) AS average_gas_price,
    STDDEV(gas_price) AS gas_price_stddev,
    MAX(gas_price) AS max_gas_price,
    MIN(gas_price) AS min_gas_price,
    AVG(gas_used) AS average_gas_used,
    STDDEV(gas_used) AS gas_used_stddev,
    MAX(gas_used) AS max_gas_used,
    MIN(gas_used) AS min_gas_used,
    AVG(tx_fee / gas_used) AS "AVG tx_fee/gas_uesd ratio",
    AVG(gas_used / gas_limit) AS "AVG gas_used/gas_limit ratio"
    FROM blast.core.fact_transactions
    where date_trunc('day', BLOCK_TIMESTAMP) is not null
    GROUP BY date
    ORDER BY date ASC;

    Last run: 17 days agoAuto-refreshes every 24 hours
    DATE
    AVERAGE_TX_FEE
    TX_FEE_STDDEV
    MAX_TX_FEE
    MIN_TX_FEE
    AVERAGE_GAS_PRICE
    GAS_PRICE_STDDEV
    MAX_GAS_PRICE
    MIN_GAS_PRICE
    AVERAGE_GAS_USED
    GAS_USED_STDDEV
    MAX_GAS_USED
    MIN_GAS_USED
    AVG tx_fee/gas_uesd ratio
    AVG gas_used/gas_limit ratio
    1
    2024-02-24 00:00:00.0000000000050398.687986242.239382605640574692100.05039868798
    2
    2024-02-25 00:00:00.0002.06281056e-70.000036636908220.00751811372102.81125975e-80.0000048465417850.001000252050348.86025425843.9706120865203075210001.695808765e-130.05029676189
    3
    2024-02-26 00:00:00.0000.0000024311059690.00042979357260.088863780200.0071153944570.8334298319100050248.5550137976.083597005873016210007.625840416e-120.050458075294
    4
    2024-02-27 00:00:00.0000.000002743466050.00013487426040.0136921095300.0010985860170.055273085563.000000252051295.5396154174.7807415535201733210003.7003907e-120.051339864601
    5
    2024-02-28 00:00:00.0000.000051153894610.00094770113930.0673990170200.015107100170.20708486610061833.828899192195.5403834997285445210005.941266776e-110.061836491117
    6
    2024-02-29 00:00:00.0000.00053058546140.001748290520.147035129101.7083121579.9829294733333.3333333330179279.489115716712.6604708228055728210004.088121819e-90.611320085032
    7
    2024-03-01 00:00:00.0000.00037620336170.0020131933560.341664322701.55911136918.009942182100000186205.014101724498.32979011328940660210003.306670787e-90.688422669836
    8
    2024-03-02 00:00:00.0000.00027915254550.0017477718730.519753135301.0711770678.897097032325.9835731450380917.6175461849076.5829554629572998210002.450309199e-90.684042528604
    9
    2024-03-03 00:00:00.0000.00029168855410.0023889811150.758164040801.12025607311.947553513029.5910670340248274.8734361374147.426260928437152210002.450782845e-90.680142751834
    10
    2024-03-04 00:00:00.0000.00040581280820.003594742920.982886334401.27877233216.2993476262715.7966564310171666.100749441331.50442766125888001210003.399203224e-90.678929949515
    11
    2024-03-05 00:00:00.0000.0003561249160.0015589376350.427599098700.88643945186.1339269341265.3418951750576727.773282069368.3671091627534316210003.012421975e-90.647201276678
    12
    2024-03-06 00:00:00.0000.00026449043550.001333696650.350097329500.741385751325.32649970816665.08427440393428.6662671463680.8526809223287248210002.85053816e-90.68878746167
    13
    2024-03-07 00:00:00.0000.00027352077480.0026125150550.859896680900.916978491310.8820490752214.6041846970413311.1560871324940.1012739127191570210002.466269139e-90.611705660589
    14
    2024-03-08 00:00:00.0000.00020154755630.00095031864490.282989362900.53675231994.0919696961221.2606046280368834.0589451270584.1412691728325089210001.883568085e-90.616619199563
    15
    2024-03-09 00:00:00.0000.00013476145410.001302102480.401575293900.18350328555.2547428581112.3005093360169673.785226663384.23969747727278218210001.34639334e-90.629267125067
    16
    2024-03-10 00:00:00.0000.00014013854390.0015101523330.437533254700.17712449626.3743372211437.2720205910177261.04028665762.35565032926892008210001.407511416e-90.625520414257
    17
    2024-03-11 00:00:00.0000.00016373923940.00084959249590.292343744300.13809247032.323744256662.6157753880190836.131345676142.93368388327543230210001.649268108e-90.625620180447
    18
    2024-03-12 00:00:00.0000.00014711766980.00093304944850.262037440300.18900075824.673521819841.1380410670163186.476537619122.502909228500000210001.494538961e-90.628324228545
    19
    2024-03-13 00:00:00.0000.0001564897860.00088745049320.183737824800.20467658713.471951941802.002428070164754.875309662377.85638226428500000210001.571971634e-90.601803753942
    20
    2024-03-14 00:00:00.0000.00019016505660.0018958386690.832957944800.23125739095.7104192371581.0791699570174434.140274700179.88319349627260122210001.719616261e-90.655298838492
    ...
    405
    77KB
    46s