PREVIEW / stock_1hour / 2006-07-12

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-07-12.parquet
  size:    604 KB
  rows:    29,133
  symbols: 2,314

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-12 07:00:00	AAPL	Stock	1.985	1.985	1.985	1.985	28000.0
2006-07-12 08:00:00	AAPL	Stock	1.9786	1.9786	1.9661	1.9732	1513204.0
2006-07-12 09:00:00	AAPL	Stock	1.9732	1.9732	1.9543	1.9564	93704016.0
2006-07-12 10:00:00	AAPL	Stock	1.9564	1.96	1.9354	1.9414	166350968.0
2006-07-12 11:00:00	AAPL	Stock	1.9411	1.9493	1.9332	1.9439	99181516.0
2006-07-12 12:00:00	AAPL	Stock	1.9441	1.9446	1.92	1.9232	124219508.0
2006-07-12 13:00:00	AAPL	Stock	1.9232	1.9239	1.8993	1.9046	133423696.0
2006-07-12 14:00:00	AAPL	Stock	1.9046	1.9132	1.8918	1.8936	131005812.0
2006-07-12 15:00:00	AAPL	Stock	1.8936	1.9071	1.8911	1.8918	164599288.0
2006-07-12 16:00:00	AAPL	Stock	1.8925	1.9064	1.8911	1.8943	6832084.0
2006-07-12 17:00:00	AAPL	Stock	1.8929	1.902	1.8893	1.902	780892.0
2006-07-12 18:00:00	AAPL	Stock	1.8893	1.8893	1.8839	1.8854	358232.0
2006-07-12 08:00:00	MSFT	Stock	23.0	23.0	22.83	22.9	89067.0
2006-07-12 09:00:00	MSFT	Stock	22.94	23.0	22.68	22.73	13377489.0
2006-07-12 10:00:00	MSFT	Stock	22.71	22.88	22.71	22.83	10822498.0
2006-07-12 11:00:00	MSFT	Stock	22.82	22.85	22.79	22.85	5518882.0
2006-07-12 12:00:00	MSFT	Stock	22.85	22.85	22.71	22.74	9052470.0
2006-07-12 13:00:00	MSFT	Stock	22.74	22.75	22.62	22.702	6984672.0
2006-07-12 14:00:00	MSFT	Stock	22.702	22.76	22.67	22.68	7362935.0
2006-07-12 15:00:00	MSFT	Stock	22.68	22.75	22.62	22.64	14292427.0
2006-07-12 16:00:00	MSFT	Stock	22.65	22.77	22.64	22.64	373610.0
2006-07-12 17:00:00	MSFT	Stock	22.65	22.7	22.585	22.65	61268.0
2006-07-12 18:00:00	MSFT	Stock	22.68	22.68	22.68	22.68	1100.0
2006-07-12 09:00:00	NVDA	Stock	0.32	0.3233	0.313	0.3148	56608800.0
2006-07-12 10:00:00	NVDA	Stock	0.3147	0.3158	0.3095	0.3102	64333020.0
2006-07-12 11:00:00	NVDA	Stock	0.3102	0.3143	0.3095	0.3137	50028060.0
2006-07-12 12:00:00	NVDA	Stock	0.3137	0.3145	0.3123	0.3132	47426520.0
2006-07-12 13:00:00	NVDA	Stock	0.3132	0.3132	0.305	0.3065	64674180.0
2006-07-12 14:00:00	NVDA	Stock	0.3065	0.3088	0.3043	0.3045	46072560.0
2006-07-12 15:00:00	NVDA	Stock	0.3043	0.3083	0.3035	0.3042	90024660.0
2006-07-12 16:00:00	NVDA	Stock	0.304	0.3167	0.3038	0.3052	28303080.0
2006-07-12 17:00:00	NVDA	Stock	0.3053	0.3053	0.3038	0.3053	134700.0
2006-07-12 08:00:00	AMZN	Stock	1.7675	1.7675	1.753	1.755	25000.0
2006-07-12 09:00:00	AMZN	Stock	1.7685	1.795	1.766	1.781	7101960.0
2006-07-12 10:00:00	AMZN	Stock	1.7805	1.791	1.7765	1.78	11360260.0
2006-07-12 11:00:00	AMZN	Stock	1.78	1.7805	1.7635	1.779	9774300.0
2006-07-12 12:00:00	AMZN	Stock	1.7785	1.7785	1.751	1.761	7291740.0
2006-07-12 13:00:00	AMZN	Stock	1.761	1.761	1.738	1.743	12875520.0
2006-07-12 14:00:00	AMZN	Stock	1.7425	1.7575	1.7285	1.737	22523340.0
2006-07-12 15:00:00	AMZN	Stock	1.7365	1.745	1.729	1.731	20114540.0
2006-07-12 16:00:00	AMZN	Stock	1.731	1.7335	1.73	1.7315	3772000.0
2006-07-12 09:00:00	CL	Stock	30.875	30.92	30.8	30.855	170200.0
2006-07-12 10:00:00	CL	Stock	30.855	30.9	30.77	30.865	431400.0
2006-07-12 11:00:00	CL	Stock	30.865	30.925	30.85	30.91	217200.0
2006-07-12 12:00:00	CL	Stock	30.9195	30.92	30.82	30.87	213400.0
2006-07-12 13:00:00	CL	Stock	30.87	30.875	30.775	30.78	358800.0
2006-07-12 14:00:00	CL	Stock	30.79	30.83	30.67	30.67	389400.0
2006-07-12 15:00:00	CL	Stock	30.675	30.775	30.61	30.695	552000.0
2006-07-12 16:00:00	CL	Stock	30.71	30.71	30.71	30.71	200.0

> showing 49 of 29,133 rows — these rows as CSV

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