Afonso_DiazTotal
Updated 2025-02-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
with
main as (
select
tx_hash,
block_timestamp,
from_address as creator,
tx_fee
from
monad.testnet.fact_transactions
where
to_address is null
and origin_function_signature = '0x60806040'
and input_data is not null
and tx_succeeded
)
select
count(distinct tx_hash) as contracts_created,
count(distinct creator) as creators,
sum(tx_fee) as fee_volume,
avg(tx_fee) as average_fee_amount,
contracts_created / count(distinct block_timestamp::date) as daily_average_contracts_created,
creators / count(distinct block_timestamp::date) as daily_average_contracts_creators
from
main
QueryRunArchived: QueryRun has been archived