(

select --- Selecting addresses that are delegating to a Terra Validator.

validator_address_label,

VALIDATOR_ADDRESS, --- Important to add for addresses that do not have a validator label.

delegator_address as address_dataset, --- Delegator addresses will be selected amongst those who are staking MINE.

ACTION,

EVENT_AMOUNT_USD --- delegated amounts converted to USD

from terra.staking

where address_dataset in

(

select --- Dataset of addresses staking MINE

event_attributes:"from"::string as address_dataset

from terra.msg_events

where event_attributes:"1_contract_address" = 'terra1xu8utj38xuw6mjwck4n97enmavlv852zkcvhgp' -- pylon governance for deposits

or event_attributes:"0_contract_address" = 'terra1xu8utj38xuw6mjwck4n97enmavlv852zkcvhgp' -- pylon governance for withdrawals

)

and action <> 'undelegate'

)

select

validator_address_label,

VALIDATOR_ADDRESS,

round(sum(EVENT_AMOUNT_USD),2) as Total_Delegated_Amount_USD

from staking

group by 1, 2

order by 3 DESC