msg_value:delegator_address::string as delegators,

sum(msg_value:amount:amount / pow(10,6)) as luna_delegated

from terra.msgs

where msg_module = 'staking'

and msg_type = 'staking/MsgDelegate'

and tx_status = 'SUCCEEDED'

and block_timestamp >= '2020-10-03' -- min(block_timestamp)

and msg_value:delegator_address::string != 'terra1dp0taj85ruc299rkdvzp4z5pfg6z6swaed74e6' -- removing this because this is a TFL address

group by 1

order by 2 DESC

limit 25