PREVIEW / stock_5min / 2010-09-17

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-09-17.parquet
  size:    4.8 MB
  rows:    329,506
  symbols: 3,492

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-09-17 04:25:00	AAPL	Stock	9.9454	9.9454	9.9454	9.9454	2800.0
2010-09-17 04:30:00	AAPL	Stock	9.9454	9.9454	9.9454	9.9454	2800.0
2010-09-17 04:50:00	AAPL	Stock	9.9286	9.9286	9.9286	9.9286	2800.0
2010-09-17 05:30:00	AAPL	Stock	9.9554	9.9554	9.9554	9.9554	2800.0
2010-09-17 05:35:00	AAPL	Stock	9.9196	9.9196	9.9196	9.9196	16800.0
2010-09-17 05:50:00	AAPL	Stock	9.92	9.92	9.9196	9.9196	16800.0
2010-09-17 05:55:00	AAPL	Stock	9.9107	9.9107	9.9096	9.9096	20720.0
2010-09-17 06:00:00	AAPL	Stock	9.9107	9.9107	9.9107	9.9107	8400.0
2010-09-17 06:05:00	AAPL	Stock	9.9107	9.9107	9.9107	9.9107	8400.0
2010-09-17 06:30:00	AAPL	Stock	9.9	9.9	9.9	9.9	8400.0
2010-09-17 06:40:00	AAPL	Stock	9.9071	9.9071	9.9071	9.9071	2800.0
2010-09-17 06:45:00	AAPL	Stock	9.9071	9.9071	9.9071	9.9071	2800.0
2010-09-17 06:50:00	AAPL	Stock	9.8893	9.8893	9.8893	9.8893	5600.0
2010-09-17 06:55:00	AAPL	Stock	9.9104	9.9104	9.9104	9.9104	8400.0
2010-09-17 07:00:00	AAPL	Stock	9.9143	9.9464	9.9143	9.9407	120400.0
2010-09-17 07:05:00	AAPL	Stock	9.9254	9.9271	9.9254	9.9271	5600.0
2010-09-17 07:10:00	AAPL	Stock	9.9268	9.9286	9.9268	9.9286	8400.0
2010-09-17 07:15:00	AAPL	Stock	9.9282	9.9286	9.9214	9.9268	39200.0
2010-09-17 07:20:00	AAPL	Stock	9.9196	9.9196	9.9196	9.9196	2800.0
2010-09-17 07:25:00	AAPL	Stock	9.9196	9.9196	9.9196	9.9196	13300.0
2010-09-17 07:30:00	AAPL	Stock	9.9246	9.9246	9.9196	9.9196	16800.0
2010-09-17 07:35:00	AAPL	Stock	9.9168	9.9182	9.9168	9.9179	14000.0
2010-09-17 07:40:00	AAPL	Stock	9.915	9.915	9.9029	9.9039	100940.0
2010-09-17 07:45:00	AAPL	Stock	9.9039	9.9039	9.8939	9.8964	98000.0
2010-09-17 07:50:00	AAPL	Stock	9.8932	9.8993	9.8775	9.8775	96460.0
2010-09-17 07:55:00	AAPL	Stock	9.8871	9.9004	9.8861	9.9004	49000.0
2010-09-17 08:00:00	AAPL	Stock	9.8932	9.9179	9.8768	9.9168	666260.0
2010-09-17 08:05:00	AAPL	Stock	9.9193	9.9321	9.9111	9.9143	1487108.0
2010-09-17 08:10:00	AAPL	Stock	9.9146	9.9229	9.9107	9.9229	395024.0
2010-09-17 08:15:00	AAPL	Stock	9.9232	9.9286	9.9207	9.925	324464.0
2010-09-17 08:20:00	AAPL	Stock	9.925	9.9339	9.92	9.9314	422156.0
2010-09-17 08:25:00	AAPL	Stock	9.9314	9.9393	9.9304	9.9321	373464.0
2010-09-17 08:30:00	AAPL	Stock	9.9321	9.9357	9.9207	9.925	701680.0
2010-09-17 08:35:00	AAPL	Stock	9.9243	9.9286	9.9211	9.9282	271796.0
2010-09-17 08:40:00	AAPL	Stock	9.9282	9.9336	9.9236	9.9318	159460.0
2010-09-17 08:45:00	AAPL	Stock	9.9318	9.9321	9.9261	9.9279	210336.0
2010-09-17 08:50:00	AAPL	Stock	9.9268	9.9282	9.9218	9.9243	206948.0
2010-09-17 08:55:00	AAPL	Stock	9.9229	9.9229	9.9143	9.9157	538244.0
2010-09-17 09:00:00	AAPL	Stock	9.9157	9.9179	9.9125	9.9125	435876.0
2010-09-17 09:05:00	AAPL	Stock	9.9136	9.9221	9.9118	9.9221	324184.0
2010-09-17 09:10:00	AAPL	Stock	9.9218	9.9236	9.9186	9.9221	264068.0
2010-09-17 09:15:00	AAPL	Stock	9.9186	9.9218	9.9161	9.9161	232736.0
2010-09-17 09:20:00	AAPL	Stock	9.9175	9.9243	9.9171	9.9232	337848.0
2010-09-17 09:25:00	AAPL	Stock	9.9211	9.925	9.9168	9.9179	822976.0
2010-09-17 09:30:00	AAPL	Stock	9.9186	9.9271	9.8896	9.9075	24686116.0
2010-09-17 09:35:00	AAPL	Stock	9.9071	9.9214	9.8525	9.8529	24353420.0
2010-09-17 09:40:00	AAPL	Stock	9.8532	9.8689	9.8304	9.8311	23881760.0
2010-09-17 09:45:00	AAPL	Stock	9.8318	9.8457	9.8082	9.84	25958800.0
2010-09-17 09:50:00	AAPL	Stock	9.84	9.84	9.8143	9.8161	16429056.0
2010-09-17 09:55:00	AAPL	Stock	9.8161	9.8261	9.7743	9.7875	25320764.0

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

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