PREVIEW / stock_1hour / 2017-11-17

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-11-17.parquet
  size:    1.1 MB
  rows:    49,479
  symbols: 2,946

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
2017-11-17 04:00:00	AAPL	Stock	42.8225	42.8275	42.81	42.8275	2400.0
2017-11-17 06:00:00	AAPL	Stock	42.8375	42.8425	42.825	42.825	10904.0
2017-11-17 07:00:00	AAPL	Stock	42.825	42.825	42.795	42.8025	132068.0
2017-11-17 08:00:00	AAPL	Stock	42.8125	42.825	42.715	42.7725	244572.0
2017-11-17 09:00:00	AAPL	Stock	42.74	42.7625	42.4575	42.5225	16406460.0
2017-11-17 10:00:00	AAPL	Stock	42.5212	42.8475	42.4575	42.7205	15071744.0
2017-11-17 11:00:00	AAPL	Stock	42.72	42.73	42.565	42.685	8138520.0
2017-11-17 12:00:00	AAPL	Stock	42.6818	42.685	42.59	42.6465	4806180.0
2017-11-17 13:00:00	AAPL	Stock	42.648	42.65	42.555	42.5948	4243572.0
2017-11-17 14:00:00	AAPL	Stock	42.595	42.6072	42.505	42.55	5234440.0
2017-11-17 15:00:00	AAPL	Stock	42.55	42.5675	42.41	42.5275	14747100.0
2017-11-17 16:00:00	AAPL	Stock	42.5375	42.5375	42.475	42.4925	6388188.0
2017-11-17 17:00:00	AAPL	Stock	42.5025	42.5025	42.49	42.5	80300.0
2017-11-17 18:00:00	AAPL	Stock	42.5	42.5	42.49	42.49	22600.0
2017-11-17 19:00:00	AAPL	Stock	42.4925	42.4975	42.48	42.485	21528.0
2017-11-17 07:00:00	MSFT	Stock	83.19	83.27	83.15	83.18	7591.0
2017-11-17 08:00:00	MSFT	Stock	83.17	83.2	82.98	83.02	13627.0
2017-11-17 09:00:00	MSFT	Stock	83.12	83.2	82.48	82.61	3563213.0
2017-11-17 10:00:00	MSFT	Stock	82.605	82.87	82.37	82.42	2852790.0
2017-11-17 11:00:00	MSFT	Stock	82.42	82.55	82.24	82.502	2502414.0
2017-11-17 12:00:00	MSFT	Stock	82.505	82.52	82.39	82.43	1327942.0
2017-11-17 13:00:00	MSFT	Stock	82.43	82.45	82.32	82.45	1561545.0
2017-11-17 14:00:00	MSFT	Stock	82.45	82.47	82.36	82.43	1792927.0
2017-11-17 15:00:00	MSFT	Stock	82.43	82.55	82.34	82.37	3857205.0
2017-11-17 16:00:00	MSFT	Stock	82.4	82.44	82.32	82.34	2183784.0
2017-11-17 17:00:00	MSFT	Stock	82.33	82.38	82.33	82.37	554.0
2017-11-17 18:00:00	MSFT	Stock	82.33	82.33	82.28	82.28	2593.0
2017-11-17 19:00:00	MSFT	Stock	82.32	82.37	82.32	82.37	500.0
2017-11-17 04:00:00	NVDA	Stock	5.325	5.335	5.325	5.3322	24000.0
2017-11-17 05:00:00	NVDA	Stock	5.3225	5.3225	5.3175	5.3175	65840.0
2017-11-17 06:00:00	NVDA	Stock	5.3263	5.34	5.32	5.33	133080.0
2017-11-17 07:00:00	NVDA	Stock	5.3313	5.3562	5.3313	5.345	1614600.0
2017-11-17 08:00:00	NVDA	Stock	5.3475	5.3565	5.3025	5.3428	3887600.0
2017-11-17 09:00:00	NVDA	Stock	5.3438	5.3838	5.3162	5.3805	118636240.0
2017-11-17 10:00:00	NVDA	Stock	5.3815	5.382	5.3428	5.3568	85105760.0
2017-11-17 11:00:00	NVDA	Stock	5.356	5.3588	5.2975	5.3123	66486960.0
2017-11-17 12:00:00	NVDA	Stock	5.311	5.3212	5.2975	5.3011	35677600.0
2017-11-17 13:00:00	NVDA	Stock	5.301	5.302	5.2733	5.2838	52377040.0
2017-11-17 14:00:00	NVDA	Stock	5.2833	5.2982	5.2795	5.2965	27949520.0
2017-11-17 15:00:00	NVDA	Stock	5.2958	5.2965	5.2688	5.2828	56425960.0
2017-11-17 16:00:00	NVDA	Stock	5.284	5.3008	5.2812	5.2833	12107280.0
2017-11-17 17:00:00	NVDA	Stock	5.2815	5.2818	5.2675	5.2688	650440.0
2017-11-17 18:00:00	NVDA	Stock	5.2688	5.275	5.2648	5.275	279960.0
2017-11-17 19:00:00	NVDA	Stock	5.273	5.2773	5.2705	5.275	287320.0
2017-11-17 05:00:00	AMZN	Stock	56.8495	56.8495	56.8495	56.8495	2000.0
2017-11-17 06:00:00	AMZN	Stock	56.8475	56.8475	56.8475	56.8475	4140.0
2017-11-17 07:00:00	AMZN	Stock	56.905	56.9275	56.905	56.9275	14220.0
2017-11-17 08:00:00	AMZN	Stock	56.9235	56.9395	56.8925	56.8925	78700.0
2017-11-17 09:00:00	AMZN	Stock	56.891	56.922	56.6425	56.7415	7424080.0
2017-11-17 10:00:00	AMZN	Stock	56.746	56.9035	56.65	56.8895	4182220.0

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

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