Ali3NTop 10 Cosmos Validators Stats in 2023
    Updated 2023-02-17
    with Validators_Table as (
    select tx_id,
    label as Validator_Label
    from cosmos.core.fact_msg_attributes t1 join cosmos.core.fact_validators t2 on t1.attribute_value = t2.address
    where msg_type = 'delegate'
    and attribute_key = 'validator'
    and label in ('🐠stake.fish','DokiaCapital','Coinbase Custody','SG-1','Zero Knowledge Validator (ZKV)','Binance Node','Everstake','Polychain','GAME','Paradigm')),

    delegateamount as (
    select tx_id,
    block_timestamp,
    split(ATTRIBUTE_VALUE,'uatom')[0]::numeric/1e6 as Delegate_Amount
    from cosmos.core.fact_msg_attributes
    where msg_type = 'delegate'
    and attribute_key = 'amount'
    and tx_id in (select tx_id from Validators_Table)
    and block_timestamp >= '2023-01-01'),

    delegatort as (
    select tx_id,
    block_timestamp,
    attribute_value as Delegator
    from cosmos.core.fact_msg_attributes
    where msg_type = 'coin_spent'
    and attribute_index = '0'
    and attribute_key = 'spender'
    and msg_index = '0'
    and tx_id in (select tx_id from Validators_Table)
    and block_timestamp >= '2023-01-01'),

    maindelegate as (
    select t1.tx_id,
    t2.block_timestamp,
    delegator,
    delegate_amount,
    Validator_Label
    Run a query to Download Data