PREVIEW / stock_1hour / 2019-05-20

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-05-20.parquet
  size:    1.1 MB
  rows:    49,684
  symbols: 2,589

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-05-20 04:00:00	AAPL	Stock	47.325	47.45	46.7	46.715	117164.0
2019-05-20 05:00:00	AAPL	Stock	46.705	46.85	46.6125	46.7375	91436.0
2019-05-20 06:00:00	AAPL	Stock	46.6325	46.6325	46.035	46.05	402524.0
2019-05-20 07:00:00	AAPL	Stock	46.0475	46.2175	45.9625	46.0825	843236.0
2019-05-20 08:00:00	AAPL	Stock	46.0975	46.2	45.825	45.9125	1277200.0
2019-05-20 09:00:00	AAPL	Stock	45.9375	46.1	45.071	45.7425	34168076.0
2019-05-20 10:00:00	AAPL	Stock	45.74	46.0872	45.5375	45.8375	24252488.0
2019-05-20 11:00:00	AAPL	Stock	45.83	45.8875	45.5625	45.717	12829392.0
2019-05-20 12:00:00	AAPL	Stock	45.7125	45.855	45.62	45.6618	9848560.0
2019-05-20 13:00:00	AAPL	Stock	45.6575	45.7675	45.55	45.685	7906220.0
2019-05-20 14:00:00	AAPL	Stock	45.6875	45.7125	45.47	45.4975	10354928.0
2019-05-20 15:00:00	AAPL	Stock	45.5	45.8125	45.0925	45.7725	18518740.0
2019-05-20 16:00:00	AAPL	Stock	45.7725	45.875	45.7375	45.875	14054360.0
2019-05-20 17:00:00	AAPL	Stock	45.82	45.87	45.7725	45.82	522856.0
2019-05-20 18:00:00	AAPL	Stock	45.82	45.85	45.8	45.8275	44092.0
2019-05-20 19:00:00	AAPL	Stock	45.835	45.89	45.825	45.8875	88044.0
2019-05-20 04:00:00	MSFT	Stock	127.86	128.57	127.61	127.61	1910.0
2019-05-20 05:00:00	MSFT	Stock	127.8	127.8	127.66	127.66	1158.0
2019-05-20 06:00:00	MSFT	Stock	127.6	127.66	127.0	127.0	4240.0
2019-05-20 07:00:00	MSFT	Stock	127.05	127.2	126.88	127.0	15881.0
2019-05-20 08:00:00	MSFT	Stock	127.085	127.2	126.3	126.7	58371.0
2019-05-20 09:00:00	MSFT	Stock	126.46	127.04	125.761	127.02	3383852.0
2019-05-20 10:00:00	MSFT	Stock	127.027	127.589	126.48	127.44	2884519.0
2019-05-20 11:00:00	MSFT	Stock	127.45	127.575	126.69	126.89	2012738.0
2019-05-20 12:00:00	MSFT	Stock	126.89	127.35	126.583	126.62	1549966.0
2019-05-20 13:00:00	MSFT	Stock	126.62	126.71	126.38	126.52	1378264.0
2019-05-20 14:00:00	MSFT	Stock	126.52	126.56	125.97	126.23	1669642.0
2019-05-20 15:00:00	MSFT	Stock	126.24	126.51	125.91	126.2	3320168.0
2019-05-20 16:00:00	MSFT	Stock	126.17	126.5	126.096	126.49	4294285.0
2019-05-20 17:00:00	MSFT	Stock	126.49	126.49	126.22	126.4	213620.0
2019-05-20 18:00:00	MSFT	Stock	126.44	126.5	126.4	126.41	4770.0
2019-05-20 19:00:00	MSFT	Stock	126.42	126.55	126.42	126.55	11351.0
2019-05-20 04:00:00	NVDA	Stock	3.9188	3.9188	3.8925	3.8925	16000.0
2019-05-20 05:00:00	NVDA	Stock	3.8885	3.8925	3.85	3.8502	237360.0
2019-05-20 06:00:00	NVDA	Stock	3.85	3.85	3.8102	3.8215	186840.0
2019-05-20 07:00:00	NVDA	Stock	3.839	3.845	3.8112	3.8175	2265200.0
2019-05-20 08:00:00	NVDA	Stock	3.82	3.923	3.7935	3.8	5506240.0
2019-05-20 09:00:00	NVDA	Stock	3.8	3.8688	3.7752	3.8033	132383440.0
2019-05-20 10:00:00	NVDA	Stock	3.8022	3.8413	3.7828	3.8352	110215720.0
2019-05-20 11:00:00	NVDA	Stock	3.836	3.8518	3.8118	3.847	60005840.0
2019-05-20 12:00:00	NVDA	Stock	3.8465	3.8693	3.8315	3.832	51734960.0
2019-05-20 13:00:00	NVDA	Stock	3.8335	3.8458	3.811	3.8192	34696480.0
2019-05-20 14:00:00	NVDA	Stock	3.82	3.8205	3.7848	3.7905	51344200.0
2019-05-20 15:00:00	NVDA	Stock	3.7912	3.812	3.7688	3.7918	89784040.0
2019-05-20 16:00:00	NVDA	Stock	3.7938	3.805	3.7938	3.8035	1874600.0
2019-05-20 17:00:00	NVDA	Stock	3.8	3.8038	3.7972	3.8002	555000.0
2019-05-20 18:00:00	NVDA	Stock	3.8038	3.8088	3.8	3.8062	366280.0
2019-05-20 19:00:00	NVDA	Stock	3.8062	3.8088	3.8025	3.8078	372880.0
2019-05-20 04:00:00	AMZN	Stock	93.9	93.904	93.2505	93.2505	56080.0
2019-05-20 05:00:00	AMZN	Stock	93.2505	93.258	93.125	93.125	27160.0

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

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