hessOverview of top 1000 Addresses
    Updated 4 days ago
    with delegate as (select DELEGATOR_ADDRESS,
    sum(amount/pow(10,6)) as delegate_amount,
    count(DISTINCT tx_id) as delegate_tx,
    count(DISTINCT DELEGATOR_ADDRESS) as delegate_user,
    avg(amount/pow(10,6)) as avg_delegate_amount
    from axelar.gov.fact_staking
    where action = 'delegate'
    group by 1
    )
    ,
    undelegate as (select DELEGATOR_ADDRESS,
    sum(amount/pow(10,6))*-1 as undelegate_amounts,
    count(DISTINCT tx_id)*-1 as undelegate_txs,
    count(DISTINCT DELEGATOR_ADDRESS)*-1 as undelegate_user,
    avg(amount/pow(10,6)) as avg_undelegate_amounts
    from axelar.gov.fact_staking
    where action = 'undelegate'
    group by 1
    )

    select a.DELEGATOR_ADDRESS,
    delegate_amount,
    ifnull(avg_undelegate_amounts,0) as undelegate_amount,
    delegate_amount+undelegate_amount as Net,
    delegate_tx,
    ifnull(undelegate_txs,0) as undelegate_tx,
    avg_delegate_amount,
    ifnull(avg_undelegate_amounts,0) as avgavg_undelegate_amount
    from delegate a left outer join undelegate b on a.DELEGATOR_ADDRESS = b.DELEGATOR_ADDRESS
    order by 4 desc
    limit 1000



    Last run: 4 days ago
    DELEGATOR_ADDRESS
    DELEGATE_AMOUNT
    UNDELEGATE_AMOUNT
    NET
    DELEGATE_TX
    UNDELEGATE_TX
    AVG_DELEGATE_AMOUNT
    AVGAVG_UNDELEGATE_AMOUNT
    1
    axelar14frs4mpggrww86h2n0ykqjstwypcllsz077e50252769999.9999951328828.8840367254098828.88403243-522633020.833333281328828.8840367
    2
    axelar1r3pu4jjatcrwpjyca5zaweltstepkgqp54dhtv4640454046404540928090801-14640454046404540
    3
    axelar1ren608jc4cnslzsxs08memmmda2djncxcudhh784555669.7335623676333.4666766188232003.2002386134-23631012.4606982243676333.46667661
    4
    axelar1am2yc4lvyp27q8a6ehmscyv29u4qhfjx6a4jvs81058465.15831699465.3586218382757930.516921838-232133117.504165791699465.35862183
    5
    axelar1ezpemdmshyje4p4d2gmje8vv8w6nz4k5ndy52x62467051.0796343287721.1094592165754772.1890932371-19168374.800753733287721.10945921
    6
    axelar14k7jpx6u0fj4yl273yu5glzdedaw5wzkkdzzmj59000004.22950000.2161950004.4129-202034482.903448282950000.21
    7
    axelar15366t0hk23wz8rrz92yw8trvperwr3nehc52m054355073.96551907270.8225833356262344.788083320-62717753.6982751907270.82258333
    8
    axelar1470j254cgy9tecw333v5dar2x6cudjpnxzvynk27176960.01734113588480.008670540765440.026011589-2305359.10131843813588480.0086705
    9
    axelar1y7rv6fqxyum0yux9tmplhfk9e3z3t7kk3he7wy1785714217857142357142841-11785714217857142
    10
    axelar17h2wdyu6pcdfck6t0wy280jk24m8nugftf2pmf31657461.83832638121.73652534295583.57482515-122110497.455886672638121.736525
    11
    axelar1tkxrdzgrwkgrhl9ks3cujlkkjlgc5dk8udwu3u33632295.639999033632295.639999202802691.303333250
    12
    axelar1ph0qnh7u2fhuqrx0w27mpg338np6uhqhrqh7qs32400000719687.11111113333119687.111111157-45568421.052631579719687.111111133
    13
    axelar1kn40l8w85f72s8n793ky5dhghf39lpmsdz0fef20575549.80729710287774.903648530863324.710945589-2231185.95289097810287774.9036485
    14
    axelar1ez4duq7700ncrn9fjspl055tkvvtg47kfdmtw628239974.448339655083.62234392128895058.070682931-38910966.917688355655083.622343921
    15
    axelar107st7afj07qgp5qsdvz8e0v5zd97xerr046m4y23043985.1004344569593.9864176727613579.0868517348-366218.3479897534569593.98641767
    16
    axelar1ae85qw6pyl6wsf6hgz3szh0wg5mqf0zjxqfjf023212500.761837400000027212500.7618379-22579166.751315224000000
    17
    axelar1qksza8ge9r872syq4n4ec3nufr5jzwfv7shenf13204254.63676213204254.63676226408509.2735242-16602127.31838113204254.636762
    18
    axelar1j0annpmn5qyfsw466a78skjssdlnhq7z2rpw8s22562421.7891511364387.2827028623926809.071853917-71327201.281714761364387.28270286
    19
    axelar12ff0kf7ndscu8epmnwn7nzwmwwud64fhjjv9gs212379632654745.37523892708.3757-83033994.714285712654745.375
    20
    axelar159akkvrsrl24ypa8q52wf3rsq8duk5af0ryqfv180000003000000210000006-630000003000000
    ...
    1000
    106KB
    4s