PREVIEW / stock_1hour / 2020-06-15

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-06-15.parquet
  size:    1.3 MB
  rows:    58,345
  symbols: 2,402

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
2020-06-15 04:00:00	AAPL	Stock	82.625	83.1	82.625	83.0	61240.0
2020-06-15 05:00:00	AAPL	Stock	83.0675	83.445	82.925	83.3325	30540.0
2020-06-15 06:00:00	AAPL	Stock	83.3375	83.73	82.975	82.975	35496.0
2020-06-15 07:00:00	AAPL	Stock	83.0	83.6875	82.905	83.4725	248124.0
2020-06-15 08:00:00	AAPL	Stock	83.295	83.6825	82.9295	83.405	591648.0
2020-06-15 09:00:00	AAPL	Stock	83.3875	84.2	83.145	84.04	15251920.0
2020-06-15 10:00:00	AAPL	Stock	84.0275	84.4112	83.6	83.8975	15453632.0
2020-06-15 11:00:00	AAPL	Stock	83.8925	84.4775	83.86	84.395	13600744.0
2020-06-15 12:00:00	AAPL	Stock	84.3918	85.0748	84.34	84.957	12113928.0
2020-06-15 13:00:00	AAPL	Stock	84.965	85.27	84.75	85.22	9019744.0
2020-06-15 14:00:00	AAPL	Stock	85.23	86.2	85.2225	86.04	17340488.0
2020-06-15 15:00:00	AAPL	Stock	86.035	86.42	85.2975	85.7475	19584144.0
2020-06-15 16:00:00	AAPL	Stock	85.7675	86.0	85.5	85.9625	10497052.0
2020-06-15 17:00:00	AAPL	Stock	85.9625	86.06	85.9125	85.9975	55368.0
2020-06-15 18:00:00	AAPL	Stock	86.01	86.22	85.925	86.075	67724.0
2020-06-15 19:00:00	AAPL	Stock	86.1125	86.4475	85.99	86.4475	119140.0
2020-06-15 04:00:00	MSFT	Stock	183.6	184.2	183.19	184.2	9823.0
2020-06-15 05:00:00	MSFT	Stock	184.53	185.0	184.2	185.0	7029.0
2020-06-15 06:00:00	MSFT	Stock	185.2	185.39	183.7	184.0	10748.0
2020-06-15 07:00:00	MSFT	Stock	184.0	185.27	183.5	184.57	50945.0
2020-06-15 08:00:00	MSFT	Stock	184.0	185.52	183.98	185.3	72997.0
2020-06-15 09:00:00	MSFT	Stock	185.25	187.21	184.01	187.16	3947699.0
2020-06-15 10:00:00	MSFT	Stock	187.13	187.89	186.37	186.66	3641007.0
2020-06-15 11:00:00	MSFT	Stock	186.68	187.61	186.44	187.21	2444816.0
2020-06-15 12:00:00	MSFT	Stock	187.2	187.97	187.08	187.8	2052536.0
2020-06-15 13:00:00	MSFT	Stock	187.84	188.74	187.62	188.535	1936299.0
2020-06-15 14:00:00	MSFT	Stock	188.55	190.82	188.55	190.08	4068858.0
2020-06-15 15:00:00	MSFT	Stock	190.09	190.43	188.37	189.09	5658391.0
2020-06-15 16:00:00	MSFT	Stock	188.94	189.9	188.94	189.75	4028152.0
2020-06-15 17:00:00	MSFT	Stock	189.85	189.98	189.53	189.97	11424.0
2020-06-15 18:00:00	MSFT	Stock	189.75	190.5	189.55	189.85	22368.0
2020-06-15 19:00:00	MSFT	Stock	189.76	191.49	189.66	191.39	28717.0
2020-06-15 04:00:00	NVDA	Stock	8.774	8.774	8.6213	8.7088	77160.0
2020-06-15 05:00:00	NVDA	Stock	8.7095	8.7475	8.7095	8.7475	136000.0
2020-06-15 06:00:00	NVDA	Stock	8.748	8.7505	8.748	8.748	71480.0
2020-06-15 07:00:00	NVDA	Stock	8.798	8.798	8.7442	8.7765	1609720.0
2020-06-15 08:00:00	NVDA	Stock	8.7794	8.7985	8.7442	8.7735	1297440.0
2020-06-15 09:00:00	NVDA	Stock	8.7812	8.95	8.7438	8.9415	55271320.0
2020-06-15 10:00:00	NVDA	Stock	8.9475	9.01	8.895	8.9062	62681360.0
2020-06-15 11:00:00	NVDA	Stock	8.9113	8.983	8.8988	8.9558	36934360.0
2020-06-15 12:00:00	NVDA	Stock	8.9568	9.0768	8.9461	9.0576	41265200.0
2020-06-15 13:00:00	NVDA	Stock	9.0588	9.0965	9.0461	9.0695	26410120.0
2020-06-15 14:00:00	NVDA	Stock	9.0708	9.1823	9.0708	9.1578	64418800.0
2020-06-15 15:00:00	NVDA	Stock	9.1562	9.1798	9.0758	9.1768	55941960.0
2020-06-15 16:00:00	NVDA	Stock	9.1738	9.2	9.1632	9.193	32182800.0
2020-06-15 17:00:00	NVDA	Stock	9.195	9.2	9.1915	9.1963	236360.0
2020-06-15 18:00:00	NVDA	Stock	9.2	9.222	9.18	9.1882	670360.0
2020-06-15 19:00:00	NVDA	Stock	9.195	9.2438	9.1875	9.2438	584440.0
2020-06-15 04:00:00	AMZN	Stock	125.75	125.75	125.7	125.75	19680.0
2020-06-15 05:00:00	AMZN	Stock	125.75	125.75	125.75	125.75	12840.0

> showing 50 of 58,345 rows — these rows as CSV

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