PREVIEW / stock_1hour / 2005-07-08

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-07-08.parquet
  size:    556 KB
  rows:    26,394
  symbols: 2,025

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
2005-07-08 08:00:00	AAPL	Stock	1.35	1.355	1.345	1.3525	971180.0
2005-07-08 09:00:00	AAPL	Stock	1.3525	1.3543	1.3432	1.3464	41261500.0
2005-07-08 10:00:00	AAPL	Stock	1.3468	1.3475	1.3382	1.3432	46713548.0
2005-07-08 11:00:00	AAPL	Stock	1.3436	1.3436	1.3393	1.3418	24875172.0
2005-07-08 12:00:00	AAPL	Stock	1.3418	1.3557	1.3414	1.3521	35804664.0
2005-07-08 13:00:00	AAPL	Stock	1.3521	1.3546	1.3475	1.3539	21489468.0
2005-07-08 14:00:00	AAPL	Stock	1.3539	1.3636	1.3532	1.3611	38974376.0
2005-07-08 15:00:00	AAPL	Stock	1.3611	1.3671	1.3589	1.3661	72562112.0
2005-07-08 16:00:00	AAPL	Stock	1.3654	1.3714	1.3618	1.3704	3444952.0
2005-07-08 17:00:00	AAPL	Stock	1.3679	1.3686	1.3664	1.3686	102480.0
2005-07-08 18:00:00	AAPL	Stock	1.3679	1.3679	1.3679	1.3679	28000.0
2005-07-08 08:00:00	MSFT	Stock	24.74	24.74	24.68	24.7	39135.0
2005-07-08 09:00:00	MSFT	Stock	24.71	24.73	24.61	24.68	5252774.0
2005-07-08 10:00:00	MSFT	Stock	24.682	24.75	24.66	24.72	6418281.0
2005-07-08 11:00:00	MSFT	Stock	24.72	24.74	24.66	24.72	5891040.0
2005-07-08 12:00:00	MSFT	Stock	24.72	24.91	24.71	24.86	8245916.0
2005-07-08 13:00:00	MSFT	Stock	24.86	24.92	24.82	24.89	5585157.0
2005-07-08 14:00:00	MSFT	Stock	24.9	25.05	24.88	25.02	9037149.0
2005-07-08 15:00:00	MSFT	Stock	25.02	25.121	25.01	25.08	10915569.0
2005-07-08 16:00:00	MSFT	Stock	25.09	25.17	24.847	25.1	2500630.0
2005-07-08 17:00:00	MSFT	Stock	25.09	25.09	25.09	25.09	5126.0
2005-07-08 18:00:00	MSFT	Stock	25.08	25.08	25.08	25.08	300.0
2005-07-08 08:00:00	NVDA	Stock	0.2333	0.2344	0.2333	0.2338	249000.0
2005-07-08 09:00:00	NVDA	Stock	0.2337	0.2337	0.23	0.2301	45111120.0
2005-07-08 10:00:00	NVDA	Stock	0.2301	0.2317	0.23	0.2315	54048840.0
2005-07-08 11:00:00	NVDA	Stock	0.2316	0.2335	0.2308	0.2329	63337800.0
2005-07-08 12:00:00	NVDA	Stock	0.233	0.2352	0.2327	0.2341	83264280.0
2005-07-08 13:00:00	NVDA	Stock	0.2341	0.2342	0.2329	0.2337	38881680.0
2005-07-08 14:00:00	NVDA	Stock	0.2337	0.2347	0.2334	0.2342	35059920.0
2005-07-08 15:00:00	NVDA	Stock	0.2342	0.2346	0.2334	0.2345	73070760.0
2005-07-08 16:00:00	NVDA	Stock	0.2344	0.2345	0.2342	0.2345	2114520.0
2005-07-08 17:00:00	NVDA	Stock	0.2342	0.2343	0.2342	0.2343	151920.0
2005-07-08 08:00:00	AMZN	Stock	1.7	1.7	1.7	1.7	3640.0
2005-07-08 09:00:00	AMZN	Stock	1.703	1.7165	1.6925	1.709	8927200.0
2005-07-08 10:00:00	AMZN	Stock	1.709	1.718	1.7035	1.716	11923740.0
2005-07-08 11:00:00	AMZN	Stock	1.716	1.7205	1.7085	1.719	7771880.0
2005-07-08 12:00:00	AMZN	Stock	1.719	1.725	1.7165	1.719	13447560.0
2005-07-08 13:00:00	AMZN	Stock	1.719	1.7215	1.718	1.721	3725680.0
2005-07-08 14:00:00	AMZN	Stock	1.7215	1.7295	1.7215	1.729	11827820.0
2005-07-08 15:00:00	AMZN	Stock	1.729	1.7375	1.728	1.737	23322560.0
2005-07-08 16:00:00	AMZN	Stock	1.7355	1.738	1.731	1.737	2213920.0
2005-07-08 17:00:00	AMZN	Stock	1.738	1.738	1.738	1.738	2000.0
2005-07-08 09:00:00	CL	Stock	25.06	25.06	24.93	24.94	281200.0
2005-07-08 10:00:00	CL	Stock	24.935	25.02	24.89	25.0	517600.0
2005-07-08 11:00:00	CL	Stock	25.0	25.01	24.965	24.985	720600.0
2005-07-08 12:00:00	CL	Stock	24.985	25.08	24.985	25.07	541000.0
2005-07-08 13:00:00	CL	Stock	25.07	25.155	25.045	25.13	317600.0
2005-07-08 14:00:00	CL	Stock	25.13	25.185	25.1	25.175	489600.0
2005-07-08 15:00:00	CL	Stock	25.175	25.24	25.17	25.21	677000.0

> showing 49 of 26,394 rows — these rows as CSV

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