Retail investing has experienced a rebirth over the past year, with nearly 800,000 new accounts opened at the three biggest brokers in March and April.