PREVIEW / stock_1hour / 2005-12-23

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-12-23.parquet
  size:    545 KB
  rows:    26,417
  symbols: 2,154

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-23 04:00:00	AAPL	Stock	2.6518	2.6518	2.6518	2.6518	16800.0
2005-12-23 08:00:00	AAPL	Stock	2.6411	2.6482	2.6393	2.6396	847364.0
2005-12-23 09:00:00	AAPL	Stock	2.6396	2.6521	2.6325	2.6443	41845664.0
2005-12-23 10:00:00	AAPL	Stock	2.6446	2.6446	2.625	2.6293	56094304.0
2005-12-23 11:00:00	AAPL	Stock	2.6293	2.6314	2.6186	2.6239	36244656.0
2005-12-23 12:00:00	AAPL	Stock	2.6246	2.6282	2.6207	2.6264	22952384.0
2005-12-23 13:00:00	AAPL	Stock	2.6264	2.6304	2.6225	2.6236	16560880.0
2005-12-23 14:00:00	AAPL	Stock	2.6239	2.6275	2.6179	2.6268	19918864.0
2005-12-23 15:00:00	AAPL	Stock	2.6268	2.6286	2.6196	2.6196	32771592.0
2005-12-23 16:00:00	AAPL	Stock	2.6204	2.6204	2.6161	2.6179	565712.0
2005-12-23 17:00:00	AAPL	Stock	2.6196	2.6207	2.6179	2.6207	53200.0
2005-12-23 18:00:00	AAPL	Stock	2.6196	2.6196	2.6171	2.6171	127400.0
2005-12-23 08:00:00	MSFT	Stock	26.5	26.54	26.5	26.52	21156.0
2005-12-23 09:00:00	MSFT	Stock	26.52	26.63	26.44	26.59	4161571.0
2005-12-23 10:00:00	MSFT	Stock	26.6	26.6	26.51	26.56	4650888.0
2005-12-23 11:00:00	MSFT	Stock	26.56	26.61	26.55	26.59	3422279.0
2005-12-23 12:00:00	MSFT	Stock	26.599	26.6	26.49	26.54	4574131.0
2005-12-23 13:00:00	MSFT	Stock	26.54	26.58	26.5	26.58	3305839.0
2005-12-23 14:00:00	MSFT	Stock	26.57	26.63	26.53	26.62	3603973.0
2005-12-23 15:00:00	MSFT	Stock	26.63	26.67	26.6	26.64	6153442.0
2005-12-23 16:00:00	MSFT	Stock	26.65	26.67	26.6	26.6	76060.0
2005-12-23 17:00:00	MSFT	Stock	26.64	26.64	26.64	26.64	700.0
2005-12-23 18:00:00	MSFT	Stock	26.64	26.64	26.64	26.64	425.0
2005-12-23 08:00:00	NVDA	Stock	0.3105	0.3105	0.3105	0.3105	12000.0
2005-12-23 09:00:00	NVDA	Stock	0.3033	0.3125	0.3033	0.312	33091080.0
2005-12-23 10:00:00	NVDA	Stock	0.3121	0.3123	0.3096	0.311	42315360.0
2005-12-23 11:00:00	NVDA	Stock	0.3111	0.3117	0.3109	0.3112	20349360.0
2005-12-23 12:00:00	NVDA	Stock	0.3112	0.3112	0.3102	0.311	14756280.0
2005-12-23 13:00:00	NVDA	Stock	0.3111	0.3113	0.3102	0.3109	21423720.0
2005-12-23 14:00:00	NVDA	Stock	0.3109	0.3118	0.3107	0.3117	14614200.0
2005-12-23 15:00:00	NVDA	Stock	0.3117	0.3132	0.3114	0.3127	62848680.0
2005-12-23 16:00:00	NVDA	Stock	0.3128	0.3128	0.3127	0.3128	144000.0
2005-12-23 17:00:00	NVDA	Stock	0.3133	0.3133	0.3133	0.3133	210240.0
2005-12-23 08:00:00	AMZN	Stock	2.457	2.4575	2.454	2.454	28000.0
2005-12-23 09:00:00	AMZN	Stock	2.454	2.465	2.4505	2.46	8368060.0
2005-12-23 10:00:00	AMZN	Stock	2.46	2.4625	2.4535	2.4605	8170860.0
2005-12-23 11:00:00	AMZN	Stock	2.4605	2.4695	2.456	2.458	7462580.0
2005-12-23 12:00:00	AMZN	Stock	2.4575	2.458	2.436	2.4395	13490020.0
2005-12-23 13:00:00	AMZN	Stock	2.4395	2.4465	2.439	2.444	8244320.0
2005-12-23 14:00:00	AMZN	Stock	2.4445	2.4605	2.444	2.459	7176440.0
2005-12-23 15:00:00	AMZN	Stock	2.459	2.4615	2.4515	2.461	10670000.0
2005-12-23 16:00:00	AMZN	Stock	2.461	2.462	2.458	2.462	58580.0
2005-12-23 17:00:00	AMZN	Stock	2.462	2.462	2.462	2.462	4000.0
2005-12-23 09:00:00	CL	Stock	27.8	27.825	27.725	27.77	168600.0
2005-12-23 10:00:00	CL	Stock	27.77	27.77	27.605	27.675	292000.0
2005-12-23 11:00:00	CL	Stock	27.675	27.81	27.675	27.805	142800.0
2005-12-23 12:00:00	CL	Stock	27.795	27.81	27.735	27.75	146200.0
2005-12-23 13:00:00	CL	Stock	27.75	27.77	27.705	27.73	133200.0
2005-12-23 14:00:00	CL	Stock	27.73	27.78	27.695	27.72	161400.0
2005-12-23 15:00:00	CL	Stock	27.72	27.775	27.715	27.765	280000.0

> showing 50 of 26,417 rows — these rows as CSV

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