defi_internValidators
    Updated 2023-11-16
    SELECT
    DISTINCT DELEGATOR_ADDRESS AS delegator
    , sum(amount/pow(10,6)) as amount_sei
    from sei.core.fact_staking
    group by 1
    order by 2 desc




    /*
    case VALIDATOR_ADDRESS
    when 'seivaloper1xhxnad3c86q3d8ggsyu24j7r0y5k3ef4uhh9e2' then 'sei0'
    when 'seivaloper1qe8uuf5x69c526h4nzxwv4ltftr73v7qnkypla' then 'Stakecito'
    when 'seivaloper1d3ar2psa9ca55q45jg3q6f3ltmpr0ndqqlty87' then 'sei1'
    when 'seivaloper1qae8v3h6wd6f5yfxyx3zeumuddwhm4qeyz5qre' then 'Brochain'
    when 'seivaloper1hnkkqnzwmyw652muh6wfea7xlfgplnyj0ku4w4' then 'Cosmostation'
    when 'seivaloper1xh2gf9gyvumlgpr9ws5n425vhntv9rysw9gr4q' then 'StakingCabin'
    when 'seivaloper1d4lyuujr4urd7fkdlytccrd0cljqycycjp9xz8' then 'Notional'
    when 'seivaloper1zv9z2wqt348dhxqn38xv8dvsu78cle4xs2cdf4' then 'Enigma'
    when 'seivaloper1ummny4p645xraxc4m7nphf7vxawfzt3p5hn47t' then 'Everstake'
    when 'seivaloper1t9fq3qfm7ngau5gr8qgf5dpfzjqg79kf65cu04' then 'Imperator.co'
    when 'seivaloper146m089lq8mkqw6w0mmlhxz6247g2taha89at74' then 'RHINO'
    when 'seivaloper1mpe9rdk7ycujge7r9ncjt4ekamgrdcygvzwqe8' then 'polkachu.com'
    when 'seivaloper10hg23nf7eejwvthlad096x95pq84g4wnnwjtzq' then 'ContributionDAO'
    when 'seivaloper140l6y2gp3gxvay6qtn70re7z2s0gn57zl6nups' then 'Lavender.Five Nodes'
    when 'seivaloper16znh8ktn33dwnxxc9q0jmxmjf6hsz4tl0s6vxh' then 'Flipside'
    when 'seivaloper1wuj3xg3yrw4ryxn9vygwuz0necs4klj7j9nay6' then 'Hype INFRA'
    when 'seivaloper1spg334qdsxtmlzqn9vsh566477wd0hr56cjspj' then 'Citadel.one'
    when 'seivaloper14u38cl6knqxs6vs7lj7vzfvap42yyc3runtrwc' then 'Blockscope.net'
    when 'seivaloper17yen4et6asmmz43a49dka69h9l9r56n0tsq0yv' then 'Dora Factory'
    when 'seivaloper1eqgnd7ey0hnha8rrfukjrsawulhna0zagcg6a4' then 'Stakin'
    when 'seivaloper17ga9jha45gu0x04yrmfpjpksmqe48wupzk5jex' then 'Active Nodes'
    when 'seivaloper1wwfpmcvehq6yqdxfccs5rdr745q3kmy06l9d0d' then 'kingnodes 👑'
    when 'seivaloper1es38d8hn854vdcg8ql6fr3cycmahj6qypmpefu' then 'WhisperNode🤐'
    when 'seivaloper18tpdet22kpvswxayekwn55ry0r5acx4kaauupk' then 'A41'
    Run a query to Download Data