flipside

    Share of Stakes by Platform
    SniperShare of Stakes by Platform
    Updated 2025-02-16
    with tbl as ( select block_timestamp,
    PROGRAM_NAME,
    tx_hash,
    MULTISIG_ADDRESS,
    ORIGIN_FROM_ADDRESS ,
    OWNER_ADDRESS,
    SERVICE_ID
    from crosschain.olas.ez_service_staking
    )

    select
    PROGRAM_NAME as platform,
    count(DISTINCT tx_hash) as stakes,
    count(DISTINCT ORIGIN_FROM_ADDRESS) as stakers,
    count(DISTINCT MULTISIG_ADDRESS) as mu_addr,
    count (DISTINCT SERVICE_ID) as serviceId,
    from tbl
    group by 1
    order by 1 desc






    Last run: about 2 months ago
    PLATFORM
    STAKES
    STAKERS
    MU_ADDR
    SERVICEID
    1
    		Quickstart Beta - Hobbyist209444444
    2
    		Quickstart Beta - Expert252595959
    3
    		Pearl Beta4131534528528
    4
    		Everest255171717
    5
    		Coastal771113112112
    6
    		Alpine336797979
    7
    		Alpha401717371
    7
    219B
    2s