PREVIEW / stock_5min / 2009-06-24

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-06-24.parquet
  size:    4.6 MB
  rows:    318,449
  symbols: 3,359

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-24 06:10:00	AAPL	Stock	4.7896	4.7896	4.7896	4.7896	2800.0
2009-06-24 06:45:00	AAPL	Stock	4.7857	4.7857	4.7857	4.7857	5600.0
2009-06-24 07:10:00	AAPL	Stock	4.8207	4.8214	4.8207	4.8214	30800.0
2009-06-24 07:20:00	AAPL	Stock	4.8211	4.8214	4.8186	4.8186	14000.0
2009-06-24 07:25:00	AAPL	Stock	4.8179	4.8179	4.8168	4.8168	31808.0
2009-06-24 07:30:00	AAPL	Stock	4.8089	4.8089	4.8089	4.8089	27020.0
2009-06-24 07:35:00	AAPL	Stock	4.8089	4.8089	4.8071	4.8071	11200.0
2009-06-24 07:40:00	AAPL	Stock	4.8089	4.8089	4.8089	4.8089	14000.0
2009-06-24 07:50:00	AAPL	Stock	4.8007	4.8007	4.8007	4.8007	2800.0
2009-06-24 07:55:00	AAPL	Stock	4.8096	4.8096	4.8096	4.8096	2800.0
2009-06-24 08:00:00	AAPL	Stock	4.8043	4.8079	4.7964	4.7964	242508.0
2009-06-24 08:05:00	AAPL	Stock	4.7993	4.8079	4.7993	4.8071	201404.0
2009-06-24 08:10:00	AAPL	Stock	4.805	4.8064	4.7982	4.8064	95340.0
2009-06-24 08:15:00	AAPL	Stock	4.8054	4.81	4.8036	4.81	201600.0
2009-06-24 08:20:00	AAPL	Stock	4.8089	4.8132	4.8089	4.8121	62300.0
2009-06-24 08:25:00	AAPL	Stock	4.8121	4.8121	4.81	4.81	14000.0
2009-06-24 08:30:00	AAPL	Stock	4.8089	4.8357	4.8089	4.8314	971012.0
2009-06-24 08:35:00	AAPL	Stock	4.8304	4.8418	4.8304	4.8418	381780.0
2009-06-24 08:40:00	AAPL	Stock	4.8393	4.84	4.835	4.8368	182504.0
2009-06-24 08:45:00	AAPL	Stock	4.8357	4.8371	4.8357	4.8361	50400.0
2009-06-24 08:50:00	AAPL	Stock	4.8386	4.8679	4.8386	4.8643	955668.0
2009-06-24 08:55:00	AAPL	Stock	4.8643	4.8661	4.8571	4.8604	241864.0
2009-06-24 09:00:00	AAPL	Stock	4.8629	4.8643	4.8571	4.8571	293720.0
2009-06-24 09:05:00	AAPL	Stock	4.8571	4.8571	4.845	4.85	253820.0
2009-06-24 09:10:00	AAPL	Stock	4.8532	4.8571	4.8518	4.8543	188524.0
2009-06-24 09:15:00	AAPL	Stock	4.8521	4.8521	4.85	4.8507	205800.0
2009-06-24 09:20:00	AAPL	Stock	4.8507	4.8521	4.8482	4.8521	81480.0
2009-06-24 09:25:00	AAPL	Stock	4.8489	4.8489	4.8296	4.8368	566356.0
2009-06-24 09:30:00	AAPL	Stock	4.8364	4.8396	4.8164	4.8236	19301576.0
2009-06-24 09:35:00	AAPL	Stock	4.8236	4.8607	4.8221	4.8496	15353884.0
2009-06-24 09:40:00	AAPL	Stock	4.8496	4.8607	4.8332	4.8375	13105540.0
2009-06-24 09:45:00	AAPL	Stock	4.8386	4.8482	4.8279	4.8364	8603756.0
2009-06-24 09:50:00	AAPL	Stock	4.8371	4.8457	4.8318	4.8389	8256248.0
2009-06-24 09:55:00	AAPL	Stock	4.8382	4.8557	4.8346	4.8536	9956212.0
2009-06-24 10:00:00	AAPL	Stock	4.8536	4.8536	4.8371	4.8521	8547000.0
2009-06-24 10:05:00	AAPL	Stock	4.8521	4.8764	4.8436	4.8761	13105008.0
2009-06-24 10:10:00	AAPL	Stock	4.8757	4.8854	4.8739	4.8854	12595380.0
2009-06-24 10:15:00	AAPL	Stock	4.8854	4.9039	4.8829	4.8957	17262728.0
2009-06-24 10:20:00	AAPL	Stock	4.8961	4.9036	4.8925	4.8964	8617896.0
2009-06-24 10:25:00	AAPL	Stock	4.8964	4.8993	4.8861	4.8879	7338100.0
2009-06-24 10:30:00	AAPL	Stock	4.8879	4.8939	4.8843	4.8911	5001220.0
2009-06-24 10:35:00	AAPL	Stock	4.8911	4.8964	4.8861	4.895	4157132.0
2009-06-24 10:40:00	AAPL	Stock	4.8946	4.8993	4.8904	4.8979	4865728.0
2009-06-24 10:45:00	AAPL	Stock	4.8982	4.9089	4.895	4.9058	5891620.0
2009-06-24 10:50:00	AAPL	Stock	4.9071	4.9074	4.8954	4.8961	7018648.0
2009-06-24 10:55:00	AAPL	Stock	4.8961	4.8961	4.8804	4.8807	9764888.0
2009-06-24 11:00:00	AAPL	Stock	4.8807	4.8964	4.8807	4.8932	3229016.0
2009-06-24 11:05:00	AAPL	Stock	4.8939	4.8957	4.8882	4.895	2525012.0
2009-06-24 11:10:00	AAPL	Stock	4.8954	4.8964	4.8911	4.8927	2808232.0
2009-06-24 11:15:00	AAPL	Stock	4.8929	4.8957	4.8921	4.8943	2676380.0

> showing 50 of 318,449 rows — these rows as CSV

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