PREVIEW / stock_5min / 2009-07-10

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-07-10.parquet
  size:    4.2 MB
  rows:    296,291
  symbols: 3,297

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-07-10 07:40:00	AAPL	Stock	4.8696	4.8696	4.8696	4.8696	11200.0
2009-07-10 08:00:00	AAPL	Stock	4.8579	4.8582	4.85	4.8507	191660.0
2009-07-10 08:05:00	AAPL	Stock	4.8571	4.8686	4.8571	4.8686	53200.0
2009-07-10 08:10:00	AAPL	Stock	4.8614	4.8614	4.8607	4.8607	56280.0
2009-07-10 08:15:00	AAPL	Stock	4.8593	4.8593	4.8579	4.8579	34384.0
2009-07-10 08:20:00	AAPL	Stock	4.8539	4.8571	4.8529	4.8571	93128.0
2009-07-10 08:25:00	AAPL	Stock	4.8571	4.8607	4.8571	4.8571	104440.0
2009-07-10 08:30:00	AAPL	Stock	4.8607	4.8607	4.8582	4.8582	25200.0
2009-07-10 08:35:00	AAPL	Stock	4.8568	4.8596	4.8568	4.8596	87192.0
2009-07-10 08:40:00	AAPL	Stock	4.8596	4.8596	4.8571	4.8589	142100.0
2009-07-10 08:45:00	AAPL	Stock	4.8596	4.8743	4.8596	4.8743	221256.0
2009-07-10 08:50:00	AAPL	Stock	4.8661	4.8786	4.8625	4.8786	205520.0
2009-07-10 08:55:00	AAPL	Stock	4.8746	4.8746	4.8664	4.8664	25200.0
2009-07-10 09:00:00	AAPL	Stock	4.8668	4.87	4.8661	4.87	47600.0
2009-07-10 09:05:00	AAPL	Stock	4.87	4.87	4.8679	4.8679	8400.0
2009-07-10 09:10:00	AAPL	Stock	4.8757	4.8768	4.8664	4.8696	70000.0
2009-07-10 09:15:00	AAPL	Stock	4.8689	4.8689	4.8689	4.8689	126000.0
2009-07-10 09:20:00	AAPL	Stock	4.8689	4.8704	4.8689	4.8704	268800.0
2009-07-10 09:25:00	AAPL	Stock	4.8661	4.8754	4.8661	4.8714	123900.0
2009-07-10 09:30:00	AAPL	Stock	4.8693	4.9175	4.8675	4.9107	20422836.0
2009-07-10 09:35:00	AAPL	Stock	4.9107	4.9339	4.9096	4.9179	20463800.0
2009-07-10 09:40:00	AAPL	Stock	4.9179	4.9321	4.9107	4.9168	11776492.0
2009-07-10 09:45:00	AAPL	Stock	4.9164	4.9443	4.9161	4.9443	17001824.0
2009-07-10 09:50:00	AAPL	Stock	4.9446	4.9496	4.8743	4.9364	14750148.0
2009-07-10 09:55:00	AAPL	Stock	4.9368	4.9589	4.9286	4.9514	19040000.0
2009-07-10 10:00:00	AAPL	Stock	4.95	4.9571	4.9293	4.94	14075880.0
2009-07-10 10:05:00	AAPL	Stock	4.9398	4.9454	4.9314	4.9432	8754788.0
2009-07-10 10:10:00	AAPL	Stock	4.9432	4.9518	4.9361	4.9493	9542512.0
2009-07-10 10:15:00	AAPL	Stock	4.9493	4.9514	4.9382	4.9396	7019488.0
2009-07-10 10:20:00	AAPL	Stock	4.9393	4.9464	4.9346	4.9411	5101572.0
2009-07-10 10:25:00	AAPL	Stock	4.9411	4.9454	4.9375	4.945	3189032.0
2009-07-10 10:30:00	AAPL	Stock	4.9446	4.945	4.9371	4.9436	3094476.0
2009-07-10 10:35:00	AAPL	Stock	4.9439	4.9486	4.9357	4.9375	3685612.0
2009-07-10 10:40:00	AAPL	Stock	4.9375	4.9393	4.9225	4.9243	6837068.0
2009-07-10 10:45:00	AAPL	Stock	4.9232	4.9339	4.9232	4.9332	5238324.0
2009-07-10 10:50:00	AAPL	Stock	4.9332	4.9443	4.9329	4.9425	4088028.0
2009-07-10 10:55:00	AAPL	Stock	4.9429	4.9521	4.9418	4.9434	5223792.0
2009-07-10 11:00:00	AAPL	Stock	4.9429	4.9443	4.9332	4.9379	5680108.0
2009-07-10 11:05:00	AAPL	Stock	4.9386	4.9479	4.9379	4.9479	3967824.0
2009-07-10 11:10:00	AAPL	Stock	4.9475	4.9493	4.9407	4.9458	4185412.0
2009-07-10 11:15:00	AAPL	Stock	4.9457	4.9479	4.9343	4.9386	6505128.0
2009-07-10 11:20:00	AAPL	Stock	4.9382	4.9386	4.9161	4.9246	8384880.0
2009-07-10 11:25:00	AAPL	Stock	4.9236	4.9257	4.9075	4.9143	7635208.0
2009-07-10 11:30:00	AAPL	Stock	4.9143	4.92	4.9007	4.9196	7621572.0
2009-07-10 11:35:00	AAPL	Stock	4.92	4.9246	4.9173	4.9232	4432652.0
2009-07-10 11:40:00	AAPL	Stock	4.9229	4.9236	4.9164	4.9182	2760100.0
2009-07-10 11:45:00	AAPL	Stock	4.9182	4.9279	4.9175	4.9261	2765140.0
2009-07-10 11:50:00	AAPL	Stock	4.9261	4.9346	4.9236	4.9311	3192476.0
2009-07-10 11:55:00	AAPL	Stock	4.9311	4.9318	4.9207	4.9218	1965712.0
2009-07-10 12:00:00	AAPL	Stock	4.9218	4.9264	4.9186	4.926	2443168.0

> showing 50 of 296,291 rows — these rows as CSV

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