flipside

    select-chains-score historical 0/4+ compare copy copy
    winnie-fsselect-chains-score historical 0/4+ compare copy copy
    Updated 5 days ago
    -- forked from theericstone / select-chains-score historical 0/4+ compare copy @ https://flipsidecrypto.xyz/theericstone/q/nhDDXJPZifIj/select-chains-score-historical-0-4-compare-copy

    -- forked from charliemarketplace / select-chains-score historical 0/4+ compare @ https://flipsidecrypto.xyz/charliemarketplace/q/NOZr-hhX7kZr/select-chains-score-historical-0-4-compare

    -- forked from select-chains-score historical 0/1/4+ @ https://flipsidecrypto.xyz/studio/queries/a5b7796c-9f8e-4528-93ac-4acb095a6e87

    -- 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 (
    SELECT value
    FROM TABLE(SPLIT_TO_TABLE('{{Chains}}', ' '))
    )
    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: 5 days ago
    CHAIN
    WEEK_
    # Active Addresses
    # Score 4+
    1
    		ethereum2024-01-01 00:00:00.00010718046629010
    2
    		solana2024-01-01 00:00:00.00047762501418601
    3
    		solana2024-01-08 00:00:00.00050695021529830
    4
    		ethereum2024-01-08 00:00:00.00010846370636931
    5
    		solana2024-01-15 00:00:00.00054319621673614
    6
    		ethereum2024-01-15 00:00:00.00011142325646336
    7
    		solana2024-01-22 00:00:00.00058293331878167
    8
    		ethereum2024-01-22 00:00:00.00011362969661593
    9
    		solana2024-01-29 00:00:00.00064331492146654
    10
    		ethereum2024-01-29 00:00:00.00011499290676811
    11
    		solana2024-02-05 00:00:00.00067552452275560
    12
    		ethereum2024-02-05 00:00:00.00011592426686705
    13
    		ethereum2024-02-12 00:00:00.00011734028696191
    14
    		solana2024-02-12 00:00:00.00069912512393564
    15
    		solana2024-02-19 00:00:00.00073539252473175
    16
    		ethereum2024-02-19 00:00:00.00011856372704530
    17
    		solana2024-02-26 00:00:00.00077747962669778
    18
    		ethereum2024-02-26 00:00:00.00012167593715010
    19
    		solana2024-03-04 00:00:00.00085684542982247
    20
    		ethereum2024-03-04 00:00:00.00012400814720683
    ...
    130
    7KB
    2s