Hmmm...so many issues. I’ll start with two: 1) why you experience a squeaking noise, and 2) why I hate those pre-cast footing supports.
1) The footing is pre-cast...not poured in place. Some have metal clips cast into them...this one does not. This one probably has a hole for a metal connector to fit in, like this one.
Unfortunately, this type of connector CAN move up and down in the pre-cast hole. The joists, beam, post, etc. can dry out and shrink. When this happens, the footing connector will move slightly up in the hole. Then, when you walk across the floor your weight will cause the metal post to scrape as it moves down in the pre-cast hole...and likewise it will scrape when you pass and the extra load is removed. (Have I mentioned how much I hate these connectors and pre-cast footings yet?)
2) Seismic loads come 2 ways: side-to-side AND up-and-down. Seismic design is intended to keep everything together no matter which way the loading occurs.
Your seismic loading comes primarily from side-to-side (I’m guessing you’re from Southern California.) When this happens you can see that there’s a good chance the wood floors will be moving in one direction and the concrete is moving in the opposite direction. When this happens the footing will tip over and the connector can slip out of the hole in the pre-cast footing and you have no support for your floors.
(Have I mentioned how much I hate these types of connectors and pre-cast footings yet?)
The fix: replace the pre-cast footings with poured in place AND install connectors in the footing during the pour. (If you try to epoxy the existing metal base support into the existing pre-cast footing there’s no guarantee it will withstand the additional load of you walking on it and not continue to squeak. Remember, the lumber will continue to shrink.)