select-chains-score count copy

winnie-fsselect-chains-score count copy

Updated 2024-12-11

-- forked from charliemarketplace / select-chains-score count @ https://flipsidecrypto.xyz/charliemarketplace/q/r3uYAGC6wBhM/select-chains-score-count

-- forked from select-chains-score @ https://flipsidecrypto.xyz/studio/queries/8184dd83-bf7c-4b54-946f-685cb272480e

select

chain, score, count_with_score

from

DATASCIENCE_PUBLIC_MISC.SCORE_ANALYTICS.CHAIN_SCORE_DISTRIBUTION

where score_date= (select max(score_date) from DATASCIENCE_PUBLIC_MISC.SCORE_ANALYTICS.CHAIN_SCORE_DISTRIBUTION where chain = '{{Chain}}')

and chain IN ('{{Chain}}')

$query('id')

Last run: 12 days ago

	CHAIN	SCORE	COUNT_WITH_SCORE
1	sei	1	6642891
2	sei	11	138
3	sei	7	12217
4	sei	12	30
5	sei	6	21829
6	sei	9	2768
7	sei	13	9
8	sei	8	8690
9	sei	4	1094351
10	sei	5	38747
11	sei	10	576
12	sei	2	1125914
13	sei	3	1372824
14	sei	0	9835461

226B