PREVIEW / stock_5min / 2009-06-15

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-06-15.parquet
  size:    4.6 MB
  rows:    323,523
  symbols: 3,342

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
2009-06-15 07:25:00	AAPL	Stock	4.8561	4.8561	4.8561	4.8561	2800.0
2009-06-15 07:40:00	AAPL	Stock	4.8393	4.8393	4.8393	4.8393	2800.0
2009-06-15 07:45:00	AAPL	Stock	4.8432	4.8432	4.8432	4.8432	2800.0
2009-06-15 07:55:00	AAPL	Stock	4.8518	4.8564	4.8468	4.8471	48048.0
2009-06-15 08:00:00	AAPL	Stock	4.8536	4.8568	4.8268	4.8271	339500.0
2009-06-15 08:05:00	AAPL	Stock	4.8271	4.8307	4.8214	4.8307	257656.0
2009-06-15 08:10:00	AAPL	Stock	4.8321	4.8343	4.8211	4.8211	240772.0
2009-06-15 08:15:00	AAPL	Stock	4.8214	4.8264	4.8182	4.8246	169960.0
2009-06-15 08:20:00	AAPL	Stock	4.8225	4.8389	4.8225	4.8389	227052.0
2009-06-15 08:25:00	AAPL	Stock	4.8421	4.8468	4.84	4.8468	131768.0
2009-06-15 08:30:00	AAPL	Stock	4.8468	4.8468	4.8432	4.8468	134988.0
2009-06-15 08:35:00	AAPL	Stock	4.8464	4.8493	4.8432	4.8486	64680.0
2009-06-15 08:40:00	AAPL	Stock	4.8479	4.8536	4.8446	4.8486	217000.0
2009-06-15 08:45:00	AAPL	Stock	4.8464	4.8532	4.845	4.845	50400.0
2009-06-15 08:50:00	AAPL	Stock	4.85	4.8543	4.8446	4.8543	150584.0
2009-06-15 08:55:00	AAPL	Stock	4.8504	4.8529	4.8504	4.8529	21000.0
2009-06-15 09:00:00	AAPL	Stock	4.8507	4.8536	4.8504	4.8518	61964.0
2009-06-15 09:05:00	AAPL	Stock	4.8518	4.8536	4.8507	4.8511	154840.0
2009-06-15 09:10:00	AAPL	Stock	4.8525	4.8529	4.85	4.85	50092.0
2009-06-15 09:15:00	AAPL	Stock	4.8521	4.8579	4.8521	4.8539	176988.0
2009-06-15 09:20:00	AAPL	Stock	4.8525	4.8589	4.8518	4.8589	175168.0
2009-06-15 09:25:00	AAPL	Stock	4.8618	4.8714	4.85	4.8593	1027124.0
2009-06-15 09:30:00	AAPL	Stock	4.8593	4.8632	4.8175	4.8343	22979600.0
2009-06-15 09:35:00	AAPL	Stock	4.8341	4.8789	4.8329	4.8715	19192124.0
2009-06-15 09:40:00	AAPL	Stock	4.8715	4.8875	4.8625	4.8761	17183124.0
2009-06-15 09:45:00	AAPL	Stock	4.8771	4.8793	4.8368	4.8568	18784388.0
2009-06-15 09:50:00	AAPL	Stock	4.8568	4.8707	4.8471	4.8584	13649468.0
2009-06-15 09:55:00	AAPL	Stock	4.8579	4.8718	4.8536	4.8593	10015068.0
2009-06-15 10:00:00	AAPL	Stock	4.8589	4.8625	4.8446	4.8446	7412720.0
2009-06-15 10:05:00	AAPL	Stock	4.8446	4.8529	4.8429	4.8495	8478624.0
2009-06-15 10:10:00	AAPL	Stock	4.8496	4.8629	4.849	4.85	6724368.0
2009-06-15 10:15:00	AAPL	Stock	4.8489	4.8661	4.8454	4.8636	9253160.0
2009-06-15 10:20:00	AAPL	Stock	4.8639	4.8904	4.8589	4.8839	12209988.0
2009-06-15 10:25:00	AAPL	Stock	4.8839	4.8893	4.8714	4.8782	8463112.0
2009-06-15 10:30:00	AAPL	Stock	4.8782	4.8782	4.8314	4.8446	29912988.0
2009-06-15 10:35:00	AAPL	Stock	4.845	4.8536	4.835	4.8368	12656084.0
2009-06-15 10:40:00	AAPL	Stock	4.8368	4.8514	4.835	4.8418	9994348.0
2009-06-15 10:45:00	AAPL	Stock	4.8418	4.8611	4.8414	4.8511	9755620.0
2009-06-15 10:50:00	AAPL	Stock	4.8511	4.8657	4.8496	4.8629	6493200.0
2009-06-15 10:55:00	AAPL	Stock	4.8629	4.8629	4.8464	4.8511	5171936.0
2009-06-15 11:00:00	AAPL	Stock	4.8511	4.8532	4.8418	4.8418	5609548.0
2009-06-15 11:05:00	AAPL	Stock	4.8419	4.8432	4.825	4.8343	12160484.0
2009-06-15 11:10:00	AAPL	Stock	4.8336	4.84	4.8286	4.8389	4546528.0
2009-06-15 11:15:00	AAPL	Stock	4.8386	4.8421	4.8304	4.8332	4701256.0
2009-06-15 11:20:00	AAPL	Stock	4.8339	4.8393	4.8268	4.8393	4699828.0
2009-06-15 11:25:00	AAPL	Stock	4.8393	4.8396	4.8296	4.8357	3437252.0
2009-06-15 11:30:00	AAPL	Stock	4.8355	4.8429	4.835	4.8407	3506692.0
2009-06-15 11:35:00	AAPL	Stock	4.8409	4.8425	4.8368	4.8389	2211608.0
2009-06-15 11:40:00	AAPL	Stock	4.8386	4.8425	4.8325	4.8339	3962616.0
2009-06-15 11:45:00	AAPL	Stock	4.8339	4.8375	4.8264	4.8279	4328408.0

> showing 50 of 323,523 rows — these rows as CSV

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