PREVIEW / stock_5min / 2012-09-17

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-09-17.parquet
  size:    4.7 MB
  rows:    316,441
  symbols: 3,458

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-09-17 04:00:00	AAPL	Stock	24.7857	24.7857	24.7857	24.7857	18200.0
2012-09-17 04:10:00	AAPL	Stock	24.7736	24.7736	24.7736	24.7736	2800.0
2012-09-17 04:20:00	AAPL	Stock	24.7679	24.7679	24.7679	24.7679	2800.0
2012-09-17 04:25:00	AAPL	Stock	24.7857	24.7857	24.7857	24.7857	5600.0
2012-09-17 04:40:00	AAPL	Stock	24.7643	24.7643	24.7643	24.7643	6972.0
2012-09-17 04:50:00	AAPL	Stock	24.795	24.795	24.795	24.795	2800.0
2012-09-17 05:35:00	AAPL	Stock	24.7679	24.7679	24.7679	24.7679	2800.0
2012-09-17 06:05:00	AAPL	Stock	24.8068	24.8068	24.8068	24.8068	3584.0
2012-09-17 06:10:00	AAPL	Stock	24.8068	24.8068	24.8068	24.8068	2800.0
2012-09-17 06:25:00	AAPL	Stock	24.7857	24.7857	24.7857	24.7857	8400.0
2012-09-17 06:35:00	AAPL	Stock	24.7925	24.7925	24.7925	24.7925	57400.0
2012-09-17 06:55:00	AAPL	Stock	24.8036	24.8036	24.7929	24.7929	26572.0
2012-09-17 07:00:00	AAPL	Stock	24.7857	24.8036	24.7786	24.8032	79940.0
2012-09-17 07:05:00	AAPL	Stock	24.7929	24.8246	24.7879	24.8232	219800.0
2012-09-17 07:10:00	AAPL	Stock	24.8304	24.85	24.8268	24.8268	130648.0
2012-09-17 07:15:00	AAPL	Stock	24.8268	24.8432	24.8268	24.8343	137200.0
2012-09-17 07:20:00	AAPL	Stock	24.8393	24.8393	24.8339	24.8339	21000.0
2012-09-17 07:25:00	AAPL	Stock	24.8232	24.8357	24.8214	24.8357	28140.0
2012-09-17 07:30:00	AAPL	Stock	24.83	24.8332	24.8129	24.8129	37240.0
2012-09-17 07:35:00	AAPL	Stock	24.8132	24.8132	24.7964	24.7964	104692.0
2012-09-17 07:40:00	AAPL	Stock	24.7946	24.7946	24.7682	24.7682	82824.0
2012-09-17 07:45:00	AAPL	Stock	24.7821	24.7821	24.7686	24.7821	39340.0
2012-09-17 07:55:00	AAPL	Stock	24.7929	24.8032	24.7929	24.8032	15932.0
2012-09-17 08:00:00	AAPL	Stock	24.7989	24.8464	24.78	24.7857	378084.0
2012-09-17 08:05:00	AAPL	Stock	24.7846	24.8143	24.7846	24.8093	158984.0
2012-09-17 08:10:00	AAPL	Stock	24.8079	24.8339	24.8071	24.8339	407680.0
2012-09-17 08:15:00	AAPL	Stock	24.8339	24.8464	24.8339	24.8436	354116.0
2012-09-17 08:20:00	AAPL	Stock	24.85	24.8571	24.8436	24.8461	287756.0
2012-09-17 08:25:00	AAPL	Stock	24.8461	24.8532	24.8339	24.8532	217000.0
2012-09-17 08:30:00	AAPL	Stock	24.8504	24.9036	24.8486	24.8711	1007944.0
2012-09-17 08:35:00	AAPL	Stock	24.8673	24.9	24.8575	24.8979	948864.0
2012-09-17 08:40:00	AAPL	Stock	24.9	24.9	24.8825	24.8929	530908.0
2012-09-17 08:45:00	AAPL	Stock	24.8929	24.8957	24.8821	24.8907	208684.0
2012-09-17 08:50:00	AAPL	Stock	24.8893	24.9118	24.8893	24.9075	647976.0
2012-09-17 08:55:00	AAPL	Stock	24.9071	24.91	24.8843	24.8957	537012.0
2012-09-17 09:00:00	AAPL	Stock	24.8964	24.8964	24.8829	24.8871	270648.0
2012-09-17 09:05:00	AAPL	Stock	24.8914	24.9018	24.8861	24.9018	560252.0
2012-09-17 09:10:00	AAPL	Stock	24.9057	24.9604	24.9032	24.9554	1185212.0
2012-09-17 09:15:00	AAPL	Stock	24.9554	24.9854	24.95	24.9646	1404648.0
2012-09-17 09:20:00	AAPL	Stock	24.97	24.9939	24.9643	24.9789	980896.0
2012-09-17 09:25:00	AAPL	Stock	24.9814	24.9893	24.9536	24.9771	1100428.0
2012-09-17 09:30:00	AAPL	Stock	24.9768	24.9836	24.8897	24.9181	23308236.0
2012-09-17 09:35:00	AAPL	Stock	24.9086	24.9568	24.8807	24.8904	13898416.0
2012-09-17 09:40:00	AAPL	Stock	24.89	24.9336	24.8671	24.9336	11377996.0
2012-09-17 09:45:00	AAPL	Stock	24.9321	24.9571	24.8929	24.9104	10298288.0
2012-09-17 09:50:00	AAPL	Stock	24.9072	24.915	24.8607	24.875	7855848.0
2012-09-17 09:55:00	AAPL	Stock	24.87	24.8743	24.8089	24.8389	11299988.0
2012-09-17 10:00:00	AAPL	Stock	24.8367	24.8693	24.8289	24.865	8237012.0
2012-09-17 10:05:00	AAPL	Stock	24.8684	24.9036	24.8455	24.8861	6686932.0
2012-09-17 10:10:00	AAPL	Stock	24.8846	24.8989	24.8704	24.8975	4414900.0

> showing 50 of 316,441 rows — these rows as CSV

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