flipside

    Monad Contracts Leaderboard
    Monad Metrics GuildMonad Contracts Leaderboard
    Updated 4 hours ago
    -- forked from @pepperatzi / Top Contracts Based on Gas Fees @ https://flipsidecrypto.xyz/pepperatzi/q/XrrQmfkcT-Ms/top-contracts-based-on-gas-fees
    -- edited by @chainrunner_


    with labelled_contracts as (
    select * from $query('ae1af2d4-a9d1-4cad-a095-6c6a6c33fae4')
    )

    , contracts as (
    select * from $query('2bc7dc97-d2ae-4744-bc3e-20fc230d46e1')
    )

    , base as (
    select
    block_timestamp
    , from_address as user_
    , contract
    , coalesce((max_priority_fee_per_gas * gas_used) / 1e9, 0) as priority_fee
    from monad.testnet.fact_transactions right join contracts on to_address = contract_address
    where 1=1
    and block_timestamp >= '2025-02-19 15:00:00'
    and tx_succeeded
    )


    , agg as (
    select
    contract
    , count(*) as tx_count
    , count(distinct user_) as alltime_uw
    , round(sum(priority_fee), 1) as total_pfee
    , round(sum(priority_fee) / alltime_uw, 4) as pfee_by_uw
    from base
    group by 1
    )

    Last run: about 4 hours agoAuto-refreshes every 12 hours
    CONTRACT
    CATEGORY
    TX_COUNT
    ALLTIME_UW
    AVG_DUW
    TOTAL_PFEE
    PFEE_BY_UW
    1
    		CurvanceDeFi109534202120199410388071715.90.0597
    2
    		Wrapped MONToken20655979136092913022328541.10.021
    3
    		UniswapDeFi148815322389021184891113780.40.0476
    4
    		FastlaneDeFi13396395422188271345710.10.0135
    5
    		Bean ExchangeDeFi10079241133518610020621662.50.0162
    6
    		AI CraftAI99080116571505187856154.70.0855
    7
    		Ambient FinanceDeFi9609054141805711026228622.90.0202
    8
    		Magma StakingDeFi91801291650682109262178940.0108
    9
    		aPrioriDeFi8678732194696414269421163.40.0109
    10
    		shMONToken74649011093857751394568.40.0042
    11
    		Nad.funDeFi58306786982804904841807.90.0599
    12
    		KuruDeFi56885077124315994623865.50.0335
    13
    		Izumi FinanceDeFi42892337105504943214937.10.021
    14
    		USDCToken38491561200654786395630.90.0047
    15
    		DustedSocialFi3699522767261596243391.70.0044
    16
    		sMONToken34406711074057675345151.40.0048
    17
    		Nad name serviceSocialFi320660414967566124227940.60.0187
    18
    		TalentumSocialFi31737774821225638556689.40.1176
    19
    		Fantasy TopGambleFi2884014748227358087313.90.0098
    20
    		Open Edition CHOGSTARNFT28625981473474616816657.70.0045
    ...
    862
    62KB
    258s