PREVIEW / stock_1hour / 2022-05-13

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-05-13.parquet
  size:    1.4 MB
  rows:    63,641
  symbols: 2,480

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
2022-05-13 04:00:00	AAPL	Stock	144.5	145.69	144.5	144.94	79749.0
2022-05-13 05:00:00	AAPL	Stock	145.02	145.35	144.7	145.0	39279.0
2022-05-13 06:00:00	AAPL	Stock	144.87	145.3	144.71	145.06	40526.0
2022-05-13 07:00:00	AAPL	Stock	145.18	145.71	144.56	145.55	249001.0
2022-05-13 08:00:00	AAPL	Stock	144.8501	145.7788	142.56	145.0	677976.0
2022-05-13 09:00:00	AAPL	Stock	145.0	145.26	143.11	144.9844	14391735.0
2022-05-13 10:00:00	AAPL	Stock	144.99	146.92	144.98	146.86	16272009.0
2022-05-13 11:00:00	AAPL	Stock	146.87	147.84	146.56	147.0391	12161124.0
2022-05-13 12:00:00	AAPL	Stock	147.06	148.105	146.81	147.255	10086469.0
2022-05-13 13:00:00	AAPL	Stock	147.2572	147.48	146.0	146.215	7805060.0
2022-05-13 14:00:00	AAPL	Stock	146.2	146.93	144.8	146.86	11811543.0
2022-05-13 15:00:00	AAPL	Stock	146.8784	147.81	145.92	147.13	16708589.0
2022-05-13 16:00:00	AAPL	Stock	147.15	147.15	146.6421	146.71	9717692.0
2022-05-13 17:00:00	AAPL	Stock	146.73	147.27	146.69	147.2089	122975.0
2022-05-13 18:00:00	AAPL	Stock	147.2	147.29	147.0	147.26	88723.0
2022-05-13 19:00:00	AAPL	Stock	147.27	147.3	147.18	147.28	96824.0
2022-05-13 04:00:00	MSFT	Stock	257.8	260.24	257.8	259.64	8947.0
2022-05-13 05:00:00	MSFT	Stock	259.8	260.26	259.51	259.61	9265.0
2022-05-13 06:00:00	MSFT	Stock	259.85	260.15	259.52	260.05	15577.0
2022-05-13 07:00:00	MSFT	Stock	259.9	260.25	259.5	260.23	69872.0
2022-05-13 08:00:00	MSFT	Stock	259.9999	260.25	259.28	259.78	101877.0
2022-05-13 09:00:00	MSFT	Stock	259.5	260.51	255.35	259.45	3461792.0
2022-05-13 10:00:00	MSFT	Stock	259.475	262.09	259.05	260.78	3691968.0
2022-05-13 11:00:00	MSFT	Stock	260.77	261.915	259.67	261.31	2198936.0
2022-05-13 12:00:00	MSFT	Stock	261.3	263.04	261.11	261.5699	2282939.0
2022-05-13 13:00:00	MSFT	Stock	261.554	261.8	259.11	259.3071	1787291.0
2022-05-13 14:00:00	MSFT	Stock	259.31	260.39	257.8	260.2316	2185397.0
2022-05-13 15:00:00	MSFT	Stock	260.29	261.81	259.15	261.07	4816491.0
2022-05-13 16:00:00	MSFT	Stock	261.12	261.65	260.5	261.0	4272325.0
2022-05-13 17:00:00	MSFT	Stock	260.89	261.38	260.8014	261.1201	10790.0
2022-05-13 18:00:00	MSFT	Stock	261.38	261.7	261.16	261.46	9629.0
2022-05-13 19:00:00	MSFT	Stock	261.6	262.2	261.55	261.63	12760.0
2022-05-13 04:00:00	NVDA	Stock	16.6	16.729	16.6	16.64	342000.0
2022-05-13 05:00:00	NVDA	Stock	16.65	16.72	16.641	16.657	123750.0
2022-05-13 06:00:00	NVDA	Stock	16.69	16.72	16.627	16.715	79160.0
2022-05-13 07:00:00	NVDA	Stock	16.695	16.84	16.652	16.803	843930.0
2022-05-13 08:00:00	NVDA	Stock	16.686	16.86	16.2154	16.812	2300530.0
2022-05-13 09:00:00	NVDA	Stock	16.82	17.407	16.5925	17.216	94456860.0
2022-05-13 10:00:00	NVDA	Stock	17.2168	17.5542	17.153	17.4749	90355960.0
2022-05-13 11:00:00	NVDA	Stock	17.475	17.716	17.408	17.695	60954080.0
2022-05-13 12:00:00	NVDA	Stock	17.695	17.9284	17.576	17.7846	66933380.0
2022-05-13 13:00:00	NVDA	Stock	17.783	17.825	17.58	17.617	41288240.0
2022-05-13 14:00:00	NVDA	Stock	17.616	17.727	17.359	17.7007	63309760.0
2022-05-13 15:00:00	NVDA	Stock	17.702	17.858	17.525	17.706	84157830.0
2022-05-13 16:00:00	NVDA	Stock	17.706	17.771	17.665	17.75	28456710.0
2022-05-13 17:00:00	NVDA	Stock	17.751	17.79	17.75	17.78	618770.0
2022-05-13 18:00:00	NVDA	Stock	17.763	17.85	17.76	17.85	500600.0
2022-05-13 19:00:00	NVDA	Stock	17.849	17.92	17.849	17.902	361060.0
2022-05-13 04:00:00	AMZN	Stock	109.8345	109.996	109.5	109.5	8000.0
2022-05-13 05:00:00	AMZN	Stock	109.0	109.0	109.0	109.0	2000.0

> showing 50 of 63,641 rows — these rows as CSV

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