PREVIEW / stock_1hour / 2002-07-31

all stock 1-hour files

  file:    by_date/stock_1hour/2002/2002-07-31.parquet
  size:    412 KB
  rows:    19,032
  symbols: 1,459

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-07-31 08:00:00	AAPL	Stock	0.2759	0.2759	0.2682	0.2732	1461600.0
2002-07-31 09:00:00	AAPL	Stock	0.275	0.2752	0.2675	0.2688	31761296.0
2002-07-31 10:00:00	AAPL	Stock	0.2688	0.2695	0.2666	0.2677	39772096.0
2002-07-31 11:00:00	AAPL	Stock	0.2679	0.2698	0.2661	0.2675	42901040.0
2002-07-31 12:00:00	AAPL	Stock	0.2675	0.2689	0.267	0.2689	26396496.0
2002-07-31 13:00:00	AAPL	Stock	0.2689	0.272	0.268	0.2704	34467048.0
2002-07-31 14:00:00	AAPL	Stock	0.2704	0.2713	0.2688	0.2688	40788160.0
2002-07-31 15:00:00	AAPL	Stock	0.2688	0.275	0.2671	0.2725	61313560.0
2002-07-31 16:00:00	AAPL	Stock	0.2723	0.2732	0.2702	0.2725	13908720.0
2002-07-31 17:00:00	AAPL	Stock	0.2725	0.2725	0.2679	0.2725	2711688.0
2002-07-31 08:00:00	MSFT	Stock	24.05	24.28	23.695	24.02	268992.0
2002-07-31 09:00:00	MSFT	Stock	23.785	24.02	23.53	23.7645	9608430.0
2002-07-31 10:00:00	MSFT	Stock	23.77	23.77	23.275	23.455	16727154.0
2002-07-31 11:00:00	MSFT	Stock	23.45	23.68	23.39	23.665	8251948.0
2002-07-31 12:00:00	MSFT	Stock	23.665	23.78	23.375	23.48	9049458.0
2002-07-31 13:00:00	MSFT	Stock	23.48	23.5	23.26	23.2955	7609852.0
2002-07-31 14:00:00	MSFT	Stock	23.295	23.49	23.18	23.34	12917162.0
2002-07-31 15:00:00	MSFT	Stock	23.33	23.965	23.255	23.955	20093074.0
2002-07-31 16:00:00	MSFT	Stock	23.96	24.015	23.475	23.99	10039660.0
2002-07-31 17:00:00	MSFT	Stock	23.86	23.99	23.825	23.87	22600.0
2002-07-31 18:00:00	MSFT	Stock	23.845	23.865	23.835	23.85	9400.0
2002-07-31 08:00:00	NVDA	Stock	0.1062	0.1329	0.1	0.1002	181513080.0
2002-07-31 09:00:00	NVDA	Stock	0.1004	0.1084	0.0937	0.0947	1147643280.0
2002-07-31 10:00:00	NVDA	Stock	0.0946	0.095	0.0912	0.0939	990068880.0
2002-07-31 11:00:00	NVDA	Stock	0.0938	0.0947	0.0925	0.093	372278280.0
2002-07-31 12:00:00	NVDA	Stock	0.0931	0.0954	0.0927	0.0939	423622440.0
2002-07-31 13:00:00	NVDA	Stock	0.0939	0.0943	0.0918	0.0926	499106280.0
2002-07-31 14:00:00	NVDA	Stock	0.0926	0.0938	0.0922	0.0932	290985960.0
2002-07-31 15:00:00	NVDA	Stock	0.0932	0.0946	0.0913	0.0921	725779440.0
2002-07-31 16:00:00	NVDA	Stock	0.0923	0.0997	0.0906	0.092	55322520.0
2002-07-31 17:00:00	NVDA	Stock	0.0918	0.0987	0.0918	0.0922	2853600.0
2002-07-31 18:00:00	NVDA	Stock	0.0922	0.0922	0.0919	0.0921	1523400.0
2002-07-31 08:00:00	AMZN	Stock	0.7388	0.7395	0.726	0.73	80600.0
2002-07-31 09:00:00	AMZN	Stock	0.7256	0.733	0.7165	0.722	10027960.0
2002-07-31 10:00:00	AMZN	Stock	0.7215	0.7295	0.7175	0.729	19306960.0
2002-07-31 11:00:00	AMZN	Stock	0.7285	0.729	0.7205	0.7235	6554600.0
2002-07-31 12:00:00	AMZN	Stock	0.724	0.727	0.722	0.7235	5951160.0
2002-07-31 13:00:00	AMZN	Stock	0.723	0.723	0.7105	0.7125	7794460.0
2002-07-31 14:00:00	AMZN	Stock	0.7125	0.7155	0.707	0.7105	8716420.0
2002-07-31 15:00:00	AMZN	Stock	0.711	0.7265	0.7095	0.7245	14157520.0
2002-07-31 16:00:00	AMZN	Stock	0.7225	0.723	0.718	0.723	1448000.0
2002-07-31 17:00:00	AMZN	Stock	0.718	0.718	0.718	0.718	32000.0
2002-07-31 18:00:00	AMZN	Stock	0.723	0.723	0.718	0.723	422000.0
2002-07-31 09:00:00	CL	Stock	25.65	25.715	25.49	25.505	703600.0
2002-07-31 10:00:00	CL	Stock	25.5	25.685	25.275	25.295	1000400.0
2002-07-31 11:00:00	CL	Stock	25.295	25.555	25.295	25.53	592000.0
2002-07-31 12:00:00	CL	Stock	25.5	25.615	25.45	25.545	607400.0
2002-07-31 13:00:00	CL	Stock	25.545	25.55	25.275	25.33	533800.0
2002-07-31 14:00:00	CL	Stock	25.325	25.405	24.94	25.095	1203800.0
2002-07-31 15:00:00	CL	Stock	25.095	25.69	25.025	25.61	1486800.0

> showing 50 of 19,032 rows — these rows as CSV

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