PREVIEW / stock_1hour / 2017-03-20

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-03-20.parquet
  size:    1.0 MB
  rows:    48,172
  symbols: 3,071

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-03-20 04:00:00	AAPL	Stock	35.035	35.035	35.0	35.02	7816.0
2017-03-20 05:00:00	AAPL	Stock	35.0025	35.015	35.0025	35.015	2072.0
2017-03-20 06:00:00	AAPL	Stock	35.07	35.0725	35.0325	35.045	18128.0
2017-03-20 07:00:00	AAPL	Stock	35.045	35.0625	35.045	35.0625	18576.0
2017-03-20 08:00:00	AAPL	Stock	35.0625	35.1225	35.0325	35.075	384696.0
2017-03-20 09:00:00	AAPL	Stock	35.0825	35.19	35.0575	35.184	11697120.0
2017-03-20 10:00:00	AAPL	Stock	35.1825	35.335	35.1725	35.2702	14449904.0
2017-03-20 11:00:00	AAPL	Stock	35.2725	35.335	35.2612	35.27	7383040.0
2017-03-20 12:00:00	AAPL	Stock	35.2712	35.3125	35.26	35.2772	5580472.0
2017-03-20 13:00:00	AAPL	Stock	35.2772	35.31	35.2275	35.25	5539576.0
2017-03-20 14:00:00	AAPL	Stock	35.2525	35.29	35.215	35.225	6180060.0
2017-03-20 15:00:00	AAPL	Stock	35.2275	35.375	35.2125	35.3725	15129156.0
2017-03-20 16:00:00	AAPL	Stock	35.3698	35.38	35.35	35.3675	7609884.0
2017-03-20 17:00:00	AAPL	Stock	35.3625	35.39	35.3625	35.3825	2214040.0
2017-03-20 18:00:00	AAPL	Stock	35.3825	35.385	35.37	35.385	26316.0
2017-03-20 19:00:00	AAPL	Stock	35.385	35.3875	35.37	35.3875	26576.0
2017-03-20 06:00:00	MSFT	Stock	65.01	65.01	65.01	65.01	657.0
2017-03-20 08:00:00	MSFT	Stock	65.0	65.08	65.0	65.08	744.0
2017-03-20 09:00:00	MSFT	Stock	65.07	65.175	64.85	65.01	1441007.0
2017-03-20 10:00:00	MSFT	Stock	65.01	65.145	64.945	65.02	1571956.0
2017-03-20 11:00:00	MSFT	Stock	65.02	65.04	64.86	64.918	1237703.0
2017-03-20 12:00:00	MSFT	Stock	64.915	64.93	64.81	64.905	929399.0
2017-03-20 13:00:00	MSFT	Stock	64.91	64.93	64.72	64.82	1292313.0
2017-03-20 14:00:00	MSFT	Stock	64.815	64.88	64.735	64.82	1271516.0
2017-03-20 15:00:00	MSFT	Stock	64.82	64.97	64.81	64.93	2281628.0
2017-03-20 16:00:00	MSFT	Stock	64.905	64.93	64.9	64.9	2401532.0
2017-03-20 17:00:00	MSFT	Stock	64.93	64.93	64.91	64.91	840212.0
2017-03-20 18:00:00	MSFT	Stock	64.93	64.93	64.93	64.93	298.0
2017-03-20 19:00:00	MSFT	Stock	64.91	64.91	64.91	64.91	1323.0
2017-03-20 04:00:00	NVDA	Stock	2.6663	2.6663	2.6663	2.6663	10240.0
2017-03-20 05:00:00	NVDA	Stock	2.6725	2.6725	2.6725	2.6725	4000.0
2017-03-20 06:00:00	NVDA	Stock	2.6722	2.6725	2.6675	2.672	59720.0
2017-03-20 07:00:00	NVDA	Stock	2.6722	2.6792	2.6632	2.6762	501720.0
2017-03-20 08:00:00	NVDA	Stock	2.6712	2.678	2.6678	2.6748	1835400.0
2017-03-20 09:00:00	NVDA	Stock	2.6725	2.6845	2.6532	2.6795	113694720.0
2017-03-20 10:00:00	NVDA	Stock	2.6798	2.7248	2.678	2.7204	171085080.0
2017-03-20 11:00:00	NVDA	Stock	2.7202	2.733	2.705	2.7315	108317600.0
2017-03-20 12:00:00	NVDA	Stock	2.7318	2.7402	2.7198	2.7368	91013640.0
2017-03-20 13:00:00	NVDA	Stock	2.737	2.737	2.7142	2.7199	70715320.0
2017-03-20 14:00:00	NVDA	Stock	2.7198	2.731	2.7175	2.7245	55878840.0
2017-03-20 15:00:00	NVDA	Stock	2.7248	2.7383	2.7205	2.7362	109316520.0
2017-03-20 16:00:00	NVDA	Stock	2.7361	2.7395	2.7361	2.7395	14485680.0
2017-03-20 17:00:00	NVDA	Stock	2.739	2.739	2.7365	2.7388	300400.0
2017-03-20 18:00:00	NVDA	Stock	2.7365	2.7388	2.7365	2.7388	144800.0
2017-03-20 19:00:00	NVDA	Stock	2.7383	2.7408	2.7378	2.74	428920.0
2017-03-20 06:00:00	AMZN	Stock	42.648	42.648	42.648	42.648	2000.0
2017-03-20 08:00:00	AMZN	Stock	42.5675	42.6275	42.5675	42.6275	31520.0
2017-03-20 09:00:00	AMZN	Stock	42.6275	42.8495	42.5505	42.849	7860020.0
2017-03-20 10:00:00	AMZN	Stock	42.849	42.89	42.76	42.78	10203580.0
2017-03-20 11:00:00	AMZN	Stock	42.7795	42.8465	42.7275	42.773	4293700.0

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

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