PREVIEW / stock_1hour / 2006-07-18

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-07-18.parquet
  size:    595 KB
  rows:    28,875
  symbols: 2,312

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-18 07:00:00	AAPL	Stock	1.8768	1.8893	1.8768	1.8893	162400.0
2006-07-18 08:00:00	AAPL	Stock	1.8896	1.9036	1.8825	1.8854	2858604.0
2006-07-18 09:00:00	AAPL	Stock	1.8839	1.9232	1.8821	1.9053	187798380.0
2006-07-18 10:00:00	AAPL	Stock	1.9043	1.905	1.8846	1.8896	169183924.0
2006-07-18 11:00:00	AAPL	Stock	1.8896	1.8986	1.8786	1.8918	106837892.0
2006-07-18 12:00:00	AAPL	Stock	1.8911	1.8946	1.8786	1.88	79999024.0
2006-07-18 13:00:00	AAPL	Stock	1.8796	1.88	1.8518	1.8546	128573732.0
2006-07-18 14:00:00	AAPL	Stock	1.8543	1.8804	1.8536	1.8696	162009932.0
2006-07-18 15:00:00	AAPL	Stock	1.8696	1.8936	1.8618	1.8925	153476120.0
2006-07-18 16:00:00	AAPL	Stock	1.8921	1.9018	1.8821	1.8864	2930004.0
2006-07-18 17:00:00	AAPL	Stock	1.8854	1.8893	1.8836	1.8854	1185604.0
2006-07-18 18:00:00	AAPL	Stock	1.8843	1.8843	1.8793	1.8793	231112.0
2006-07-18 07:00:00	MSFT	Stock	22.41	22.41	22.41	22.41	200.0
2006-07-18 08:00:00	MSFT	Stock	22.49	22.56	22.49	22.56	8651.0
2006-07-18 09:00:00	MSFT	Stock	22.57	22.72	22.52	22.64	6334048.0
2006-07-18 10:00:00	MSFT	Stock	22.645	22.74	22.62	22.64	6979964.0
2006-07-18 11:00:00	MSFT	Stock	22.64	22.72	22.6	22.68	6128228.0
2006-07-18 12:00:00	MSFT	Stock	22.67	22.76	22.65	22.67	5652035.0
2006-07-18 13:00:00	MSFT	Stock	22.66	22.74	22.48	22.52	11227111.0
2006-07-18 14:00:00	MSFT	Stock	22.51	22.69	22.51	22.643	7710251.0
2006-07-18 15:00:00	MSFT	Stock	22.65	22.76	22.55	22.73	11450633.0
2006-07-18 16:00:00	MSFT	Stock	22.66	22.77	22.6	22.69	148491.0
2006-07-18 17:00:00	MSFT	Stock	22.61	22.66	22.56	22.57	74237.0
2006-07-18 18:00:00	MSFT	Stock	22.63	22.63	22.58	22.58	3800.0
2006-07-18 08:00:00	NVDA	Stock	0.298	0.3083	0.298	0.3075	6863100.0
2006-07-18 09:00:00	NVDA	Stock	0.3075	0.3162	0.305	0.3077	112096080.0
2006-07-18 10:00:00	NVDA	Stock	0.3078	0.3085	0.2972	0.2975	120148440.0
2006-07-18 11:00:00	NVDA	Stock	0.2973	0.3032	0.296	0.3008	103709940.0
2006-07-18 12:00:00	NVDA	Stock	0.3007	0.3063	0.2997	0.303	89196480.0
2006-07-18 13:00:00	NVDA	Stock	0.3032	0.3032	0.2993	0.3007	101373180.0
2006-07-18 14:00:00	NVDA	Stock	0.3005	0.3068	0.3005	0.3067	152254440.0
2006-07-18 15:00:00	NVDA	Stock	0.3068	0.315	0.3052	0.3132	268267140.0
2006-07-18 16:00:00	NVDA	Stock	0.3132	0.3165	0.3108	0.3108	2250540.0
2006-07-18 17:00:00	NVDA	Stock	0.3108	0.3133	0.3083	0.3117	231180.0
2006-07-18 18:00:00	NVDA	Stock	0.3115	0.3125	0.3115	0.3118	200640.0
2006-07-18 05:00:00	AMZN	Stock	1.66	1.6625	1.66	1.6625	4000.0
2006-07-18 09:00:00	AMZN	Stock	1.677	1.7145	1.677	1.7005	14001700.0
2006-07-18 10:00:00	AMZN	Stock	1.7005	1.7025	1.6845	1.686	14879380.0
2006-07-18 11:00:00	AMZN	Stock	1.6865	1.6875	1.666	1.6705	18802920.0
2006-07-18 12:00:00	AMZN	Stock	1.671	1.676	1.6615	1.6645	9364080.0
2006-07-18 13:00:00	AMZN	Stock	1.664	1.665	1.648	1.6585	9930780.0
2006-07-18 14:00:00	AMZN	Stock	1.6585	1.6815	1.6545	1.665	15636260.0
2006-07-18 15:00:00	AMZN	Stock	1.665	1.6795	1.6555	1.674	19838520.0
2006-07-18 16:00:00	AMZN	Stock	1.674	1.694	1.65	1.655	344180.0
2006-07-18 17:00:00	AMZN	Stock	1.655	1.655	1.65	1.65	124820.0
2006-07-18 18:00:00	AMZN	Stock	1.6545	1.6545	1.6545	1.6545	10000.0
2006-07-18 09:00:00	CL	Stock	30.54	30.54	30.325	30.375	207000.0
2006-07-18 10:00:00	CL	Stock	30.365	30.43	30.29	30.32	332000.0
2006-07-18 11:00:00	CL	Stock	30.325	30.43	30.285	30.335	316800.0
2006-07-18 12:00:00	CL	Stock	30.345	30.365	30.265	30.265	364000.0

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

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