PapasotLuna Staking date specific query
    Updated 2022-01-23
    select
    date_trunc('day',block_timestamp) as block_day,
    date_trunc('hour',block_timestamp) as block_hour,
    delegator_address,
    validator_address,
    validator_address_label,
    event_amount_usd,
    case
    when delegator_address = 'terra1aj42lga06ujtj4vwfpsn74rqdcjvfdh2namcs8' then 'me'
    else 'everyone else' end as delegator
    from terra.staking
    where validator_address = 'terravaloper1r843mpk5zzkfgtnduskd0dzgeltv0n503ckzy6'
    and block_day = '2021-12-16'
    Run a query to Download Data