hi there, don't look at the stigmas (which people call pistils), but look with a magnifying glass at the trichomes themselves..
remember that the type of high depends not only on the strain, but also on the state of the trichomes..
the main question you should ask yourself is "what kind of high" do you like?
Should it be more of an "active" head high for during the day, or more of a "body high" which pushes you into the couch and makes you sleep well?
Once you know that, you should look at the strain you're growing..
If the plant you grow is a pure indica, the standard high will lock you more into the couch by default, while a pure sativa would give you more of a head-high (the basic sativa-indica difference) when harvested at the same time, but then of course there are still a lot of hybrids in between. This is just a general rule, but it also depends on time of harvest.
When it comes to trichomes you know they go from clear to milky and then to amber..
In general if the plant one is an indica-heavy plant (so more of a couch-lock), if you want a head-high, you'd be best off harvesting when a bit over half are still clear, and half are milky.. If you want a body high, then most should be milky and some amber. If 20 or 30% or more of them are amber, it'll just be definitely in the body-high area, pushing you into the couch (and as always, don't wait too long or they'll fall off the plant).
In comparison if this were a sativa, then even even when the trichomes are full milky it should still give you more of a head-high, and to get more of a body-high effect you'd need to wait until there are a lot of amber trichomes.
The hybrids are obviously somewhere in between.. unfortunately you didn't mention the strain you have grown (or have a grow diary for this plant), so it's a bit difficult to tell.
So it's basically up to you, what you prefer and the type of strain you grow, but definitely keep the trichomes in check.
happy harvest!