PREVIEW / stock_1hour / 2001-07-17

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-07-17.parquet
  size:    363 KB
  rows:    17,469
  symbols: 1,308

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-07-17 08:00:00	AAPL	Stock	0.4277	0.4286	0.4277	0.4286	72800.0
2001-07-17 09:00:00	AAPL	Stock	0.4289	0.4375	0.4268	0.4311	73326400.0
2001-07-17 10:00:00	AAPL	Stock	0.4311	0.4363	0.4257	0.4304	82880000.0
2001-07-17 11:00:00	AAPL	Stock	0.4304	0.4329	0.4221	0.4223	33034400.0
2001-07-17 12:00:00	AAPL	Stock	0.4221	0.4257	0.4109	0.4257	84722400.0
2001-07-17 13:00:00	AAPL	Stock	0.4257	0.4352	0.4255	0.4338	69109600.0
2001-07-17 14:00:00	AAPL	Stock	0.4336	0.4438	0.433	0.4421	72212000.0
2001-07-17 15:00:00	AAPL	Stock	0.442	0.4504	0.4402	0.4479	121760800.0
2001-07-17 16:00:00	AAPL	Stock	0.448	0.4723	0.3936	0.4055	70168000.0
2001-07-17 17:00:00	AAPL	Stock	0.4063	0.4107	0.4002	0.4054	11950400.0
2001-07-17 18:00:00	AAPL	Stock	0.4054	0.4054	0.3991	0.4	2352000.0
2001-07-17 08:00:00	MSFT	Stock	35.435	35.535	35.3	35.425	28800.0
2001-07-17 09:00:00	MSFT	Stock	35.425	35.575	35.2	35.385	7980800.0
2001-07-17 10:00:00	MSFT	Stock	35.395	35.65	35.07	35.445	13886200.0
2001-07-17 11:00:00	MSFT	Stock	35.445	35.74	35.315	35.49	5615200.0
2001-07-17 12:00:00	MSFT	Stock	35.495	35.52	35.27	35.455	6168200.0
2001-07-17 13:00:00	MSFT	Stock	35.455	35.72	35.41	35.69	5350800.0
2001-07-17 14:00:00	MSFT	Stock	35.69	36.005	35.675	35.9	9468400.0
2001-07-17 15:00:00	MSFT	Stock	35.89	35.99	35.71	35.905	9487000.0
2001-07-17 16:00:00	MSFT	Stock	35.93	36.25	35.47	35.875	2441000.0
2001-07-17 17:00:00	MSFT	Stock	35.845	35.865	35.71	35.865	5600.0
2001-07-17 18:00:00	MSFT	Stock	35.865	35.91	35.67	35.7	10800.0
2001-07-17 08:00:00	NVDA	Stock	0.3102	0.3102	0.3042	0.3077	1296000.0
2001-07-17 09:00:00	NVDA	Stock	0.3077	0.3135	0.3021	0.3125	224856000.0
2001-07-17 10:00:00	NVDA	Stock	0.3126	0.32	0.307	0.3146	291288000.0
2001-07-17 11:00:00	NVDA	Stock	0.3146	0.3187	0.312	0.3175	88392000.0
2001-07-17 12:00:00	NVDA	Stock	0.3171	0.3175	0.3135	0.3147	45816000.0
2001-07-17 13:00:00	NVDA	Stock	0.315	0.32	0.3135	0.3193	83208000.0
2001-07-17 14:00:00	NVDA	Stock	0.3198	0.3246	0.3188	0.3237	213408000.0
2001-07-17 15:00:00	NVDA	Stock	0.3237	0.3306	0.3234	0.3275	162480000.0
2001-07-17 16:00:00	NVDA	Stock	0.3275	0.3294	0.3213	0.3238	11352000.0
2001-07-17 17:00:00	NVDA	Stock	0.3221	0.3275	0.319	0.3227	2232000.0
2001-07-17 18:00:00	NVDA	Stock	0.3227	0.3227	0.3227	0.3227	120000.0
2001-07-17 08:00:00	AMZN	Stock	0.7965	0.8005	0.7845	0.7975	120000.0
2001-07-17 09:00:00	AMZN	Stock	0.7975	0.8175	0.79	0.8	16744000.0
2001-07-17 10:00:00	AMZN	Stock	0.8	0.809	0.8	0.8005	9986000.0
2001-07-17 11:00:00	AMZN	Stock	0.801	0.804	0.7925	0.8	10708000.0
2001-07-17 12:00:00	AMZN	Stock	0.8	0.804	0.797	0.804	5722000.0
2001-07-17 13:00:00	AMZN	Stock	0.804	0.8085	0.801	0.806	5580000.0
2001-07-17 14:00:00	AMZN	Stock	0.805	0.8245	0.8045	0.813	10692000.0
2001-07-17 15:00:00	AMZN	Stock	0.8145	0.818	0.81	0.817	10384000.0
2001-07-17 16:00:00	AMZN	Stock	0.8175	0.8375	0.803	0.82	1228000.0
2001-07-17 17:00:00	AMZN	Stock	0.8325	0.8325	0.8025	0.82	30000.0
2001-07-17 09:00:00	CL	Stock	28.175	28.175	27.955	28.025	364600.0
2001-07-17 10:00:00	CL	Stock	28.045	28.085	27.95	27.995	513600.0
2001-07-17 11:00:00	CL	Stock	27.995	28.125	27.945	28.025	558600.0
2001-07-17 12:00:00	CL	Stock	28.035	28.1	28.005	28.1	302000.0
2001-07-17 13:00:00	CL	Stock	28.1	28.275	28.075	28.155	337600.0
2001-07-17 14:00:00	CL	Stock	28.145	28.18	28.1	28.11	425600.0
2001-07-17 15:00:00	CL	Stock	28.105	28.175	28.05	28.155	547400.0

> showing 50 of 17,469 rows — these rows as CSV

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