Great!

cast(left(a.vesting_shares, len(vesting_shares)-6) as float)*RATE/1000000

will soon be

vesting_shares*RATE/1000000

A little easier to read and a bit quicker, although I'm sure it's not the bottleneck in most of my queries ;)