PREVIEW / stock_5min / 2009-04-30

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-04-30.parquet
  size:    4.8 MB
  rows:    325,248
  symbols: 3,340

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-04-30 04:20:00	AAPL	Stock	4.5046	4.5046	4.5046	4.5046	2800.0
2009-04-30 04:30:00	AAPL	Stock	4.5332	4.5332	4.5332	4.5332	2800.0
2009-04-30 04:55:00	AAPL	Stock	4.5286	4.5286	4.5286	4.5286	14000.0
2009-04-30 07:00:00	AAPL	Stock	4.5204	4.525	4.5204	4.525	42000.0
2009-04-30 07:05:00	AAPL	Stock	4.525	4.5268	4.525	4.5268	15400.0
2009-04-30 07:15:00	AAPL	Stock	4.5321	4.5321	4.5054	4.5054	20720.0
2009-04-30 07:20:00	AAPL	Stock	4.5304	4.5321	4.5279	4.5279	12600.0
2009-04-30 07:25:00	AAPL	Stock	4.5268	4.5268	4.5268	4.5268	5600.0
2009-04-30 07:30:00	AAPL	Stock	4.5268	4.5268	4.5132	4.5132	5600.0
2009-04-30 07:35:00	AAPL	Stock	4.5096	4.5161	4.5096	4.5161	84000.0
2009-04-30 07:40:00	AAPL	Stock	4.515	4.515	4.515	4.515	2800.0
2009-04-30 07:45:00	AAPL	Stock	4.5132	4.5132	4.5132	4.5132	2800.0
2009-04-30 07:50:00	AAPL	Stock	4.5096	4.5179	4.5089	4.5179	49000.0
2009-04-30 08:00:00	AAPL	Stock	4.5179	4.5304	4.5093	4.5304	169540.0
2009-04-30 08:05:00	AAPL	Stock	4.5214	4.5268	4.5214	4.5254	172340.0
2009-04-30 08:10:00	AAPL	Stock	4.525	4.5268	4.5214	4.5261	382536.0
2009-04-30 08:15:00	AAPL	Stock	4.5261	4.5261	4.5196	4.5196	75600.0
2009-04-30 08:20:00	AAPL	Stock	4.5196	4.5232	4.5179	4.5232	33348.0
2009-04-30 08:25:00	AAPL	Stock	4.5232	4.5232	4.5179	4.5214	52388.0
2009-04-30 08:30:00	AAPL	Stock	4.5214	4.5214	4.5179	4.5179	214620.0
2009-04-30 08:35:00	AAPL	Stock	4.5179	4.5179	4.5157	4.5171	52500.0
2009-04-30 08:40:00	AAPL	Stock	4.5179	4.5179	4.5132	4.5143	38220.0
2009-04-30 08:45:00	AAPL	Stock	4.5179	4.5179	4.5125	4.5157	22120.0
2009-04-30 08:50:00	AAPL	Stock	4.5154	4.5179	4.5125	4.5179	8400.0
2009-04-30 08:55:00	AAPL	Stock	4.5179	4.5179	4.5107	4.5107	50680.0
2009-04-30 09:00:00	AAPL	Stock	4.5107	4.5214	4.5107	4.5179	77616.0
2009-04-30 09:05:00	AAPL	Stock	4.5179	4.5182	4.5179	4.5179	26908.0
2009-04-30 09:10:00	AAPL	Stock	4.5182	4.5182	4.5107	4.5107	45640.0
2009-04-30 09:15:00	AAPL	Stock	4.5114	4.5129	4.5107	4.5107	24108.0
2009-04-30 09:20:00	AAPL	Stock	4.5107	4.5107	4.5089	4.5089	54488.0
2009-04-30 09:25:00	AAPL	Stock	4.5118	4.515	4.5071	4.5143	150360.0
2009-04-30 09:30:00	AAPL	Stock	4.5071	4.5143	4.4696	4.4711	18891992.0
2009-04-30 09:35:00	AAPL	Stock	4.4714	4.49	4.4643	4.4771	11292092.0
2009-04-30 09:40:00	AAPL	Stock	4.4771	4.5054	4.4754	4.4971	16835924.0
2009-04-30 09:45:00	AAPL	Stock	4.495	4.5036	4.4775	4.4941	12607280.0
2009-04-30 09:50:00	AAPL	Stock	4.4939	4.5154	4.4936	4.505	10977876.0
2009-04-30 09:55:00	AAPL	Stock	4.505	4.5136	4.5004	4.5039	8472968.0
2009-04-30 10:00:00	AAPL	Stock	4.5046	4.5143	4.5032	4.5121	6714624.0
2009-04-30 10:05:00	AAPL	Stock	4.5125	4.5196	4.5107	4.5156	8422428.0
2009-04-30 10:10:00	AAPL	Stock	4.5164	4.5268	4.5125	4.5175	6748840.0
2009-04-30 10:15:00	AAPL	Stock	4.5177	4.5214	4.5082	4.5096	4810652.0
2009-04-30 10:20:00	AAPL	Stock	4.5089	4.5175	4.5054	4.5156	4675412.0
2009-04-30 10:25:00	AAPL	Stock	4.5151	4.5243	4.5146	4.5229	3758104.0
2009-04-30 10:30:00	AAPL	Stock	4.5232	4.5264	4.5096	4.5121	3786608.0
2009-04-30 10:35:00	AAPL	Stock	4.5125	4.52	4.5104	4.5175	3191692.0
2009-04-30 10:40:00	AAPL	Stock	4.5172	4.5172	4.5089	4.5143	4563804.0
2009-04-30 10:45:00	AAPL	Stock	4.5143	4.5143	4.5032	4.5082	5071612.0
2009-04-30 10:50:00	AAPL	Stock	4.5084	4.5232	4.5084	4.5225	3941308.0
2009-04-30 10:55:00	AAPL	Stock	4.5218	4.5279	4.5179	4.5257	7111776.0
2009-04-30 11:00:00	AAPL	Stock	4.5268	4.5318	4.5241	4.5275	4552884.0

> showing 50 of 325,248 rows — these rows as CSV

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