It's psychoactive when it's decarboxylated (smoked, prepared as an edible). From what I can tell that turns it from Delta 9 THC-A to Delta 9 THC. I first went down this rabbit hole because I found what looked like normal flower in a smoke shop, and it does indeed get you high.

I've looked at the lab results for various medical/recreational products and even they tend to have a lot of THC-A, with THC hovering around or higher than the federal limit of 0.3%.

For instance, a quick look at a Chicago dispensary: https://www.sunnyside.shop/product/3439284

THC: 0.61%

THCA: 29.91%

Edit: Wild, ninja'd on a several hour late reply!

Not psychoactive until you heat it (vape or smoking it), then it decarbolyzes (sp?) to THC D9. That’s true even in dispensary grade and the reason you can just eat it directly and get high.