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'