/*
Twitter: @der_piper
Discrod: piper#6707
Gnosis - Some Numbers and Charts
*/
SELECT
block_timestamp::date AS date,
count(tx_hash) AS number_of_transactions,
status
FROM
gnosis.core.fact_transactions
GROUP BY date, status
ORDER BY date ASC
/* The End! */