neari news | adriaparcerisas

Updated 2025-03-02

WITH first_appearance AS (

SELECT

owner_id,

token_id,

MIN(DATE_TRUNC('week', block_timestamp)) as first_week

FROM near.defi.fact_intents

GROUP BY 1,2

daily_metrics AS (

SELECT

DATE_TRUNC('week', i.block_timestamp) as date,

COUNT(DISTINCT i.tx_hash) as daily_intents,

COUNT(DISTINCT i.owner_id) as active_users,

COUNT(DISTINCT i.token_id) as active_contracts,

COUNT(DISTINCT CASE

WHEN DATE_TRUNC('week', i.block_timestamp) = fo.first_week

THEN i.owner_id

END) as new_users,

COUNT(DISTINCT CASE

WHEN DATE_TRUNC('week', i.block_timestamp) = fp.first_week

THEN i.token_id

END) as new_contracts

FROM near.defi.fact_intents i

LEFT JOIN first_appearance fo ON i.owner_id = fo.owner_id

LEFT JOIN first_appearance fp ON i.token_id = fp.token_id

GROUP BY 1

ORDER BY 1

cumulative_metrics AS (

SELECT

date,

daily_intents,

active_users,

active_contracts,

new_users,

new_contracts,

Last run: 2 months ago

	DATE	DAILY_INTENTS	ACTIVE_USERS	NEW_USERS	TOTAL_USERS	ACTIVE_CONTRACTS	NEW_CONTRACTS	TOTAL_CONTRACTS	CUMULATIVE_INTENTS
1	2025-02-17 00:00:00.000	1486	234	164	2189	36	32	408	18980
2	2025-02-10 00:00:00.000	1524	263	200	2025	42	33	376	17494
3	2025-02-03 00:00:00.000	1396	239	197	1825	46	36	343	15970
4	2025-01-27 00:00:00.000	851	186	135	1628	39	35	307	14574
5	2025-01-20 00:00:00.000	2012	255	208	1493	31	29	272	13723
6	2025-01-13 00:00:00.000	1432	263	220	1285	31	26	243	11711
7	2025-01-06 00:00:00.000	680	150	113	1065	30	29	217	10279
8	2024-12-30 00:00:00.000	578	172	141	952	21	19	188	9599
9	2024-12-23 00:00:00.000	737	194	177	811	27	22	169	9021
10	2024-12-16 00:00:00.000	879	226	205	634	27	24	147	8284
11	2024-12-09 00:00:00.000	764	167	153	429	21	21	123	7405
12	2024-12-02 00:00:00.000	1849	99	92	276	22	19	102	6641
13	2024-11-25 00:00:00.000	3188	61	52	184	24	19	83	4792
14	2024-11-18 00:00:00.000	299	69	65	132	20	20	64	1604
15	2024-11-11 00:00:00.000	384	43	37	67	22	21	44	1305
16	2024-11-04 00:00:00.000	921	30	30	30	23	23	23	921

949B

12s

flipside