PREVIEW / stock_5min / 2012-07-09

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-07-09.parquet
  size:    4.6 MB
  rows:    314,732
  symbols: 3,475

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-07-09 04:00:00	AAPL	Stock	21.7321	21.7321	21.7321	21.7321	2800.0
2012-07-09 04:10:00	AAPL	Stock	21.6071	21.6071	21.6071	21.6071	2800.0
2012-07-09 04:15:00	AAPL	Stock	21.6071	21.6071	21.6071	21.6071	2800.0
2012-07-09 05:25:00	AAPL	Stock	21.5539	21.5893	21.5536	21.5893	77000.0
2012-07-09 06:30:00	AAPL	Stock	21.6321	21.6321	21.6321	21.6321	2800.0
2012-07-09 06:35:00	AAPL	Stock	21.6429	21.6429	21.6429	21.6429	2800.0
2012-07-09 06:45:00	AAPL	Stock	21.6321	21.6321	21.6321	21.6321	2800.0
2012-07-09 06:50:00	AAPL	Stock	21.6393	21.6393	21.6393	21.6393	2800.0
2012-07-09 06:55:00	AAPL	Stock	21.6379	21.6379	21.635	21.635	5600.0
2012-07-09 07:00:00	AAPL	Stock	21.6354	21.6518	21.635	21.6518	22400.0
2012-07-09 07:05:00	AAPL	Stock	21.655	21.655	21.6446	21.6446	14000.0
2012-07-09 07:10:00	AAPL	Stock	21.65	21.65	21.6354	21.6354	20244.0
2012-07-09 07:15:00	AAPL	Stock	21.6386	21.6425	21.6386	21.6425	16940.0
2012-07-09 07:20:00	AAPL	Stock	21.6361	21.6364	21.6361	21.6361	10360.0
2012-07-09 07:30:00	AAPL	Stock	21.6429	21.6429	21.6429	21.6429	2800.0
2012-07-09 07:35:00	AAPL	Stock	21.6396	21.6429	21.6393	21.6429	11200.0
2012-07-09 07:40:00	AAPL	Stock	21.6518	21.6518	21.6518	21.6518	2800.0
2012-07-09 07:50:00	AAPL	Stock	21.6454	21.6454	21.6214	21.6214	67200.0
2012-07-09 07:55:00	AAPL	Stock	21.6232	21.6389	21.6214	21.6389	17640.0
2012-07-09 08:00:00	AAPL	Stock	21.6568	21.6571	21.6071	21.6121	182420.0
2012-07-09 08:05:00	AAPL	Stock	21.6093	21.6518	21.6	21.6429	270788.0
2012-07-09 08:10:00	AAPL	Stock	21.6475	21.6582	21.6071	21.645	72156.0
2012-07-09 08:15:00	AAPL	Stock	21.65	21.6746	21.65	21.6696	89628.0
2012-07-09 08:20:00	AAPL	Stock	21.6714	21.6786	21.6661	21.6775	88592.0
2012-07-09 08:25:00	AAPL	Stock	21.6736	21.6764	21.6721	21.6754	25200.0
2012-07-09 08:30:00	AAPL	Stock	21.675	21.6754	21.6682	21.6739	89376.0
2012-07-09 08:35:00	AAPL	Stock	21.6743	21.6768	21.6729	21.6768	116144.0
2012-07-09 08:40:00	AAPL	Stock	21.6725	21.6786	21.65	21.6579	712320.0
2012-07-09 08:45:00	AAPL	Stock	21.6579	21.6746	21.6579	21.6679	135520.0
2012-07-09 08:50:00	AAPL	Stock	21.6711	21.6718	21.6521	21.6521	47600.0
2012-07-09 08:55:00	AAPL	Stock	21.6607	21.6607	21.625	21.6354	133868.0
2012-07-09 09:00:00	AAPL	Stock	21.6464	21.6579	21.6314	21.6321	123004.0
2012-07-09 09:05:00	AAPL	Stock	21.6418	21.6421	21.6143	21.625	153244.0
2012-07-09 09:10:00	AAPL	Stock	21.625	21.6321	21.625	21.6286	37800.0
2012-07-09 09:15:00	AAPL	Stock	21.6271	21.6311	21.6071	21.6161	146832.0
2012-07-09 09:20:00	AAPL	Stock	21.6154	21.625	21.6154	21.625	99764.0
2012-07-09 09:25:00	AAPL	Stock	21.6336	21.6339	21.6236	21.6246	128156.0
2012-07-09 09:30:00	AAPL	Stock	21.6182	21.7829	21.5754	21.7644	17967516.0
2012-07-09 09:35:00	AAPL	Stock	21.7666	21.8382	21.7568	21.7896	18131512.0
2012-07-09 09:40:00	AAPL	Stock	21.7921	21.795	21.7418	21.7904	12131616.0
2012-07-09 09:45:00	AAPL	Stock	21.7904	21.7904	21.6654	21.7207	14033152.0
2012-07-09 09:50:00	AAPL	Stock	21.7193	21.7621	21.6964	21.7493	8031800.0
2012-07-09 09:55:00	AAPL	Stock	21.745	21.8	21.745	21.7774	7392084.0
2012-07-09 10:00:00	AAPL	Stock	21.7698	21.7782	21.7111	21.7679	6049904.0
2012-07-09 10:05:00	AAPL	Stock	21.7686	21.7782	21.7457	21.7543	4666032.0
2012-07-09 10:10:00	AAPL	Stock	21.7564	21.7719	21.7432	21.7609	3475612.0
2012-07-09 10:15:00	AAPL	Stock	21.7607	21.7839	21.7429	21.7629	5642084.0
2012-07-09 10:20:00	AAPL	Stock	21.7586	21.7689	21.7357	21.7657	3592708.0
2012-07-09 10:25:00	AAPL	Stock	21.7637	21.8179	21.7597	21.7975	8044932.0
2012-07-09 10:30:00	AAPL	Stock	21.7954	21.8171	21.7464	21.7586	7094528.0

> showing 50 of 314,732 rows — these rows as CSV

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