PREVIEW / stock_1hour / 2023-04-25

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-04-25.parquet
  size:    1.3 MB
  rows:    59,848
  symbols: 1,687

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-25 04:00:00	AAPL	Stock	164.93	164.93	164.23	164.49	25628.0
2023-04-25 05:00:00	AAPL	Stock	164.52	164.65	164.5	164.62	2392.0
2023-04-25 06:00:00	AAPL	Stock	164.64	165.1	164.6	165.0	31467.0
2023-04-25 07:00:00	AAPL	Stock	165.0	165.08	164.75	164.87	43221.0
2023-04-25 08:00:00	AAPL	Stock	164.95	165.02	164.09	164.85	127479.0
2023-04-25 09:00:00	AAPL	Stock	164.8051	166.305	164.8051	166.05	5604785.0
2023-04-25 10:00:00	AAPL	Stock	166.04	166.28	165.0595	165.22	5844324.0
2023-04-25 11:00:00	AAPL	Stock	165.23	165.65	164.78	164.865	4095144.0
2023-04-25 12:00:00	AAPL	Stock	164.86	164.9263	164.38	164.62	3244919.0
2023-04-25 13:00:00	AAPL	Stock	164.6226	164.82	163.8	163.92	3886667.0
2023-04-25 14:00:00	AAPL	Stock	163.9224	164.53	163.75	164.0001	3831133.0
2023-04-25 15:00:00	AAPL	Stock	164.0	164.42	163.73	163.8	7387717.0
2023-04-25 16:00:00	AAPL	Stock	163.81	164.43	163.52	163.9799	6661704.0
2023-04-25 17:00:00	AAPL	Stock	163.98	164.4	163.84	164.32	110742.0
2023-04-25 18:00:00	AAPL	Stock	164.32	164.72	164.15	164.52	131917.0
2023-04-25 19:00:00	AAPL	Stock	164.5	164.58	164.15	164.16	63729.0
2023-04-25 04:00:00	MSFT	Stock	280.98	280.98	279.79	280.25	15701.0
2023-04-25 05:00:00	MSFT	Stock	280.3	280.45	280.3	280.45	553.0
2023-04-25 06:00:00	MSFT	Stock	280.72	281.0	280.59	281.0	2917.0
2023-04-25 07:00:00	MSFT	Stock	281.1	281.25	280.22	280.28	18415.0
2023-04-25 08:00:00	MSFT	Stock	280.89	281.11	279.01	280.25	29312.0
2023-04-25 09:00:00	MSFT	Stock	280.1	281.6	278.82	280.8199	2441185.0
2023-04-25 10:00:00	MSFT	Stock	280.79	281.01	278.79	279.73	2874989.0
2023-04-25 11:00:00	MSFT	Stock	279.7401	280.48	277.62	278.27	2786774.0
2023-04-25 12:00:00	MSFT	Stock	278.28	278.37	277.0	277.945	2417192.0
2023-04-25 13:00:00	MSFT	Stock	277.945	278.51	277.23	277.85	2145274.0
2023-04-25 14:00:00	MSFT	Stock	277.86	278.13	276.26	276.82	2908550.0
2023-04-25 15:00:00	MSFT	Stock	276.815	277.3604	275.37	275.56	5935883.0
2023-04-25 16:00:00	MSFT	Stock	275.57	291.3	275.17	289.04	6710650.0
2023-04-25 17:00:00	MSFT	Stock	289.07	294.76	288.5	294.64	1142490.0
2023-04-25 18:00:00	MSFT	Stock	294.6	302.0	291.0	299.75	2592808.0
2023-04-25 19:00:00	MSFT	Stock	299.71	299.9	298.03	298.68	410925.0
2023-04-25 04:00:00	NVDA	Stock	26.841	26.868	26.79	26.844	67810.0
2023-04-25 05:00:00	NVDA	Stock	26.85	26.871	26.84	26.843	17300.0
2023-04-25 06:00:00	NVDA	Stock	26.875	26.875	26.833	26.875	54560.0
2023-04-25 07:00:00	NVDA	Stock	26.875	26.995	26.86	26.928	192700.0
2023-04-25 08:00:00	NVDA	Stock	26.855	27.03	26.749	27.03	660780.0
2023-04-25 09:00:00	NVDA	Stock	27.035	27.247	26.79	26.806	40358770.0
2023-04-25 10:00:00	NVDA	Stock	26.8004	26.921	26.547	26.6605	56573640.0
2023-04-25 11:00:00	NVDA	Stock	26.663	26.71	26.482	26.4954	34567120.0
2023-04-25 12:00:00	NVDA	Stock	26.4935	26.496	26.314	26.4545	41176540.0
2023-04-25 13:00:00	NVDA	Stock	26.456	26.5329	26.358	26.4345	30993930.0
2023-04-25 14:00:00	NVDA	Stock	26.434	26.524	26.357	26.3715	27933190.0
2023-04-25 15:00:00	NVDA	Stock	26.37	26.488	26.225	26.242	43407100.0
2023-04-25 16:00:00	NVDA	Stock	26.241	26.46	26.223	26.46	22156690.0
2023-04-25 17:00:00	NVDA	Stock	26.462	26.63	26.455	26.625	1882580.0
2023-04-25 18:00:00	NVDA	Stock	26.62	27.011	26.58	26.982	4551950.0
2023-04-25 19:00:00	NVDA	Stock	26.99	26.99	26.885	26.89	1798910.0
2023-04-25 04:00:00	AMZN	Stock	105.74	105.74	105.15	105.37	13837.0
2023-04-25 05:00:00	AMZN	Stock	105.32	105.55	105.32	105.45	3120.0

> showing 50 of 59,848 rows — these rows as CSV

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