PREVIEW / stock_5min / 2012-11-08

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-11-08.parquet
  size:    4.8 MB
  rows:    321,823
  symbols: 3,460

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-11-08 04:00:00	AAPL	Stock	20.0011	20.0011	20.0011	20.0011	2800.0
2012-11-08 05:15:00	AAPL	Stock	19.9736	19.9736	19.9643	19.9643	76888.0
2012-11-08 05:20:00	AAPL	Stock	19.9643	19.9643	19.9643	19.9643	14896.0
2012-11-08 05:25:00	AAPL	Stock	19.9643	20.0	19.9643	20.0	15400.0
2012-11-08 05:30:00	AAPL	Stock	19.9821	19.9821	19.9821	19.9821	5600.0
2012-11-08 05:40:00	AAPL	Stock	20.0143	20.0232	20.0143	20.0232	53200.0
2012-11-08 05:45:00	AAPL	Stock	20.0536	20.1071	20.0536	20.1071	81564.0
2012-11-08 05:50:00	AAPL	Stock	20.1054	20.1082	20.1054	20.1082	8400.0
2012-11-08 05:55:00	AAPL	Stock	20.1071	20.1071	20.1057	20.1071	79772.0
2012-11-08 06:00:00	AAPL	Stock	20.0932	20.0932	20.0932	20.0932	2800.0
2012-11-08 06:25:00	AAPL	Stock	20.0821	20.0821	20.0821	20.0821	2800.0
2012-11-08 06:30:00	AAPL	Stock	20.0714	20.0714	20.0714	20.0714	2800.0
2012-11-08 06:45:00	AAPL	Stock	20.0893	20.0893	20.0714	20.0714	36400.0
2012-11-08 06:55:00	AAPL	Stock	20.0714	20.0714	20.0214	20.0214	72240.0
2012-11-08 07:00:00	AAPL	Stock	20.0357	20.0675	20.0357	20.0675	16800.0
2012-11-08 07:05:00	AAPL	Stock	20.0368	20.0393	20.025	20.0393	23800.0
2012-11-08 07:10:00	AAPL	Stock	20.0357	20.0461	20.0357	20.0461	21532.0
2012-11-08 07:15:00	AAPL	Stock	20.0393	20.0714	20.0393	20.0629	24780.0
2012-11-08 07:20:00	AAPL	Stock	20.0596	20.0714	20.0554	20.0639	63420.0
2012-11-08 07:25:00	AAPL	Stock	20.0643	20.0696	20.0571	20.0571	72240.0
2012-11-08 07:30:00	AAPL	Stock	20.0604	20.0889	20.035	20.0357	196896.0
2012-11-08 07:35:00	AAPL	Stock	20.0532	20.085	20.0518	20.0782	105840.0
2012-11-08 07:40:00	AAPL	Stock	20.0732	20.0732	20.0536	20.0536	96320.0
2012-11-08 07:45:00	AAPL	Stock	20.0589	20.0714	20.0414	20.0707	126168.0
2012-11-08 07:50:00	AAPL	Stock	20.0707	20.1036	20.0707	20.0932	136248.0
2012-11-08 07:55:00	AAPL	Stock	20.0893	20.1318	20.0893	20.1036	185976.0
2012-11-08 08:00:00	AAPL	Stock	20.0886	20.1068	20.0636	20.0818	484960.0
2012-11-08 08:05:00	AAPL	Stock	20.0721	20.0821	20.0636	20.0821	170576.0
2012-11-08 08:10:00	AAPL	Stock	20.0814	20.0846	20.0714	20.0846	186872.0
2012-11-08 08:15:00	AAPL	Stock	20.0854	20.0893	20.0714	20.0714	362488.0
2012-11-08 08:20:00	AAPL	Stock	20.0714	20.0893	20.0714	20.075	142072.0
2012-11-08 08:25:00	AAPL	Stock	20.0839	20.1143	20.0786	20.1143	469392.0
2012-11-08 08:30:00	AAPL	Stock	20.1114	20.1454	20.1071	20.12	567952.0
2012-11-08 08:35:00	AAPL	Stock	20.1282	20.1414	20.1129	20.1129	263172.0
2012-11-08 08:40:00	AAPL	Stock	20.1179	20.1243	20.0968	20.0968	129668.0
2012-11-08 08:45:00	AAPL	Stock	20.0964	20.0968	20.0786	20.0807	299236.0
2012-11-08 08:50:00	AAPL	Stock	20.0832	20.1071	20.0811	20.1071	166852.0
2012-11-08 08:55:00	AAPL	Stock	20.1089	20.1154	20.0929	20.1057	156576.0
2012-11-08 09:00:00	AAPL	Stock	20.1071	20.1079	20.0904	20.0907	209496.0
2012-11-08 09:05:00	AAPL	Stock	20.0829	20.0886	20.0625	20.0654	298312.0
2012-11-08 09:10:00	AAPL	Stock	20.0711	20.0711	20.0429	20.0464	259224.0
2012-11-08 09:15:00	AAPL	Stock	20.0475	20.0768	20.0475	20.0736	129976.0
2012-11-08 09:20:00	AAPL	Stock	20.0732	20.0829	20.0679	20.0679	137172.0
2012-11-08 09:25:00	AAPL	Stock	20.0632	20.0714	20.0143	20.0232	542416.0
2012-11-08 09:30:00	AAPL	Stock	20.0225	20.0796	19.9454	19.9586	22969716.0
2012-11-08 09:35:00	AAPL	Stock	19.9564	19.9646	19.735	19.86	39725784.0
2012-11-08 09:40:00	AAPL	Stock	19.86	19.9875	19.8561	19.9854	19739636.0
2012-11-08 09:45:00	AAPL	Stock	19.9832	19.9961	19.8768	19.9457	16516668.0
2012-11-08 09:50:00	AAPL	Stock	19.943	19.943	19.7821	19.8143	14779492.0
2012-11-08 09:55:00	AAPL	Stock	19.8189	19.8879	19.8182	19.8493	9439248.0

> showing 50 of 321,823 rows — these rows as CSV

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