PREVIEW / stock_1hour / 2019-08-14

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-08-14.parquet
  size:    1.1 MB
  rows:    51,447
  symbols: 2,570

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-14 04:00:00	AAPL	Stock	52.2375	52.2375	52.05	52.0875	6804.0
2019-08-14 05:00:00	AAPL	Stock	52.045	52.045	51.835	51.8525	15044.0
2019-08-14 06:00:00	AAPL	Stock	51.8075	51.8075	51.465	51.5625	50764.0
2019-08-14 07:00:00	AAPL	Stock	51.54	51.7525	51.25	51.3325	474208.0
2019-08-14 08:00:00	AAPL	Stock	51.7028	52.1125	50.93	51.05	1433960.0
2019-08-14 09:00:00	AAPL	Stock	51.06	51.61	50.675	51.5175	22791464.0
2019-08-14 10:00:00	AAPL	Stock	51.505	51.515	51.075	51.0775	18445556.0
2019-08-14 11:00:00	AAPL	Stock	51.0788	51.2375	50.8175	50.8868	13675780.0
2019-08-14 12:00:00	AAPL	Stock	50.885	50.9762	50.6775	50.815	12261092.0
2019-08-14 13:00:00	AAPL	Stock	50.81	51.115	50.7025	50.9725	10577408.0
2019-08-14 14:00:00	AAPL	Stock	50.9725	50.9975	50.6468	50.7525	9249004.0
2019-08-14 15:00:00	AAPL	Stock	50.7475	50.99	50.65	50.6875	18891796.0
2019-08-14 16:00:00	AAPL	Stock	50.685	50.981	50.5875	50.6225	12785108.0
2019-08-14 17:00:00	AAPL	Stock	50.5875	50.6875	50.5125	50.55	119820.0
2019-08-14 18:00:00	AAPL	Stock	50.55	50.555	50.3875	50.4375	226532.0
2019-08-14 19:00:00	AAPL	Stock	50.415	50.625	50.4075	50.6	169152.0
2019-08-14 04:00:00	MSFT	Stock	138.21	138.21	137.94	138.02	2500.0
2019-08-14 05:00:00	MSFT	Stock	137.36	137.76	137.04	137.76	1274.0
2019-08-14 06:00:00	MSFT	Stock	137.5	137.5	137.0	137.17	1311.0
2019-08-14 07:00:00	MSFT	Stock	137.29	137.33	136.4	136.45	78174.0
2019-08-14 08:00:00	MSFT	Stock	137.25	137.3	136.26	136.57	72192.0
2019-08-14 09:00:00	MSFT	Stock	136.416	136.92	135.69	136.38	2486562.0
2019-08-14 10:00:00	MSFT	Stock	136.385	136.4	135.02	135.146	2616090.0
2019-08-14 11:00:00	MSFT	Stock	135.145	135.34	134.25	134.37	3167803.0
2019-08-14 12:00:00	MSFT	Stock	134.36	134.575	133.84	133.91	2651769.0
2019-08-14 13:00:00	MSFT	Stock	133.91	135.12	133.67	134.776	2425031.0
2019-08-14 14:00:00	MSFT	Stock	134.78	135.03	133.981	134.36	2009415.0
2019-08-14 15:00:00	MSFT	Stock	134.36	134.925	133.84	133.98	5645572.0
2019-08-14 16:00:00	MSFT	Stock	133.97	134.54	133.75	133.776	6376555.0
2019-08-14 17:00:00	MSFT	Stock	133.814	133.98	133.52	133.65	34689.0
2019-08-14 18:00:00	MSFT	Stock	133.55	133.55	133.15	133.25	19066.0
2019-08-14 19:00:00	MSFT	Stock	133.3	134.09	133.3	134.09	17782.0
2019-08-14 04:00:00	NVDA	Stock	3.8815	3.8815	3.8815	3.8815	4000.0
2019-08-14 05:00:00	NVDA	Stock	3.8932	3.8932	3.882	3.882	16000.0
2019-08-14 06:00:00	NVDA	Stock	3.881	3.881	3.8125	3.85	115560.0
2019-08-14 07:00:00	NVDA	Stock	3.85	3.8625	3.8162	3.821	581280.0
2019-08-14 08:00:00	NVDA	Stock	3.8525	3.86	3.8058	3.825	1008320.0
2019-08-14 09:00:00	NVDA	Stock	3.8285	3.8285	3.7778	3.818	58619760.0
2019-08-14 10:00:00	NVDA	Stock	3.817	3.8171	3.7702	3.7702	37795400.0
2019-08-14 11:00:00	NVDA	Stock	3.7702	3.777	3.7298	3.7384	46325280.0
2019-08-14 12:00:00	NVDA	Stock	3.738	3.746	3.714	3.7153	36396920.0
2019-08-14 13:00:00	NVDA	Stock	3.7145	3.7505	3.7078	3.7364	40827280.0
2019-08-14 14:00:00	NVDA	Stock	3.736	3.7608	3.7262	3.7538	30737520.0
2019-08-14 15:00:00	NVDA	Stock	3.7532	3.7738	3.749	3.7518	67540280.0
2019-08-14 16:00:00	NVDA	Stock	3.7518	3.9013	3.7322	3.7425	20818880.0
2019-08-14 17:00:00	NVDA	Stock	3.7425	3.7425	3.715	3.7325	1274880.0
2019-08-14 18:00:00	NVDA	Stock	3.725	3.7342	3.713	3.7248	641480.0
2019-08-14 19:00:00	NVDA	Stock	3.7245	3.737	3.7175	3.7362	944800.0
2019-08-14 04:00:00	AMZN	Stock	91.1	91.1	90.95	90.95	10920.0
2019-08-14 05:00:00	AMZN	Stock	90.925	90.925	90.925	90.925	2660.0

> showing 50 of 51,447 rows — these rows as CSV

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