MostlyData_Top 10 Validator - Monthly performance (Cosmos)
    Updated 2023-11-28
    with staking_data as(
    select
    block_timestamp,
    tx_id,
    msg_index,
    msg_type,
    msg_group,
    attribute_key,
    attribute_value

    from cosmos.core.fact_msg_attributes
    where block_timestamp > current_date() - interval '1 month'
    and (
    msg_type = 'delegate'
    or msg_type = 'unbond'
    or msg_type = 'redelegate'
    or msg_type = 'message'
    )
    ),

    staking_data_past as(
    select
    block_timestamp,
    tx_id,
    msg_index,
    msg_type,
    msg_group,
    attribute_key,
    attribute_value

    from cosmos.core.fact_msg_attributes
    where block_timestamp < current_date() - interval '1 month'
    and block_timestamp > current_date() - interval '2 month'
    and (
    msg_type = 'delegate'
    or msg_type = 'unbond'
    Run a query to Download Data