from terra.staking

where date_trunc('day',block_timestamp) = '2021-06-30'

and action = 'delegate'

group by 1