PREVIEW / stock_1hour / 2002-08-08

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-08-08.parquet
  size:    388 KB
  rows:    18,392
  symbols: 1,463

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-08 08:00:00	AAPL	Stock	0.2685	0.2696	0.2677	0.2677	728000.0
2002-08-08 09:00:00	AAPL	Stock	0.2675	0.2714	0.2638	0.2688	36364160.0
2002-08-08 10:00:00	AAPL	Stock	0.2688	0.2702	0.2657	0.2673	46140920.0
2002-08-08 11:00:00	AAPL	Stock	0.267	0.2704	0.267	0.2695	22421112.0
2002-08-08 12:00:00	AAPL	Stock	0.2695	0.2696	0.2639	0.2654	17334912.0
2002-08-08 13:00:00	AAPL	Stock	0.2654	0.2705	0.2645	0.2691	25470872.0
2002-08-08 14:00:00	AAPL	Stock	0.2689	0.2729	0.2684	0.2729	30569392.0
2002-08-08 15:00:00	AAPL	Stock	0.2727	0.2746	0.2713	0.273	39787216.0
2002-08-08 16:00:00	AAPL	Stock	0.2736	0.2736	0.2729	0.2732	1898400.0
2002-08-08 17:00:00	AAPL	Stock	0.2707	0.2732	0.2707	0.2721	1355200.0
2002-08-08 08:00:00	MSFT	Stock	23.875	23.965	23.105	23.655	369470.0
2002-08-08 09:00:00	MSFT	Stock	23.66	23.8	23.205	23.565	14311536.0
2002-08-08 10:00:00	MSFT	Stock	23.555	23.665	23.21	23.345	14973862.0
2002-08-08 11:00:00	MSFT	Stock	23.345	23.975	23.345	23.935	13042166.0
2002-08-08 12:00:00	MSFT	Stock	23.93	23.94	23.745	23.805	6839820.0
2002-08-08 13:00:00	MSFT	Stock	23.805	24.25	23.795	24.145	11215768.0
2002-08-08 14:00:00	MSFT	Stock	24.14	24.485	24.12	24.44	11892066.0
2002-08-08 15:00:00	MSFT	Stock	24.445	24.5025	24.25	24.45	13730430.0
2002-08-08 16:00:00	MSFT	Stock	24.45	24.505	24.385	24.385	1681916.0
2002-08-08 17:00:00	MSFT	Stock	24.385	24.455	24.37	24.385	181600.0
2002-08-08 18:00:00	MSFT	Stock	24.385	24.4	24.385	24.39	6900.0
2002-08-08 08:00:00	NVDA	Stock	0.0739	0.0759	0.0731	0.075	2635440.0
2002-08-08 09:00:00	NVDA	Stock	0.075	0.075	0.0725	0.0731	111064200.0
2002-08-08 10:00:00	NVDA	Stock	0.0731	0.0762	0.0729	0.0752	130531080.0
2002-08-08 11:00:00	NVDA	Stock	0.0751	0.0777	0.0751	0.076	108381720.0
2002-08-08 12:00:00	NVDA	Stock	0.0759	0.0765	0.0757	0.0762	36223560.0
2002-08-08 13:00:00	NVDA	Stock	0.0762	0.0783	0.0762	0.0773	73138680.0
2002-08-08 14:00:00	NVDA	Stock	0.0773	0.0791	0.0769	0.0786	85923480.0
2002-08-08 15:00:00	NVDA	Stock	0.0786	0.0798	0.0782	0.0786	154922640.0
2002-08-08 16:00:00	NVDA	Stock	0.0785	0.0791	0.0778	0.0779	44834400.0
2002-08-08 17:00:00	NVDA	Stock	0.0779	0.0785	0.0767	0.0768	3170400.0
2002-08-08 18:00:00	NVDA	Stock	0.0772	0.0775	0.0771	0.0771	132000.0
2002-08-08 08:00:00	AMZN	Stock	0.694	0.694	0.6704	0.6705	303000.0
2002-08-08 09:00:00	AMZN	Stock	0.6695	0.6735	0.653	0.656	16760900.0
2002-08-08 10:00:00	AMZN	Stock	0.6565	0.67	0.654	0.667	18399380.0
2002-08-08 11:00:00	AMZN	Stock	0.6665	0.6735	0.653	0.67	15255640.0
2002-08-08 12:00:00	AMZN	Stock	0.67	0.68	0.667	0.671	7953160.0
2002-08-08 13:00:00	AMZN	Stock	0.67	0.698	0.67	0.695	17579440.0
2002-08-08 14:00:00	AMZN	Stock	0.6935	0.6965	0.6824	0.6925	11830200.0
2002-08-08 15:00:00	AMZN	Stock	0.693	0.705	0.69	0.6935	19940760.0
2002-08-08 16:00:00	AMZN	Stock	0.694	0.7	0.6935	0.695	718000.0
2002-08-08 17:00:00	AMZN	Stock	0.6925	0.695	0.6925	0.695	468000.0
2002-08-08 09:00:00	CL	Stock	26.35	26.7	26.305	26.66	578800.0
2002-08-08 10:00:00	CL	Stock	26.65	26.75	26.5	26.57	630800.0
2002-08-08 11:00:00	CL	Stock	26.575	26.725	26.56	26.72	458600.0
2002-08-08 12:00:00	CL	Stock	26.72	26.75	26.625	26.68	359400.0
2002-08-08 13:00:00	CL	Stock	26.7	26.91	26.68	26.8	497800.0
2002-08-08 14:00:00	CL	Stock	26.8	26.825	26.675	26.75	368400.0
2002-08-08 15:00:00	CL	Stock	26.755	27.125	26.725	27.06	976200.0
2002-08-08 16:00:00	CL	Stock	27.06	27.065	27.06	27.065	75400.0

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

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