PREVIEW / stock_5min / 2012-06-19

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-06-19.parquet
  size:    5.0 MB
  rows:    338,444
  symbols: 3,538

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2012-06-19 04:10:00	AAPL	Stock	20.8575	20.8575	20.8571	20.8571	19600.0
2012-06-19 04:15:00	AAPL	Stock	20.8571	20.8571	20.8571	20.8571	11200.0
2012-06-19 04:55:00	AAPL	Stock	20.875	20.875	20.875	20.875	7700.0
2012-06-19 05:00:00	AAPL	Stock	20.85	20.85	20.85	20.85	8400.0
2012-06-19 05:10:00	AAPL	Stock	20.875	20.875	20.875	20.875	2800.0
2012-06-19 05:40:00	AAPL	Stock	20.8839	20.8839	20.8839	20.8839	14000.0
2012-06-19 05:45:00	AAPL	Stock	20.9043	20.9043	20.9043	20.9043	14000.0
2012-06-19 05:55:00	AAPL	Stock	20.9286	20.9286	20.9286	20.9286	12600.0
2012-06-19 06:10:00	AAPL	Stock	20.9286	20.9286	20.9286	20.9286	2800.0
2012-06-19 06:20:00	AAPL	Stock	20.9107	20.9107	20.9107	20.9107	4900.0
2012-06-19 07:00:00	AAPL	Stock	20.9193	20.9286	20.8864	20.8929	101360.0
2012-06-19 07:05:00	AAPL	Stock	20.8929	20.9286	20.8929	20.9286	60340.0
2012-06-19 07:10:00	AAPL	Stock	20.9286	20.9464	20.9286	20.9464	75600.0
2012-06-19 07:15:00	AAPL	Stock	20.9554	20.9554	20.9464	20.9464	100576.0
2012-06-19 07:20:00	AAPL	Stock	20.9482	20.9646	20.9482	20.9646	135492.0
2012-06-19 07:25:00	AAPL	Stock	20.9761	20.98	20.9339	20.9482	149772.0
2012-06-19 07:30:00	AAPL	Stock	20.9532	20.9571	20.9411	20.9429	91560.0
2012-06-19 07:35:00	AAPL	Stock	20.9518	20.9643	20.9375	20.9496	175840.0
2012-06-19 07:40:00	AAPL	Stock	20.9571	20.9611	20.9464	20.9464	103040.0
2012-06-19 07:45:00	AAPL	Stock	20.945	20.945	20.9018	20.9018	186900.0
2012-06-19 07:50:00	AAPL	Stock	20.9129	20.9268	20.9129	20.9268	146440.0
2012-06-19 07:55:00	AAPL	Stock	20.9286	20.9286	20.8682	20.8821	248164.0
2012-06-19 08:00:00	AAPL	Stock	20.8929	20.9639	20.8521	20.8571	854616.0
2012-06-19 08:05:00	AAPL	Stock	20.8661	20.8964	20.8582	20.8757	334124.0
2012-06-19 08:10:00	AAPL	Stock	20.8893	20.9036	20.8786	20.8889	326816.0
2012-06-19 08:15:00	AAPL	Stock	20.8821	20.9143	20.8821	20.9086	364588.0
2012-06-19 08:20:00	AAPL	Stock	20.9086	20.9086	20.865	20.875	420896.0
2012-06-19 08:25:00	AAPL	Stock	20.8671	20.8957	20.8643	20.8861	209188.0
2012-06-19 08:30:00	AAPL	Stock	20.885	20.8929	20.8293	20.8293	351148.0
2012-06-19 08:35:00	AAPL	Stock	20.8368	20.8368	20.8036	20.835	548352.0
2012-06-19 08:40:00	AAPL	Stock	20.8314	20.8357	20.8107	20.8271	150864.0
2012-06-19 08:45:00	AAPL	Stock	20.8243	20.8321	20.8143	20.8304	506156.0
2012-06-19 08:50:00	AAPL	Stock	20.8318	20.8429	20.8307	20.8429	92960.0
2012-06-19 08:55:00	AAPL	Stock	20.8446	20.85	20.8389	20.85	113008.0
2012-06-19 09:00:00	AAPL	Stock	20.8393	20.8475	20.8286	20.8293	245280.0
2012-06-19 09:05:00	AAPL	Stock	20.8318	20.8718	20.8304	20.8718	184856.0
2012-06-19 09:10:00	AAPL	Stock	20.8643	20.8671	20.8571	20.8661	208740.0
2012-06-19 09:15:00	AAPL	Stock	20.8657	20.8746	20.8654	20.8732	178444.0
2012-06-19 09:20:00	AAPL	Stock	20.8714	20.8714	20.8493	20.8571	329140.0
2012-06-19 09:25:00	AAPL	Stock	20.8571	20.8571	20.8264	20.8307	975492.0
2012-06-19 09:30:00	AAPL	Stock	20.8357	20.9461	20.825	20.86	21551460.0
2012-06-19 09:35:00	AAPL	Stock	20.8639	20.9889	20.8608	20.9887	12880588.0
2012-06-19 09:40:00	AAPL	Stock	20.9889	21.0532	20.9679	21.0116	20599768.0
2012-06-19 09:45:00	AAPL	Stock	21.0111	21.0282	20.9718	21.0229	9275392.0
2012-06-19 09:50:00	AAPL	Stock	21.0154	21.0289	20.9643	20.9886	8647912.0
2012-06-19 09:55:00	AAPL	Stock	20.9882	21.0043	20.9486	20.9543	6958364.0
2012-06-19 10:00:00	AAPL	Stock	20.9581	20.9589	20.8989	20.9414	9350656.0
2012-06-19 10:05:00	AAPL	Stock	20.9414	20.9414	20.8811	20.9041	7308168.0
2012-06-19 10:10:00	AAPL	Stock	20.9036	20.9764	20.9001	20.9764	6789832.0
2012-06-19 10:15:00	AAPL	Stock	20.9744	20.9764	20.9357	20.9429	5088160.0

> showing 50 of 338,444 rows — these rows as CSV

> unlock the full archive -- $79 one-time