Updated 2025-02-27
    with

    create_txs as (

    select distinct

    to_address

    from monad.testnet.fact_traces
    where tx_succeeded
    and trace_succeeded
    and type ilike 'create%'
    and to_address is not null
    ),

    all_txs as (

    select

    fact_transactions.block_timestamp
    , fact_transactions.tx_hash
    , fact_transactions.tx_succeeded
    , fact_transactions.to_address
    , fact_transactions.tx_fee

    from monad.testnet.fact_transactions
    inner join create_txs
    on fact_transactions.to_address = create_txs.to_address
    where fact_transactions.to_address is not null
    and block_timestamp >= '2025-01-07'
    ),

    agg_24h as (

    select

    Last run: 21 days ago
    CONTRACT_ADDRESS
    LABEL
    COUNT_TXS
    SUM_FEES
    AVG_FEE
    MEDIAN_FEE
    COUNT_TXS_24H
    SUM_FEES_24H
    AVG_FEE_24H
    MEDIAN_FEE_24H
    |
    ||
    1
    0x4c4eabd5fb1d1a7234a48692551eaecff8194ca7unknown474459389538.190230.018870.0208131242120718.982970.015790.0208|||
    2
    0x8280cc0c1c055054411bb8d0a7f9a86a26f25398unknown990938149546.880630.0050.00540.006930.001730.00151|||
    3
    0x8462c247356d7deb7e26160dbfab16b351eef242unknown2275434739776.745910.001750.0017340154897152.986060.001780.00173|||
    4
    0x760afe86e5de5fa0ee542fc7b7b713e1c5425701unknown457161136206.407340.007920.00236156002315362.888890.009850.00283|||
    5
    0x2555223a15a931a71951707cb32a541f14e2c730veCVE21697727006.946320.124470.01297311103627.035090.116590.01081|||
    6
    0xfcc20dddb395dc684750a68933ad553ef8923266ERC20Test1367657423551.841770.001720.00172|||
    7
    0xd97bce4518b886a36e345764333d77b5faf6fe2cunknown41641423547.546430.056550.011341085532724.823460.02510.01134|||
    8
    0xca810d095e90daae6e867c19df6d9a8c56db2c89unknown219501621616.885540.009850.008568207238158.455440.009940.00936|||
    9
    0x88b96af200c8a9c35442c8ac6cd3d22695aae4f0unknown201409921030.299460.010440.007355149534524.545320.008790.00664|||
    10
    0x9fb480a193c250bf8ece39df5d9d728e21026b34unknown528620603.705443.897793.9|||
    11
    0x822eb1add41cf87c3f178100596cf24c9a6442f6unknown35297519810.502730.056120.01124488022800.753220.057390.01118|||
    12
    0xc995498c22a012353fae7ecc701810d673e25794unknown50815417856.206510.035140.006441348972289.033420.016970.00915|||
    13
    0x758d80767a751fc1634f579d76e1ccaab3485c9cunknown72577617831.097680.024570.019071913794295.973730.022450.01953|||
    14
    0x2c9c959516e9aaedb2c748224a41249202ca8be7unknown127945216014.926030.012520.005154563905896.264860.012920.00515|||
    15
    0xb2f82d0f38dc453d596ad40a37799446cc89274aaprMON173816113333.209990.007670.003884764633892.854990.008170.00398|||
    16
    0x0000000000000068f116a894984e2db1123eb395unknown21093611589.906290.054950.00983276091004.587730.036390.00988|||
    17
    0x9077d31a794d81c21b0650974d5f581f4000cd1aunknown42660711218.707840.02630.02847858542210.872850.025750.02847|||
    18
    0xc816865f172d640d93712c68a7e1f83f3fa63235unknown74475010713.539120.014390.010892008872834.251520.014110.0109|||
    19
    0x813f6149eec58ba0dd29bcc97a185257838fd321unknown5947510614.790490.178470.02059113261812.867880.160060.02059|||
    20
    0x17642ce98f4abfabcbb5e1a5d5825902cc311cebunknown12730310248.25380.08050.03203421392339.272870.055510.03635|||
    100
    13KB
    76s