CHAIN | WEEK_ | # Active Addresses | # Score 4+ | |
|---|---|---|---|---|
1 | near | 2024-01-01 00:00:00.000 | 17852503 | 41152 |
2 | near | 2024-01-08 00:00:00.000 | 19845145 | 43097 |
3 | near | 2024-01-15 00:00:00.000 | 21112253 | 43686 |
4 | near | 2024-01-22 00:00:00.000 | 22870543 | 47881 |
5 | near | 2024-01-29 00:00:00.000 | 23786166 | 55590 |
6 | near | 2024-02-05 00:00:00.000 | 24697769 | 68616 |
7 | near | 2024-02-12 00:00:00.000 | 25446674 | 83717 |
8 | near | 2024-02-19 00:00:00.000 | 26107283 | 114054 |
9 | near | 2024-02-26 00:00:00.000 | 27449296 | 135474 |
10 | near | 2024-03-04 00:00:00.000 | 28225726 | 189038 |
11 | near | 2024-03-11 00:00:00.000 | 28325797 | 236687 |
12 | near | 2024-03-18 00:00:00.000 | 23641084 | 279743 |
13 | near | 2024-03-25 00:00:00.000 | 20462846 | 321462 |
14 | near | 2024-04-01 00:00:00.000 | 20615499 | 354024 |
15 | near | 2024-04-08 00:00:00.000 | 21177966 | 411275 |
16 | near | 2024-04-15 00:00:00.000 | 21653993 | 466762 |
17 | near | 2024-04-22 00:00:00.000 | 21760963 | 502847 |
18 | near | 2024-04-29 00:00:00.000 | 22023540 | 537176 |
19 | near | 2024-05-06 00:00:00.000 | 22194957 | 547695 |
20 | near | 2024-05-13 00:00:00.000 | 22233428 | 549695 |
theericstoneselect-chains-score historical 0/1/4+ copy
Updated 2025-03-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from charliemarketplace / select-chains-score historical 0/1/4+ @ https://flipsidecrypto.xyz/charliemarketplace/q/Cg0LXnd8TBOv/select-chains-score-historical-0-1-4
-- forked from select-chains-score historical @ https://flipsidecrypto.xyz/studio/queries/f73bc347-2acd-49e1-ba64-d88e5db21ded
with daily_score_tiers AS (
select
chain,
score_date,
sum (case when score >= 0 then count_with_score else 0 end) as n_scored,
sum (case when score >= 4 then count_with_score else 0 end) as n_4plus
from
datascience_public_misc.score_analytics.chain_score_distribution
where chain IN ('{{Chain}}')
group by chain, score_date
)
select
chain,
date_trunc('week', score_date) as week_,
median(n_scored) as "# Active Addresses",
median(n_4plus) as "# Score 4+"
from daily_score_tiers
group by chain, week_
order by week_ asc
Last run: 11 days ago
63
3KB
2s