PREVIEW / stock_1hour / 2015-01-21

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-01-21.parquet
  size:    1.0 MB
  rows:    48,594
  symbols: 3,520

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
2015-01-21 04:00:00	AAPL	Stock	27.2975	27.2975	27.2525	27.2525	18336.0
2015-01-21 05:00:00	AAPL	Stock	27.255	27.255	27.23	27.2325	7752.0
2015-01-21 06:00:00	AAPL	Stock	27.25	27.2925	27.2325	27.2475	33436.0
2015-01-21 07:00:00	AAPL	Stock	27.2475	27.25	27.155	27.1825	187020.0
2015-01-21 08:00:00	AAPL	Stock	27.195	27.3375	27.1575	27.315	768328.0
2015-01-21 09:00:00	AAPL	Stock	27.3075	27.41	27.0675	27.26	29060580.0
2015-01-21 10:00:00	AAPL	Stock	27.2588	27.7388	27.2312	27.7075	42013296.0
2015-01-21 11:00:00	AAPL	Stock	27.71	27.765	27.58	27.64	23607396.0
2015-01-21 12:00:00	AAPL	Stock	27.64	27.675	27.4075	27.4975	16738784.0
2015-01-21 13:00:00	AAPL	Stock	27.4925	27.5425	27.3512	27.3525	16120824.0
2015-01-21 14:00:00	AAPL	Stock	27.353	27.55	27.3025	27.5275	18337800.0
2015-01-21 15:00:00	AAPL	Stock	27.5275	27.5288	27.355	27.3875	25883812.0
2015-01-21 16:00:00	AAPL	Stock	27.3825	27.5998	27.212	27.3825	7795788.0
2015-01-21 17:00:00	AAPL	Stock	27.38	27.4	27.3725	27.3875	139180.0
2015-01-21 18:00:00	AAPL	Stock	27.3825	27.3875	27.3475	27.3625	229012.0
2015-01-21 19:00:00	AAPL	Stock	27.3625	27.3625	27.315	27.3475	109872.0
2015-01-21 06:00:00	MSFT	Stock	46.43	46.43	46.29	46.29	3300.0
2015-01-21 07:00:00	MSFT	Stock	46.29	46.29	46.12	46.2	1200.0
2015-01-21 08:00:00	MSFT	Stock	46.2	46.2	46.1	46.15	4294.0
2015-01-21 09:00:00	MSFT	Stock	46.1	46.17	45.52	45.71	5478911.0
2015-01-21 10:00:00	MSFT	Stock	45.71	45.94	45.48	45.94	6806985.0
2015-01-21 11:00:00	MSFT	Stock	45.935	46.06	45.83	45.96	5263111.0
2015-01-21 12:00:00	MSFT	Stock	45.966	46.04	45.82	45.895	3418158.0
2015-01-21 13:00:00	MSFT	Stock	45.895	45.96	45.625	45.66	2965125.0
2015-01-21 14:00:00	MSFT	Stock	45.67	45.82	45.59	45.79	2810693.0
2015-01-21 15:00:00	MSFT	Stock	45.8	45.99	45.67	45.91	5766184.0
2015-01-21 16:00:00	MSFT	Stock	45.92	45.983	45.821	45.835	2486211.0
2015-01-21 17:00:00	MSFT	Stock	45.93	45.95	45.93	45.95	400.0
2015-01-21 18:00:00	MSFT	Stock	45.98	45.98	45.98	45.98	100.0
2015-01-21 19:00:00	MSFT	Stock	45.98	45.98	45.92	45.93	1966603.0
2015-01-21 08:00:00	NVDA	Stock	0.5	0.5	0.5	0.5	4000.0
2015-01-21 09:00:00	NVDA	Stock	0.4972	0.5022	0.4942	0.5	15892640.0
2015-01-21 10:00:00	NVDA	Stock	0.5	0.5062	0.499	0.5056	21556320.0
2015-01-21 11:00:00	NVDA	Stock	0.5058	0.5065	0.5048	0.5061	17108000.0
2015-01-21 12:00:00	NVDA	Stock	0.506	0.5085	0.5058	0.5068	14911440.0
2015-01-21 13:00:00	NVDA	Stock	0.5068	0.5075	0.5041	0.5045	13830920.0
2015-01-21 14:00:00	NVDA	Stock	0.5045	0.5085	0.504	0.5085	14967160.0
2015-01-21 15:00:00	NVDA	Stock	0.5085	0.5088	0.5065	0.5075	32638040.0
2015-01-21 16:00:00	NVDA	Stock	0.5075	0.5076	0.5054	0.5075	8688080.0
2015-01-21 04:00:00	AMZN	Stock	14.4965	14.4965	14.4965	14.4965	2000.0
2015-01-21 07:00:00	AMZN	Stock	14.475	14.475	14.475	14.475	2000.0
2015-01-21 08:00:00	AMZN	Stock	14.477	14.5435	14.477	14.535	48300.0
2015-01-21 09:00:00	AMZN	Stock	14.53	14.5895	14.363	14.564	12347920.0
2015-01-21 10:00:00	AMZN	Stock	14.5655	15.2145	14.5225	15.1145	49530460.0
2015-01-21 11:00:00	AMZN	Stock	15.1155	15.3	14.778	14.8595	81969720.0
2015-01-21 12:00:00	AMZN	Stock	14.857	14.95	14.781	14.8345	10305960.0
2015-01-21 13:00:00	AMZN	Stock	14.8345	14.9294	14.8025	14.826	9058540.0
2015-01-21 14:00:00	AMZN	Stock	14.8262	14.8873	14.8025	14.852	8903220.0
2015-01-21 15:00:00	AMZN	Stock	14.857	14.9375	14.8385	14.863	16103000.0
2015-01-21 16:00:00	AMZN	Stock	14.863	14.9375	14.7805	14.9375	3459380.0

> showing 50 of 48,594 rows — these rows as CSV

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