SELECT DATE_TRUNC('DAY',BLOCK_TIMESTAMP) AS DAY, COUNT(APP_ID) Apps_created FROM (
SELECT
B.BLOCK_TIMESTAMP,
A.APP_ID
FROM
flipside_prod_db.algorand.app AS A
JOIN flipside_prod_db.algorand.block AS B ON B.BLOCK_ID = A.CREATED_AT
WHERE
APP_ID IN (
SELECT APP_ID FROM (
SELECT APP_ID, NUM FROM (
SELECT
APP_ID,
COUNT(*) AS NUM
FROM flipside_prod_db.algorand.application_call_transaction
GROUP BY APP_ID
)
WHERE NUM > 1000
)
)
ORDER BY 1 ASC
)
WHERE DAY BETWEEN '2022-01-01' AND '2022-04-30'
GROUP BY DAY
ORDER BY DAY ASC