DATE | RON_PRICE | N_VALIDATORS | N_DELEGATORS | CURRENT_DELEGATE_AMT | UNDELEGATE_AMT | DELEGATE_AMT | CLAIMED_REWARD | NET_AMOUNT | TOTAL_NET_AMOUNT | TOTAL_DELEGATE_AMT | TOTAL_CLAIMED_REWARD | CURRENT_DELEGATE_AMT_USD | UNDELEGATE_AMT_AMT_USD | DELEGATE_AMT_AMT_USD | CLAIMED_REWARD_AMT_USD | TOTAL_CLAIMED_REWARD_USD | TOTAL_DELEGATE_AMT_USD | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-03-27 00:00:00.000 | 0.791806 | 36 | 335 | -94234.0547986 | -109934.322225709 | 15700.267427108 | 2736.354824884 | -94234.0547986 | 8306801.04839342 | 8306801.04839343 | 2164274.57005741 | -74615.08999386 | -87046.655944249 | 12431.565950389 | 2166.662168472 | 1713685.59021887 | 12473720.4700434 |
2 | 2025-03-26 00:00:00.000 | 0.804955 | 38 | 1255 | -264870.444845935 | -505122.165121209 | 240251.720275274 | 16640.382085479 | -264870.444845935 | 8401035.10319202 | 8401035.10319203 | 2161538.21523252 | -213208.78893096 | -406600.612425143 | 193391.823494183 | 13394.758761617 | 1739940.99404249 | 12548335.5600373 |
3 | 2025-03-25 00:00:00.000 | 0.8048865 | 39 | 1534 | -249674.747040269 | -3946855.92830392 | 3697181.18126365 | 15691.41866104 | -249674.74704027 | 8665905.54803796 | 8665905.54803796 | 2144897.83314704 | -200959.833283627 | -3176771.05413679 | 2975811.22085317 | 12629.811046119 | 1726399.30977931 | 12761544.3489683 |
4 | 2025-03-24 00:00:00.000 | 0.807054 | 38 | 2213 | 1367827.5363851 | -597574.04722293 | 1965401.58360803 | 46026.884818045 | 1367827.5363851 | 8915580.29507823 | 8915580.29507823 | 2129206.414486 | 1103910.68454974 | -482274.525107454 | 1586185.20965719 | 37146.181499942 | 1718384.55363659 | 12962504.1822519 |
5 | 2025-03-23 00:00:00.000 | 0.784499 | 38 | 1721 | -1397935.00382689 | -2288965.4105088 | 891030.406681918 | 15274.750404137 | -1397935.00382689 | 7547752.75869313 | 7547752.75869313 | 2083179.52966796 | -1096678.61256719 | -1795691.07557875 | 699012.463011558 | 11983.026417295 | 1634252.25784498 | 11858593.4977021 |
6 | 2025-03-22 00:00:00.000 | 0.7793365 | 38 | 1564 | 136605.446189593 | -143590.201046031 | 280195.647235624 | 12250.149728997 | 136605.446189593 | 8945687.76252001 | 8945687.76252002 | 2067904.77926382 | 106461.610314336 | -111905.08471751 | 218366.695031846 | 9546.988814272 | 1611593.67300474 | 12955272.1102693 |
7 | 2025-03-21 00:00:00.000 | 0.7722785 | 37 | 1370 | -371988.579725102 | -596634.246769713 | 224645.667044611 | 13574.684751028 | -371988.579725102 | 8809082.31633042 | 8809082.31633042 | 2055654.62953483 | -287278.782367232 | -460767.801143944 | 173489.018776712 | 10483.437177497 | 1587537.87381521 | 12848810.499955 |
8 | 2025-03-20 00:00:00.000 | 0.787228 | 38 | 1763 | -112977.42842768 | -1733847.32516272 | 1620869.89673504 | 8585.591049814 | -112977.42842768 | 9181070.89605552 | 9181070.89605552 | 2042079.9447838 | -88938.995026265 | -1364933.1620932 | 1275994.16706693 | 6758.817670963 | 1607582.51077226 | 13136089.2823222 |
9 | 2025-03-19 00:00:00.000 | 0.794482 | 37 | 1257 | -403711.498277924 | -585373.933483531 | 181662.435205607 | 6728.368237832 | -403711.498277924 | 9294048.3244832 | 9294048.3244832 | 2033494.35373398 | -320741.518574842 | -465069.053421862 | 144327.534847021 | 5345.567454329 | 1615574.66114328 | 13225028.2773485 |
10 | 2025-03-18 00:00:00.000 | 0.779985 | 37 | 1321 | 228059.27525625 | -369832.368862458 | 597891.644118707 | 58524.954699604 | 228059.27525625 | 9697759.82276112 | 9697759.82276113 | 2026765.98549615 | 177882.813810746 | -288463.700227184 | 466346.51403793 | 45648.586791371 | 1580847.06719722 | 13545769.7959233 |
11 | 2025-03-17 00:00:00.000 | 0.7966735 | 37 | 1451 | -72660.790091056 | -697719.348449545 | 625058.558358489 | 29323.004433343 | -72660.790091056 | 9469700.54750487 | 9469700.54750488 | 1968241.03079655 | -57886.925954607 | -555854.515347019 | 497967.589392412 | 23360.860572427 | 1568045.47084829 | 13367886.9821126 |
12 | 2025-03-16 00:00:00.000 | 0.793401 | 36 | 1804 | 12436.940754959 | -131894.283839736 | 144331.224594695 | 32231.653649584 | 12436.940754959 | 9542361.33759593 | 9542361.33759593 | 1938918.0263632 | 9867.481231926 | -104645.05669273 | 114512.537924656 | 25572.626237234 | 1538339.50103459 | 13425773.9080672 |
13 | 2025-03-15 00:00:00.000 | 0.8388435 | 36 | 2807 | 272619.371881946 | -96601.233142175 | 369220.605024121 | 21217.420806509 | 272619.371881946 | 9529924.39684097 | 9529924.39684097 | 1906686.37271362 | 228684.988077253 | -81033.316513298 | 309718.304590551 | 17798.095530304 | 1599411.4702894 | 13415906.4268353 |
14 | 2025-03-14 00:00:00.000 | 0.8302815 | 38 | 3286 | 168599.883669832 | -414039.052640655 | 582638.936310487 | 5885.272356422 | 168599.883669832 | 9257305.02495902 | 9257305.02495903 | 1885468.95190711 | 139985.364313214 | -343768.965685062 | 483754.329998275 | 4886.432759999 | 1565469.98959286 | 13187221.438758 |
15 | 2025-03-13 00:00:00.000 | 0.8101125 | 37 | 1686 | 309185.43855702 | -193422.986805676 | 502608.425362696 | 10110.959167307 | 309185.43855702 | 9088705.14128919 | 9088705.1412892 | 1879583.67955069 | 250474.988593024 | -156694.379398613 | 407169.367991637 | 8191.014408425 | 1522674.23360001 | 13047236.0744448 |
16 | 2025-03-12 00:00:00.000 | 0.8032635 | 35 | 1416 | 490419.593909042 | -329647.886784145 | 820067.480693187 | 59509.278505838 | 490419.593909042 | 8779519.70273217 | 8779519.70273218 | 1869472.72038338 | 393936.159471956 | -264794.115305836 | 658730.274777792 | 47801.631335074 | 1501679.20052968 | 12796761.0858518 |
17 | 2025-03-11 00:00:00.000 | 0.719162 | 35 | 1483 | 893850.851443016 | -595614.470968501 | 1489465.32241152 | 19690.915990514 | 893850.851443016 | 8289100.10882313 | 8289100.10882313 | 1809963.44187754 | 642823.566025463 | -428343.294170649 | 1071166.86019611 | 14160.95852557 | 1301656.92878754 | 12402824.9263798 |
18 | 2025-03-10 00:00:00.000 | 0.7869915 | 35 | 1826 | -150820.867779268 | -772349.274052723 | 621528.406273456 | 6939.904368993 | -150820.867779268 | 7395249.25738011 | 7395249.25738012 | 1790272.52588703 | -118694.740964908 | -607832.313710664 | 489137.572745756 | 5461.645749211 | 1408929.26055662 | 11760001.3603544 |
19 | 2025-03-09 00:00:00.000 | 0.858716 | 36 | 1595 | 2525955.85079337 | -711451.793511736 | 3237407.6443051 | 39403.387687793 | 2525955.85079337 | 7546070.12515938 | 7546070.12515938 | 1783332.62151804 | 2169078.70436988 | -610935.038317224 | 2780013.7426871 | 33836.319461711 | 1531376.25541948 | 11878696.1013193 |
20 | 2025-03-08 00:00:00.000 | 0.889915 | 35 | 1456 | -152067.989201629 | -405757.568268339 | 253689.57906671 | 39640.665881231 | -152067.989201629 | 5020114.27436602 | 5020114.27436602 | 1743929.23383024 | -135327.584610368 | -361089.746365519 | 225762.161755151 | 35276.823177695 | 1551948.78412404 | 9709617.3969494 |
0xHaM-dOver Time
Updated 8 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with eventTb as (
select
block_timestamp,
ORIGIN_FUNCTION_SIGNATURE,
tx_hash,
from_address as delegator,
value as amount,
concat('0x',split(input_data,'000000000000000000000000')[1]) as validator_id
from ronin.core.fact_transactions
where block_timestamp::date>='2024-10-01'
and ORIGIN_FUNCTION_SIGNATURE = '0x5c19a95c' --Delegate
and TO_ADDRESS='0x545edb750eb8769c868429be9586f5857a768758'
union all
select
block_timestamp,
ORIGIN_FUNCTION_SIGNATURE,
tx_hash,
origin_from_address as delegator,
DECODED_LOG:amount/1e18 as amount,
DECODED_LOG:poolId as validator_id
from ronin.core.ez_decoded_event_logs
where block_timestamp::date>='2024-10-01'
and origin_TO_ADDRESS='0x545edb750eb8769c868429be9586f5857a768758'
and ORIGIN_FUNCTION_SIGNATURE in (
'0x4d99dd16' --undelegate
, '0x097e4a9d' -- RewardClaimed
)
and EVENT_NAME in ('Undelegated','RewardClaimed')
)
,
priceTb as (
select
hour::date as p_date,
median(price) as ron_price,
Last run: 8 days ago
86
23KB
38s