CHAIN | WEEK_ | Median Score | Avg. Score | 90th Percentile (top 10%) | 99th Percentile (top 1%) | |
|---|---|---|---|---|---|---|
1 | near | 2024-01-01 00:00:00.000 | 1 | 1.178357231 | 2 | 2 |
2 | near | 2024-01-08 00:00:00.000 | 1 | 1.162807427 | 2 | 2 |
3 | near | 2024-01-15 00:00:00.000 | 1 | 1.148071928 | 2 | 2 |
4 | near | 2024-01-22 00:00:00.000 | 1 | 1.170981642 | 2 | 2 |
5 | near | 2024-01-29 00:00:00.000 | 1 | 1.193173334 | 2 | 2 |
6 | near | 2024-02-05 00:00:00.000 | 1 | 1.207387032 | 2 | 2 |
7 | near | 2024-02-12 00:00:00.000 | 1 | 1.219353618 | 2 | 2 |
8 | near | 2024-02-19 00:00:00.000 | 1 | 1.23128347 | 2 | 2 |
9 | near | 2024-02-26 00:00:00.000 | 1 | 1.233165652 | 2 | 3 |
10 | near | 2024-03-04 00:00:00.000 | 1 | 1.23545924 | 2 | 3 |
11 | near | 2024-03-11 00:00:00.000 | 1 | 1.254636825 | 2 | 3 |
12 | near | 2024-03-18 00:00:00.000 | 1 | 1.324266941 | 2 | 4 |
13 | near | 2024-03-25 00:00:00.000 | 1 | 1.39647095 | 2 | 4 |
14 | near | 2024-04-01 00:00:00.000 | 1 | 1.415936961 | 2 | 4 |
15 | near | 2024-04-08 00:00:00.000 | 1 | 1.425808125 | 2 | 4 |
16 | near | 2024-04-15 00:00:00.000 | 1 | 1.434622196 | 2 | 4 |
17 | near | 2024-04-22 00:00:00.000 | 1 | 1.443752237 | 2 | 4 |
18 | near | 2024-04-29 00:00:00.000 | 1 | 1.435038418 | 2 | 4 |
19 | near | 2024-05-06 00:00:00.000 | 1 | 1.41568605 | 2 | 4 |
20 | near | 2024-05-13 00:00:00.000 | 1 | 1.424650711 | 2 | 4 |
theericstoneselect-chains-score historical 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
›
⌄
-- forked from charliemarketplace / select-chains-score historical @ https://flipsidecrypto.xyz/charliemarketplace/q/UC2HutShHFCm/select-chains-score-historical
select
chain, -- the blockchain, e.g., aptos, arbitrum, avalanche, base.
date_trunc('week', score_date) as week_, -- the date when scores for all users on the chain were calculated.
median(median_score) as "Median Score", -- The median score across all scored addresses on the chain-score_date. .e., 0, 1, 2, 3, etc. up to 15.
AVG(avg_score) as "Avg. Score", -- the average score across all scored addresses on the chain as of the score_date
median(percentile90_score) as "90th Percentile (top 10%)", -- 90th percentile score (uses approximation for speed which is fine) 90% of users have this score or lower.
median(percentile99_score) as "99th Percentile (top 1%)" -- 99th percentile score, i.e., top 1% active users have this score or higher.
from
datascience_public_misc.score_analytics.chain_score_spread
where chain IN ('{{Chain}}')
group by 1,2
order by week_ ASC
Last run: 11 days ago
63
3KB
1s