WITH txs AS (
SELECT
date(block_timestamp) AS date,
COUNT(DISTINCT tx_hash) AS tx_vol
FROM polygon.core.fact_transactions
WHERE status = 'SUCCESS'
GROUP BY 1
),
interact AS (
SELECT
block_timestamp,
from_address
FROM polygon.core.fact_transactions
UNION ALL
SELECT
block_timestamp,
to_address
FROM polygon.core.fact_transactions
),
users AS (
SELECT
date(block_timestamp) AS date,
COUNT(DISTINCT from_address) AS addresses
FROM interact
GROUP BY 1
)
SELECT
t.date AS "Date",
t.tx_vol AS "Transactions",
u.addresses AS "Addresses"
FROM txs t
JOIN users u ON t.date = u.date
WHERE t.date BETWEEN '2022-07-01' AND '2022-07-14'