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

, tx_fee

-- , 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(tx_fee), 1) as total_fees

-- , round(sum(priority_fee), 1) as total_pfee

-- , round(sum(priority_fee) / alltime_uw, 4) as pfee_by_uw

from base

group by 1