PREVIEW / stock_1hour / 2019-08-22

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-08-22.parquet
  size:    1.1 MB
  rows:    49,420
  symbols: 2,557

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-22 04:00:00	AAPL	Stock	53.3175	53.3175	53.085	53.11	4784.0
2019-08-22 05:00:00	AAPL	Stock	53.1075	53.1075	52.885	52.95	36780.0
2019-08-22 06:00:00	AAPL	Stock	52.9975	53.05	52.9775	53.01	23248.0
2019-08-22 07:00:00	AAPL	Stock	53.0475	53.3	53.0	53.2625	122744.0
2019-08-22 08:00:00	AAPL	Stock	53.295	53.36	53.0	53.3225	284244.0
2019-08-22 09:00:00	AAPL	Stock	53.2875	53.6088	53.2225	53.56	11644960.0
2019-08-22 10:00:00	AAPL	Stock	53.57	53.58	52.7525	52.7875	14914812.0
2019-08-22 11:00:00	AAPL	Stock	52.79	53.15	52.6875	53.0178	11368644.0
2019-08-22 12:00:00	AAPL	Stock	53.02	53.1575	53.0075	53.0675	4720460.0
2019-08-22 13:00:00	AAPL	Stock	53.065	53.2825	53.0525	53.185	5443232.0
2019-08-22 14:00:00	AAPL	Stock	53.1875	53.215	53.0822	53.1912	5750964.0
2019-08-22 15:00:00	AAPL	Stock	53.195	53.325	53.06	53.1125	12884848.0
2019-08-22 16:00:00	AAPL	Stock	53.115	53.185	53.06	53.0875	8941680.0
2019-08-22 17:00:00	AAPL	Stock	53.0875	53.0875	53.025	53.03	71112.0
2019-08-22 18:00:00	AAPL	Stock	53.0475	53.1125	53.035	53.0925	27176.0
2019-08-22 19:00:00	AAPL	Stock	53.0875	53.0925	53.0075	53.09	28888.0
2019-08-22 05:00:00	MSFT	Stock	138.3	138.4	137.89	137.95	1764.0
2019-08-22 07:00:00	MSFT	Stock	138.39	139.2	138.21	139.07	8679.0
2019-08-22 08:00:00	MSFT	Stock	138.6	139.3	138.2	139.08	14246.0
2019-08-22 09:00:00	MSFT	Stock	139.09	139.2	138.52	138.88	1790030.0
2019-08-22 10:00:00	MSFT	Stock	138.886	138.9	136.29	136.404	3217769.0
2019-08-22 11:00:00	MSFT	Stock	136.42	137.1	136.315	136.67	1886236.0
2019-08-22 12:00:00	MSFT	Stock	136.67	137.235	136.62	137.086	1288760.0
2019-08-22 13:00:00	MSFT	Stock	137.082	137.59	137.082	137.47	1218261.0
2019-08-22 14:00:00	MSFT	Stock	137.48	137.78	137.22	137.74	1402945.0
2019-08-22 15:00:00	MSFT	Stock	137.75	138.36	137.492	137.77	2885490.0
2019-08-22 16:00:00	MSFT	Stock	137.78	138.36	137.78	137.94	2692678.0
2019-08-22 17:00:00	MSFT	Stock	137.96	138.1	137.79	137.91	9187.0
2019-08-22 18:00:00	MSFT	Stock	138.02	138.19	138.02	138.1	2247.0
2019-08-22 19:00:00	MSFT	Stock	138.08	138.18	137.86	138.1	8909.0
2019-08-22 04:00:00	NVDA	Stock	4.2958	4.2958	4.275	4.275	66000.0
2019-08-22 05:00:00	NVDA	Stock	4.2762	4.2762	4.2748	4.2748	51480.0
2019-08-22 06:00:00	NVDA	Stock	4.2748	4.2838	4.2748	4.275	53200.0
2019-08-22 07:00:00	NVDA	Stock	4.2748	4.298	4.2625	4.298	389760.0
2019-08-22 08:00:00	NVDA	Stock	4.2962	4.31	4.27	4.3062	799960.0
2019-08-22 09:00:00	NVDA	Stock	4.3088	4.3333	4.2668	4.3294	61213040.0
2019-08-22 10:00:00	NVDA	Stock	4.3295	4.3305	4.2476	4.2597	61698240.0
2019-08-22 11:00:00	NVDA	Stock	4.2627	4.294	4.255	4.278	28745520.0
2019-08-22 12:00:00	NVDA	Stock	4.2775	4.305	4.2765	4.2868	22240840.0
2019-08-22 13:00:00	NVDA	Stock	4.2862	4.3046	4.285	4.2965	15923640.0
2019-08-22 14:00:00	NVDA	Stock	4.2975	4.304	4.2862	4.2995	16035160.0
2019-08-22 15:00:00	NVDA	Stock	4.2998	4.3048	4.2848	4.2865	37752720.0
2019-08-22 16:00:00	NVDA	Stock	4.287	4.2935	4.2775	4.287	10959960.0
2019-08-22 17:00:00	NVDA	Stock	4.2835	4.2865	4.2825	4.2825	141920.0
2019-08-22 18:00:00	NVDA	Stock	4.28	4.2875	4.28	4.285	199200.0
2019-08-22 19:00:00	NVDA	Stock	4.285	4.287	4.2833	4.2833	149520.0
2019-08-22 04:00:00	AMZN	Stock	91.048	91.048	91.048	91.048	2000.0
2019-08-22 05:00:00	AMZN	Stock	90.714	90.7235	90.66	90.66	8820.0
2019-08-22 07:00:00	AMZN	Stock	90.9995	91.375	90.975	91.375	76220.0
2019-08-22 08:00:00	AMZN	Stock	90.9	91.544	90.9	91.536	335900.0

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

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