ramishoowUntitled Query
Updated 2023-01-13
9
1
2
3
4
›
⌄
WITH FIRST_ACTIVITY AS ( SELECT MIN(BLOCK_TIMESTAMP)::DATE FIRST_ACTIVITY_DATE , TX_SIGNER AS ADDRESS FROM near.core.fact_transactions GROUP BY TX_SIGNER) SELECT FIRST_ACTIVITY_DATE, COUNT(ADDRESS) AS NUMBER_OF_NEW_WALLETS,
--WITH FIRST_ACTIVITY AS ( SELECT MIN(BLOCK_TIMESTAMP)::DATE FIRST_ACTIVITY_DATE , TX_SIGNER AS ADDRESS FROM near.core.fact_transactions GROUP BY TX_SIGNER) SELECT FIRST_ACTIVITY_DATE, COUNT(ADDRESS) AS NUMBER_OF_NEW_WALLETS,
CASE WHEN FIRST_ACTIVITY_DATE BETWEEN '2022-12-25' AND '2022-12-31' THEN 'First week of holidays' WHEN FIRST_ACTIVITY_DATE BETWEEN '2023-01-01' AND '2023-01-13' THEN 'Second week of holidays' END AS TYPE
FROM FIRST_ACTIVITY WHERE FIRST_ACTIVITY_DATE BETWEEN '2022-12-25' AND '2023-01-13' GROUP BY FIRST_ACTIVITY_DATE ORDER BY FIRST_ACTIVITY_DATE
Run a query to Download Data