/* Count and plot the number of daily transactions and unique addresses on Polygon, beginning July 1, 2022.*/
SELECT
date_trunc('day', block_timestamp) as date,
count(distinct tx_id) as n_daily_txs
FROM flipside_prod_db.polygon.transactions
WHERE block_timestamp >= '2022-05-01'
GROUP BY date ORDER BY date