PREVIEW / stock_5min / 2009-09-23

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-09-23.parquet
  size:    4.8 MB
  rows:    327,470
  symbols: 3,393

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-09-23 07:00:00	AAPL	Stock	6.6071	6.6071	6.6071	6.6071	5600.0
2009-09-23 07:30:00	AAPL	Stock	6.6071	6.6071	6.6071	6.6071	4760.0
2009-09-23 07:40:00	AAPL	Stock	6.6236	6.6236	6.6214	6.6214	31360.0
2009-09-23 07:55:00	AAPL	Stock	6.6236	6.6236	6.6236	6.6236	9660.0
2009-09-23 08:00:00	AAPL	Stock	6.6179	6.6236	6.6089	6.6179	123004.0
2009-09-23 08:05:00	AAPL	Stock	6.6189	6.6196	6.6143	6.6143	133000.0
2009-09-23 08:10:00	AAPL	Stock	6.6179	6.6196	6.6157	6.6157	33600.0
2009-09-23 08:15:00	AAPL	Stock	6.6143	6.6143	6.6082	6.6082	127400.0
2009-09-23 08:20:00	AAPL	Stock	6.6118	6.6118	6.5721	6.5721	632240.0
2009-09-23 08:25:00	AAPL	Stock	6.6086	6.6089	6.6071	6.6071	77588.0
2009-09-23 08:30:00	AAPL	Stock	6.6104	6.6125	6.6071	6.6125	69076.0
2009-09-23 08:35:00	AAPL	Stock	6.6136	6.6136	6.6136	6.6136	14140.0
2009-09-23 08:40:00	AAPL	Stock	6.6136	6.6139	6.6136	6.6139	14000.0
2009-09-23 08:45:00	AAPL	Stock	6.6143	6.6161	6.6136	6.615	55720.0
2009-09-23 08:50:00	AAPL	Stock	6.6154	6.6229	6.6154	6.6196	241808.0
2009-09-23 08:55:00	AAPL	Stock	6.6196	6.6214	6.6179	6.6196	173208.0
2009-09-23 09:00:00	AAPL	Stock	6.6175	6.6189	6.6157	6.6186	71232.0
2009-09-23 09:05:00	AAPL	Stock	6.6204	6.6207	6.6179	6.6179	100800.0
2009-09-23 09:10:00	AAPL	Stock	6.6182	6.6182	6.6139	6.6139	131068.0
2009-09-23 09:15:00	AAPL	Stock	6.6171	6.6182	6.6146	6.6182	62552.0
2009-09-23 09:20:00	AAPL	Stock	6.6186	6.6186	6.6164	6.6164	50400.0
2009-09-23 09:25:00	AAPL	Stock	6.6161	6.625	6.6161	6.6211	207872.0
2009-09-23 09:30:00	AAPL	Stock	6.6214	6.625	6.6082	6.6154	15077468.0
2009-09-23 09:35:00	AAPL	Stock	6.6153	6.6504	6.6132	6.6468	11880792.0
2009-09-23 09:40:00	AAPL	Stock	6.6461	6.6596	6.6343	6.6561	12841640.0
2009-09-23 09:45:00	AAPL	Stock	6.6561	6.6839	6.6539	6.6818	16382016.0
2009-09-23 09:50:00	AAPL	Stock	6.6829	6.7093	6.6804	6.6886	26885404.0
2009-09-23 09:55:00	AAPL	Stock	6.6886	6.6904	6.665	6.6889	18021920.0
2009-09-23 10:00:00	AAPL	Stock	6.6904	6.7014	6.6789	6.7	11950092.0
2009-09-23 10:05:00	AAPL	Stock	6.6998	6.7054	6.6882	6.6886	11776996.0
2009-09-23 10:10:00	AAPL	Stock	6.6882	6.6961	6.6779	6.6811	8781332.0
2009-09-23 10:15:00	AAPL	Stock	6.6804	6.6943	6.6761	6.6914	9458708.0
2009-09-23 10:20:00	AAPL	Stock	6.6911	6.6957	6.685	6.6914	4603872.0
2009-09-23 10:25:00	AAPL	Stock	6.6921	6.6921	6.6696	6.6707	7456764.0
2009-09-23 10:30:00	AAPL	Stock	6.6711	6.6846	6.665	6.6804	8079708.0
2009-09-23 10:35:00	AAPL	Stock	6.68	6.6814	6.6429	6.6482	9911916.0
2009-09-23 10:40:00	AAPL	Stock	6.6482	6.66	6.6429	6.6589	7970760.0
2009-09-23 10:45:00	AAPL	Stock	6.6596	6.6618	6.6464	6.661	4836412.0
2009-09-23 10:50:00	AAPL	Stock	6.66	6.6786	6.6536	6.6746	7201908.0
2009-09-23 10:55:00	AAPL	Stock	6.6739	6.6839	6.6686	6.6732	4936008.0
2009-09-23 11:00:00	AAPL	Stock	6.6739	6.6839	6.6668	6.6671	3075940.0
2009-09-23 11:05:00	AAPL	Stock	6.6678	6.6699	6.6643	6.6693	1766688.0
2009-09-23 11:10:00	AAPL	Stock	6.6704	6.6714	6.6621	6.6639	2454928.0
2009-09-23 11:15:00	AAPL	Stock	6.6629	6.6693	6.6618	6.6693	1606108.0
2009-09-23 11:20:00	AAPL	Stock	6.6686	6.6786	6.6686	6.6775	4201120.0
2009-09-23 11:25:00	AAPL	Stock	6.6775	6.6829	6.6757	6.6789	5244148.0
2009-09-23 11:30:00	AAPL	Stock	6.6787	6.685	6.6771	6.6811	3016020.0
2009-09-23 11:35:00	AAPL	Stock	6.6818	6.6836	6.6771	6.6793	2254980.0
2009-09-23 11:40:00	AAPL	Stock	6.6793	6.6907	6.6757	6.6893	4614652.0
2009-09-23 11:45:00	AAPL	Stock	6.6893	6.6911	6.6832	6.6832	2294068.0

> showing 50 of 327,470 rows — these rows as CSV

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