PREVIEW / stock_5min / 2009-09-21

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-09-21.parquet
  size:    4.6 MB
  rows:    319,137
  symbols: 3,394

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-21 04:40:00	AAPL	Stock	6.6071	6.6071	6.6071	6.6071	5600.0
2009-09-21 04:50:00	AAPL	Stock	6.6071	6.6071	6.6054	6.6054	6552.0
2009-09-21 05:05:00	AAPL	Stock	6.6054	6.6054	6.6054	6.6054	5124.0
2009-09-21 05:30:00	AAPL	Stock	6.5754	6.5754	6.5754	6.5754	4200.0
2009-09-21 07:10:00	AAPL	Stock	6.5821	6.5821	6.5714	6.5714	43400.0
2009-09-21 07:15:00	AAPL	Stock	6.575	6.575	6.5707	6.5714	69580.0
2009-09-21 07:20:00	AAPL	Stock	6.5671	6.5671	6.5661	6.5661	5600.0
2009-09-21 07:30:00	AAPL	Stock	6.5675	6.5675	6.5604	6.5604	33600.0
2009-09-21 07:35:00	AAPL	Stock	6.5611	6.5639	6.5611	6.5639	11452.0
2009-09-21 07:40:00	AAPL	Stock	6.5668	6.5714	6.5668	6.5714	90888.0
2009-09-21 07:45:00	AAPL	Stock	6.5736	6.5818	6.5725	6.5818	38920.0
2009-09-21 07:50:00	AAPL	Stock	6.5821	6.5829	6.5793	6.5793	25200.0
2009-09-21 07:55:00	AAPL	Stock	6.5786	6.5825	6.5786	6.5825	8400.0
2009-09-21 08:00:00	AAPL	Stock	6.5832	6.5889	6.5714	6.5721	209720.0
2009-09-21 08:05:00	AAPL	Stock	6.5714	6.575	6.5711	6.5714	119784.0
2009-09-21 08:10:00	AAPL	Stock	6.5714	6.575	6.5714	6.5714	197344.0
2009-09-21 08:15:00	AAPL	Stock	6.5725	6.5818	6.5714	6.5714	123676.0
2009-09-21 08:20:00	AAPL	Stock	6.5689	6.5714	6.5646	6.5646	185668.0
2009-09-21 08:25:00	AAPL	Stock	6.565	6.565	6.56	6.56	137004.0
2009-09-21 08:30:00	AAPL	Stock	6.5607	6.5607	6.5571	6.5571	163716.0
2009-09-21 08:35:00	AAPL	Stock	6.5571	6.5661	6.5571	6.5661	139104.0
2009-09-21 08:40:00	AAPL	Stock	6.5614	6.5686	6.5614	6.5661	142016.0
2009-09-21 08:45:00	AAPL	Stock	6.5686	6.5686	6.5643	6.5661	115640.0
2009-09-21 08:50:00	AAPL	Stock	6.5661	6.5714	6.5661	6.5671	81200.0
2009-09-21 08:55:00	AAPL	Stock	6.5668	6.5668	6.5668	6.5668	54880.0
2009-09-21 09:00:00	AAPL	Stock	6.5668	6.5721	6.5668	6.5718	286860.0
2009-09-21 09:05:00	AAPL	Stock	6.5732	6.575	6.5696	6.5696	68600.0
2009-09-21 09:10:00	AAPL	Stock	6.5714	6.5725	6.5714	6.5725	50568.0
2009-09-21 09:15:00	AAPL	Stock	6.5718	6.5804	6.5714	6.5804	144536.0
2009-09-21 09:20:00	AAPL	Stock	6.5743	6.5743	6.5657	6.5714	110376.0
2009-09-21 09:25:00	AAPL	Stock	6.5682	6.5857	6.5682	6.5857	165900.0
2009-09-21 09:30:00	AAPL	Stock	6.5836	6.5882	6.5679	6.575	12373676.0
2009-09-21 09:35:00	AAPL	Stock	6.5746	6.6129	6.5736	6.5843	20106268.0
2009-09-21 09:40:00	AAPL	Stock	6.5839	6.5961	6.4864	6.5821	13359976.0
2009-09-21 09:45:00	AAPL	Stock	6.5821	6.5868	6.5625	6.5632	13710592.0
2009-09-21 09:50:00	AAPL	Stock	6.5629	6.5636	6.5236	6.5379	16314396.0
2009-09-21 09:55:00	AAPL	Stock	6.5368	6.5371	6.5143	6.5214	11340868.0
2009-09-21 10:00:00	AAPL	Stock	6.5243	6.5354	6.5182	6.5332	8400056.0
2009-09-21 10:05:00	AAPL	Stock	6.5332	6.5475	6.53	6.5311	9184980.0
2009-09-21 10:10:00	AAPL	Stock	6.5311	6.5339	6.505	6.5297	7430052.0
2009-09-21 10:15:00	AAPL	Stock	6.53	6.5346	6.5204	6.5214	6014008.0
2009-09-21 10:20:00	AAPL	Stock	6.5225	6.5368	6.5214	6.5345	7893032.0
2009-09-21 10:25:00	AAPL	Stock	6.5343	6.5364	6.5264	6.5264	5477864.0
2009-09-21 10:30:00	AAPL	Stock	6.5261	6.53	6.5179	6.5186	4685492.0
2009-09-21 10:35:00	AAPL	Stock	6.5189	6.5189	6.5075	6.5114	6180244.0
2009-09-21 10:40:00	AAPL	Stock	6.5114	6.5182	6.5096	6.5179	4599700.0
2009-09-21 10:45:00	AAPL	Stock	6.5176	6.5254	6.5176	6.5229	4467260.0
2009-09-21 10:50:00	AAPL	Stock	6.5232	6.5243	6.5107	6.5132	4006072.0
2009-09-21 10:55:00	AAPL	Stock	6.5132	6.5157	6.4982	6.5018	9339036.0
2009-09-21 11:00:00	AAPL	Stock	6.5018	6.5025	6.4943	6.5002	7201908.0

> showing 50 of 319,137 rows — these rows as CSV

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