count(DISTINCT from_address) as users,

count(DISTINCT a.tx_hash) as txns,

count(DISTINCT contract_address) as "Active Hourly Contracts",

users/"Active Hourly Contracts" as "Avg Contract Per User (Usage)"

from sei.core_evm.fact_transactions a left outer join sei.core_evm.fact_event_logs b on a.tx_hash = b.tx_hash

where a.block_timestamp::date >= '2024-05-27'