PREVIEW / stock_1hour / 2023-11-24

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-11-24.parquet
  size:    918 KB
  rows:    37,806
  symbols: 1,211

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-11-24 04:00:00	AAPL	Stock	191.26	191.26	191.1	191.1	2234.0
2023-11-24 05:00:00	AAPL	Stock	191.08	191.1	190.97	191.1	5833.0
2023-11-24 06:00:00	AAPL	Stock	191.1	191.1	190.72	190.76	6915.0
2023-11-24 07:00:00	AAPL	Stock	190.8	190.9	190.67	190.77	17482.0
2023-11-24 08:00:00	AAPL	Stock	190.7989	191.35	190.59	190.85	68050.0
2023-11-24 09:00:00	AAPL	Stock	190.88	190.9	189.69	190.0	3886021.0
2023-11-24 10:00:00	AAPL	Stock	189.99	190.09	189.25	189.485	4725399.0
2023-11-24 11:00:00	AAPL	Stock	189.49	189.7889	189.35	189.6	3809531.0
2023-11-24 12:00:00	AAPL	Stock	189.6	190.0	189.5	189.98	4507212.0
2023-11-24 13:00:00	AAPL	Stock	189.97	190.0	189.84	189.9	3178756.0
2023-11-24 14:00:00	AAPL	Stock	189.9	190.0	189.85	189.92	35384.0
2023-11-24 15:00:00	AAPL	Stock	189.97	190.09	189.94	189.99	3644.0
2023-11-24 16:00:00	AAPL	Stock	189.97	189.99	189.9	189.9	2409.0
2023-11-24 04:00:00	MSFT	Stock	378.25	379.33	378.08	378.94	4002.0
2023-11-24 05:00:00	MSFT	Stock	378.85	378.85	378.03	378.68	1817.0
2023-11-24 06:00:00	MSFT	Stock	378.6	378.73	378.25	378.73	600.0
2023-11-24 07:00:00	MSFT	Stock	378.64	378.76	378.45	378.57	15880.0
2023-11-24 08:00:00	MSFT	Stock	378.75	378.8	377.3	377.3	62676.0
2023-11-24 09:00:00	MSFT	Stock	377.3027	377.97	376.39	377.74	1564172.0
2023-11-24 10:00:00	MSFT	Stock	377.77	377.9	375.135	375.785	1449676.0
2023-11-24 11:00:00	MSFT	Stock	375.79	376.71	375.38	376.51	1139087.0
2023-11-24 12:00:00	MSFT	Stock	376.504	377.5	376.23	377.3201	1115165.0
2023-11-24 13:00:00	MSFT	Stock	377.43	377.98	377.22	377.43	1406938.0
2023-11-24 14:00:00	MSFT	Stock	377.43	377.55	376.68	377.35	5944.0
2023-11-24 15:00:00	MSFT	Stock	377.39	377.47	377.2	377.47	3465.0
2023-11-24 16:00:00	MSFT	Stock	377.4	377.41	377.22	377.41	1953.0
2023-11-24 04:00:00	NVDA	Stock	48.3	48.52	48.02	48.052	322310.0
2023-11-24 05:00:00	NVDA	Stock	48.075	48.075	47.511	47.7	793750.0
2023-11-24 06:00:00	NVDA	Stock	47.72	47.93	47.65	47.93	248600.0
2023-11-24 07:00:00	NVDA	Stock	47.955	47.994	47.763	47.94	1176720.0
2023-11-24 08:00:00	NVDA	Stock	47.975	48.735	47.763	48.43	6898330.0
2023-11-24 09:00:00	NVDA	Stock	48.424	48.921	48.081	48.3169	60690110.0
2023-11-24 10:00:00	NVDA	Stock	48.333	48.413	47.94	48.2329	63143380.0
2023-11-24 11:00:00	NVDA	Stock	48.24	48.264	48.06	48.065	30830760.0
2023-11-24 12:00:00	NVDA	Stock	48.067	48.08	47.745	47.758	52893670.0
2023-11-24 13:00:00	NVDA	Stock	47.776	47.8	47.734	47.7478	9164910.0
2023-11-24 14:00:00	NVDA	Stock	47.74	47.79	47.725	47.772	276230.0
2023-11-24 15:00:00	NVDA	Stock	47.765	47.786	47.758	47.776	228620.0
2023-11-24 16:00:00	NVDA	Stock	47.775	47.783	47.75	47.778	186400.0
2023-11-24 04:00:00	AMZN	Stock	146.82	146.98	146.82	146.98	2795.0
2023-11-24 05:00:00	AMZN	Stock	146.8	146.98	146.69	146.88	3729.0
2023-11-24 06:00:00	AMZN	Stock	146.83	146.87	146.8	146.83	1592.0
2023-11-24 07:00:00	AMZN	Stock	146.83	146.96	146.69	146.79	18419.0
2023-11-24 08:00:00	AMZN	Stock	146.89	147.076	146.51	146.96	94982.0
2023-11-24 09:00:00	AMZN	Stock	146.97	147.3	145.835	146.28	3979397.0
2023-11-24 10:00:00	AMZN	Stock	146.29	146.37	145.32	145.84	4689370.0
2023-11-24 11:00:00	AMZN	Stock	145.85	147.08	145.78	146.72	4038033.0
2023-11-24 12:00:00	AMZN	Stock	146.72	146.915	146.51	146.72	3665122.0
2023-11-24 13:00:00	AMZN	Stock	146.74	146.8	146.04	146.65	1836696.0
2023-11-24 14:00:00	AMZN	Stock	146.65	146.7	146.61	146.66	18825.0

> showing 50 of 37,806 rows — these rows as CSV

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