DATE_TRUNC('day', block_timestamp) AS transaction_date,

COUNT(from_address) AS daily_smart_contract_interactions

optimism.core.fact_transactions

to_address IS NOT NULL

AND value > 0

GROUP BY

1

ORDER BY

1 DESC;