PREVIEW / stock_1hour / 2016-12-19

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-12-19.parquet
  size:    1.1 MB
  rows:    48,822
  symbols: 3,165

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-19 04:00:00	AAPL	Stock	28.955	28.955	28.955	28.955	664.0
2016-12-19 05:00:00	AAPL	Stock	28.9275	28.95	28.9275	28.95	4112.0
2016-12-19 06:00:00	AAPL	Stock	28.925	28.925	28.9	28.925	8924.0
2016-12-19 07:00:00	AAPL	Stock	28.9275	29.0	28.9125	28.98	37228.0
2016-12-19 08:00:00	AAPL	Stock	28.9475	28.9975	28.9175	28.9725	143988.0
2016-12-19 09:00:00	AAPL	Stock	28.9725	29.205	28.9375	29.1525	15553044.0
2016-12-19 10:00:00	AAPL	Stock	29.1525	29.305	29.1425	29.2872	17696012.0
2016-12-19 11:00:00	AAPL	Stock	29.285	29.345	29.2025	29.2075	13426804.0
2016-12-19 12:00:00	AAPL	Stock	29.2062	29.3	29.205	29.265	7775556.0
2016-12-19 13:00:00	AAPL	Stock	29.2668	29.285	29.1875	29.2375	6782252.0
2016-12-19 14:00:00	AAPL	Stock	29.2375	29.25	29.1625	29.1725	5484268.0
2016-12-19 15:00:00	AAPL	Stock	29.1725	29.19	29.095	29.1575	12995940.0
2016-12-19 16:00:00	AAPL	Stock	29.16	29.19	29.1125	29.15	10936300.0
2016-12-19 17:00:00	AAPL	Stock	29.15	29.1625	29.1425	29.1425	52096.0
2016-12-19 18:00:00	AAPL	Stock	29.16	29.1625	29.15	29.16	9016.0
2016-12-19 19:00:00	AAPL	Stock	29.15	29.17	29.15	29.16	58084.0
2016-12-19 07:00:00	MSFT	Stock	62.5	62.5	62.5	62.5	400.0
2016-12-19 08:00:00	MSFT	Stock	62.47	62.5	62.3	62.3	10019.0
2016-12-19 09:00:00	MSFT	Stock	62.5	63.04	62.42	63.01	3320030.0
2016-12-19 10:00:00	MSFT	Stock	63.01	63.52	62.91	63.505	4691629.0
2016-12-19 11:00:00	MSFT	Stock	63.5	63.72	63.5	63.524	4515119.0
2016-12-19 12:00:00	MSFT	Stock	63.52	63.65	63.5	63.59	2380161.0
2016-12-19 13:00:00	MSFT	Stock	63.59	63.72	63.545	63.7	2043955.0
2016-12-19 14:00:00	MSFT	Stock	63.71	63.77	63.67	63.695	2328107.0
2016-12-19 15:00:00	MSFT	Stock	63.69	63.71	63.405	63.62	5400319.0
2016-12-19 16:00:00	MSFT	Stock	63.62	63.72	62.75	63.72	7110212.0
2016-12-19 17:00:00	MSFT	Stock	63.62	63.75	63.62	63.65	834534.0
2016-12-19 18:00:00	MSFT	Stock	63.63	63.73	63.61	63.65	6325.0
2016-12-19 19:00:00	MSFT	Stock	63.74	63.74	63.73	63.74	810.0
2016-12-19 04:00:00	NVDA	Stock	2.5003	2.5038	2.5003	2.5013	36000.0
2016-12-19 05:00:00	NVDA	Stock	2.5	2.5	2.485	2.485	107600.0
2016-12-19 06:00:00	NVDA	Stock	2.485	2.485	2.485	2.485	4920.0
2016-12-19 07:00:00	NVDA	Stock	2.4888	2.4942	2.4838	2.4838	532080.0
2016-12-19 08:00:00	NVDA	Stock	2.4862	2.5102	2.482	2.502	2037000.0
2016-12-19 09:00:00	NVDA	Stock	2.502	2.5163	2.475	2.5116	118928280.0
2016-12-19 10:00:00	NVDA	Stock	2.5118	2.5318	2.5038	2.5273	148248360.0
2016-12-19 11:00:00	NVDA	Stock	2.5278	2.5458	2.5198	2.54	98719640.0
2016-12-19 12:00:00	NVDA	Stock	2.5392	2.5548	2.5338	2.5452	85184840.0
2016-12-19 13:00:00	NVDA	Stock	2.5452	2.5608	2.538	2.5568	81141160.0
2016-12-19 14:00:00	NVDA	Stock	2.557	2.5613	2.546	2.5479	71831200.0
2016-12-19 15:00:00	NVDA	Stock	2.5475	2.551	2.5328	2.5413	91170520.0
2016-12-19 16:00:00	NVDA	Stock	2.5413	2.545	2.5403	2.545	28412400.0
2016-12-19 17:00:00	NVDA	Stock	2.5458	2.5468	2.5415	2.546	257240.0
2016-12-19 18:00:00	NVDA	Stock	2.546	2.546	2.544	2.5458	183720.0
2016-12-19 19:00:00	NVDA	Stock	2.5462	2.5528	2.5462	2.5523	141440.0
2016-12-19 07:00:00	AMZN	Stock	38.0	38.05	38.0	38.05	32220.0
2016-12-19 08:00:00	AMZN	Stock	38.0275	38.0375	37.8885	37.8885	123780.0
2016-12-19 09:00:00	AMZN	Stock	37.982	38.2457	37.808	38.181	9328580.0
2016-12-19 10:00:00	AMZN	Stock	38.1965	38.4908	38.179	38.3898	13477140.0
2016-12-19 11:00:00	AMZN	Stock	38.3865	38.525	38.335	38.3635	7840040.0

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

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