Most data providers I find online offer historical market data in time resolutions of 1 minute bars or longer (which is too long), or tick resolution (which is too short). Of course one could get tick data and construct 1 second bars from this information. However, the price for tick data is very excessive.
Is there a data provider offering 1 second bar resolution historical market data for US equities? If there are several, which one is most affordable?