PREVIEW / stock_1hour / 2005-09-23

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-09-23.parquet
  size:    552 KB
  rows:    26,037
  symbols: 2,074

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-09-23 08:00:00	AAPL	Stock	1.8571	1.8682	1.855	1.8643	987616.0
2005-09-23 09:00:00	AAPL	Stock	1.8643	1.8689	1.8514	1.8675	57538404.0
2005-09-23 10:00:00	AAPL	Stock	1.8671	1.8786	1.8636	1.875	87859156.0
2005-09-23 11:00:00	AAPL	Stock	1.875	1.9014	1.8736	1.8993	100450252.0
2005-09-23 12:00:00	AAPL	Stock	1.8993	1.9039	1.8825	1.89	65630852.0
2005-09-23 13:00:00	AAPL	Stock	1.89	1.9086	1.8896	1.9054	68183584.0
2005-09-23 14:00:00	AAPL	Stock	1.9054	1.9107	1.8982	1.9089	61793228.0
2005-09-23 15:00:00	AAPL	Stock	1.9089	1.91	1.8975	1.9004	106907752.0
2005-09-23 16:00:00	AAPL	Stock	1.9014	1.905	1.9	1.9011	1024464.0
2005-09-23 17:00:00	AAPL	Stock	1.9	1.9032	1.8982	1.9011	363804.0
2005-09-23 18:00:00	AAPL	Stock	1.9032	1.9032	1.9004	1.9004	46256.0
2005-09-23 08:00:00	MSFT	Stock	25.3	25.3	25.24	25.27	36198.0
2005-09-23 09:00:00	MSFT	Stock	25.29	25.55	25.249	25.43	7152053.0
2005-09-23 10:00:00	MSFT	Stock	25.43	25.54	25.3	25.35	10114792.0
2005-09-23 11:00:00	MSFT	Stock	25.36	25.43	25.33	25.38	7326085.0
2005-09-23 12:00:00	MSFT	Stock	25.371	25.4	25.23	25.24	4717294.0
2005-09-23 13:00:00	MSFT	Stock	25.24	25.4	25.22	25.28	10412858.0
2005-09-23 14:00:00	MSFT	Stock	25.29	25.291	25.16	25.2	9141898.0
2005-09-23 15:00:00	MSFT	Stock	25.2	25.32	25.12	25.28	15435668.0
2005-09-23 16:00:00	MSFT	Stock	25.28	25.35	25.25	25.31	334647.0
2005-09-23 17:00:00	MSFT	Stock	25.27	25.36	25.27	25.27	123518.0
2005-09-23 18:00:00	MSFT	Stock	25.3	25.31	25.27	25.31	800.0
2005-09-23 09:00:00	NVDA	Stock	0.2684	0.2699	0.2658	0.2667	39920160.0
2005-09-23 10:00:00	NVDA	Stock	0.2667	0.2706	0.2665	0.2703	69932880.0
2005-09-23 11:00:00	NVDA	Stock	0.2706	0.2711	0.269	0.2709	41192640.0
2005-09-23 12:00:00	NVDA	Stock	0.2708	0.2717	0.2703	0.2716	14046000.0
2005-09-23 13:00:00	NVDA	Stock	0.2716	0.2721	0.2712	0.2721	21759960.0
2005-09-23 14:00:00	NVDA	Stock	0.2721	0.2749	0.2717	0.2745	43273320.0
2005-09-23 15:00:00	NVDA	Stock	0.2746	0.2746	0.2717	0.2726	74305320.0
2005-09-23 16:00:00	NVDA	Stock	0.2724	0.2726	0.2721	0.2724	353760.0
2005-09-23 18:00:00	NVDA	Stock	0.2723	0.2723	0.2722	0.2722	36000.0
2005-09-23 09:00:00	AMZN	Stock	2.1	2.114	2.0855	2.086	8112620.0
2005-09-23 10:00:00	AMZN	Stock	2.086	2.0975	2.0775	2.0875	11080020.0
2005-09-23 11:00:00	AMZN	Stock	2.088	2.105	2.088	2.099	7895020.0
2005-09-23 12:00:00	AMZN	Stock	2.098	2.1015	2.087	2.0925	4353920.0
2005-09-23 13:00:00	AMZN	Stock	2.092	2.131	2.0915	2.13	10987080.0
2005-09-23 14:00:00	AMZN	Stock	2.13	2.131	2.1175	2.1205	7556220.0
2005-09-23 15:00:00	AMZN	Stock	2.1205	2.121	2.106	2.109	11648300.0
2005-09-23 16:00:00	AMZN	Stock	2.1105	2.1125	2.1095	2.1125	116660.0
2005-09-23 17:00:00	AMZN	Stock	2.1125	2.1125	2.1125	2.1125	20000.0
2005-09-23 18:00:00	AMZN	Stock	2.1125	2.1345	2.1125	2.1345	22000.0
2005-09-23 09:00:00	CL	Stock	26.07	26.175	26.02	26.0715	239200.0
2005-09-23 10:00:00	CL	Stock	26.07	26.105	25.83	25.95	591200.0
2005-09-23 11:00:00	CL	Stock	25.95	26.0	25.875	25.99	246600.0
2005-09-23 12:00:00	CL	Stock	25.99	26.0	25.87	25.98	250600.0
2005-09-23 13:00:00	CL	Stock	25.985	26.115	25.945	26.095	265000.0
2005-09-23 14:00:00	CL	Stock	26.095	26.12	26.055	26.085	192200.0
2005-09-23 15:00:00	CL	Stock	26.085	26.09	26.02	26.045	359000.0

> showing 48 of 26,037 rows — these rows as CSV

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