PREVIEW / stock_1hour / 2002-08-16

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-08-16.parquet
  size:    383 KB
  rows:    18,341
  symbols: 1,451

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
2002-08-16 08:00:00	AAPL	Stock	0.2788	0.2796	0.2788	0.2796	16800.0
2002-08-16 09:00:00	AAPL	Stock	0.2759	0.2786	0.2729	0.2768	25749304.0
2002-08-16 10:00:00	AAPL	Stock	0.2768	0.2816	0.2766	0.2809	33304376.0
2002-08-16 11:00:00	AAPL	Stock	0.2809	0.2875	0.2807	0.2834	47150824.0
2002-08-16 12:00:00	AAPL	Stock	0.2832	0.2838	0.2779	0.2784	44804424.0
2002-08-16 13:00:00	AAPL	Stock	0.2786	0.2813	0.2775	0.2811	15169952.0
2002-08-16 14:00:00	AAPL	Stock	0.2811	0.2818	0.2788	0.2813	23309944.0
2002-08-16 15:00:00	AAPL	Stock	0.2813	0.2834	0.2788	0.2823	36752464.0
2002-08-16 16:00:00	AAPL	Stock	0.283	0.283	0.2782	0.2823	6798400.0
2002-08-16 17:00:00	AAPL	Stock	0.2823	0.2823	0.2823	0.2823	2212000.0
2002-08-16 18:00:00	AAPL	Stock	0.2823	0.2823	0.2823	0.2823	5600.0
2002-08-16 08:00:00	MSFT	Stock	24.885	24.97	24.775	24.78	237100.0
2002-08-16 09:00:00	MSFT	Stock	24.8	24.875	24.46	24.76	12996838.0
2002-08-16 10:00:00	MSFT	Stock	24.76	24.9365	24.575	24.845	11304928.0
2002-08-16 11:00:00	MSFT	Stock	24.85	25.08	24.815	24.955	10352538.0
2002-08-16 12:00:00	MSFT	Stock	24.95	25.055	24.84	24.9135	6557446.0
2002-08-16 13:00:00	MSFT	Stock	24.915	25.0	24.88	24.97	4438970.0
2002-08-16 14:00:00	MSFT	Stock	24.965	25.0805	24.875	25.07	5903076.0
2002-08-16 15:00:00	MSFT	Stock	25.075	25.115	24.8975	25.005	12182832.0
2002-08-16 16:00:00	MSFT	Stock	24.99	25.015	24.965	25.0095	3841028.0
2002-08-16 17:00:00	MSFT	Stock	25.005	25.05	24.99	25.0	354610.0
2002-08-16 18:00:00	MSFT	Stock	25.019	25.019	24.99	24.99	5600.0
2002-08-16 08:00:00	NVDA	Stock	0.0846	0.0852	0.0797	0.0812	11519640.0
2002-08-16 09:00:00	NVDA	Stock	0.0812	0.0842	0.0787	0.0835	314705760.0
2002-08-16 10:00:00	NVDA	Stock	0.0836	0.0904	0.0835	0.0892	460224000.0
2002-08-16 11:00:00	NVDA	Stock	0.0893	0.0913	0.0876	0.0901	260888160.0
2002-08-16 12:00:00	NVDA	Stock	0.0902	0.0911	0.0887	0.0897	107212920.0
2002-08-16 13:00:00	NVDA	Stock	0.0897	0.0921	0.0889	0.0916	135413640.0
2002-08-16 14:00:00	NVDA	Stock	0.0916	0.0921	0.09	0.0909	103413360.0
2002-08-16 15:00:00	NVDA	Stock	0.0908	0.0917	0.0889	0.0892	172233840.0
2002-08-16 16:00:00	NVDA	Stock	0.0892	0.0897	0.0887	0.0888	18498960.0
2002-08-16 17:00:00	NVDA	Stock	0.089	0.0892	0.0888	0.0891	2024160.0
2002-08-16 18:00:00	NVDA	Stock	0.089	0.0901	0.0888	0.0888	1255080.0
2002-08-16 08:00:00	AMZN	Stock	0.728	0.731	0.728	0.731	22000.0
2002-08-16 09:00:00	AMZN	Stock	0.7315	0.7325	0.7155	0.7285	9169860.0
2002-08-16 10:00:00	AMZN	Stock	0.729	0.7475	0.7255	0.7447	16825520.0
2002-08-16 11:00:00	AMZN	Stock	0.744	0.7495	0.7375	0.7435	12043740.0
2002-08-16 12:00:00	AMZN	Stock	0.744	0.7485	0.7415	0.746	5726120.0
2002-08-16 13:00:00	AMZN	Stock	0.7465	0.7495	0.7445	0.7485	3914000.0
2002-08-16 14:00:00	AMZN	Stock	0.748	0.749	0.7445	0.7465	3505920.0
2002-08-16 15:00:00	AMZN	Stock	0.7475	0.7505	0.7405	0.7445	17022820.0
2002-08-16 16:00:00	AMZN	Stock	0.7445	0.753	0.7435	0.749	2075000.0
2002-08-16 17:00:00	AMZN	Stock	0.745	0.7465	0.745	0.745	412000.0
2002-08-16 18:00:00	AMZN	Stock	0.7455	0.7455	0.745	0.745	12000.0
2002-08-16 09:00:00	CL	Stock	26.95	27.005	26.75	27.0	793200.0
2002-08-16 10:00:00	CL	Stock	27.0	27.25	26.975	27.05	695200.0
2002-08-16 11:00:00	CL	Stock	27.055	27.24	27.05	27.11	473200.0
2002-08-16 12:00:00	CL	Stock	27.115	27.125	26.875	26.94	322200.0
2002-08-16 13:00:00	CL	Stock	26.92	27.065	26.9	26.93	229000.0
2002-08-16 14:00:00	CL	Stock	26.95	27.175	26.915	27.15	415800.0

> showing 50 of 18,341 rows — these rows as CSV

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