To get the shine you are talking about, You need to wet sand the clear coat to remove all the orange peel. Try using 1000 grit then move up to 1500 and then 2000. Once you all done. Get a rotary(buffer) with a wool pads and some rubbing compound as nosey said. Put the rubbing compound on pad and start the buffer at 600 or the lowest setting to spread the compound on a 2x2 area and once it's all speard. Increase the buffer to 1500 or what ever closer to it and start moving the buffer in a slow pace with the pad flat against the area from side to side and then up and down. Do this with the rest of the hood and it would come out looking new.

 

The part where you messed up is when you decided to spray clear coat out of the can. You will never get the same results as the original finish on the hood unless you get a body shop to spray UV protective clear. I suggest you sand off all of the clear, wet sand w/ 400 grit sand paper until its smooth then bring it to the shop and get them to spray clear on it. I'd say $100 to clear your whole hood is a reasonable amount to pay. They will first clean your hood to remove oil and dirt, then spray the clear coat and let dry for at least 12 hours (the ones that dry in 2 hours are cheap and will crack eventually), then buff & polish and you're set! Guaranteed you will get factory finish.