with contract_labels as (

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

, contracts as (

select

address

, coalesce(

case

when creator_address = '0xc816865f172d640d93712c68a7e1f83f3fa63235' then 'Kuru'

when creator_address = '0x7fe0bce62b95b22eb6335b2dac3b4e5a2f6f034e' then 'Nad.fun'

when creator_address = '0x321fb42877b7c61efe489505ab87bf1dff33f1e4' then 'Nad.fun'

when creator_address = '0x60216fb3285595f4643f9f7cddab842e799bd642' then 'Nad.fun'

end

, l.name

, d_c.name

, symbol

, 'NA'

) as contract_name

, case when contract_name != 'NA' then contract_name else address end as contract

, coalesce(category, 'NA') as category

from monad.testnet.dim_contracts d_c

left join contract_labels l using(address)

, contract_interactions as (

select

date_trunc(day, block_timestamp)::date as day_

, contract

, tx_fee

, coalesce(max_priority_fee_per_gas * gas_used / 1e9, 0) as prio_fee

from contracts left join monad.testnet.fact_transactions on address = to_address

where 1=1

and block_timestamp >= '2025-02-19 15:00:00'