PREVIEW / stock_1hour / 2005-09-22

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-09-22.parquet
  size:    585 KB
  rows:    28,092
  symbols: 2,078

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-22 08:00:00	AAPL	Stock	1.8571	1.8604	1.8443	1.8604	512400.0
2005-09-22 09:00:00	AAPL	Stock	1.8539	1.8589	1.8329	1.8475	65510396.0
2005-09-22 10:00:00	AAPL	Stock	1.8479	1.8675	1.8471	1.8496	94335416.0
2005-09-22 11:00:00	AAPL	Stock	1.85	1.8575	1.8411	1.8482	57146796.0
2005-09-22 12:00:00	AAPL	Stock	1.8475	1.8639	1.8407	1.8607	44985472.0
2005-09-22 13:00:00	AAPL	Stock	1.8604	1.8739	1.8546	1.8625	65404808.0
2005-09-22 14:00:00	AAPL	Stock	1.8621	1.8646	1.8439	1.8525	59240216.0
2005-09-22 15:00:00	AAPL	Stock	1.8525	1.8604	1.8489	1.8539	61267220.0
2005-09-22 16:00:00	AAPL	Stock	1.8536	1.8542	1.8489	1.8521	1617980.0
2005-09-22 17:00:00	AAPL	Stock	1.8521	1.8525	1.8496	1.8525	549864.0
2005-09-22 18:00:00	AAPL	Stock	1.8536	1.8568	1.8404	1.8568	308280.0
2005-09-22 08:00:00	MSFT	Stock	25.5	25.52	25.45	25.48	11935.0
2005-09-22 09:00:00	MSFT	Stock	25.46	25.55	25.25	25.34	7923241.0
2005-09-22 10:00:00	MSFT	Stock	25.35	25.47	25.2	25.24	12279488.0
2005-09-22 11:00:00	MSFT	Stock	25.25	25.47	25.21	25.22	9094869.0
2005-09-22 12:00:00	MSFT	Stock	25.22	25.4	25.15	25.4	8736266.0
2005-09-22 13:00:00	MSFT	Stock	25.4	25.6	25.35	25.49	10857431.0
2005-09-22 14:00:00	MSFT	Stock	25.49	25.55	25.4	25.44	6765572.0
2005-09-22 15:00:00	MSFT	Stock	25.44	25.45	25.33	25.33	11701501.0
2005-09-22 16:00:00	MSFT	Stock	25.35	25.385	25.33	25.37	276513.0
2005-09-22 17:00:00	MSFT	Stock	25.36	25.36	25.24	25.31	498205.0
2005-09-22 18:00:00	MSFT	Stock	25.31	25.34	25.29	25.29	9400.0
2005-09-22 09:00:00	NVDA	Stock	0.2762	0.2767	0.2689	0.2717	92473440.0
2005-09-22 10:00:00	NVDA	Stock	0.2719	0.2733	0.2682	0.2682	148859640.0
2005-09-22 11:00:00	NVDA	Stock	0.2682	0.2757	0.268	0.2681	70234560.0
2005-09-22 12:00:00	NVDA	Stock	0.2681	0.2687	0.2637	0.2683	145067520.0
2005-09-22 13:00:00	NVDA	Stock	0.2683	0.2711	0.2675	0.2683	81345360.0
2005-09-22 14:00:00	NVDA	Stock	0.2682	0.2706	0.2661	0.2671	77578080.0
2005-09-22 15:00:00	NVDA	Stock	0.2671	0.2732	0.267	0.2683	104186160.0
2005-09-22 16:00:00	NVDA	Stock	0.2682	0.2691	0.2681	0.2687	2958240.0
2005-09-22 17:00:00	NVDA	Stock	0.269	0.269	0.269	0.269	24000.0
2005-09-22 08:00:00	AMZN	Stock	2.06	2.06	2.06	2.06	4000.0
2005-09-22 09:00:00	AMZN	Stock	2.0575	2.09	2.025	2.0845	18519460.0
2005-09-22 10:00:00	AMZN	Stock	2.0845	2.1085	2.0715	2.076	20540280.0
2005-09-22 11:00:00	AMZN	Stock	2.0765	2.0865	2.0625	2.069	8667940.0
2005-09-22 12:00:00	AMZN	Stock	2.069	2.0785	2.059	2.0785	7508140.0
2005-09-22 13:00:00	AMZN	Stock	2.0785	2.1135	2.0775	2.0995	14239800.0
2005-09-22 14:00:00	AMZN	Stock	2.1	2.106	2.0865	2.096	13832180.0
2005-09-22 15:00:00	AMZN	Stock	2.096	2.1075	2.094	2.1075	24732360.0
2005-09-22 16:00:00	AMZN	Stock	2.104	2.105	2.0828	2.1025	420760.0
2005-09-22 17:00:00	AMZN	Stock	2.104	2.1065	2.103	2.1065	25440.0
2005-09-22 08:00:00	CL	Stock	25.975	25.975	25.975	25.975	32000.0
2005-09-22 09:00:00	CL	Stock	25.85	25.98	25.73	25.785	495000.0
2005-09-22 10:00:00	CL	Stock	25.785	25.825	25.665	25.745	672600.0
2005-09-22 11:00:00	CL	Stock	25.745	25.8	25.71	25.74	426800.0
2005-09-22 12:00:00	CL	Stock	25.74	25.82	25.725	25.79	559400.0
2005-09-22 13:00:00	CL	Stock	25.785	25.92	25.785	25.905	567400.0
2005-09-22 14:00:00	CL	Stock	25.91	25.94	25.865	25.9185	433200.0
2005-09-22 15:00:00	CL	Stock	25.92	26.055	25.915	25.995	757800.0
2005-09-22 16:00:00	CL	Stock	25.8485	25.985	25.8485	25.985	75600.0

> showing 50 of 28,092 rows — these rows as CSV

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