PREVIEW / stock_5min / 2010-05-27

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-05-27.parquet
  size:    4.9 MB
  rows:    338,248
  symbols: 3,468

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
2010-05-27 04:15:00	AAPL	Stock	8.8818	8.8818	8.825	8.8618	19600.0
2010-05-27 04:50:00	AAPL	Stock	8.9071	8.9071	8.9071	8.9071	14000.0
2010-05-27 05:00:00	AAPL	Stock	8.9071	8.9082	8.9071	8.9082	5600.0
2010-05-27 05:05:00	AAPL	Stock	8.9111	8.9111	8.9111	8.9111	2800.0
2010-05-27 06:05:00	AAPL	Stock	8.9143	8.9143	8.9143	8.9143	2800.0
2010-05-27 06:15:00	AAPL	Stock	8.9439	8.9439	8.9439	8.9439	2800.0
2010-05-27 06:20:00	AAPL	Stock	8.9439	8.9439	8.9439	8.9439	2800.0
2010-05-27 06:25:00	AAPL	Stock	8.9571	8.9571	8.9571	8.9571	2800.0
2010-05-27 06:30:00	AAPL	Stock	8.9571	8.9571	8.9571	8.9571	5600.0
2010-05-27 06:35:00	AAPL	Stock	8.9571	8.9571	8.9571	8.9571	2800.0
2010-05-27 06:40:00	AAPL	Stock	8.9571	8.9571	8.9571	8.9571	5600.0
2010-05-27 06:45:00	AAPL	Stock	8.9571	8.9571	8.9571	8.9571	11200.0
2010-05-27 07:00:00	AAPL	Stock	8.9439	8.9629	8.9432	8.9464	241388.0
2010-05-27 07:05:00	AAPL	Stock	8.9361	8.9464	8.9036	8.9104	232008.0
2010-05-27 07:10:00	AAPL	Stock	8.9021	8.925	8.9021	8.9229	97216.0
2010-05-27 07:15:00	AAPL	Stock	8.9232	8.9261	8.9214	8.925	113400.0
2010-05-27 07:20:00	AAPL	Stock	8.925	8.9375	8.9243	8.9357	200088.0
2010-05-27 07:25:00	AAPL	Stock	8.9375	8.9375	8.9175	8.9175	112308.0
2010-05-27 07:30:00	AAPL	Stock	8.9161	8.9193	8.9079	8.9079	77840.0
2010-05-27 07:35:00	AAPL	Stock	8.9104	8.9193	8.9064	8.9189	57400.0
2010-05-27 07:40:00	AAPL	Stock	8.9193	8.9196	8.9129	8.9196	47180.0
2010-05-27 07:45:00	AAPL	Stock	8.9282	8.9282	8.9164	8.9164	30156.0
2010-05-27 07:50:00	AAPL	Stock	8.9196	8.92	8.9196	8.92	19600.0
2010-05-27 07:55:00	AAPL	Stock	8.9146	8.9186	8.9146	8.9186	5600.0
2010-05-27 08:00:00	AAPL	Stock	8.9146	8.9286	8.9071	8.9107	893340.0
2010-05-27 08:05:00	AAPL	Stock	8.9121	8.9211	8.9114	8.9189	372288.0
2010-05-27 08:10:00	AAPL	Stock	8.9193	8.9275	8.9193	8.9232	394968.0
2010-05-27 08:15:00	AAPL	Stock	8.9229	8.9248	8.9111	8.9161	185556.0
2010-05-27 08:20:00	AAPL	Stock	8.9177	8.9268	8.9175	8.9236	441224.0
2010-05-27 08:25:00	AAPL	Stock	8.9236	8.9239	8.9143	8.9179	411404.0
2010-05-27 08:30:00	AAPL	Stock	8.9179	8.9179	8.8936	8.9021	991788.0
2010-05-27 08:35:00	AAPL	Stock	8.8993	8.9129	8.8932	8.8982	650636.0
2010-05-27 08:40:00	AAPL	Stock	8.8996	8.9054	8.8957	8.8982	406756.0
2010-05-27 08:45:00	AAPL	Stock	8.8982	8.9118	8.8964	8.9118	661500.0
2010-05-27 08:50:00	AAPL	Stock	8.9136	8.9157	8.9104	8.9107	256676.0
2010-05-27 08:55:00	AAPL	Stock	8.9087	8.9125	8.9061	8.9107	270004.0
2010-05-27 09:00:00	AAPL	Stock	8.9107	8.9143	8.9089	8.9129	223048.0
2010-05-27 09:05:00	AAPL	Stock	8.915	8.925	8.915	8.9232	407484.0
2010-05-27 09:10:00	AAPL	Stock	8.9214	8.9332	8.92	8.9286	641284.0
2010-05-27 09:15:00	AAPL	Stock	8.9286	8.9304	8.9214	8.9279	285740.0
2010-05-27 09:20:00	AAPL	Stock	8.9282	8.9357	8.9236	8.9354	273980.0
2010-05-27 09:25:00	AAPL	Stock	8.9354	8.9554	8.9321	8.95	1214500.0
2010-05-27 09:30:00	AAPL	Stock	8.95	8.9821	8.945	8.9679	33831672.0
2010-05-27 09:35:00	AAPL	Stock	8.9671	8.9743	8.9132	8.9141	26704972.0
2010-05-27 09:40:00	AAPL	Stock	8.915	8.9464	8.9132	8.9429	18013296.0
2010-05-27 09:45:00	AAPL	Stock	8.9421	8.9464	8.9236	8.9257	11129972.0
2010-05-27 09:50:00	AAPL	Stock	8.9254	8.9282	8.8968	8.9129	15705396.0
2010-05-27 09:55:00	AAPL	Stock	8.9122	8.9375	8.8982	8.9336	11555852.0
2010-05-27 10:00:00	AAPL	Stock	8.9336	8.9407	8.9107	8.9386	13130236.0
2010-05-27 10:05:00	AAPL	Stock	8.9402	8.9589	8.9357	8.9455	11783996.0

> showing 50 of 338,248 rows — these rows as CSV

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