PREVIEW / stock_1min / 2012-07-05

all stock 1-min files

  file:    by_date/stock_1min/2012/2012-07-05.parquet
  size:    12.4 MB
  rows:    929,002
  symbols: 2,843

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
2012-07-05 04:00:00	AAPL	Stock	21.3929	21.3929	21.3929	21.3929	2800.0
2012-07-05 04:26:00	AAPL	Stock	21.3575	21.3575	21.3575	21.3575	8400.0
2012-07-05 04:27:00	AAPL	Stock	21.3575	21.3575	21.3575	21.3575	2800.0
2012-07-05 04:34:00	AAPL	Stock	21.3732	21.3732	21.3732	21.3732	2800.0
2012-07-05 04:35:00	AAPL	Stock	21.3732	21.3732	21.3732	21.3732	2800.0
2012-07-05 04:38:00	AAPL	Stock	21.3732	21.3732	21.3732	21.3732	5600.0
2012-07-05 04:42:00	AAPL	Stock	21.3571	21.3571	21.3571	21.3571	2800.0
2012-07-05 05:58:00	AAPL	Stock	21.3582	21.3582	21.3582	21.3582	2800.0
2012-07-05 06:55:00	AAPL	Stock	21.3839	21.3839	21.3839	21.3839	14000.0
2012-07-05 07:00:00	AAPL	Stock	21.3929	21.4271	21.3929	21.4271	17164.0
2012-07-05 07:02:00	AAPL	Stock	21.4614	21.4614	21.4614	21.4614	2800.0
2012-07-05 07:03:00	AAPL	Stock	21.4646	21.475	21.4646	21.475	5600.0
2012-07-05 07:04:00	AAPL	Stock	21.4821	21.4821	21.4821	21.4821	2800.0
2012-07-05 07:06:00	AAPL	Stock	21.4921	21.4921	21.4921	21.4921	5600.0
2012-07-05 07:07:00	AAPL	Stock	21.4643	21.4646	21.4643	21.4646	5600.0
2012-07-05 07:08:00	AAPL	Stock	21.4646	21.4646	21.4646	21.4646	8400.0
2012-07-05 07:09:00	AAPL	Stock	21.4679	21.475	21.4679	21.4679	11200.0
2012-07-05 07:10:00	AAPL	Stock	21.4554	21.4554	21.4554	21.4554	2800.0
2012-07-05 07:12:00	AAPL	Stock	21.4571	21.4571	21.4571	21.4571	5600.0
2012-07-05 07:13:00	AAPL	Stock	21.4821	21.4821	21.4821	21.4821	5600.0
2012-07-05 07:16:00	AAPL	Stock	21.4836	21.4836	21.4836	21.4836	14000.0
2012-07-05 07:17:00	AAPL	Stock	21.4679	21.4721	21.4679	21.4721	13888.0
2012-07-05 07:18:00	AAPL	Stock	21.4936	21.4957	21.4936	21.4957	8400.0
2012-07-05 07:19:00	AAPL	Stock	21.4993	21.5007	21.4957	21.5	24612.0
2012-07-05 07:20:00	AAPL	Stock	21.5175	21.5175	21.5175	21.5175	5600.0
2012-07-05 07:22:00	AAPL	Stock	21.5179	21.5318	21.5179	21.5318	15260.0
2012-07-05 07:23:00	AAPL	Stock	21.5314	21.5314	21.5314	21.5314	2800.0
2012-07-05 07:25:00	AAPL	Stock	21.5161	21.535	21.5161	21.535	8400.0
2012-07-05 07:26:00	AAPL	Stock	21.535	21.535	21.535	21.535	2800.0
2012-07-05 07:27:00	AAPL	Stock	21.5218	21.5218	21.5218	21.5218	2800.0
2012-07-05 07:28:00	AAPL	Stock	21.5286	21.5286	21.5179	21.5179	14000.0
2012-07-05 07:29:00	AAPL	Stock	21.5129	21.5129	21.5107	21.5111	19600.0
2012-07-05 07:30:00	AAPL	Stock	21.5107	21.5107	21.5025	21.5025	8400.0
2012-07-05 07:31:00	AAPL	Stock	21.5096	21.5096	21.5096	21.5096	2800.0
2012-07-05 07:32:00	AAPL	Stock	21.51	21.51	21.4839	21.4839	89880.0
2012-07-05 07:34:00	AAPL	Stock	21.4929	21.5	21.4929	21.5	8400.0
2012-07-05 07:35:00	AAPL	Stock	21.4964	21.4964	21.4964	21.4964	5600.0
2012-07-05 07:36:00	AAPL	Stock	21.4843	21.4843	21.4821	21.4821	16800.0
2012-07-05 07:37:00	AAPL	Stock	21.4979	21.4979	21.4979	21.4979	2800.0
2012-07-05 07:39:00	AAPL	Stock	21.5	21.5	21.5	21.5	5600.0
2012-07-05 07:43:00	AAPL	Stock	21.4993	21.5143	21.4993	21.5143	28140.0
2012-07-05 07:44:00	AAPL	Stock	21.5107	21.5164	21.5107	21.5161	25200.0
2012-07-05 07:45:00	AAPL	Stock	21.5186	21.5186	21.4893	21.4893	47600.0
2012-07-05 07:46:00	AAPL	Stock	21.5064	21.5179	21.4996	21.5107	49700.0
2012-07-05 07:47:00	AAPL	Stock	21.51	21.51	21.49	21.4964	26684.0
2012-07-05 07:50:00	AAPL	Stock	21.5039	21.5154	21.5039	21.5143	35896.0
2012-07-05 07:51:00	AAPL	Stock	21.5161	21.525	21.5157	21.5214	104468.0
2012-07-05 07:52:00	AAPL	Stock	21.5114	21.5143	21.5107	21.5143	15400.0
2012-07-05 07:53:00	AAPL	Stock	21.5221	21.5221	21.5221	21.5221	2800.0
2012-07-05 07:54:00	AAPL	Stock	21.5104	21.5104	21.5	21.5	15400.0

> showing 50 of 929,002 rows — these rows as CSV

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