PREVIEW / stock_5min / 2009-05-19

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-05-19.parquet
  size:    4.6 MB
  rows:    320,317
  symbols: 3,356

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-05-19 04:35:00	AAPL	Stock	4.5557	4.5557	4.5557	4.5557	2800.0
2009-05-19 04:40:00	AAPL	Stock	4.5646	4.5768	4.5646	4.5768	19600.0
2009-05-19 04:50:00	AAPL	Stock	4.5618	4.5618	4.5618	4.5618	2800.0
2009-05-19 05:40:00	AAPL	Stock	4.5786	4.5804	4.5786	4.5804	11200.0
2009-05-19 05:45:00	AAPL	Stock	4.5893	4.5911	4.5893	4.5911	9716.0
2009-05-19 06:35:00	AAPL	Stock	4.5739	4.5739	4.5429	4.5429	61600.0
2009-05-19 06:40:00	AAPL	Stock	4.5429	4.5429	4.5286	4.5286	21000.0
2009-05-19 06:50:00	AAPL	Stock	4.5868	4.5871	4.5868	4.5871	19600.0
2009-05-19 07:05:00	AAPL	Stock	4.5646	4.5646	4.5643	4.5643	56000.0
2009-05-19 07:10:00	AAPL	Stock	4.5643	4.5646	4.5643	4.5646	30800.0
2009-05-19 07:15:00	AAPL	Stock	4.5625	4.5643	4.5625	4.5639	61236.0
2009-05-19 07:40:00	AAPL	Stock	4.5571	4.5571	4.5571	4.5571	2800.0
2009-05-19 07:55:00	AAPL	Stock	4.5625	4.5639	4.5607	4.5607	28000.0
2009-05-19 08:00:00	AAPL	Stock	4.5607	4.5639	4.5543	4.56	103068.0
2009-05-19 08:05:00	AAPL	Stock	4.5536	4.5571	4.5536	4.5536	30772.0
2009-05-19 08:10:00	AAPL	Stock	4.5554	4.5614	4.5536	4.5536	103432.0
2009-05-19 08:15:00	AAPL	Stock	4.5536	4.5536	4.5529	4.5529	42000.0
2009-05-19 08:20:00	AAPL	Stock	4.5536	4.5557	4.5493	4.5557	69160.0
2009-05-19 08:25:00	AAPL	Stock	4.5568	4.5568	4.5536	4.5536	8400.0
2009-05-19 08:30:00	AAPL	Stock	4.5518	4.5571	4.5507	4.5564	185584.0
2009-05-19 08:35:00	AAPL	Stock	4.5564	4.5564	4.5525	4.5525	63000.0
2009-05-19 08:40:00	AAPL	Stock	4.5525	4.5564	4.5504	4.5514	165116.0
2009-05-19 08:45:00	AAPL	Stock	4.5514	4.5529	4.5514	4.5529	230664.0
2009-05-19 08:50:00	AAPL	Stock	4.5525	4.5525	4.5514	4.5525	112784.0
2009-05-19 08:55:00	AAPL	Stock	4.5514	4.5525	4.5514	4.5518	25200.0
2009-05-19 09:00:00	AAPL	Stock	4.5518	4.5518	4.5375	4.5386	146860.0
2009-05-19 09:05:00	AAPL	Stock	4.5396	4.5404	4.5357	4.5404	109760.0
2009-05-19 09:10:00	AAPL	Stock	4.5454	4.5489	4.54	4.5411	76020.0
2009-05-19 09:15:00	AAPL	Stock	4.54	4.5404	4.5361	4.5386	39200.0
2009-05-19 09:20:00	AAPL	Stock	4.54	4.5404	4.5357	4.5357	75880.0
2009-05-19 09:25:00	AAPL	Stock	4.5357	4.5371	4.525	4.5279	312760.0
2009-05-19 09:30:00	AAPL	Stock	4.5293	4.5318	4.4907	4.4914	17128356.0
2009-05-19 09:35:00	AAPL	Stock	4.4925	4.5254	4.4907	4.5221	15053444.0
2009-05-19 09:40:00	AAPL	Stock	4.5211	4.5436	4.5109	4.5382	12249580.0
2009-05-19 09:45:00	AAPL	Stock	4.5382	4.55	4.5307	4.5486	10718344.0
2009-05-19 09:50:00	AAPL	Stock	4.5489	4.5489	4.5114	4.5173	9298996.0
2009-05-19 09:55:00	AAPL	Stock	4.5171	4.5361	4.5114	4.5307	6391168.0
2009-05-19 10:00:00	AAPL	Stock	4.53	4.5446	4.5275	4.5411	5904724.0
2009-05-19 10:05:00	AAPL	Stock	4.5411	4.5596	4.54	4.5571	10003616.0
2009-05-19 10:10:00	AAPL	Stock	4.5568	4.5596	4.5475	4.5589	5566596.0
2009-05-19 10:15:00	AAPL	Stock	4.5584	4.5646	4.555	4.5589	7419468.0
2009-05-19 10:20:00	AAPL	Stock	4.5582	4.5614	4.5336	4.5489	8346548.0
2009-05-19 10:25:00	AAPL	Stock	4.5493	4.5675	4.5486	4.5664	6747020.0
2009-05-19 10:30:00	AAPL	Stock	4.5675	4.5696	4.5611	4.5657	6114864.0
2009-05-19 10:35:00	AAPL	Stock	4.5657	4.5814	4.5643	4.5796	7211680.0
2009-05-19 10:40:00	AAPL	Stock	4.58	4.5811	4.5721	4.5739	4833640.0
2009-05-19 10:45:00	AAPL	Stock	4.5746	4.5775	4.5682	4.5725	4032924.0
2009-05-19 10:50:00	AAPL	Stock	4.5736	4.575	4.5629	4.5664	3421012.0
2009-05-19 10:55:00	AAPL	Stock	4.5675	4.5714	4.5646	4.5675	2306192.0
2009-05-19 11:00:00	AAPL	Stock	4.5679	4.5696	4.5614	4.5643	2948512.0

> showing 50 of 320,317 rows — these rows as CSV

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