PREVIEW / stock_1hour / 2016-11-30

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-11-30.parquet
  size:    1.1 MB
  rows:    49,455
  symbols: 3,189

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-11-30 06:00:00	AAPL	Stock	27.865	27.865	27.865	27.865	800.0
2016-11-30 07:00:00	AAPL	Stock	27.875	27.935	27.875	27.875	5568.0
2016-11-30 08:00:00	AAPL	Stock	27.935	27.9525	27.8475	27.9375	120176.0
2016-11-30 09:00:00	AAPL	Stock	27.9425	28.05	27.88	27.9175	12435272.0
2016-11-30 10:00:00	AAPL	Stock	27.915	27.9175	27.635	27.7135	21739020.0
2016-11-30 11:00:00	AAPL	Stock	27.7138	27.77	27.6425	27.6725	13464340.0
2016-11-30 12:00:00	AAPL	Stock	27.6725	27.79	27.65	27.79	9481924.0
2016-11-30 13:00:00	AAPL	Stock	27.7892	27.8012	27.7425	27.7475	6040936.0
2016-11-30 14:00:00	AAPL	Stock	27.75	27.75	27.5675	27.615	14927388.0
2016-11-30 15:00:00	AAPL	Stock	27.615	27.7175	27.605	27.63	22731236.0
2016-11-30 16:00:00	AAPL	Stock	27.63	27.66	27.625	27.6425	30851248.0
2016-11-30 17:00:00	AAPL	Stock	27.645	27.6625	27.6375	27.66	45688.0
2016-11-30 18:00:00	AAPL	Stock	27.65	27.66	27.6375	27.66	10104.0
2016-11-30 19:00:00	AAPL	Stock	27.66	27.6625	27.6475	27.6625	9752.0
2016-11-30 06:00:00	MSFT	Stock	61.25	61.25	61.25	61.25	106.0
2016-11-30 08:00:00	MSFT	Stock	61.32	61.32	61.2	61.2	3115.0
2016-11-30 09:00:00	MSFT	Stock	61.17	61.2	60.73	60.765	2571079.0
2016-11-30 10:00:00	MSFT	Stock	60.77	61.01	60.64	60.755	3430540.0
2016-11-30 11:00:00	MSFT	Stock	60.75	60.82	60.34	60.385	2851095.0
2016-11-30 12:00:00	MSFT	Stock	60.39	60.59	60.215	60.561	2567387.0
2016-11-30 13:00:00	MSFT	Stock	60.56	60.625	60.48	60.57	1320023.0
2016-11-30 14:00:00	MSFT	Stock	60.565	60.57	60.27	60.35	2491206.0
2016-11-30 15:00:00	MSFT	Stock	60.35	60.52	60.26	60.26	6922154.0
2016-11-30 16:00:00	MSFT	Stock	60.27	60.33	60.24	60.33	10235312.0
2016-11-30 17:00:00	MSFT	Stock	60.29	60.29	60.29	60.29	100.0
2016-11-30 18:00:00	MSFT	Stock	60.29	60.32	60.26	60.26	6218.0
2016-11-30 19:00:00	MSFT	Stock	60.32	60.32	60.32	60.32	100.0
2016-11-30 05:00:00	NVDA	Stock	2.34	2.34	2.34	2.34	4800.0
2016-11-30 06:00:00	NVDA	Stock	2.3425	2.3425	2.3425	2.3425	6000.0
2016-11-30 08:00:00	NVDA	Stock	2.36	2.36	2.3475	2.3475	68800.0
2016-11-30 09:00:00	NVDA	Stock	2.3468	2.3512	2.3138	2.3442	41504320.0
2016-11-30 10:00:00	NVDA	Stock	2.3442	2.354	2.336	2.3428	49602840.0
2016-11-30 11:00:00	NVDA	Stock	2.343	2.3509	2.3345	2.3358	31945800.0
2016-11-30 12:00:00	NVDA	Stock	2.3352	2.3433	2.3315	2.3412	21517080.0
2016-11-30 13:00:00	NVDA	Stock	2.3412	2.3435	2.338	2.341	14549240.0
2016-11-30 14:00:00	NVDA	Stock	2.3409	2.3458	2.3318	2.3385	31165640.0
2016-11-30 15:00:00	NVDA	Stock	2.3382	2.3535	2.3025	2.3052	127697000.0
2016-11-30 16:00:00	NVDA	Stock	2.3098	2.3248	2.3049	2.3135	102266400.0
2016-11-30 17:00:00	NVDA	Stock	2.315	2.3195	2.305	2.3185	523000.0
2016-11-30 18:00:00	NVDA	Stock	2.3162	2.3172	2.3162	2.3172	98800.0
2016-11-30 19:00:00	NVDA	Stock	2.3172	2.3183	2.3128	2.3128	142080.0
2016-11-30 05:00:00	AMZN	Stock	38.101	38.101	38.101	38.101	4720.0
2016-11-30 07:00:00	AMZN	Stock	38.225	38.25	38.225	38.25	38880.0
2016-11-30 08:00:00	AMZN	Stock	38.27	38.3325	38.2255	38.3325	883380.0
2016-11-30 09:00:00	AMZN	Stock	38.32	38.4045	38.1	38.2405	10378680.0
2016-11-30 10:00:00	AMZN	Stock	38.2493	38.2585	37.7935	37.8156	14601540.0
2016-11-30 11:00:00	AMZN	Stock	37.8125	37.966	37.651	37.662	8917900.0
2016-11-30 12:00:00	AMZN	Stock	37.6535	37.696	37.533	37.6265	9997240.0
2016-11-30 13:00:00	AMZN	Stock	37.631	37.7445	37.6245	37.7158	4003120.0
2016-11-30 14:00:00	AMZN	Stock	37.7225	37.7305	37.5125	37.622	10120500.0

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

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