PREVIEW / stock_1hour / 2019-08-09

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-08-09.parquet
  size:    1.1 MB
  rows:    49,044
  symbols: 2,544

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
2019-08-09 04:00:00	AAPL	Stock	50.375	50.375	50.25	50.2975	20240.0
2019-08-09 05:00:00	AAPL	Stock	50.2975	50.375	50.2	50.2125	17160.0
2019-08-09 06:00:00	AAPL	Stock	50.2275	50.275	50.1825	50.1875	11216.0
2019-08-09 07:00:00	AAPL	Stock	50.25	50.35	50.0625	50.13	234520.0
2019-08-09 08:00:00	AAPL	Stock	50.255	50.3625	50.065	50.31	312224.0
2019-08-09 09:00:00	AAPL	Stock	50.3075	50.625	50.15	50.395	10681520.0
2019-08-09 10:00:00	AAPL	Stock	50.39	50.46	49.915	50.1325	13980980.0
2019-08-09 11:00:00	AAPL	Stock	50.125	50.1558	49.8225	49.9372	10593864.0
2019-08-09 12:00:00	AAPL	Stock	49.9325	50.48	49.9175	50.31	9196936.0
2019-08-09 13:00:00	AAPL	Stock	50.3075	50.605	50.268	50.45	8746436.0
2019-08-09 14:00:00	AAPL	Stock	50.45	50.6125	50.4	50.505	6035580.0
2019-08-09 15:00:00	AAPL	Stock	50.508	50.69	50.21	50.2325	15428140.0
2019-08-09 16:00:00	AAPL	Stock	50.2475	50.375	50.225	50.315	8802112.0
2019-08-09 17:00:00	AAPL	Stock	50.325	50.37	50.2475	50.305	26572.0
2019-08-09 18:00:00	AAPL	Stock	50.28	50.305	50.28	50.28	4692.0
2019-08-09 19:00:00	AAPL	Stock	50.295	50.35	50.275	50.275	13136.0
2019-08-09 04:00:00	MSFT	Stock	138.15	138.27	138.15	138.27	200.0
2019-08-09 05:00:00	MSFT	Stock	138.18	138.18	138.0	138.0	300.0
2019-08-09 06:00:00	MSFT	Stock	137.91	137.91	137.87	137.88	1957.0
2019-08-09 07:00:00	MSFT	Stock	138.0	138.22	137.7	137.89	13940.0
2019-08-09 08:00:00	MSFT	Stock	137.7	138.35	137.7	138.3	27601.0
2019-08-09 09:00:00	MSFT	Stock	138.2	139.38	137.43	137.58	2630492.0
2019-08-09 10:00:00	MSFT	Stock	137.58	137.99	137.1	137.795	3259566.0
2019-08-09 11:00:00	MSFT	Stock	137.79	137.88	136.46	136.7	2285889.0
2019-08-09 12:00:00	MSFT	Stock	136.68	137.84	136.51	137.412	1924237.0
2019-08-09 13:00:00	MSFT	Stock	137.41	138.43	137.38	137.99	2175073.0
2019-08-09 14:00:00	MSFT	Stock	137.99	138.34	137.83	138.03	1226266.0
2019-08-09 15:00:00	MSFT	Stock	138.04	138.51	137.55	137.69	3586027.0
2019-08-09 16:00:00	MSFT	Stock	137.71	138.1	137.5	137.95	3627231.0
2019-08-09 17:00:00	MSFT	Stock	137.71	137.95	137.71	137.753	5629.0
2019-08-09 18:00:00	MSFT	Stock	137.75	137.9	137.75	137.9	868.0
2019-08-09 19:00:00	MSFT	Stock	137.85	137.9	137.73	137.73	2193.0
2019-08-09 07:00:00	NVDA	Stock	3.9088	3.9225	3.9013	3.9125	275120.0
2019-08-09 08:00:00	NVDA	Stock	3.905	3.9225	3.9	3.9175	481160.0
2019-08-09 09:00:00	NVDA	Stock	3.9198	3.93	3.8562	3.8745	48343680.0
2019-08-09 10:00:00	NVDA	Stock	3.874	3.8825	3.817	3.836	64905600.0
2019-08-09 11:00:00	NVDA	Stock	3.8362	3.8368	3.8038	3.8095	34575480.0
2019-08-09 12:00:00	NVDA	Stock	3.8095	3.854	3.8075	3.8413	37204520.0
2019-08-09 13:00:00	NVDA	Stock	3.8408	3.871	3.8378	3.856	30964320.0
2019-08-09 14:00:00	NVDA	Stock	3.8562	3.8642	3.8445	3.859	21644160.0
2019-08-09 15:00:00	NVDA	Stock	3.86	3.8825	3.8492	3.8545	51155160.0
2019-08-09 16:00:00	NVDA	Stock	3.8545	3.8612	3.8478	3.8548	16520520.0
2019-08-09 17:00:00	NVDA	Stock	3.855	3.855	3.845	3.85	245160.0
2019-08-09 18:00:00	NVDA	Stock	3.85	3.8538	3.8452	3.8488	101160.0
2019-08-09 19:00:00	NVDA	Stock	3.8455	3.8525	3.8435	3.8525	168600.0
2019-08-09 04:00:00	AMZN	Stock	90.7275	90.7275	90.7275	90.7275	8420.0
2019-08-09 07:00:00	AMZN	Stock	90.9675	90.9675	90.818	90.95	89840.0
2019-08-09 08:00:00	AMZN	Stock	90.975	91.15	90.8005	91.1255	143180.0
2019-08-09 09:00:00	AMZN	Stock	91.1135	91.5545	90.7695	91.1015	6235740.0
2019-08-09 10:00:00	AMZN	Stock	91.1245	91.1335	90.361	90.7305	7856420.0

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

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