maybeyonaschain_tx_stats
    Updated 13 minutes ago
    select
    date_trunc('day', block_timestamp) as date,
    count(tx_hash) as actual_txs,
    count(
    case
    when tx_succeeded then tx_hash
    else null end
    ) as actual_succeeded_txs,
    count(
    case
    when not(tx_succeeded) then tx_hash
    else null end
    ) as actual_failed_txs,
    count(distinct from_address) as interacting_wallets,
    sum(tx_fee_precise) as fees,
    sum(l1_fee_precise) as l1_fees,
    actual_txs/86400 as actual_tps,
    sum(gas_used) as daily_gas_used,

    sum(actual_txs) over(order by date) as cumu_actual_txs,
    sum(actual_succeeded_txs) over(order by date) as cumu_actual_succeeded_txs,
    sum(actual_failed_txs) over(order by date) as cumu_actual_failed_txs,
    sum(fees) over(order by date) as cumu_fees,
    sum(l1_fees) over(order by date) as cumu_l1_fees,
    sum(daily_gas_used) over(order by date) as cumu_gas_used,

    avg(actual_txs) over(order by date rows between 7 preceding and current row) as dma7_actual_txs,
    avg(actual_succeeded_txs) over(order by date rows between 7 preceding and current row) as dma7_actual_succeeded_txs,
    avg(actual_failed_txs) over(order by date rows between 7 preceding and current row) as dma7_actual_failed_txs,
    avg(interacting_wallets) over(order by date rows between 7 preceding and current row) as dma7_interacting_wallets,
    avg(fees) over(order by date rows between 7 preceding and current row) as dma7_fees,
    avg(l1_fees) over(order by date rows between 7 preceding and current row) as dma7_l1_fees,
    avg(daily_gas_used) over(order by date rows between 7 preceding and current row) as dma7_gas_used,

    min(effective_gas_price/1e6) as min_gas_price,
    max(effective_gas_price/1e6) as max_gas_price,
    Last run: 13 minutes ago
    DATE
    ACTUAL_TXS
    ACTUAL_SUCCEEDED_TXS
    ACTUAL_FAILED_TXS
    INTERACTING_WALLETS
    FEES
    L1_FEES
    ACTUAL_TPS
    DAILY_GAS_USED
    CUMU_ACTUAL_TXS
    CUMU_ACTUAL_SUCCEEDED_TXS
    CUMU_ACTUAL_FAILED_TXS
    CUMU_FEES
    CUMU_L1_FEES
    CUMU_GAS_USED
    DMA7_ACTUAL_TXS
    DMA7_ACTUAL_SUCCEEDED_TXS
    DMA7_ACTUAL_FAILED_TXS
    DMA7_INTERACTING_WALLETS
    DMA7_FEES
    DMA7_L1_FEES
    DMA7_GAS_USED
    MIN_GAS_PRICE
    MAX_GAS_PRICE
    OPEN_GAS_PRICE
    CLOSE_GAS_PRICE
    MIN_L1_GAS_PRICE
    MAX_L1_GAS_PRICE
    OPEN_L1_GAS_PRICE
    CLOSE_L1_GAS_PRICE
    1
    2025-04-07 00:00:00.0001425138837860.0017381879620.0010657984660.016493161065119542472531192112801.497814560.6739130913536332083734203.754136.2567.5438.3750.0060617209040.000926506338431501430.1250.0002521500.0002511.0002510.0802540.4311111314.488926072.4030002030.727648104
    2
    2025-04-06 00:00:00.00045094424854610.0068156934780.0019010636840.052188440828694541047529804112431.4960763730.6728472929534721432544510.6254442.37568.25470.8750.0063958141150.0007941986183465214551.250.0002511500.0002511.0002511.0002510.27950495837.1641740590.3693810392.600031734
    3
    2025-04-05 00:00:00.00033043284205600.0030031793760.0000059245643430.038241249034347536538525380111581.4892606790.6709462292530313145604426.54357.569451.6250.0063821738310.0005670588124462059630.6250.0002521500.0002511.0002511.0002510.3529585170.5859179960.4298730980.416245742
    4
    2025-04-04 00:00:00.00036883637512890.0050406645780.000013101977060.042685355996435533234522096111381.48625750.6709403046527822802134562.6254473.62589418.250.0063098831130.0006687281141493483861.1250.0002521500.0002511.0002511.0002510.3386382162.2559659670.4964762530.422103753
    5
    2025-04-03 00:00:00.00054565385715410.010185812260.000063632989580.063148540825724529546518459110871.4812168350.6709272026524262837784615.3754507.25108.1254300.0067634252660.0006718844876533389473.250.00025230001.0002511.0002510.3117436326.2664415230.5641380010.540609704
    6
    2025-04-02 00:00:00.000554954241255710.01026939160.000035914414590.064225690188175524090513074110161.4710310230.6708635696518854580544649.54497.125152.375421.3750.0079305521840.00066887217045711244080.0002511500.0002511.0002511.0002510.3175349264.4277980420.5319650220.614939139
    7
    2025-04-01 00:00:00.00049034818855510.0056395709290.0032809824730.056748471919327518541507650108911.4607616310.6708276552511952698794474.1254319.25154.8753860.0073761252950.0006659521426552298567.750.0002521500.0002511.0002511.0002510.2972038253.9531596740.5499294590.549902338
    8
    2025-03-31 00:00:00.00047964730664480.0058012670460.0010456321350.055509542153620513638502832108061.455122060.6675466728507233505524418.8754261157.875358.1250.0070619016460.0002576938247558212292.750.0002511500.0002511.0005021.0002510.2970409952.4706033690.3537284280.51407522
    9
    2025-03-30 00:00:00.00038803837433460.0044109336580.0000073367088530.044907430770088508842498102107401.4493207930.6665010406501811969324195.254031.25164332.8750.0066644848230.0001275982161523217382.50.0002521500.0002511.0002511.0002510.2972758240.8845944880.3436205120.375253244
    10
    2025-03-29 00:00:00.00038363745913070.0067065712070.000083945236780.044398415589329504962494265106971.444909860.6664937039497504268444096.3753925.625170.75316.250.0062846818760.0001354863297508358033.750.0002511500.21.0002511.0002510.2990466211.2795059290.5851530170.36685274
    11
    2025-03-28 00:00:00.000439342131802930.0024248536320.00081927897850.050845500428191501126490520106061.4382032880.6664097587493348375154040.253867.375172.875306.8750.0057876658820.0001264200072499550316.6250.0002511500.0002511.0002511.0002510.3025113331.7723494690.3964935050.610591178
    12
    2025-03-27 00:00:00.000411039062043830.0086690018010.000038352964790.047569675241332496733486307104261.4357784350.6655904797488344093243982.1253812.875169.25304.250.0063672337280.0000255089465490968845.8750.00025130001.0005021.0002510.2861744452.1254376870.3465651080.371333643
    13
    2025-03-26 00:00:00.000572953044254720.019522827610.000039534452340.066308842705202492623482401102221.4271094330.6655521267481591679923996.1253834.25161.875289.8750.0060303266990.00002398528922462914862.1250.0002511500.21.0002511.0002510.3027126272.5835430240.339690710.353722434
    14
    2025-03-25 00:00:00.000414640011452880.0058339764830.000012554192030.04798653958145348689447709797971.4075866050.6655125923473164627903732.753607.75125262.50.0039046381650.00003644004724403924914.750.0002512000.0002511.0002511.1002510.3116500792.0287331430.6622137730.311650079
    15
    2025-03-24 00:00:00.000446143521093280.0031257817380.000014915929030.05163251922912748274847309696521.4017526290.66550003814677688133736303509.5120.5259.6250.0037779249350.0003150010651377140961.750.00025230001.0002511.0005020.3062679573.2695779330.4224826010.52544433
    16
    2025-03-23 00:00:00.000300728921152460.0026219324570.0000048672666140.03480326219433847828746874495431.3986268470.6654851222462576522103501.8753379.75122.125246.3750.003554089870.0003225068037351694409.6250.0002521500.0002511.0002511.3750.2900287850.5766034620.3848369840.387188538
    17
    2025-03-22 00:00:00.00030892992972130.0013725100850.000070441617330.03575231189529847528046585294281.3960049150.6654802549459954578723478.253360.125118.125244.750.0035665183380.0003421466535350875492.250.0002521500.0002511.0002511.0002510.3319753920.5751413390.3788376110.357410846
    18
    2025-03-21 00:00:00.000338732791082320.0027304432520.000011414656830.03920134512759247219146286093311.3946324050.6654098133456835625743515.8753396.5119.375250.8750.0040783891260.00048509580473569813960.0002521500.0002511.0002511.0002510.3354485520.6734721570.3995977120.439226329
    19
    2025-03-20 00:00:00.000392837771512720.0070613963970.000011990493030.04546343177642546880445958192231.3919019610.6653983986453384349823545.753427.375118.375253.6250.0046415138230.0007723145145359487122.750.0002511500.0002511.0002511.0002510.3625279152.4283714490.4517995080.469688436
    20
    2025-03-19 00:00:00.000422240771452680.0059737455750.000026163706520.04886645080946246487645580490721.3848405650.6653864081449066585573914.1253792.375121.75251.8750.0052724414870.0013108468524360472930.0002511500.0002510.0669181.2003010.3382846163.598210150.4325330540.421268796
    ...
    130
    39KB
    1s