flyingfishhourly tx
    Updated 2025-02-26
    with txs as (

    select
    *
    -- , block_timestamp
    -- , block_number
    -- , tx_hash
    -- , tx_succeeded
    -- , from_address
    -- , max_fee_per_gas
    -- , max_priority_fee_per_gas
    -- , tx_fee
    , gas_used * 50 / 1e9 as mon_burned
    , gas_used * (gas_price - 50) / 1e9 as tx_savings
    from monad.testnet.fact_transactions

    where 1 = 1
    --and block_timestamp > '2025-02-14'
    --and block_timestamp > current_date - 7
    --and tx_hash = '0x8845ab3ef11842d764f598c16d7a84131671c8eb7a45b4b7bdde10521d54d043'
    -- and (tx_hash = '0xdac05244373d466d547690ecaf151b3a3a1d6365a520c68528e8a83681dc7351'
    -- or
    -- tx_hash = '0x0589a5135644149a25e4f87b3d6e23c42f60b514034ffa33db24b48ee3ff21a1'
    -- )
    )

    select

    date_trunc(day, block_timestamp) as hour_
    , count(distinct from_address) as signers
    , count(distinct block_number) as blocks
    , sum(iff(origin_function_signature in ('0xa9059cbb', '0x'), 1, 0)) as simple_transfer
    , sum(iff(origin_function_signature != '0xa9059cbb', 1, 0)) as not_a_simple_transfer
    , count(1) as txs
    --, txs / (24 * 60 * 60) as tps
    Last run: 18 days ago
    HOUR_
    SIGNERS
    BLOCKS
    SIMPLE_TRANSFER
    NOT_A_SIMPLE_TRANSFER
    TXS
    GUD
    NOT_SO_GUD
    TX_PER_ORIGIN
    MEDIAN(GAS_PRICE)
    AVG(GAS_PRICE)
    MEDIAN(TX_FEE)
    AVG(TX_FEE)
    SUM(MON_BURNED)
    SUM(TX_SAVINGS)
    1
    2025-02-13 00:00:00.0006361128026488825856265212326519801434170.0047175050.0170932540.00172130.00173536034597.9414373.781852516
    2
    2025-02-17 00:00:00.00019642806869675421408709931709805126361.4719965050.1577673110.0050.0052516442193706.019122.286513305
    3
    2025-02-04 00:00:00.00015923716564191433842924627.2830195254.0580958970.0017192760.00798718350330.5710914.076946438
    4
    2025-01-27 00:00:00.00011712341902016201919714817.256415255.8961683580.0017192760.0182069421731.6740115.085703033
    5
    2025-01-25 00:00:00.000413171134864864751111.8536595252.646913580.0017192760.012601213235.7654580.3586954285
    6
    2025-01-17 00:00:00.0009415472322448248424651926.4255325252.3417069240.0017192760.00840281019720.3351870.5372589296
    7
    2025-02-24 00:00:00.00076355017229971597498329179911016972302118799512.9801795253.0892331360.0017328480.0100144349592445.0559536807.524334344
    8
    2025-01-20 00:00:00.00022337267598398998724.4349785252.0401415570.0010920.0063701446126.1276820.1723690212
    9
    2025-01-30 00:00:00.000171160734420492114181529912.3625735252.5379048340.0023906480.0141776209428.7144231.257117222
    10
    2025-02-03 00:00:00.00013324584623206328532414424.6992485253.6531350150.0017192760.0122002714732.218977.858852782
    11
    2025-02-22 00:00:00.0004423541723806493614972270512399750260349796311.5834765256.7655909230.0021630.0101216299746929.987924932.914459525
    12
    2025-02-18 00:00:00.000897202454404133386538455359425160.02787162.462.1762916330.00310613160.009433487341445.81268962.133488187
    13
    2025-02-06 00:00:00.000229850722108104981697526442.8646295253.5690607170.0027140880.00775735929271.6715064.473680458
    14
    2025-01-24 00:00:00.0002138673114551950597614555064145548861786807.79425050.0008300150.00172130.00172677900325126.4824133.172833808
    15
    2025-02-09 00:00:00.00011114495081330148914692013.4144145255.2079919410.003404180.00880764860912.3140070.8006403789
    16
    2025-02-07 00:00:00.00018876982801566147278018895801667722184249.54695050.0020455310.00172130.00172780096313850.2556072.748727601
    17
    2025-01-18 00:00:00.000304081084474473885914.95252.0158389260.0067829840.0079603512663.4641420.0941260661
    18
    2025-01-12 00:00:00.0001521798218218217114.5333335151.3853211010.0067820480.01453031973.1343480.03326499405
    19
    2025-01-09 00:00:00.0003732831931819518197181925491.8108115252.0218277740.0013676520.00242746583642.4987121.67363937
    20
    2025-01-31 00:00:00.000138159633326972781267710420.1521745252.2602604520.0017192760.00969773802226.3312060.6380530392
    51
    7KB
    16s