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: 9 days ago

	CHAIN	SCORE	COUNT_WITH_SCORE
1	sei	0	6847563
2	sei	10	289
3	sei	9	703
4	sei	12	22
5	sei	2	726916
6	sei	4	1505887
7	sei	11	99
8	sei	3	908063
9	sei	5	41828
10	sei	8	4218
11	sei	7	13346
12	sei	13	3
13	sei	6	23239
14	sei	1	3921055

222B