Salehtotal_date
    Updated 17 hours ago
    with lst_price_one as (
    select
    hour::date as date_price
    ,avg(price) as ron_price
    from ronin.price.ez_prices_hourly
    where symbol='RON'
    group by 1
    order by hour::date desc
    limit 1
    )
    ,lst_validators as (
    select '0x6aaabf51c5f6d2d93212cf7dad73d67afa0148d0' as contract ,'Luganodes' as validator_name
    union all
    select '0xfc3e31519b551bd594235dd0ef014375a87c4e21' as contract ,'Nansen' as validator_name
    union all
    select '0x76310f62e47fc7f7ff3558a3afc88e2cf8fbb644' as contract ,'Zentry' as validator_name
    union all
    select '0x4e7ea047ec7e95c7a02cb117128b94ccdd8356bf' as contract ,'Ronin Catalyst' as validator_name
    union all
    select '0x05ad3ded6fcc510324af8e2631717af6da5c8b5b' as contract ,'MysticNode' as validator_name
    union all
    select '0xae53daac1bf3c4633d4921b8c3f8d579e757f5bc' as contract ,'EternityHub.tech' as validator_name
    union all
    select '0x32d619dc6188409cebbc52f921ab306f07db085b' as contract ,'Google' as validator_name
    union all
    select '0xf41af21f0a800dc4d86efb14ad46cfb9884fdf38' as contract ,'Sky Mavis GV' as validator_name
    union all
    select '0xedcafc4ad8097c2012980a2a7087d74b86bddaf9' as contract ,'BYAC' as validator_name
    union all
    select '0xca54a1700e0403dcb531f8db4ae3847758b90b01' as contract ,'artic x' as validator_name
    union all
    select '0x749f36cc1daeec1bced9f1f182c92851727d1e73' as contract ,'RonerDAO' as validator_name
    union all
    select '0xbeef86b900b6b791d1cc7746ce030aa8d4e4cafe' as contract ,'BlockAhead.dev' as validator_name
    union all
    select '0x6e46924371d0e910769aabe0d867590deac20684' as contract ,'StableNode' as validator_name
    Last run: about 17 hours ago
    DATE
    RON Price
    Stakes
    Delegators
    Validators
    Staked Volume
    Staked Volume-USD
    Average Staked Volume-USD
    1
    2024-09-30 00:00:00.0000.79002225126237631282279475.695213421800836.5175528285.566688091
    2
    2024-10-07 00:00:00.0000.7900222513376788429-1867169.12881339-1475105.15627569-64.8169943
    3
    2024-10-14 00:00:00.0000.7900222515020909429491302.446281032388139.86404144515.544247659
    4
    2024-10-21 00:00:00.0000.7900222516055100323030532.10032225924121.0385938170.9288397163
    5
    2024-10-28 00:00:00.0000.7900222514288893129-139688.666549608-110357.154647021-4.623257421
    6
    2024-11-04 00:00:00.0000.7900222515695938831-1829202.40273851-1445110.59791688-54.298887725
    7
    2024-11-11 00:00:00.0000.7900222516911973331572251.732755801452091.60147813716.614906339
    8
    2024-11-18 00:00:00.0000.79002225176621030531-855579.002427178-675926.448550274-23.399793968
    9
    2024-11-25 00:00:00.0000.79002225224281247331-10099439.2772235-7978781.74153046-230.307751459
    10
    2024-12-02 00:00:00.0000.7900222522256124283313435786.639200410614570.3912211304.247030246
    11
    2024-12-09 00:00:00.0000.79002225170539518322869430.28704332266913.7715880980.681701662
    12
    2024-12-16 00:00:00.0000.79002225195221019432-1284280.88150724-1014610.47164034-32.570719131
    13
    2024-12-23 00:00:00.0000.790022252678820194341081175.50168481854152.70248591321.850367156
    14
    2024-12-30 00:00:00.0000.79002225184031064133970219.492226057766494.98624228724.367210905
    15
    2025-01-06 00:00:00.0000.790022253893522214362088108.023231561649651.7987564531.16195925
    16
    2025-01-13 00:00:00.0000.790022253898520176332843129.264732342246135.3787646942.825949107
    17
    2025-01-20 00:00:00.0000.79002225326411484634-874475.181706401-690854.850620849-15.11684319
    18
    2025-01-27 00:00:00.0000.79002225242801283034373708.544501575295238.065171367.849153644
    19
    2025-02-03 00:00:00.0000.790022252286313674341960915.750275491549167.0730930842.925105932
    20
    2025-02-10 00:00:00.0000.79002225203791052934-2356947.29418613-1862040.80448434-54.407456887
    25
    2KB
    20s