/*
Twitter: @der_piper
Discrod: piper#6707
Polygon - Daily Transactions and Unique Addresses
Q1. Count and plot the number of daily transactions and unique addresses on Polygon, beginning July 1, 2022.
In your estimation, discuss whether Polygon is still growing, has reached a plateau, etc.
*/
SELECT
COUNT(DISTINCT(contract_address)) AS number_of_contract_addresses
FROM
polygon.core.fact_event_logs
WHERE
block_timestamp BETWEEN '2022-07-01' AND '2022-07-10'
/* The End! */