PREVIEW / stock_1hour / 2017-10-11

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-10-11.parquet
  size:    1.1 MB
  rows:    48,260
  symbols: 2,954

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-10-11 04:00:00	AAPL	Stock	38.945	38.945	38.9	38.925	7488.0
2017-10-11 05:00:00	AAPL	Stock	38.925	38.945	38.925	38.945	2800.0
2017-10-11 06:00:00	AAPL	Stock	38.955	38.955	38.9	38.9	43000.0
2017-10-11 07:00:00	AAPL	Stock	38.9375	38.97	38.9125	38.9125	64348.0
2017-10-11 08:00:00	AAPL	Stock	38.95	39.055	38.9125	38.9725	126744.0
2017-10-11 09:00:00	AAPL	Stock	38.9725	39.08	38.9375	39.055	8356832.0
2017-10-11 10:00:00	AAPL	Stock	39.0575	39.245	39.05	39.1862	14387216.0
2017-10-11 11:00:00	AAPL	Stock	39.1868	39.2175	39.13	39.1675	6457568.0
2017-10-11 12:00:00	AAPL	Stock	39.1675	39.21	39.145	39.1725	4980888.0
2017-10-11 13:00:00	AAPL	Stock	39.17	39.2032	39.11	39.11	4636320.0
2017-10-11 14:00:00	AAPL	Stock	39.1125	39.1875	39.095	39.1275	4974700.0
2017-10-11 15:00:00	AAPL	Stock	39.13	39.17	39.105	39.135	9012336.0
2017-10-11 16:00:00	AAPL	Stock	39.1375	39.145	39.1075	39.145	7994968.0
2017-10-11 17:00:00	AAPL	Stock	39.1375	39.18	39.1	39.125	224324.0
2017-10-11 18:00:00	AAPL	Stock	39.1125	39.15	39.1075	39.1375	16224.0
2017-10-11 19:00:00	AAPL	Stock	39.1375	39.1375	39.1	39.1075	19296.0
2017-10-11 06:00:00	MSFT	Stock	76.38	76.38	76.38	76.38	100.0
2017-10-11 07:00:00	MSFT	Stock	76.32	76.33	76.21	76.21	10117.0
2017-10-11 08:00:00	MSFT	Stock	76.23	76.23	76.23	76.23	1620.0
2017-10-11 09:00:00	MSFT	Stock	76.2	76.42	75.96	75.99	1408274.0
2017-10-11 10:00:00	MSFT	Stock	75.99	76.25	75.95	76.08	1779297.0
2017-10-11 11:00:00	MSFT	Stock	76.08	76.21	76.01	76.16	1156597.0
2017-10-11 12:00:00	MSFT	Stock	76.155	76.29	76.15	76.16	1138981.0
2017-10-11 13:00:00	MSFT	Stock	76.165	76.26	76.09	76.195	1134457.0
2017-10-11 14:00:00	MSFT	Stock	76.195	76.32	76.19	76.22	1122847.0
2017-10-11 15:00:00	MSFT	Stock	76.21	76.46	76.2	76.41	2415606.0
2017-10-11 16:00:00	MSFT	Stock	76.41	76.45	76.16	76.44	3802131.0
2017-10-11 17:00:00	MSFT	Stock	76.42	76.45	76.42	76.45	6796.0
2017-10-11 18:00:00	MSFT	Stock	76.38	76.44	76.38	76.4	775.0
2017-10-11 19:00:00	MSFT	Stock	76.4	76.4	76.4	76.4	100.0
2017-10-11 04:00:00	NVDA	Stock	4.7415	4.75	4.7373	4.75	108480.0
2017-10-11 05:00:00	NVDA	Stock	4.75	4.75	4.7448	4.7448	32320.0
2017-10-11 06:00:00	NVDA	Stock	4.7405	4.7448	4.739	4.7398	62640.0
2017-10-11 07:00:00	NVDA	Stock	4.7368	4.7375	4.7088	4.7125	851040.0
2017-10-11 08:00:00	NVDA	Stock	4.7398	4.74	4.7062	4.7345	2862360.0
2017-10-11 09:00:00	NVDA	Stock	4.7345	4.7525	4.6935	4.715	89431920.0
2017-10-11 10:00:00	NVDA	Stock	4.7148	4.775	4.708	4.7665	145327840.0
2017-10-11 11:00:00	NVDA	Stock	4.7662	4.77	4.7432	4.7586	81074840.0
2017-10-11 12:00:00	NVDA	Stock	4.7595	4.7732	4.7528	4.771	54402880.0
2017-10-11 13:00:00	NVDA	Stock	4.7718	4.7735	4.76	4.7655	30453760.0
2017-10-11 14:00:00	NVDA	Stock	4.766	4.7722	4.7555	4.758	39246480.0
2017-10-11 15:00:00	NVDA	Stock	4.7588	4.7745	4.7585	4.7732	66392720.0
2017-10-11 16:00:00	NVDA	Stock	4.775	4.775	4.765	4.7725	5932800.0
2017-10-11 17:00:00	NVDA	Stock	4.7722	4.775	4.771	4.7735	541360.0
2017-10-11 18:00:00	NVDA	Stock	4.7735	4.7812	4.7735	4.7803	304560.0
2017-10-11 19:00:00	NVDA	Stock	4.7805	4.787	4.78	4.7838	658880.0
2017-10-11 04:00:00	AMZN	Stock	49.455	49.455	49.455	49.455	2000.0
2017-10-11 05:00:00	AMZN	Stock	49.4	49.4	49.4	49.4	3480.0
2017-10-11 06:00:00	AMZN	Stock	49.45	49.4515	49.45	49.4515	9680.0
2017-10-11 07:00:00	AMZN	Stock	49.45	49.5	49.4	49.415	66460.0

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

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