SELECT block_timestamp::DATE AS DAY, address_name,
COUNT(DISTINCT tx_hash) AS "Number of Transactions",
COUNT (DISTINCT origin_from_address) "Number of From Addresses",
COUNT (DISTINCT origin_to_address) "Number of To Addresses"
FROM gnosis.core.fact_event_logs
INNER JOIN gnosis.core.dim_labels on address = contract_address
WHERE block_timestamp::DATE BETWEEN CURRENT_DATE - 90 AND CURRENT_DATE - 1
AND event_name IS NOT NULL
GROUP BY 1,2
ORDER BY 1