PREVIEW / stock_1hour / 2019-07-17

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-07-17.parquet
  size:    1.1 MB
  rows:    49,859
  symbols: 2,558

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-07-17 04:00:00	AAPL	Stock	51.1375	51.1375	51.1375	51.1375	400.0
2019-07-17 05:00:00	AAPL	Stock	51.175	51.22	51.175	51.22	1360.0
2019-07-17 06:00:00	AAPL	Stock	51.1975	51.1975	51.1325	51.175	12596.0
2019-07-17 07:00:00	AAPL	Stock	51.225	51.2325	51.1025	51.1625	59308.0
2019-07-17 08:00:00	AAPL	Stock	51.1875	51.225	51.0	51.0175	170312.0
2019-07-17 09:00:00	AAPL	Stock	51.025	51.165	50.915	51.1325	8076852.0
2019-07-17 10:00:00	AAPL	Stock	51.13	51.19	50.995	51.1438	7132368.0
2019-07-17 11:00:00	AAPL	Stock	51.1475	51.24	51.1025	51.21	5551100.0
2019-07-17 12:00:00	AAPL	Stock	51.2175	51.273	51.15	51.255	3789892.0
2019-07-17 13:00:00	AAPL	Stock	51.2575	51.2575	51.155	51.2212	2830680.0
2019-07-17 14:00:00	AAPL	Stock	51.2225	51.225	51.045	51.085	3342364.0
2019-07-17 15:00:00	AAPL	Stock	51.085	51.09	50.8175	50.82	8544148.0
2019-07-17 16:00:00	AAPL	Stock	50.8375	50.8725	50.7	50.7222	5862132.0
2019-07-17 17:00:00	AAPL	Stock	50.75	50.8375	50.7375	50.8375	55408.0
2019-07-17 18:00:00	AAPL	Stock	50.7725	50.79	50.7525	50.765	22228.0
2019-07-17 19:00:00	AAPL	Stock	50.7625	50.7625	50.7025	50.75	45324.0
2019-07-17 06:00:00	MSFT	Stock	137.34	137.34	137.34	137.34	2054.0
2019-07-17 07:00:00	MSFT	Stock	137.26	137.31	137.07	137.18	5212.0
2019-07-17 08:00:00	MSFT	Stock	137.11	137.439	137.0	137.09	14477.0
2019-07-17 09:00:00	MSFT	Stock	137.0	137.75	137.0	137.53	2252994.0
2019-07-17 10:00:00	MSFT	Stock	137.54	137.93	137.13	137.14	2526764.0
2019-07-17 11:00:00	MSFT	Stock	137.15	137.26	136.86	137.075	1856932.0
2019-07-17 12:00:00	MSFT	Stock	137.08	137.165	136.9	136.98	1342453.0
2019-07-17 13:00:00	MSFT	Stock	136.985	137.17	136.9	137.17	1161471.0
2019-07-17 14:00:00	MSFT	Stock	137.18	137.41	137.0	137.32	1199019.0
2019-07-17 15:00:00	MSFT	Stock	137.315	137.34	136.22	136.22	4330973.0
2019-07-17 16:00:00	MSFT	Stock	136.22	136.32	135.8	136.07	3223317.0
2019-07-17 17:00:00	MSFT	Stock	136.0	136.27	135.76	135.94	26918.0
2019-07-17 18:00:00	MSFT	Stock	135.95	136.04	135.86	135.98	17607.0
2019-07-17 19:00:00	MSFT	Stock	135.95	136.02	135.85	135.85	15207.0
2019-07-17 04:00:00	NVDA	Stock	4.1975	4.2488	4.1975	4.2125	86320.0
2019-07-17 06:00:00	NVDA	Stock	4.2222	4.2225	4.2095	4.2095	42720.0
2019-07-17 07:00:00	NVDA	Stock	4.2028	4.2075	4.1962	4.205	253480.0
2019-07-17 08:00:00	NVDA	Stock	4.2038	4.2116	4.1875	4.1938	1203080.0
2019-07-17 09:00:00	NVDA	Stock	4.195	4.2312	4.1494	4.2193	57262480.0
2019-07-17 10:00:00	NVDA	Stock	4.22	4.222	4.1965	4.2128	53751320.0
2019-07-17 11:00:00	NVDA	Stock	4.2129	4.2325	4.212	4.2214	38742960.0
2019-07-17 12:00:00	NVDA	Stock	4.2208	4.2338	4.216	4.2253	30656200.0
2019-07-17 13:00:00	NVDA	Stock	4.2258	4.2299	4.219	4.2208	26954480.0
2019-07-17 14:00:00	NVDA	Stock	4.2213	4.2398	4.2172	4.2393	31842920.0
2019-07-17 15:00:00	NVDA	Stock	4.2388	4.2498	4.2338	4.2422	72319320.0
2019-07-17 16:00:00	NVDA	Stock	4.2428	4.2458	4.2225	4.2298	18648600.0
2019-07-17 17:00:00	NVDA	Stock	4.23	4.2428	4.2235	4.2428	264840.0
2019-07-17 18:00:00	NVDA	Stock	4.2262	4.2338	4.225	4.225	258960.0
2019-07-17 19:00:00	NVDA	Stock	4.2275	4.2288	4.2225	4.2225	450680.0
2019-07-17 04:00:00	AMZN	Stock	100.4	100.643	100.4	100.643	20080.0
2019-07-17 05:00:00	AMZN	Stock	100.5005	100.5005	100.5	100.5	4000.0
2019-07-17 06:00:00	AMZN	Stock	100.35	100.35	100.105	100.105	14500.0
2019-07-17 07:00:00	AMZN	Stock	100.125	100.1525	100.085	100.1005	46560.0
2019-07-17 08:00:00	AMZN	Stock	100.1	100.2925	100.0635	100.15	197300.0

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

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