PREVIEW / stock_1hour / 2005-12-27

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-12-27.parquet
  size:    585 KB
  rows:    27,784
  symbols: 2,178

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-12-27 06:00:00	AAPL	Stock	2.6393	2.6393	2.6393	2.6393	8400.0
2005-12-27 07:00:00	AAPL	Stock	2.6429	2.6429	2.6286	2.6336	16800.0
2005-12-27 08:00:00	AAPL	Stock	2.6346	2.6479	2.6339	2.6429	2152080.0
2005-12-27 09:00:00	AAPL	Stock	2.6429	2.6589	2.6304	2.6532	65389492.0
2005-12-27 10:00:00	AAPL	Stock	2.6529	2.6782	2.65	2.6775	128331140.0
2005-12-27 11:00:00	AAPL	Stock	2.6775	2.685	2.6539	2.6568	128871932.0
2005-12-27 12:00:00	AAPL	Stock	2.6575	2.67	2.6521	2.6686	52033968.0
2005-12-27 13:00:00	AAPL	Stock	2.6682	2.6764	2.6518	2.6531	67413668.0
2005-12-27 14:00:00	AAPL	Stock	2.6529	2.6693	2.6514	2.6604	50880788.0
2005-12-27 15:00:00	AAPL	Stock	2.66	2.6632	2.6468	2.6507	83800836.0
2005-12-27 16:00:00	AAPL	Stock	2.6511	2.6511	2.6475	2.6507	2137408.0
2005-12-27 17:00:00	AAPL	Stock	2.6511	2.6568	2.6507	2.6536	176316.0
2005-12-27 18:00:00	AAPL	Stock	2.6525	2.6525	2.6482	2.6511	336980.0
2005-12-27 08:00:00	MSFT	Stock	26.74	26.74	26.62	26.7	16829.0
2005-12-27 09:00:00	MSFT	Stock	26.68	26.85	26.62	26.83	3736769.0
2005-12-27 10:00:00	MSFT	Stock	26.82	26.84	26.77	26.78	4369755.0
2005-12-27 11:00:00	MSFT	Stock	26.78	26.79	26.59	26.6	6738857.0
2005-12-27 12:00:00	MSFT	Stock	26.6	26.66	26.58	26.63	3546350.0
2005-12-27 13:00:00	MSFT	Stock	26.62	26.65	26.52	26.55	4765338.0
2005-12-27 14:00:00	MSFT	Stock	26.55	26.6	26.5	26.54	4466269.0
2005-12-27 15:00:00	MSFT	Stock	26.54	26.55	26.45	26.46	8386213.0
2005-12-27 16:00:00	MSFT	Stock	26.47	26.536	26.43	26.46	461218.0
2005-12-27 17:00:00	MSFT	Stock	26.46	26.54	26.45	26.48	84113.0
2005-12-27 18:00:00	MSFT	Stock	26.5	26.51	26.5	26.51	3200.0
2005-12-27 09:00:00	NVDA	Stock	0.3133	0.3177	0.3123	0.3161	48362640.0
2005-12-27 10:00:00	NVDA	Stock	0.3162	0.3182	0.3158	0.3177	53993880.0
2005-12-27 11:00:00	NVDA	Stock	0.3177	0.3179	0.3115	0.3131	80373240.0
2005-12-27 12:00:00	NVDA	Stock	0.3131	0.315	0.3122	0.314	28982880.0
2005-12-27 13:00:00	NVDA	Stock	0.3141	0.3151	0.3132	0.3138	27763680.0
2005-12-27 14:00:00	NVDA	Stock	0.3138	0.3162	0.3137	0.3155	32494200.0
2005-12-27 15:00:00	NVDA	Stock	0.3155	0.3169	0.3145	0.3148	77960520.0
2005-12-27 16:00:00	NVDA	Stock	0.3147	0.3148	0.3147	0.3148	500160.0
2005-12-27 17:00:00	NVDA	Stock	0.3147	0.3147	0.3147	0.3147	276000.0
2005-12-27 18:00:00	NVDA	Stock	0.3147	0.3147	0.3147	0.3147	31560.0
2005-12-27 07:00:00	AMZN	Stock	2.49	2.49	2.4625	2.4625	12000.0
2005-12-27 08:00:00	AMZN	Stock	2.49	2.49	2.465	2.469	627000.0
2005-12-27 09:00:00	AMZN	Stock	2.47	2.47	2.427	2.4305	19495880.0
2005-12-27 10:00:00	AMZN	Stock	2.431	2.4425	2.4225	2.4355	20177120.0
2005-12-27 11:00:00	AMZN	Stock	2.436	2.441	2.4225	2.426	15480000.0
2005-12-27 12:00:00	AMZN	Stock	2.426	2.439	2.418	2.4355	15313720.0
2005-12-27 13:00:00	AMZN	Stock	2.4355	2.438	2.4215	2.424	9969780.0
2005-12-27 14:00:00	AMZN	Stock	2.4235	2.435	2.423	2.432	8356560.0
2005-12-27 15:00:00	AMZN	Stock	2.432	2.4395	2.422	2.428	14280300.0
2005-12-27 16:00:00	AMZN	Stock	2.426	2.438	2.4215	2.423	10656720.0
2005-12-27 18:00:00	AMZN	Stock	2.4245	2.4245	2.4245	2.4245	10000.0
2005-12-27 09:00:00	CL	Stock	27.75	27.77	27.62	27.685	192600.0
2005-12-27 10:00:00	CL	Stock	27.7	27.74	27.67	27.725	209800.0
2005-12-27 11:00:00	CL	Stock	27.73	27.75	27.675	27.69	299600.0
2005-12-27 12:00:00	CL	Stock	27.68	27.685	27.585	27.6	223000.0
2005-12-27 13:00:00	CL	Stock	27.605	27.605	27.485	27.505	305600.0

> showing 50 of 27,784 rows — these rows as CSV

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