PREVIEW / stock_5min / 2013-11-20

all stock 5-min files

  file:    by_date/stock_5min/2013/2013-11-20.parquet
  size:    5.3 MB
  rows:    347,102
  symbols: 3,547

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
2013-11-20 05:20:00	AAPL	Stock	18.5579	18.5579	18.5579	18.5579	2800.0
2013-11-20 06:10:00	AAPL	Stock	18.525	18.525	18.525	18.525	2800.0
2013-11-20 06:55:00	AAPL	Stock	18.5321	18.5321	18.5321	18.5321	2800.0
2013-11-20 07:05:00	AAPL	Stock	18.5321	18.5357	18.5321	18.5357	9520.0
2013-11-20 07:35:00	AAPL	Stock	18.5364	18.5364	18.5364	18.5364	2800.0
2013-11-20 07:50:00	AAPL	Stock	18.5375	18.5375	18.505	18.505	49952.0
2013-11-20 07:55:00	AAPL	Stock	18.5321	18.5321	18.5182	18.5182	41020.0
2013-11-20 08:00:00	AAPL	Stock	18.5336	18.5446	18.5189	18.5446	55860.0
2013-11-20 08:05:00	AAPL	Stock	18.5439	18.5596	18.5439	18.5596	28000.0
2013-11-20 08:10:00	AAPL	Stock	18.5636	18.5636	18.5214	18.5214	115668.0
2013-11-20 08:15:00	AAPL	Stock	18.5357	18.5357	18.5357	18.5357	5600.0
2013-11-20 08:20:00	AAPL	Stock	18.5529	18.5536	18.5529	18.5536	12600.0
2013-11-20 08:25:00	AAPL	Stock	18.5632	18.5643	18.5536	18.5536	22820.0
2013-11-20 08:30:00	AAPL	Stock	18.5607	18.5607	18.5607	18.5607	5600.0
2013-11-20 08:35:00	AAPL	Stock	18.5604	18.5714	18.5604	18.5714	44800.0
2013-11-20 08:40:00	AAPL	Stock	18.5818	18.5821	18.5696	18.5696	32340.0
2013-11-20 08:45:00	AAPL	Stock	18.565	18.565	18.5625	18.5625	22400.0
2013-11-20 08:55:00	AAPL	Stock	18.5632	18.5679	18.5625	18.5625	11900.0
2013-11-20 09:00:00	AAPL	Stock	18.5625	18.5696	18.5614	18.5696	73724.0
2013-11-20 09:05:00	AAPL	Stock	18.5696	18.5696	18.5696	18.5696	13944.0
2013-11-20 09:10:00	AAPL	Stock	18.5786	18.5786	18.5714	18.5714	120148.0
2013-11-20 09:15:00	AAPL	Stock	18.5657	18.5657	18.55	18.5536	60340.0
2013-11-20 09:20:00	AAPL	Stock	18.5621	18.5621	18.5536	18.5614	53284.0
2013-11-20 09:25:00	AAPL	Stock	18.5454	18.5468	18.5357	18.5414	82376.0
2013-11-20 09:30:00	AAPL	Stock	18.5439	18.5757	18.5125	18.5457	10111752.0
2013-11-20 09:35:00	AAPL	Stock	18.5477	18.5864	18.5343	18.5714	5276152.0
2013-11-20 09:40:00	AAPL	Stock	18.575	18.585	18.5371	18.5371	3825752.0
2013-11-20 09:45:00	AAPL	Stock	18.5404	18.5404	18.5039	18.5282	5029948.0
2013-11-20 09:50:00	AAPL	Stock	18.5193	18.5318	18.4842	18.4943	5462072.0
2013-11-20 09:55:00	AAPL	Stock	18.4943	18.5182	18.4839	18.5	3884076.0
2013-11-20 10:00:00	AAPL	Stock	18.5014	18.5071	18.4739	18.4966	3303356.0
2013-11-20 10:05:00	AAPL	Stock	18.4961	18.5131	18.4821	18.5021	2979732.0
2013-11-20 10:10:00	AAPL	Stock	18.5043	18.515	18.4854	18.5039	3306576.0
2013-11-20 10:15:00	AAPL	Stock	18.5043	18.5236	18.4907	18.5179	2399544.0
2013-11-20 10:20:00	AAPL	Stock	18.52	18.56	18.52	18.5425	4228476.0
2013-11-20 10:25:00	AAPL	Stock	18.5421	18.5464	18.5189	18.5321	1927688.0
2013-11-20 10:30:00	AAPL	Stock	18.5321	18.5439	18.5057	18.5093	2376612.0
2013-11-20 10:35:00	AAPL	Stock	18.5076	18.5129	18.4911	18.5046	3895948.0
2013-11-20 10:40:00	AAPL	Stock	18.5068	18.5114	18.4879	18.5093	4527068.0
2013-11-20 10:45:00	AAPL	Stock	18.5089	18.5211	18.4979	18.5132	3325476.0
2013-11-20 10:50:00	AAPL	Stock	18.5146	18.5325	18.5062	18.5293	2587732.0
2013-11-20 10:55:00	AAPL	Stock	18.5243	18.5404	18.5189	18.525	1242416.0
2013-11-20 11:00:00	AAPL	Stock	18.5243	18.5296	18.5066	18.5129	3140200.0
2013-11-20 11:05:00	AAPL	Stock	18.5132	18.5268	18.4989	18.5186	3540432.0
2013-11-20 11:10:00	AAPL	Stock	18.5257	18.5268	18.4975	18.5082	2847656.0
2013-11-20 11:15:00	AAPL	Stock	18.5129	18.5146	18.4896	18.4961	4754848.0
2013-11-20 11:20:00	AAPL	Stock	18.4939	18.5093	18.4939	18.5039	1842652.0
2013-11-20 11:25:00	AAPL	Stock	18.5036	18.5204	18.5018	18.5164	2287460.0
2013-11-20 11:30:00	AAPL	Stock	18.5157	18.5179	18.505	18.5143	2359728.0
2013-11-20 11:35:00	AAPL	Stock	18.5132	18.5279	18.5036	18.5036	2205532.0

> showing 50 of 347,102 rows — these rows as CSV

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