/*
Twitter: @der_piper
Discrod: piper#6707
Gnosis - Some Numbers and Charts
*/
SELECT
block_timestamp::date AS date,
COUNT(DISTINCT(tx_fee)) AS number_of_fees,
SUM(number_of_fees) OVER (ORDER BY date ASC) AS cum_fees
FROM
gnosis.core.fact_transactions
GROUP BY date
/* The End! */