PREVIEW / stock_5min / 2013-05-28

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-05-28.parquet
  size:    5.3 MB
  rows:    349,837
  symbols: 3,533

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
2013-05-28 04:35:00	AAPL	Stock	16.0036	16.0036	16.0	16.0	25200.0
2013-05-28 04:55:00	AAPL	Stock	16.0225	16.0225	16.0225	16.0225	2800.0
2013-05-28 05:35:00	AAPL	Stock	16.0036	16.0036	16.0036	16.0036	5600.0
2013-05-28 05:40:00	AAPL	Stock	16.0107	16.0107	16.0107	16.0107	5600.0
2013-05-28 05:50:00	AAPL	Stock	16.0143	16.0179	16.0143	16.0179	5600.0
2013-05-28 05:55:00	AAPL	Stock	16.0	16.0	16.0	16.0	20916.0
2013-05-28 06:00:00	AAPL	Stock	15.9946	15.9946	15.9839	15.9839	16688.0
2013-05-28 06:05:00	AAPL	Stock	15.9821	15.9821	15.9821	15.9821	14000.0
2013-05-28 06:10:00	AAPL	Stock	15.9821	15.9821	15.9821	15.9821	2800.0
2013-05-28 06:30:00	AAPL	Stock	15.9821	15.9821	15.975	15.975	11200.0
2013-05-28 06:35:00	AAPL	Stock	15.9911	15.9911	15.9911	15.9911	8400.0
2013-05-28 06:40:00	AAPL	Stock	15.9821	15.9821	15.9646	15.9646	12600.0
2013-05-28 06:45:00	AAPL	Stock	15.9679	15.9679	15.9679	15.9679	5600.0
2013-05-28 06:50:00	AAPL	Stock	15.9643	15.9643	15.9329	15.9486	51800.0
2013-05-28 07:00:00	AAPL	Stock	15.9711	15.9936	15.9711	15.9936	89600.0
2013-05-28 07:05:00	AAPL	Stock	15.9907	15.9929	15.9761	15.9929	91280.0
2013-05-28 07:10:00	AAPL	Stock	15.9929	16.0089	15.9879	16.0089	157864.0
2013-05-28 07:15:00	AAPL	Stock	15.9996	16.0321	15.9996	16.0321	79800.0
2013-05-28 07:20:00	AAPL	Stock	16.0189	16.0321	16.0189	16.0321	25172.0
2013-05-28 07:25:00	AAPL	Stock	16.0304	16.0532	16.0304	16.0357	152964.0
2013-05-28 07:30:00	AAPL	Stock	16.0314	16.0357	16.0268	16.0357	75096.0
2013-05-28 07:35:00	AAPL	Stock	16.0304	16.0664	16.0304	16.0664	97216.0
2013-05-28 07:40:00	AAPL	Stock	16.0546	16.0836	16.0543	16.0829	426636.0
2013-05-28 07:45:00	AAPL	Stock	16.0718	16.0718	16.0429	16.0536	71400.0
2013-05-28 07:50:00	AAPL	Stock	16.0536	16.0589	16.0464	16.0589	62636.0
2013-05-28 07:55:00	AAPL	Stock	16.0539	16.0643	16.0536	16.0643	33264.0
2013-05-28 08:00:00	AAPL	Stock	16.0539	16.0718	15.9714	16.0643	428400.0
2013-05-28 08:05:00	AAPL	Stock	16.0675	16.0675	15.8929	16.0396	228060.0
2013-05-28 08:10:00	AAPL	Stock	16.0464	16.0679	16.0411	16.0625	196476.0
2013-05-28 08:15:00	AAPL	Stock	16.0575	16.0811	16.0575	16.075	375088.0
2013-05-28 08:20:00	AAPL	Stock	16.075	16.0896	16.0718	16.0832	114912.0
2013-05-28 08:25:00	AAPL	Stock	16.0843	16.0893	16.0714	16.0893	270704.0
2013-05-28 08:30:00	AAPL	Stock	16.0907	16.1125	16.0786	16.0893	299376.0
2013-05-28 08:35:00	AAPL	Stock	16.0961	16.1032	16.0786	16.0964	267204.0
2013-05-28 08:40:00	AAPL	Stock	16.1036	16.1193	16.0982	16.1057	262808.0
2013-05-28 08:45:00	AAPL	Stock	16.0993	16.1121	16.0982	16.1071	154504.0
2013-05-28 08:50:00	AAPL	Stock	16.0986	16.1007	16.0911	16.0961	122388.0
2013-05-28 08:55:00	AAPL	Stock	16.0914	16.0964	16.0893	16.0893	179928.0
2013-05-28 09:00:00	AAPL	Stock	16.0825	16.0929	16.0568	16.0846	595336.0
2013-05-28 09:05:00	AAPL	Stock	16.0825	16.0839	16.0546	16.0804	276472.0
2013-05-28 09:10:00	AAPL	Stock	16.0857	16.0964	16.0839	16.0957	231756.0
2013-05-28 09:15:00	AAPL	Stock	16.0946	16.1057	16.0946	16.105	244244.0
2013-05-28 09:20:00	AAPL	Stock	16.105	16.1071	16.0929	16.0936	341012.0
2013-05-28 09:25:00	AAPL	Stock	16.0829	16.1007	16.0661	16.0661	1011724.0
2013-05-28 09:30:00	AAPL	Stock	16.0679	16.095	16.0357	16.0711	23056516.0
2013-05-28 09:35:00	AAPL	Stock	16.071	16.1111	16.0539	16.0711	14891324.0
2013-05-28 09:40:00	AAPL	Stock	16.0729	16.0932	16.0037	16.0289	8583932.0
2013-05-28 09:45:00	AAPL	Stock	16.02	16.0321	15.9893	16.0211	10199560.0
2013-05-28 09:50:00	AAPL	Stock	16.0221	16.0264	15.9414	15.9432	10004988.0
2013-05-28 09:55:00	AAPL	Stock	15.9439	16.0032	15.9417	15.9943	6649244.0

> showing 50 of 349,837 rows — these rows as CSV

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