Hot answers tagged analysis
If you just want to run some simplistic technical analysis on quotes, then select the last quote for each unique timestamp. That will ensure that you don't have duplicate timestamps. If you must have it evenly spaced (i.e. no gaps from one second to another), then you can reuse the previous quote to fill-in the missing value.
To help you understand why you need to follow recipes (like chrisaycock's) just have a look at your tick data. You will find ticks clustered at some points in time while they seem scarce at others. If you proceed with your recipe 2, you will lose those clusters of activity and stretch them out. In periods of low activity you will condense the market. ...
Only top voted, non community-wiki answers of a minimum length are eligible