permaryDaily contract creation
    Updated 2025-02-20
    select
    date(ft.block_timestamp) as "Date",
    count(distinct dc.address) as "Total contracts created",
    sum(ft.gas_used) / 1e9 as "Total deployment cost (MON)",
    ((sum(ft.gas_used) /1e9) /count(distinct dc.address)) as "Avg gas used per contract (MON)",
    sum(ft.tx_fee) as "Total tx fee (MON)",
    avg(ft.tx_fee) as "Avg tx fee (MON)"
    from monad.testnet.fact_transactions ft
    join monad.testnet.dim_contracts dc
    on ft.tx_hash = dc.created_tx_hash
    group by "Date"
    order by "Date" desc;

    Last run: 27 days ago
    Date
    Total contracts created
    Total deployment cost (MON)
    Avg gas used per contract (MON)
    Total tx fee (MON)
    Avg tx fee (MON)
    1
    2025-02-20 00:00:00.0002789345.913330.0016460520562448.4964817740.08778175463
    2
    2025-02-19 00:00:00.0004848729.1987330.0006021971461577.6545521310.03253768128
    3
    2025-02-18 00:00:00.0005841.3795870.00236230650771.9593116030.1232179993
    4
    2025-02-17 00:00:00.0006651.2192180.00183341052662.8638087630.09453204325
    5
    2025-02-16 00:00:00.0002020.4177670.00206815346522.7600848090.1126736872
    6
    2025-02-15 00:00:00.0004830.9867680.0020429979351.3227868540.1062583579
    7
    2025-02-14 00:00:00.0006491.0645190.00164024499255.0043383520.08475244738
    8
    2025-02-13 00:00:00.0002130.2802680.00131581220715.2141840260.07142809402
    9
    2025-02-12 00:00:00.0005711.0031190.00175677583251.2653448860.08978168982
    10
    2025-02-11 00:00:00.0002250.3612350.00160548888923.6057176260.1049143006
    11
    2025-02-10 00:00:00.0001900.4841090.00254794210525.1584559490.132412926
    12
    2025-02-09 00:00:00.000260.0503810.0019377307692.5949275620.09980490623
    13
    2025-02-08 00:00:00.0001670.1070830.0006412155695.6367874840.03375321847
    14
    2025-02-07 00:00:00.0002350.5135270.00218522127726.6472707930.1133926417
    15
    2025-02-06 00:00:00.0002920.6598520.00225976712335.1079064060.1202325562
    16
    2025-02-05 00:00:00.0002750.5207650.00189369090927.7047106960.1007444025
    17
    2025-02-04 00:00:00.0001340.2897230.0021621119417.6137675950.1314460268
    18
    2025-02-03 00:00:00.0001730.41980.00242658959528.0728588670.1622708605
    19
    2025-02-02 00:00:00.000230.0332790.0014469130431.8520585080.08052428296
    20
    2025-02-01 00:00:00.000420.0665150.0015836904763.4739876560.08271399181
    45
    4KB
    1s