PREVIEW / stock_1hour / 2025-02-20

all stock 1-hour files

  file:    by_date/stock_1hour/2025/2025-02-20.parquet
  size:    1.4 MB
  rows:    63,639
  symbols: 518

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
2025-02-20 04:00:00	AAPL	Stock	243.98	244.28	243.79	244.09	17485.0
2025-02-20 05:00:00	AAPL	Stock	244.11	244.23	244.0	244.1	5675.0
2025-02-20 06:00:00	AAPL	Stock	244.1	244.1	243.86	243.91	4842.0
2025-02-20 07:00:00	AAPL	Stock	243.87	244.57	243.87	244.5	9103.0
2025-02-20 08:00:00	AAPL	Stock	244.17	244.87	243.5	243.78	118133.0
2025-02-20 09:00:00	AAPL	Stock	243.7967	246.78	243.77	244.9	3651974.0
2025-02-20 10:00:00	AAPL	Stock	244.9	245.3539	244.29	245.07	3005020.0
2025-02-20 11:00:00	AAPL	Stock	245.11	246.7	245.08	245.275	4072270.0
2025-02-20 12:00:00	AAPL	Stock	245.265	246.46	245.03	245.36	2144032.0
2025-02-20 13:00:00	AAPL	Stock	245.369	245.8178	245.02	245.3506	1551186.0
2025-02-20 14:00:00	AAPL	Stock	245.33	245.75	244.85	245.335	1483160.0
2025-02-20 15:00:00	AAPL	Stock	245.33	246.0	245.2724	245.86	3237155.0
2025-02-20 16:00:00	AAPL	Stock	245.86	245.86	245.6	245.67	4460301.0
2025-02-20 17:00:00	AAPL	Stock	245.6703	245.7	245.5006	245.6025	8220.0
2025-02-20 18:00:00	AAPL	Stock	245.65	245.7	245.56	245.69	8323.0
2025-02-20 19:00:00	AAPL	Stock	245.69	245.7	245.5717	245.6	4237.0
2025-02-20 04:00:00	MSFT	Stock	415.91	419.0	415.5	417.65	29272.0
2025-02-20 05:00:00	MSFT	Stock	417.7	418.85	417.33	417.33	16190.0
2025-02-20 06:00:00	MSFT	Stock	417.3	417.6	416.55	417.29	24139.0
2025-02-20 07:00:00	MSFT	Stock	417.03	417.03	414.71	415.43	48451.0
2025-02-20 08:00:00	MSFT	Stock	415.4	417.8644	414.0296	414.47	110231.0
2025-02-20 09:00:00	MSFT	Stock	414.35	417.3099	413.565	413.89	2719710.0
2025-02-20 10:00:00	MSFT	Stock	413.89	416.97	412.54	416.2	2105611.0
2025-02-20 11:00:00	MSFT	Stock	416.21	419.31	415.7	416.59	2702208.0
2025-02-20 12:00:00	MSFT	Stock	416.605	418.38	416.29	417.37	965841.0
2025-02-20 13:00:00	MSFT	Stock	417.41	418.0599	416.579	417.29	784076.0
2025-02-20 14:00:00	MSFT	Stock	417.23	417.89	416.39	416.73	1067854.0
2025-02-20 15:00:00	MSFT	Stock	416.76	416.83	414.93	416.13	1819763.0
2025-02-20 16:00:00	MSFT	Stock	416.15	416.15	415.3112	415.6053	3173755.0
2025-02-20 17:00:00	MSFT	Stock	415.6	415.87	415.49	415.78	10683.0
2025-02-20 18:00:00	MSFT	Stock	415.8	416.5	415.7501	416.26	13276.0
2025-02-20 19:00:00	MSFT	Stock	416.26	416.7998	416.0276	416.44	14770.0
2025-02-20 04:00:00	NVDA	Stock	138.7	139.63	138.27	139.63	249012.0
2025-02-20 05:00:00	NVDA	Stock	139.62	139.64	139.22	139.3	140691.0
2025-02-20 06:00:00	NVDA	Stock	139.25	139.79	138.79	139.44	356867.0
2025-02-20 07:00:00	NVDA	Stock	139.45	139.76	139.03	139.65	346930.0
2025-02-20 08:00:00	NVDA	Stock	139.24	140.27	138.45	140.21	1421809.0
2025-02-20 09:00:00	NVDA	Stock	140.2	140.89	137.06	137.145	21471314.0
2025-02-20 10:00:00	NVDA	Stock	137.17	139.07	136.7901	137.24	24435801.0
2025-02-20 11:00:00	NVDA	Stock	137.24	139.0	137.16	138.735	14550193.0
2025-02-20 12:00:00	NVDA	Stock	138.739	139.97	138.662	139.1784	12803179.0
2025-02-20 13:00:00	NVDA	Stock	139.175	139.8396	139.0836	139.585	8296481.0
2025-02-20 14:00:00	NVDA	Stock	139.59	140.2269	139.38	140.15	10623249.0
2025-02-20 15:00:00	NVDA	Stock	140.145	140.66	139.62	140.12	15013378.0
2025-02-20 16:00:00	NVDA	Stock	140.13	140.18	139.79	139.82	11127581.0
2025-02-20 17:00:00	NVDA	Stock	139.8	140.11	139.75	139.86	178239.0
2025-02-20 18:00:00	NVDA	Stock	139.9	140.0	139.79	139.86	161427.0
2025-02-20 19:00:00	NVDA	Stock	139.8505	140.01	139.85	139.9984	225305.0
2025-02-20 04:00:00	AMZN	Stock	225.82	225.96	225.27	225.45	10477.0
2025-02-20 05:00:00	AMZN	Stock	225.49	226.09	225.49	225.86	14701.0

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

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