flipside

    meta_pool_dist_user_date
    Salehmeta_pool_dist_user_date
    Updated 2025-04-22
    with near_price as (
    with MEMEs_api as (
    select livequery.live.udf_api(
    'GET',
    'https://api.nearblocks.io/v1/stats/price'
    ,{'accept': 'application/json'}, {}) as response
    )
    ,tokens_raw as (
    select
    value:near_price as near_price
    from
    MEMEs_api,
    LATERAL FLATTEN (input => response:data:stats))
    select * from tokens_raw
    )
    ,stNEAR_price as (
    with MEMEs_api as (
    select livequery.live.udf_api(
    'GET',
    'https://api.nearblocks.io/v1/fts/meta-pool.near'
    ,{'accept': 'application/json'}, {}) as response
    )
    ,tokens_raw as (
    select
    value:price as stNEAR_price
    from
    MEMEs_api,
    LATERAL FLATTEN (input => response:data:contracts))
    select * from tokens_raw
    )

    ,lst_stake as (
    select
    block_timestamp::date as date
    ,tx_hash
    ,signer_id as staker
    Last run: about 2 months ago
    DATE
    ($) Staking Distribution
    DELEGATORS
    1
    		2025-04-01 00:00:00.000[11-100 ($)]19
    2
    		2025-04-01 00:00:00.000[101-500 ($)]16
    3
    		2023-02-01 00:00:00.000[101-500 ($)]46
    4
    		2023-01-01 00:00:00.000[less than 10 ($)]35
    5
    		2022-12-01 00:00:00.000[101-500 ($)]59
    6
    		2025-02-01 00:00:00.000[501-1,000 ($)]13
    7
    		2025-02-01 00:00:00.000[less than 10 ($)]30
    8
    		2022-02-01 00:00:00.000[5,001-10,000 ($)]17
    9
    		2023-10-01 00:00:00.000[501-1,000 ($)]10
    10
    		2021-11-01 00:00:00.000[501-1,000 ($)]82
    11
    		2023-03-01 00:00:00.000[101-500 ($)]59
    12
    		2024-04-01 00:00:00.000[1,001-5,000 ($)]33
    13
    		2024-06-01 00:00:00.000[501-1,000 ($)]24
    14
    		2023-05-01 00:00:00.000[More than 10,000 ($)]12
    15
    		2024-06-01 00:00:00.000[less than 10 ($)]263
    16
    		2022-10-01 00:00:00.000[101-500 ($)]71
    17
    		2023-05-01 00:00:00.000[101-500 ($)]49
    18
    		2022-08-01 00:00:00.000[1,001-5,000 ($)]47
    19
    		2024-02-01 00:00:00.000[5,001-10,000 ($)]6
    20
    		2024-07-01 00:00:00.000[More than 10,000 ($)]10
    ...
    314
    15KB
    125s