SELECT

MIN(tr.block_timestamp) AS create_timestamp,

tr.tx_hash,

tr.to_address AS contract

FROM monad.testnet.fact_traces tr

JOIN monad.testnet.fact_transactions t ON tr.tx_hash = t.tx_hash

WHERE tr.type ILIKE 'create%'

AND tr.tx_succeeded = TRUE

AND tr.trace_succeeded = TRUE

AND tr.to_address IS NOT NULL

GROUP BY 2, 3

),

user_metrics AS (

SELECT

t.from_address AS wallet_address,

COUNT(*) AS total_transactions,

COUNT(DISTINCT c.contract) AS unique_contracts,

SUM(tx_fee) / 1e18 AS total_fees_eth, -- Переводим комиссии в ETH

COUNT(DISTINCT DATE(t.block_timestamp)) AS active_days,

COUNT(DISTINCT DATE_TRUNC('week', t.block_timestamp)) AS active_weeks,

COUNT(DISTINCT DATE_TRUNC('month', t.block_timestamp)) AS active_months

FROM monad.testnet.fact_transactions t

LEFT JOIN contracts c

ON t.to_address = c.contract

WHERE t.block_timestamp >= CURRENT_TIMESTAMP() - INTERVAL '30 days'

AND t.from_address IN ('0x1e1bD10bc1A59c647A1a6377FF063148B6f9aAaF', '0xa340b9d2819cc346d07ac7b198ff25218fa9f9b1', '0xe5891c130a3bd9694f772b9725703119c6dffead') -- Вставьте список кошельков

GROUP BY 1

),

popular_contracts AS (

SELECT

from_address AS wallet_address,

to_address AS contract_address,

COUNT(tx_hash) AS tx_count,