PREVIEW / stock_1hour / 2021-06-08

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-06-08.parquet
  size:    1.5 MB
  rows:    67,045
  symbols: 2,972

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
2021-06-08 04:00:00	AAPL	Stock	126.1	126.3	125.96	126.3	32945.0
2021-06-08 05:00:00	AAPL	Stock	126.27	126.4	126.22	126.38	14572.0
2021-06-08 06:00:00	AAPL	Stock	126.38	126.6	125.84	126.49	39502.0
2021-06-08 07:00:00	AAPL	Stock	126.44	126.85	126.4	126.83	160598.0
2021-06-08 08:00:00	AAPL	Stock	126.4101	126.95	126.3999	126.93	464261.0
2021-06-08 09:00:00	AAPL	Stock	126.92	128.46	126.4485	127.025	16486099.0
2021-06-08 10:00:00	AAPL	Stock	127.02	127.64	126.78	127.135	12147254.0
2021-06-08 11:00:00	AAPL	Stock	127.14	127.47	126.2101	126.61	9487689.0
2021-06-08 12:00:00	AAPL	Stock	126.61	126.84	126.53	126.825	4768843.0
2021-06-08 13:00:00	AAPL	Stock	126.82	126.93	126.43	126.7072	4261344.0
2021-06-08 14:00:00	AAPL	Stock	126.709	127.3183	126.67	127.285	4595869.0
2021-06-08 15:00:00	AAPL	Stock	127.29	127.42	126.68	126.74	8809294.0
2021-06-08 16:00:00	AAPL	Stock	126.74	126.85	126.54	126.66	5307485.0
2021-06-08 17:00:00	AAPL	Stock	126.69	126.85	126.65	126.66	40809.0
2021-06-08 18:00:00	AAPL	Stock	126.69	126.74	126.66	126.73	45578.0
2021-06-08 19:00:00	AAPL	Stock	126.725	126.76	126.64	126.64	35237.0
2021-06-08 04:00:00	MSFT	Stock	254.34	254.34	253.58	254.3	910.0
2021-06-08 05:00:00	MSFT	Stock	254.23	254.65	254.22	254.25	5527.0
2021-06-08 06:00:00	MSFT	Stock	254.36	254.47	253.64	254.2	2403.0
2021-06-08 07:00:00	MSFT	Stock	254.6	255.54	254.6	255.45	23558.0
2021-06-08 08:00:00	MSFT	Stock	254.3601	255.7	253.176	255.48	33677.0
2021-06-08 09:00:00	MSFT	Stock	255.47	256.01	254.31	254.81	2933407.0
2021-06-08 10:00:00	MSFT	Stock	254.78	255.32	253.94	254.19	2475961.0
2021-06-08 11:00:00	MSFT	Stock	254.2	254.29	252.8701	252.97	2201770.0
2021-06-08 12:00:00	MSFT	Stock	252.95	253.42	252.7	253.315	1377735.0
2021-06-08 13:00:00	MSFT	Stock	253.3	253.33	252.57	252.77	1363651.0
2021-06-08 14:00:00	MSFT	Stock	252.75	253.48	252.54	253.42	1078580.0
2021-06-08 15:00:00	MSFT	Stock	253.44	253.77	252.51	252.54	2501634.0
2021-06-08 16:00:00	MSFT	Stock	252.57	252.63	252.39	252.53	4373462.0
2021-06-08 17:00:00	MSFT	Stock	252.63	252.6399	252.5	252.52	2906.0
2021-06-08 18:00:00	MSFT	Stock	252.57	252.6	252.45	252.6	1909.0
2021-06-08 19:00:00	MSFT	Stock	252.62	252.63	252.565	252.58	3063.0
2021-06-08 04:00:00	NVDA	Stock	17.5923	17.6	17.5752	17.5912	43640.0
2021-06-08 05:00:00	NVDA	Stock	17.5912	17.6113	17.5912	17.6095	24800.0
2021-06-08 06:00:00	NVDA	Stock	17.5878	17.5878	17.5	17.5	96280.0
2021-06-08 07:00:00	NVDA	Stock	17.5	17.525	17.3625	17.4	480520.0
2021-06-08 08:00:00	NVDA	Stock	17.475	17.663	17.375	17.47	1330160.0
2021-06-08 09:00:00	NVDA	Stock	17.4985	17.6216	17.3445	17.3583	43987160.0
2021-06-08 10:00:00	NVDA	Stock	17.3575	17.5197	17.3098	17.4111	35827520.0
2021-06-08 11:00:00	NVDA	Stock	17.41	17.4375	17.251	17.3462	37093800.0
2021-06-08 12:00:00	NVDA	Stock	17.3454	17.4475	17.3195	17.4262	18304680.0
2021-06-08 13:00:00	NVDA	Stock	17.4254	17.4432	17.3775	17.4005	9392000.0
2021-06-08 14:00:00	NVDA	Stock	17.3956	17.49	17.3628	17.4662	22244880.0
2021-06-08 15:00:00	NVDA	Stock	17.4695	17.479	17.4275	17.4572	23611280.0
2021-06-08 16:00:00	NVDA	Stock	17.457	17.4595	17.425	17.43	18067240.0
2021-06-08 17:00:00	NVDA	Stock	17.4305	17.4488	17.4125	17.438	84520.0
2021-06-08 18:00:00	NVDA	Stock	17.457	17.457	17.425	17.45	139480.0
2021-06-08 19:00:00	NVDA	Stock	17.45	17.4692	17.4442	17.4588	236320.0
2021-06-08 04:00:00	AMZN	Stock	160.4465	160.4465	160.4465	160.4465	7100.0
2021-06-08 05:00:00	AMZN	Stock	160.55	160.6	160.55	160.6	10000.0

> showing 50 of 67,045 rows — these rows as CSV

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