/*
Twitter: @der_piper
Discrod: piper#6707
Gnosis - Some Numbers and Charts
*/
SELECT
logs.block_timestamp::date AS date,
labels.label_type AS type,
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) as users,
COUNT(DISTINCT(logs.tx_hash)) AS number_of_transactions
FROM
gnosis.core.fact_event_logs logs
JOIN
arbitrum.core.dim_labels labels
ON
logs.contract_address = labels.address
WHERE
labels.label_type IS NOT NULL
GROUP BY date, type
/* The End! */