I've had similar issues syncing data across platforms, especially with inconsistent timestamp formats. What helped me was building a lightweight middleware layer that standardizes all incoming data before it hits my database. I use axiom crypto bot to feed the market data into that layer—it handles a good variety of sources, and its output is pretty clean, which saves me from doing too much reformatting myself.