SELECT
from_address,
count(DISTINCT tx_hash) as transactions,
count(DISTINCT date_trunc('day', block_timestamp)) as active_days
-- count(DISTINCT to_address) as contracts_interacted_with
from base.goerli.fact_transactions
GROUP BY 1
ORDER BY 2 DESC
LIMIT 100