PREVIEW / stock_1hour / 2005-07-29

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-07-29.parquet
  size:    560 KB
  rows:    26,701
  symbols: 2,044

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-07-29 08:00:00	AAPL	Stock	1.5611	1.5611	1.5536	1.5589	146468.0
2005-07-29 09:00:00	AAPL	Stock	1.5586	1.5807	1.5518	1.5807	56470344.0
2005-07-29 10:00:00	AAPL	Stock	1.5807	1.585	1.5375	1.5439	121345896.0
2005-07-29 11:00:00	AAPL	Stock	1.5439	1.5471	1.5307	1.5382	63411992.0
2005-07-29 12:00:00	AAPL	Stock	1.5379	1.5418	1.5336	1.5386	28783664.0
2005-07-29 13:00:00	AAPL	Stock	1.5386	1.5429	1.5346	1.5411	26688088.0
2005-07-29 14:00:00	AAPL	Stock	1.5414	1.545	1.5093	1.525	135977632.0
2005-07-29 15:00:00	AAPL	Stock	1.5246	1.5296	1.5179	1.5236	101998680.0
2005-07-29 16:00:00	AAPL	Stock	1.5232	1.5257	1.5179	1.5214	9296644.0
2005-07-29 17:00:00	AAPL	Stock	1.5221	1.5395	1.5168	1.5193	1432760.0
2005-07-29 18:00:00	AAPL	Stock	1.5193	1.5214	1.5161	1.5161	77336.0
2005-07-29 08:00:00	MSFT	Stock	25.82	25.83	25.8	25.83	106804.0
2005-07-29 09:00:00	MSFT	Stock	25.82	26.0	25.76	25.86	10024022.0
2005-07-29 10:00:00	MSFT	Stock	25.86	25.88	25.71	25.74	10738978.0
2005-07-29 11:00:00	MSFT	Stock	25.74	25.85	25.7	25.72	5807523.0
2005-07-29 12:00:00	MSFT	Stock	25.72	25.73	25.66	25.69	6977306.0
2005-07-29 13:00:00	MSFT	Stock	25.7	25.75	25.69	25.74	5271916.0
2005-07-29 14:00:00	MSFT	Stock	25.75	25.81	25.72	25.76	5331279.0
2005-07-29 15:00:00	MSFT	Stock	25.75	25.77	25.59	25.61	10803504.0
2005-07-29 16:00:00	MSFT	Stock	25.6	25.65	25.57	25.65	1217754.0
2005-07-29 17:00:00	MSFT	Stock	25.65	25.727	25.61	25.65	446260.0
2005-07-29 18:00:00	MSFT	Stock	25.65	25.65	25.64	25.64	3760.0
2005-07-29 09:00:00	NVDA	Stock	0.2267	0.2277	0.2237	0.2274	32040840.0
2005-07-29 10:00:00	NVDA	Stock	0.2274	0.2287	0.2261	0.2267	59614560.0
2005-07-29 11:00:00	NVDA	Stock	0.2267	0.2269	0.2255	0.2262	55670640.0
2005-07-29 12:00:00	NVDA	Stock	0.2262	0.2262	0.2245	0.2246	38225280.0
2005-07-29 13:00:00	NVDA	Stock	0.2246	0.2269	0.2245	0.2262	26292720.0
2005-07-29 14:00:00	NVDA	Stock	0.2262	0.2267	0.2254	0.2262	24732240.0
2005-07-29 15:00:00	NVDA	Stock	0.2261	0.2262	0.2246	0.2254	86010600.0
2005-07-29 16:00:00	NVDA	Stock	0.2256	0.2262	0.2252	0.2255	15778320.0
2005-07-29 17:00:00	NVDA	Stock	0.2255	0.2255	0.2255	0.2255	372000.0
2005-07-29 08:00:00	AMZN	Stock	2.2805	2.29	2.2755	2.278	866520.0
2005-07-29 09:00:00	AMZN	Stock	2.275	2.2875	2.2575	2.267	43026860.0
2005-07-29 10:00:00	AMZN	Stock	2.267	2.2715	2.2405	2.2415	45889700.0
2005-07-29 11:00:00	AMZN	Stock	2.242	2.253	2.2305	2.239	25260040.0
2005-07-29 12:00:00	AMZN	Stock	2.239	2.246	2.231	2.237	15742280.0
2005-07-29 13:00:00	AMZN	Stock	2.2375	2.251	2.2375	2.249	17934880.0
2005-07-29 14:00:00	AMZN	Stock	2.249	2.262	2.249	2.2555	20708040.0
2005-07-29 15:00:00	AMZN	Stock	2.2555	2.262	2.2545	2.258	32690420.0
2005-07-29 16:00:00	AMZN	Stock	2.2575	2.263	2.25	2.262	1883600.0
2005-07-29 17:00:00	AMZN	Stock	2.2586	2.2586	2.2565	2.257	359840.0
2005-07-29 18:00:00	AMZN	Stock	2.255	2.2585	2.246	2.246	640000.0
2005-07-29 09:00:00	CL	Stock	26.7	26.74	26.57	26.605	631800.0
2005-07-29 10:00:00	CL	Stock	26.6	26.645	26.48	26.495	912400.0
2005-07-29 11:00:00	CL	Stock	26.49	26.645	26.49	26.64	451200.0
2005-07-29 12:00:00	CL	Stock	26.645	26.65	26.525	26.55	396000.0
2005-07-29 13:00:00	CL	Stock	26.55	26.61	26.45	26.6055	309800.0
2005-07-29 14:00:00	CL	Stock	26.61	26.625	26.565	26.58	443600.0
2005-07-29 15:00:00	CL	Stock	26.585	26.595	26.475	26.475	779600.0
2005-07-29 16:00:00	CL	Stock	26.45	26.471	26.45	26.471	137800.0

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

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