PREVIEW / stock_1hour / 2019-10-23

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-10-23.parquet
  size:    1.1 MB
  rows:    49,252
  symbols: 2,499

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-10-23 04:00:00	AAPL	Stock	59.91	60.0825	59.875	60.0825	32440.0
2019-10-23 05:00:00	AAPL	Stock	60.12	60.475	60.12	60.3975	51272.0
2019-10-23 06:00:00	AAPL	Stock	60.375	60.4	60.175	60.235	73300.0
2019-10-23 07:00:00	AAPL	Stock	60.235	60.325	60.105	60.2775	185928.0
2019-10-23 08:00:00	AAPL	Stock	60.28	60.38	59.8425	60.38	444788.0
2019-10-23 09:00:00	AAPL	Stock	60.385	60.795	59.99	60.4628	16793144.0
2019-10-23 10:00:00	AAPL	Stock	60.4625	60.705	60.305	60.655	10700324.0
2019-10-23 11:00:00	AAPL	Stock	60.6525	60.73	60.5925	60.6265	7068488.0
2019-10-23 12:00:00	AAPL	Stock	60.625	60.6872	60.5	60.6685	5246024.0
2019-10-23 13:00:00	AAPL	Stock	60.665	60.6775	60.525	60.66	3955376.0
2019-10-23 14:00:00	AAPL	Stock	60.6625	60.6625	60.455	60.6175	5943872.0
2019-10-23 15:00:00	AAPL	Stock	60.6175	60.81	60.56	60.785	10313420.0
2019-10-23 16:00:00	AAPL	Stock	60.795	60.805	60.5025	60.795	5287032.0
2019-10-23 17:00:00	AAPL	Stock	60.795	60.9375	60.77	60.8875	130668.0
2019-10-23 18:00:00	AAPL	Stock	60.8875	60.9875	60.885	60.97	243496.0
2019-10-23 19:00:00	AAPL	Stock	60.975	61.0625	60.95	61.0275	125172.0
2019-10-23 04:00:00	MSFT	Stock	136.25	136.62	136.25	136.6	4434.0
2019-10-23 05:00:00	MSFT	Stock	136.6	136.6	136.36	136.45	5345.0
2019-10-23 06:00:00	MSFT	Stock	136.45	136.85	136.05	136.3	12476.0
2019-10-23 07:00:00	MSFT	Stock	136.33	136.51	136.1	136.36	24109.0
2019-10-23 08:00:00	MSFT	Stock	136.36	136.94	136.15	136.66	58703.0
2019-10-23 09:00:00	MSFT	Stock	136.66	136.985	135.81	136.4	3475583.0
2019-10-23 10:00:00	MSFT	Stock	136.4	136.469	135.61	135.94	3146152.0
2019-10-23 11:00:00	MSFT	Stock	135.94	136.38	135.92	136.045	2257953.0
2019-10-23 12:00:00	MSFT	Stock	136.04	136.21	135.82	136.14	2236089.0
2019-10-23 13:00:00	MSFT	Stock	136.145	136.27	135.97	136.22	1914809.0
2019-10-23 14:00:00	MSFT	Stock	136.225	136.26	135.96	136.244	2038081.0
2019-10-23 15:00:00	MSFT	Stock	136.24	137.45	136.15	137.25	6617637.0
2019-10-23 16:00:00	MSFT	Stock	137.24	139.58	134.0	137.02	3474489.0
2019-10-23 17:00:00	MSFT	Stock	136.91	137.74	135.55	137.55	478959.0
2019-10-23 18:00:00	MSFT	Stock	137.55	138.25	136.51	137.75	427773.0
2019-10-23 19:00:00	MSFT	Stock	137.74	138.11	137.58	137.9	122045.0
2019-10-23 04:00:00	NVDA	Stock	4.785	4.7995	4.785	4.799	65960.0
2019-10-23 05:00:00	NVDA	Stock	4.8062	4.8062	4.8062	4.8062	4000.0
2019-10-23 06:00:00	NVDA	Stock	4.805	4.806	4.7755	4.7755	31960.0
2019-10-23 07:00:00	NVDA	Stock	4.7853	4.801	4.7662	4.801	281480.0
2019-10-23 08:00:00	NVDA	Stock	4.785	4.8783	4.765	4.823	1294640.0
2019-10-23 09:00:00	NVDA	Stock	4.8188	4.8903	4.7758	4.8424	46976840.0
2019-10-23 10:00:00	NVDA	Stock	4.8428	4.8813	4.802	4.8685	46642840.0
2019-10-23 11:00:00	NVDA	Stock	4.866	4.8915	4.8475	4.869	33501640.0
2019-10-23 12:00:00	NVDA	Stock	4.8693	4.89	4.8642	4.8745	17542360.0
2019-10-23 13:00:00	NVDA	Stock	4.8745	4.8868	4.8685	4.8722	14000400.0
2019-10-23 14:00:00	NVDA	Stock	4.8716	4.872	4.821	4.8352	33802160.0
2019-10-23 15:00:00	NVDA	Stock	4.8345	4.8795	4.8345	4.8775	48416840.0
2019-10-23 16:00:00	NVDA	Stock	4.8772	4.9	4.8488	4.8562	4066000.0
2019-10-23 17:00:00	NVDA	Stock	4.8825	4.905	4.877	4.9045	582880.0
2019-10-23 18:00:00	NVDA	Stock	4.9065	4.9125	4.9	4.9005	351960.0
2019-10-23 19:00:00	NVDA	Stock	4.905	4.9083	4.8955	4.9038	350880.0
2019-10-23 05:00:00	AMZN	Stock	88.2	88.2	88.0	88.0	20920.0
2019-10-23 06:00:00	AMZN	Stock	88.24	88.25	88.24	88.25	6880.0

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

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