from terra.staking

where dt >= CURRENT_DATE - 60 and tx_status = 'SUCCEEDED' and action in ('delegate', 'redelegate')

group by 1),

daily as (select date_trunc('day', block_timestamp) as dt, validator_address, sum(event_amount) as amount

from terra.staking

where dt >= CURRENT_DATE - 60 and tx_status = 'SUCCEEDED' and action in ('delegate', 'redelegate')

group by 1,2),

labels as (select address, label

from terra.labels

where label_subtype = 'validator'),

final as (select a.dt, a.validator_address, c.label, case

when c.label is null then a.validator_address

else c.label end as validators,

a.amount, case

when a.dt = b.dt then b.daily_total

else null end as Total_Staking,

(a.amount/total_staking)*100 as percentage

from daily a

left join staking b on a.dt = b.dt

left outer join labels c on a.validator_address = c.address),

lasts as (select dt, validators, amount, percentage, ROW_NUMBER() OVER (PARTITION BY dt ORDER BY amount DESC) as rank

from final)

select dt, validators, amount, percentage

from lasts

where rank < 11