PREVIEW / stock_5min / 2011-07-18

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-07-18.parquet
  size:    4.8 MB
  rows:    329,305
  symbols: 3,540

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
2011-07-18 04:00:00	AAPL	Stock	13.0571	13.0571	12.9961	12.9961	22400.0
2011-07-18 04:20:00	AAPL	Stock	12.9961	12.9961	12.9961	12.9961	2800.0
2011-07-18 04:25:00	AAPL	Stock	12.9857	12.9857	12.9857	12.9857	2800.0
2011-07-18 04:35:00	AAPL	Stock	12.9929	12.9929	12.9929	12.9929	2800.0
2011-07-18 04:40:00	AAPL	Stock	12.9929	12.9929	12.9929	12.9929	2800.0
2011-07-18 04:45:00	AAPL	Stock	12.9893	12.9893	12.9643	12.9643	5600.0
2011-07-18 04:50:00	AAPL	Stock	12.9893	12.9893	12.9893	12.9893	5600.0
2011-07-18 05:20:00	AAPL	Stock	12.9893	12.9893	12.9893	12.9893	19572.0
2011-07-18 05:35:00	AAPL	Stock	12.9929	12.9982	12.9929	12.9982	5600.0
2011-07-18 05:50:00	AAPL	Stock	12.9929	12.9929	12.9929	12.9929	2800.0
2011-07-18 05:55:00	AAPL	Stock	12.9929	12.9929	12.9929	12.9929	2800.0
2011-07-18 06:00:00	AAPL	Stock	12.9929	12.9929	12.9929	12.9929	5600.0
2011-07-18 06:40:00	AAPL	Stock	12.9829	13.0	12.9829	12.9982	43820.0
2011-07-18 06:45:00	AAPL	Stock	12.9982	13.0089	12.9982	13.0089	14000.0
2011-07-18 06:50:00	AAPL	Stock	13.0043	13.0043	13.0043	13.0043	19600.0
2011-07-18 06:55:00	AAPL	Stock	12.9736	12.9739	12.9736	12.9739	28000.0
2011-07-18 07:00:00	AAPL	Stock	13.0	13.0179	13.0	13.0179	22932.0
2011-07-18 07:05:00	AAPL	Stock	13.0268	13.0289	13.0214	13.025	60900.0
2011-07-18 07:10:00	AAPL	Stock	13.0268	13.0286	13.0186	13.0186	56000.0
2011-07-18 07:15:00	AAPL	Stock	13.0189	13.0286	13.0179	13.0225	130816.0
2011-07-18 07:20:00	AAPL	Stock	13.0221	13.0221	13.0089	13.0089	68516.0
2011-07-18 07:25:00	AAPL	Stock	13.0071	13.0071	12.9843	12.995	87164.0
2011-07-18 07:30:00	AAPL	Stock	12.9961	12.9996	12.9861	12.9996	63000.0
2011-07-18 07:35:00	AAPL	Stock	13.0	13.0011	13.0	13.0004	91000.0
2011-07-18 07:40:00	AAPL	Stock	13.0029	13.0114	13.0029	13.0054	127848.0
2011-07-18 07:45:00	AAPL	Stock	13.0054	13.0054	12.9946	12.9996	37100.0
2011-07-18 07:50:00	AAPL	Stock	13.0	13.0	12.9989	13.0	22400.0
2011-07-18 07:55:00	AAPL	Stock	13.0	13.0043	12.995	13.0032	181412.0
2011-07-18 08:00:00	AAPL	Stock	13.0	13.0421	12.9964	13.0232	793884.0
2011-07-18 08:05:00	AAPL	Stock	13.0221	13.0486	13.0221	13.0461	672728.0
2011-07-18 08:10:00	AAPL	Stock	13.0425	13.0814	13.0425	13.0679	395724.0
2011-07-18 08:15:00	AAPL	Stock	13.0679	13.0964	13.0643	13.0832	743764.0
2011-07-18 08:20:00	AAPL	Stock	13.0836	13.095	13.075	13.0821	485688.0
2011-07-18 08:25:00	AAPL	Stock	13.0839	13.0964	13.0725	13.0725	389200.0
2011-07-18 08:30:00	AAPL	Stock	13.0725	13.0829	13.0725	13.0782	225260.0
2011-07-18 08:35:00	AAPL	Stock	13.0757	13.0782	13.0614	13.0714	739592.0
2011-07-18 08:40:00	AAPL	Stock	13.0714	13.08	13.0636	13.0714	359240.0
2011-07-18 08:45:00	AAPL	Stock	13.0707	13.0768	13.0614	13.0679	587832.0
2011-07-18 08:50:00	AAPL	Stock	13.0711	13.0714	13.0561	13.0564	348880.0
2011-07-18 08:55:00	AAPL	Stock	13.0646	13.0661	13.0625	13.0625	154420.0
2011-07-18 09:00:00	AAPL	Stock	13.0625	13.0646	13.0543	13.0554	281512.0
2011-07-18 09:05:00	AAPL	Stock	13.0539	13.0643	13.045	13.0643	178024.0
2011-07-18 09:10:00	AAPL	Stock	13.0643	13.0725	13.0607	13.0718	486612.0
2011-07-18 09:15:00	AAPL	Stock	13.0732	13.0743	13.0643	13.0661	177464.0
2011-07-18 09:20:00	AAPL	Stock	13.0668	13.0736	13.0604	13.0625	179508.0
2011-07-18 09:25:00	AAPL	Stock	13.0625	13.0679	13.0443	13.05	502320.0
2011-07-18 09:30:00	AAPL	Stock	13.0511	13.1293	13.0457	13.1239	30217824.0
2011-07-18 09:35:00	AAPL	Stock	13.1225	13.1518	13.1154	13.1371	24436972.0
2011-07-18 09:40:00	AAPL	Stock	13.1371	13.1786	13.1268	13.1732	17203984.0
2011-07-18 09:45:00	AAPL	Stock	13.1723	13.2021	13.1554	13.1557	18836076.0

> showing 50 of 329,305 rows — these rows as CSV

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