PREVIEW / stock_1hour / 2002-08-15

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-08-15.parquet
  size:    389 KB
  rows:    18,506
  symbols: 1,462

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-15 08:00:00	AAPL	Stock	0.2707	0.2839	0.2707	0.2718	277872.0
2002-08-15 09:00:00	AAPL	Stock	0.2718	0.2743	0.2682	0.2686	22669360.0
2002-08-15 10:00:00	AAPL	Stock	0.2684	0.2748	0.268	0.2746	47976040.0
2002-08-15 11:00:00	AAPL	Stock	0.2748	0.2802	0.2741	0.2788	51449552.0
2002-08-15 12:00:00	AAPL	Stock	0.2789	0.2795	0.2713	0.2725	35259560.0
2002-08-15 13:00:00	AAPL	Stock	0.2723	0.2775	0.2688	0.2773	35882392.0
2002-08-15 14:00:00	AAPL	Stock	0.2773	0.2807	0.275	0.2771	53490696.0
2002-08-15 15:00:00	AAPL	Stock	0.277	0.2813	0.2759	0.2784	43695568.0
2002-08-15 16:00:00	AAPL	Stock	0.2788	0.2807	0.2766	0.2793	3640000.0
2002-08-15 17:00:00	AAPL	Stock	0.2798	0.2813	0.2788	0.2796	481600.0
2002-08-15 18:00:00	AAPL	Stock	0.2796	0.2796	0.2796	0.2796	11200.0
2002-08-15 08:00:00	MSFT	Stock	25.1	25.245	24.995	25.125	186456.0
2002-08-15 09:00:00	MSFT	Stock	25.12	25.125	24.755	24.77	12906816.0
2002-08-15 10:00:00	MSFT	Stock	24.765	25.34	24.674	25.335	18536332.0
2002-08-15 11:00:00	MSFT	Stock	25.335	25.37	25.18	25.235	8763734.0
2002-08-15 12:00:00	MSFT	Stock	25.245	25.3025	24.75	24.79	16278878.0
2002-08-15 13:00:00	MSFT	Stock	24.785	24.786	24.375	24.685	12800090.0
2002-08-15 14:00:00	MSFT	Stock	24.685	24.92	24.545	24.62	11450780.0
2002-08-15 15:00:00	MSFT	Stock	24.625	24.93	24.46	24.885	13953808.0
2002-08-15 16:00:00	MSFT	Stock	24.875	25.0405	24.775	24.875	1020020.0
2002-08-15 17:00:00	MSFT	Stock	24.5938	24.925	24.5938	24.85	93600.0
2002-08-15 18:00:00	MSFT	Stock	24.86	24.9	24.86	24.9	3200.0
2002-08-15 08:00:00	NVDA	Stock	0.082	0.0832	0.0816	0.0828	3822720.0
2002-08-15 09:00:00	NVDA	Stock	0.0828	0.0854	0.0818	0.0829	172489680.0
2002-08-15 10:00:00	NVDA	Stock	0.0829	0.0874	0.0823	0.086	246400080.0
2002-08-15 11:00:00	NVDA	Stock	0.0861	0.0866	0.0848	0.0859	76153680.0
2002-08-15 12:00:00	NVDA	Stock	0.086	0.0864	0.0835	0.084	110539200.0
2002-08-15 13:00:00	NVDA	Stock	0.084	0.085	0.0825	0.0848	111267960.0
2002-08-15 14:00:00	NVDA	Stock	0.0848	0.0859	0.0844	0.0849	88517880.0
2002-08-15 15:00:00	NVDA	Stock	0.0849	0.0862	0.0837	0.0862	148600560.0
2002-08-15 16:00:00	NVDA	Stock	0.0861	0.0867	0.0793	0.0817	97933800.0
2002-08-15 17:00:00	NVDA	Stock	0.0817	0.0857	0.0802	0.0822	46100880.0
2002-08-15 18:00:00	NVDA	Stock	0.0824	0.0842	0.0823	0.0833	9777720.0
2002-08-15 08:00:00	AMZN	Stock	0.6958	0.712	0.6958	0.705	780000.0
2002-08-15 09:00:00	AMZN	Stock	0.705	0.7115	0.6965	0.7015	11327620.0
2002-08-15 10:00:00	AMZN	Stock	0.7015	0.7195	0.696	0.7195	20094260.0
2002-08-15 11:00:00	AMZN	Stock	0.7195	0.731	0.716	0.726	16413440.0
2002-08-15 12:00:00	AMZN	Stock	0.7265	0.7295	0.716	0.7165	11730080.0
2002-08-15 13:00:00	AMZN	Stock	0.7165	0.7255	0.705	0.725	8374540.0
2002-08-15 14:00:00	AMZN	Stock	0.7245	0.733	0.7245	0.7275	14559720.0
2002-08-15 15:00:00	AMZN	Stock	0.7275	0.7375	0.725	0.733	14614600.0
2002-08-15 16:00:00	AMZN	Stock	0.7325	0.7395	0.731	0.731	1032420.0
2002-08-15 17:00:00	AMZN	Stock	0.731	0.731	0.73	0.73	288000.0
2002-08-15 09:00:00	CL	Stock	27.215	27.22	27.11	27.15	236400.0
2002-08-15 10:00:00	CL	Stock	27.15	27.25	27.05	27.245	409200.0
2002-08-15 11:00:00	CL	Stock	27.245	27.27	27.135	27.25	321600.0
2002-08-15 12:00:00	CL	Stock	27.25	27.255	27.015	27.08	353600.0
2002-08-15 13:00:00	CL	Stock	27.07	27.22	27.06	27.16	184200.0
2002-08-15 14:00:00	CL	Stock	27.165	27.25	27.085	27.1	404400.0
2002-08-15 15:00:00	CL	Stock	27.095	27.365	27.075	27.34	699400.0

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

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