PREVIEW / stock_1hour / 2016-12-08

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-12-08.parquet
  size:    1.1 MB
  rows:    49,618
  symbols: 3,175

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
2016-12-08 07:00:00	AAPL	Stock	27.7375	27.7375	27.6375	27.69	62620.0
2016-12-08 08:00:00	AAPL	Stock	27.7275	27.735	27.625	27.73	92972.0
2016-12-08 09:00:00	AAPL	Stock	27.7	28.0325	27.65	28.0038	18295816.0
2016-12-08 10:00:00	AAPL	Stock	28.005	28.0072	27.885	27.9825	14444232.0
2016-12-08 11:00:00	AAPL	Stock	27.9838	28.095	27.965	28.01	12896284.0
2016-12-08 12:00:00	AAPL	Stock	28.011	28.1075	27.99	28.07	10425520.0
2016-12-08 13:00:00	AAPL	Stock	28.0725	28.0875	28.015	28.0675	7171048.0
2016-12-08 14:00:00	AAPL	Stock	28.0675	28.08	27.9475	28.0	9207544.0
2016-12-08 15:00:00	AAPL	Stock	28.0025	28.05	27.9625	28.0275	14807624.0
2016-12-08 16:00:00	AAPL	Stock	28.03	28.0875	28.0075	28.055	9962528.0
2016-12-08 17:00:00	AAPL	Stock	28.03	28.0875	28.03	28.065	69648.0
2016-12-08 18:00:00	AAPL	Stock	28.075	28.075	28.0425	28.0425	7628.0
2016-12-08 19:00:00	AAPL	Stock	28.05	28.075	28.05	28.075	25168.0
2016-12-08 04:00:00	MSFT	Stock	61.23	61.23	61.23	61.23	1000.0
2016-12-08 06:00:00	MSFT	Stock	61.38	61.38	61.38	61.38	100.0
2016-12-08 07:00:00	MSFT	Stock	61.39	61.39	61.39	61.39	200.0
2016-12-08 08:00:00	MSFT	Stock	61.29	61.4	61.28	61.28	7423.0
2016-12-08 09:00:00	MSFT	Stock	61.3	61.58	61.017	61.39	3151047.0
2016-12-08 10:00:00	MSFT	Stock	61.395	61.54	61.29	61.32	2815639.0
2016-12-08 11:00:00	MSFT	Stock	61.315	61.335	61.04	61.18	2119958.0
2016-12-08 12:00:00	MSFT	Stock	61.175	61.37	61.151	61.27	1716619.0
2016-12-08 13:00:00	MSFT	Stock	61.27	61.32	61.15	61.19	1708086.0
2016-12-08 14:00:00	MSFT	Stock	61.19	61.2	60.88	60.98	2414958.0
2016-12-08 15:00:00	MSFT	Stock	60.99	61.06	60.84	61.0	3974353.0
2016-12-08 16:00:00	MSFT	Stock	61.0	61.17	60.97	61.0	2142192.0
2016-12-08 17:00:00	MSFT	Stock	61.09	61.09	61.09	61.09	116.0
2016-12-08 18:00:00	MSFT	Stock	61.09	61.17	61.07	61.07	8300.0
2016-12-08 19:00:00	MSFT	Stock	61.07	61.1	60.98	61.1	10548.0
2016-12-08 07:00:00	NVDA	Stock	2.3865	2.3875	2.3823	2.3823	215160.0
2016-12-08 08:00:00	NVDA	Stock	2.38	2.3862	2.3795	2.3862	228600.0
2016-12-08 09:00:00	NVDA	Stock	2.3875	2.4155	2.355	2.3725	81710400.0
2016-12-08 10:00:00	NVDA	Stock	2.3725	2.3802	2.3558	2.3735	59650080.0
2016-12-08 11:00:00	NVDA	Stock	2.3738	2.3755	2.3412	2.3528	59618520.0
2016-12-08 12:00:00	NVDA	Stock	2.3528	2.3651	2.345	2.3602	27211320.0
2016-12-08 13:00:00	NVDA	Stock	2.3604	2.3625	2.3452	2.3534	27823840.0
2016-12-08 14:00:00	NVDA	Stock	2.3532	2.3578	2.3263	2.3324	42040120.0
2016-12-08 15:00:00	NVDA	Stock	2.333	2.3425	2.3315	2.3368	51121880.0
2016-12-08 16:00:00	NVDA	Stock	2.337	2.3475	2.3288	2.3448	9725640.0
2016-12-08 17:00:00	NVDA	Stock	2.3425	2.3425	2.3425	2.3425	8000.0
2016-12-08 18:00:00	NVDA	Stock	2.3422	2.345	2.3382	2.3385	85480.0
2016-12-08 19:00:00	NVDA	Stock	2.3422	2.3425	2.3315	2.3425	92400.0
2016-12-08 05:00:00	AMZN	Stock	38.4845	38.4845	38.4845	38.4845	2000.0
2016-12-08 07:00:00	AMZN	Stock	38.4535	38.5	38.45	38.5	24000.0
2016-12-08 08:00:00	AMZN	Stock	38.545	38.6	38.451	38.55	240560.0
2016-12-08 09:00:00	AMZN	Stock	38.5625	38.6895	38.3706	38.4632	12288500.0
2016-12-08 10:00:00	AMZN	Stock	38.4445	38.609	38.3785	38.521	8399520.0
2016-12-08 11:00:00	AMZN	Stock	38.5104	38.5315	38.3555	38.4096	6840300.0
2016-12-08 12:00:00	AMZN	Stock	38.4195	38.49	38.36	38.3673	6143920.0
2016-12-08 13:00:00	AMZN	Stock	38.3725	38.3835	38.2595	38.3193	6776320.0
2016-12-08 14:00:00	AMZN	Stock	38.314	38.376	38.277	38.3118	6514240.0

> showing 50 of 49,618 rows — these rows as CSV

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