WITH main as (
SELECT
DATE_TRUNC ('day' ,BLOCK_TIMESTAMP ) as daily,
count(DISTINCT from_address) as unique_address
FROM polygon.core.fact_transactions
WHERE BLOCK_TIMESTAMP::DATE >= '2022-07-01'
GROUP BY daily),
avg as (
SELECT
SUM(unique_address) / 14 as avg
FROM
main
)
SELECT
daily,
unique_address,
avg
FROM
main , avg