PREVIEW / stock_1hour / 2001-05-11

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-05-11.parquet
  size:    344 KB
  rows:    16,484
  symbols: 1,284

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
2001-05-11 08:00:00	AAPL	Stock	0.4071	0.4161	0.4071	0.4086	873600.0
2001-05-11 09:00:00	AAPL	Stock	0.4086	0.4188	0.4082	0.4166	35044800.0
2001-05-11 10:00:00	AAPL	Stock	0.4161	0.4195	0.4084	0.4161	42464800.0
2001-05-11 11:00:00	AAPL	Stock	0.4166	0.4189	0.415	0.417	19947200.0
2001-05-11 12:00:00	AAPL	Stock	0.417	0.4182	0.4118	0.4175	16816800.0
2001-05-11 13:00:00	AAPL	Stock	0.4175	0.4186	0.4146	0.4155	10292800.0
2001-05-11 14:00:00	AAPL	Stock	0.4155	0.4173	0.4143	0.4152	14016800.0
2001-05-11 15:00:00	AAPL	Stock	0.4155	0.4161	0.4064	0.4082	45942400.0
2001-05-11 16:00:00	AAPL	Stock	0.408	0.4164	0.4054	0.4086	10080000.0
2001-05-11 17:00:00	AAPL	Stock	0.4063	0.4125	0.4063	0.4125	117600.0
2001-05-11 18:00:00	AAPL	Stock	0.4125	0.4125	0.4107	0.4107	44800.0
2001-05-11 08:00:00	MSFT	Stock	34.855	35.165	34.775	34.885	98400.0
2001-05-11 09:00:00	MSFT	Stock	34.885	35.0	34.485	34.855	8033200.0
2001-05-11 10:00:00	MSFT	Stock	34.87	34.91	34.505	34.73	10725000.0
2001-05-11 11:00:00	MSFT	Stock	34.725	34.82	34.5	34.645	5144400.0
2001-05-11 12:00:00	MSFT	Stock	34.645	34.68	34.5	34.67	4148400.0
2001-05-11 13:00:00	MSFT	Stock	34.675	34.72	34.49	34.5	4859600.0
2001-05-11 14:00:00	MSFT	Stock	34.5	34.685	34.48	34.585	5124400.0
2001-05-11 15:00:00	MSFT	Stock	34.59	34.72	34.325	34.655	8330200.0
2001-05-11 16:00:00	MSFT	Stock	34.695	34.715	34.56	34.715	1952200.0
2001-05-11 17:00:00	MSFT	Stock	34.675	34.695	34.675	34.675	1600.0
2001-05-11 18:00:00	MSFT	Stock	34.675	34.675	34.675	34.675	1000.0
2001-05-11 08:00:00	NVDA	Stock	0.3331	0.3344	0.3269	0.3313	1920000.0
2001-05-11 09:00:00	NVDA	Stock	0.3313	0.3354	0.3233	0.3259	215712000.0
2001-05-11 10:00:00	NVDA	Stock	0.3257	0.3325	0.3248	0.3304	165000000.0
2001-05-11 11:00:00	NVDA	Stock	0.3296	0.3321	0.3225	0.3243	89304000.0
2001-05-11 12:00:00	NVDA	Stock	0.3248	0.325	0.3189	0.3225	119616000.0
2001-05-11 13:00:00	NVDA	Stock	0.3223	0.3263	0.3215	0.3229	83112000.0
2001-05-11 14:00:00	NVDA	Stock	0.3227	0.3268	0.3221	0.324	72360000.0
2001-05-11 15:00:00	NVDA	Stock	0.3242	0.327	0.3211	0.3256	109248000.0
2001-05-11 16:00:00	NVDA	Stock	0.3256	0.3269	0.3196	0.3258	4848000.0
2001-05-11 17:00:00	NVDA	Stock	0.3271	0.3288	0.3271	0.3288	96000.0
2001-05-11 08:00:00	AMZN	Stock	0.7305	0.7515	0.722	0.7305	528000.0
2001-05-11 09:00:00	AMZN	Stock	0.728	0.731	0.7055	0.7115	15804000.0
2001-05-11 10:00:00	AMZN	Stock	0.7115	0.725	0.71	0.723	12700000.0
2001-05-11 11:00:00	AMZN	Stock	0.723	0.723	0.707	0.713	8254000.0
2001-05-11 12:00:00	AMZN	Stock	0.713	0.7145	0.705	0.71	5192000.0
2001-05-11 13:00:00	AMZN	Stock	0.709	0.7175	0.709	0.7115	3154000.0
2001-05-11 14:00:00	AMZN	Stock	0.7105	0.7205	0.708	0.715	3180000.0
2001-05-11 15:00:00	AMZN	Stock	0.714	0.74	0.71	0.734	15362000.0
2001-05-11 16:00:00	AMZN	Stock	0.7345	0.739	0.729	0.7355	3654000.0
2001-05-11 17:00:00	AMZN	Stock	0.7365	0.74	0.7365	0.74	20000.0
2001-05-11 18:00:00	AMZN	Stock	0.7375	0.7375	0.734	0.734	14000.0
2001-05-11 09:00:00	CL	Stock	29.2	29.37	29.2	29.225	261800.0
2001-05-11 10:00:00	CL	Stock	29.23	29.265	28.925	29.105	239800.0
2001-05-11 11:00:00	CL	Stock	29.055	29.2	29.05	29.175	135600.0
2001-05-11 12:00:00	CL	Stock	29.175	29.185	29.04	29.175	126400.0
2001-05-11 13:00:00	CL	Stock	29.175	29.195	29.035	29.04	173600.0
2001-05-11 14:00:00	CL	Stock	29.04	29.175	28.995	28.995	245000.0
2001-05-11 15:00:00	CL	Stock	28.99	29.2	28.825	29.05	484000.0

> showing 50 of 16,484 rows — these rows as CSV

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