PREVIEW / stock_1hour / 2006-07-06

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-07-06.parquet
  size:    594 KB
  rows:    28,477
  symbols: 2,298

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
2006-07-06 05:00:00	AAPL	Stock	2.0286	2.0286	2.0286	2.0286	22400.0
2006-07-06 06:00:00	AAPL	Stock	2.0357	2.0357	2.0357	2.0357	19600.0
2006-07-06 07:00:00	AAPL	Stock	2.0286	2.0286	2.0286	2.0286	5600.0
2006-07-06 08:00:00	AAPL	Stock	2.0357	2.0393	2.0261	2.035	736568.0
2006-07-06 09:00:00	AAPL	Stock	2.0346	2.0489	2.0211	2.0218	74766636.0
2006-07-06 10:00:00	AAPL	Stock	2.0214	2.05	2.0064	2.0111	149637796.0
2006-07-06 11:00:00	AAPL	Stock	2.0111	2.0404	1.9971	1.9996	91102480.0
2006-07-06 12:00:00	AAPL	Stock	2.0	2.0229	1.9964	2.0071	79140460.0
2006-07-06 13:00:00	AAPL	Stock	2.0071	2.0089	2.0011	2.0021	39236568.0
2006-07-06 14:00:00	AAPL	Stock	2.0021	2.0025	1.9861	1.9882	80560396.0
2006-07-06 15:00:00	AAPL	Stock	1.9879	1.9993	1.9864	1.9921	105375172.0
2006-07-06 16:00:00	AAPL	Stock	1.9914	1.9918	1.9825	1.9886	4214616.0
2006-07-06 17:00:00	AAPL	Stock	1.9879	1.9893	1.9875	1.9889	309764.0
2006-07-06 18:00:00	AAPL	Stock	1.9875	1.9907	1.9875	1.9896	154140.0
2006-07-06 08:00:00	MSFT	Stock	23.35	23.41	23.33	23.36	52797.0
2006-07-06 09:00:00	MSFT	Stock	23.35	23.5	23.31	23.47	4978098.0
2006-07-06 10:00:00	MSFT	Stock	23.47	23.57	23.45	23.54	9692399.0
2006-07-06 11:00:00	MSFT	Stock	23.55	23.61	23.47	23.48	6246880.0
2006-07-06 12:00:00	MSFT	Stock	23.48	23.55	23.48	23.51	3891720.0
2006-07-06 13:00:00	MSFT	Stock	23.51	23.56	23.5	23.5	3052532.0
2006-07-06 14:00:00	MSFT	Stock	23.5	23.51	23.43	23.482	6705796.0
2006-07-06 15:00:00	MSFT	Stock	23.48	23.55	23.45	23.5	8799714.0
2006-07-06 16:00:00	MSFT	Stock	23.47	23.5	23.45	23.48	223190.0
2006-07-06 17:00:00	MSFT	Stock	23.48	23.48	23.48	23.48	1700.0
2006-07-06 18:00:00	MSFT	Stock	23.48	23.48	23.48	23.48	650.0
2006-07-06 08:00:00	NVDA	Stock	0.345	0.3458	0.345	0.3458	120000.0
2006-07-06 09:00:00	NVDA	Stock	0.3458	0.3472	0.3402	0.3423	34283040.0
2006-07-06 10:00:00	NVDA	Stock	0.3423	0.3452	0.3407	0.3418	60622260.0
2006-07-06 11:00:00	NVDA	Stock	0.3417	0.3432	0.3382	0.3383	46321860.0
2006-07-06 12:00:00	NVDA	Stock	0.3383	0.3393	0.3353	0.3355	51957840.0
2006-07-06 13:00:00	NVDA	Stock	0.3355	0.3367	0.3335	0.3338	56114880.0
2006-07-06 14:00:00	NVDA	Stock	0.3338	0.3345	0.3303	0.332	83565360.0
2006-07-06 15:00:00	NVDA	Stock	0.3318	0.3343	0.3297	0.333	115364460.0
2006-07-06 16:00:00	NVDA	Stock	0.3332	0.3348	0.3328	0.3348	692340.0
2006-07-06 17:00:00	NVDA	Stock	0.3348	0.3348	0.3348	0.3348	24000.0
2006-07-06 18:00:00	NVDA	Stock	0.3345	0.3345	0.3345	0.3345	54000.0
2006-07-06 09:00:00	AMZN	Stock	1.8555	1.875	1.8535	1.8575	9276040.0
2006-07-06 10:00:00	AMZN	Stock	1.8575	1.887	1.857	1.87	14940000.0
2006-07-06 11:00:00	AMZN	Stock	1.87	1.88	1.8605	1.8605	8716780.0
2006-07-06 12:00:00	AMZN	Stock	1.8615	1.864	1.831	1.8385	16844100.0
2006-07-06 13:00:00	AMZN	Stock	1.8385	1.841	1.833	1.8375	9449080.0
2006-07-06 14:00:00	AMZN	Stock	1.838	1.84	1.826	1.8315	11960900.0
2006-07-06 15:00:00	AMZN	Stock	1.831	1.8415	1.8295	1.8395	12940020.0
2006-07-06 16:00:00	AMZN	Stock	1.8385	1.84	1.837	1.84	303600.0
2006-07-06 09:00:00	CL	Stock	29.95	30.075	29.93	30.06	246400.0
2006-07-06 10:00:00	CL	Stock	30.05	30.305	30.045	30.285	571800.0
2006-07-06 11:00:00	CL	Stock	30.285	30.45	30.24	30.325	750400.0
2006-07-06 12:00:00	CL	Stock	30.335	30.465	30.315	30.375	538600.0
2006-07-06 13:00:00	CL	Stock	30.375	30.422	30.345	30.385	423800.0
2006-07-06 14:00:00	CL	Stock	30.385	30.435	30.34	30.42	558400.0

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

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