PREVIEW / stock_1hour / 2023-04-17

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-04-17.parquet
  size:    1.4 MB
  rows:    60,759
  symbols: 1,700

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
2023-04-17 04:00:00	AAPL	Stock	165.25	165.62	165.25	165.39	25521.0
2023-04-17 05:00:00	AAPL	Stock	165.39	165.39	164.95	164.95	8430.0
2023-04-17 06:00:00	AAPL	Stock	165.01	165.65	165.0	165.65	23095.0
2023-04-17 07:00:00	AAPL	Stock	165.52	165.99	165.2	165.79	49953.0
2023-04-17 08:00:00	AAPL	Stock	165.65	166.19	164.48	166.05	316992.0
2023-04-17 09:00:00	AAPL	Stock	166.05	166.2	164.03	164.675	6966661.0
2023-04-17 10:00:00	AAPL	Stock	164.69	165.06	164.0745	164.5659	5266467.0
2023-04-17 11:00:00	AAPL	Stock	164.57	164.95	164.27	164.47	3775447.0
2023-04-17 12:00:00	AAPL	Stock	164.4653	164.55	164.05	164.515	2747405.0
2023-04-17 13:00:00	AAPL	Stock	164.52	164.76	164.362	164.38	2347092.0
2023-04-17 14:00:00	AAPL	Stock	164.385	164.71	164.2401	164.66	2768241.0
2023-04-17 15:00:00	AAPL	Stock	164.66	165.34	164.66	165.27	6086588.0
2023-04-17 16:00:00	AAPL	Stock	165.28	165.28	165.07	165.1	5044279.0
2023-04-17 17:00:00	AAPL	Stock	165.1	165.23	165.04	165.12	49815.0
2023-04-17 18:00:00	AAPL	Stock	165.1	165.14	165.07	165.09	12652.0
2023-04-17 19:00:00	AAPL	Stock	165.12	165.22	165.09	165.22	12331.0
2023-04-17 04:00:00	MSFT	Stock	287.89	290.0	287.0	288.05	9456.0
2023-04-17 05:00:00	MSFT	Stock	288.37	288.56	287.55	287.85	7445.0
2023-04-17 06:00:00	MSFT	Stock	288.02	291.0	288.02	290.46	22643.0
2023-04-17 07:00:00	MSFT	Stock	290.5	291.65	290.1	291.5	85322.0
2023-04-17 08:00:00	MSFT	Stock	291.3523	292.45	285.425	290.5	230499.0
2023-04-17 09:00:00	MSFT	Stock	290.63	291.6	287.96	288.6395	3391363.0
2023-04-17 10:00:00	MSFT	Stock	288.64	289.33	287.105	287.465	2416739.0
2023-04-17 11:00:00	MSFT	Stock	287.47	288.43	286.75	287.07	1781187.0
2023-04-17 12:00:00	MSFT	Stock	287.08	287.2	286.16	287.06	1475206.0
2023-04-17 13:00:00	MSFT	Stock	287.07	287.33	286.45	286.57	1438388.0
2023-04-17 14:00:00	MSFT	Stock	286.57	287.7	286.43	287.5964	1463718.0
2023-04-17 15:00:00	MSFT	Stock	287.59	288.83	287.33	288.79	2608955.0
2023-04-17 16:00:00	MSFT	Stock	288.8	288.8	288.45	288.5	3986316.0
2023-04-17 17:00:00	MSFT	Stock	288.5	288.8	288.39	288.39	15118.0
2023-04-17 18:00:00	MSFT	Stock	288.41	288.41	288.25	288.2501	7545.0
2023-04-17 19:00:00	MSFT	Stock	288.25	288.31	288.11	288.2	5099.0
2023-04-17 04:00:00	NVDA	Stock	26.701	26.758	26.601	26.601	95230.0
2023-04-17 05:00:00	NVDA	Stock	26.606	26.606	26.508	26.527	86570.0
2023-04-17 06:00:00	NVDA	Stock	26.54	26.596	26.522	26.593	151790.0
2023-04-17 07:00:00	NVDA	Stock	26.623	26.66	26.545	26.62	284520.0
2023-04-17 08:00:00	NVDA	Stock	26.629	26.811	26.553	26.6	693900.0
2023-04-17 09:00:00	NVDA	Stock	26.5863	26.793	26.4332	26.728	38747180.0
2023-04-17 10:00:00	NVDA	Stock	26.72	26.9225	26.627	26.7753	54975450.0
2023-04-17 11:00:00	NVDA	Stock	26.78	26.83	26.559	26.586	31695250.0
2023-04-17 12:00:00	NVDA	Stock	26.5851	26.599	26.491	26.591	22392760.0
2023-04-17 13:00:00	NVDA	Stock	26.593	26.676	26.553	26.5944	18146790.0
2023-04-17 14:00:00	NVDA	Stock	26.592	26.791	26.57	26.775	22065020.0
2023-04-17 15:00:00	NVDA	Stock	26.776	27.006	26.76	27.002	47245540.0
2023-04-17 16:00:00	NVDA	Stock	27.002	27.05	26.986	26.995	17532260.0
2023-04-17 17:00:00	NVDA	Stock	26.9968	27.284	26.9968	27.083	935380.0
2023-04-17 18:00:00	NVDA	Stock	27.092	27.142	27.081	27.11	161780.0
2023-04-17 19:00:00	NVDA	Stock	27.12	27.155	27.102	27.155	360930.0
2023-04-17 04:00:00	AMZN	Stock	102.48	102.98	102.48	102.68	11328.0
2023-04-17 05:00:00	AMZN	Stock	102.68	102.7	102.53	102.55	4738.0

> showing 50 of 60,759 rows — these rows as CSV

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