Account Created - Table

Flipside TeamAccount Created - Table

Updated 10 days ago

WITH weekly_periods AS (

SELECT

CASE WHEN num = 0

THEN DATE_TRUNC('week', CURRENT_DATE) -- Start of current week

ELSE dateadd('week', -num, current_date)

END as start_date,

CASE WHEN num = 0

THEN CURRENT_TIMESTAMP

ELSE dateadd('week', -num+1, current_date)

END as end_date,

num as weeks_ago,

TO_CHAR(CASE WHEN num = 0

THEN DATE_TRUNC('week', CURRENT_DATE)

ELSE dateadd('week', -num, current_date)

END, 'YYYY-MM-DD') || ' to ' ||

TO_CHAR(CASE WHEN num = 0

THEN CURRENT_DATE

ELSE dateadd('week', -num+1, current_date)

END, 'YYYY-MM-DD') as date_range

FROM (SELECT row_number() over (order by seq4()) - 1 AS num

FROM table(generator(rowcount => 12))) -- Past 12 weeks to see last 3 months

cadence_accounts AS (

SELECT

wp.weeks_ago,

wp.date_range,

COUNT(DISTINCT first_tx.value) AS new_accounts

FROM weekly_periods wp

LEFT JOIN (

SELECT

a.value,

MIN(block_timestamp) as first_tx_time

FROM flow.core.ez_transaction_actors,

LATERAL FLATTEN(INPUT => actors) a

GROUP BY a.value

Last run: 10 days ago

	New Addresses Created	Current Week	Last Week	2 Weeks Ago	3 Weeks Ago	4 Weeks Ago	5 Weeks Ago	6 Weeks Ago	7 Weeks Ago	8 Weeks Ago	9 Weeks Ago	10 Weeks Ago	11 Weeks Ago
1	# transacting wallets on Cadence	8807	18977	28084	16261	15683	224864	523029	212992	9045	4704	6449	4083
2	Cadence % Change	-53.59	-32.43	72.71	3.69	-93.03	-57.01	145.56	2254.80	92.28	-27.06	57.95
3	# transacting wallets on EVM	2102	4785	671	9483	9814	1239	763	155	291	537	301	89
4	EVM % Change	-56.07	613.11	-92.92	-3.37	692.09	62.39	392.26	-46.74	-45.81	78.41	238.20
5	# total transacting wallets	10909	23762	28755	25744	25497	226103	523792	213147	9336	5241	6750	4172
6	Total % Change	-54.09	-17.36	11.70	0.97	-88.72	-56.83	145.74	2183.07	78.13	-22.36	61.79

726B

97s

flipside