PREVIEW / stock_1hour / 2006-08-17

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-08-17.parquet
  size:    607 KB
  rows:    29,071
  symbols: 2,346

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-08-17 07:00:00	AAPL	Stock	2.4357	2.4357	2.4339	2.4357	58800.0
2006-08-17 08:00:00	AAPL	Stock	2.4321	2.4396	2.4307	2.4311	1546552.0
2006-08-17 09:00:00	AAPL	Stock	2.4321	2.4464	2.4132	2.4411	87940832.0
2006-08-17 10:00:00	AAPL	Stock	2.4411	2.4521	2.4264	2.4425	103482736.0
2006-08-17 11:00:00	AAPL	Stock	2.4429	2.445	2.435	2.4386	49028392.0
2006-08-17 12:00:00	AAPL	Stock	2.4386	2.4425	2.4275	2.4368	62364400.0
2006-08-17 13:00:00	AAPL	Stock	2.4361	2.44	2.4189	2.4221	67617480.0
2006-08-17 14:00:00	AAPL	Stock	2.4214	2.4239	2.3993	2.415	106526532.0
2006-08-17 15:00:00	AAPL	Stock	2.4152	2.4196	2.4071	2.4143	82066964.0
2006-08-17 16:00:00	AAPL	Stock	2.4146	2.4182	2.4118	2.4161	6517392.0
2006-08-17 17:00:00	AAPL	Stock	2.4161	2.4161	2.4104	2.4104	595196.0
2006-08-17 18:00:00	AAPL	Stock	2.4096	2.4096	2.4096	2.4096	2800.0
2006-08-17 08:00:00	MSFT	Stock	24.72	24.72	24.67	24.67	20782.0
2006-08-17 09:00:00	MSFT	Stock	24.67	24.75	24.65	24.7	3822408.0
2006-08-17 10:00:00	MSFT	Stock	24.7	24.75	24.61	24.71	10287558.0
2006-08-17 11:00:00	MSFT	Stock	24.7	24.72	24.67	24.69	8133128.0
2006-08-17 12:00:00	MSFT	Stock	24.68	24.71	24.66	24.7	3973224.0
2006-08-17 13:00:00	MSFT	Stock	24.7	24.72	24.67	24.7	3367771.0
2006-08-17 14:00:00	MSFT	Stock	24.701	24.71	24.66	24.69	6421158.0
2006-08-17 15:00:00	MSFT	Stock	24.69	24.7	24.69	24.7	7148447.0
2006-08-17 16:00:00	MSFT	Stock	24.71	24.75	24.62	24.7	417912.0
2006-08-17 17:00:00	MSFT	Stock	24.7	24.7	24.66	24.68	16651.0
2006-08-17 18:00:00	MSFT	Stock	24.67	24.67	24.67	24.67	100.0
2006-08-17 08:00:00	NVDA	Stock	0.4558	0.4558	0.4497	0.45	3458880.0
2006-08-17 09:00:00	NVDA	Stock	0.4477	0.4592	0.4475	0.4563	127418100.0
2006-08-17 10:00:00	NVDA	Stock	0.456	0.462	0.4533	0.4562	130318620.0
2006-08-17 11:00:00	NVDA	Stock	0.456	0.4565	0.4493	0.4503	119050440.0
2006-08-17 12:00:00	NVDA	Stock	0.4503	0.4553	0.4478	0.4548	77961960.0
2006-08-17 13:00:00	NVDA	Stock	0.4548	0.455	0.4455	0.4457	64045620.0
2006-08-17 14:00:00	NVDA	Stock	0.4458	0.4508	0.4442	0.4492	101879160.0
2006-08-17 15:00:00	NVDA	Stock	0.4493	0.4513	0.4448	0.4482	128341380.0
2006-08-17 16:00:00	NVDA	Stock	0.4488	0.4498	0.4423	0.4423	10017840.0
2006-08-17 17:00:00	NVDA	Stock	0.4433	0.4433	0.44	0.4417	768360.0
2006-08-17 18:00:00	NVDA	Stock	0.4487	0.4487	0.4417	0.4417	4937880.0
2006-08-17 08:00:00	AMZN	Stock	1.397	1.397	1.397	1.397	10960.0
2006-08-17 09:00:00	AMZN	Stock	1.397	1.3995	1.3915	1.3935	6409100.0
2006-08-17 10:00:00	AMZN	Stock	1.393	1.413	1.3915	1.4115	22399880.0
2006-08-17 11:00:00	AMZN	Stock	1.4115	1.45	1.4065	1.432	31255420.0
2006-08-17 12:00:00	AMZN	Stock	1.432	1.4875	1.427	1.478	35142880.0
2006-08-17 13:00:00	AMZN	Stock	1.4775	1.478	1.453	1.4558	32914160.0
2006-08-17 14:00:00	AMZN	Stock	1.456	1.459	1.4355	1.4535	23999980.0
2006-08-17 15:00:00	AMZN	Stock	1.4535	1.459	1.4455	1.458	32202620.0
2006-08-17 16:00:00	AMZN	Stock	1.4555	1.4555	1.4302	1.4302	454000.0
2006-08-17 17:00:00	AMZN	Stock	1.4545	1.4545	1.4505	1.4505	50000.0
2006-08-17 18:00:00	AMZN	Stock	1.4505	1.4545	1.4505	1.4505	1612000.0
2006-08-17 09:00:00	CL	Stock	29.885	29.885	29.75	29.785	220200.0
2006-08-17 10:00:00	CL	Stock	29.79	29.79	29.64	29.675	670000.0
2006-08-17 11:00:00	CL	Stock	29.673	29.7	29.5	29.55	891800.0
2006-08-17 12:00:00	CL	Stock	29.54	29.72	29.5	29.57	715600.0
2006-08-17 13:00:00	CL	Stock	29.57	29.575	29.37	29.37	925200.0

> showing 50 of 29,071 rows — these rows as CSV

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