charliemarketplaceselect-chains-score count
    Updated 4 days ago
    -- 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}}')




    Last run: 4 days ago
    CHAIN
    SCORE
    COUNT_WITH_SCORE
    1
    sei92832
    2
    sei712029
    3
    sei11161
    4
    sei621731
    5
    sei88712
    6
    sei10620
    7
    sei539834
    8
    sei17223626
    9
    sei1256
    10
    sei09949551
    11
    sei4892073
    12
    sei2997048
    13
    sei1313
    14
    sei31433703
    14
    225B
    3s