PREVIEW / stock_1hour / 2001-05-14

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-05-14.parquet
  size:    343 KB
  rows:    16,424
  symbols: 1,288

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-14 08:00:00	AAPL	Stock	0.408	0.4107	0.408	0.4107	487200.0
2001-05-14 09:00:00	AAPL	Stock	0.4098	0.4138	0.4063	0.4125	29702400.0
2001-05-14 10:00:00	AAPL	Stock	0.4129	0.418	0.4109	0.4152	50450400.0
2001-05-14 11:00:00	AAPL	Stock	0.4154	0.4223	0.4152	0.4205	31931200.0
2001-05-14 12:00:00	AAPL	Stock	0.4204	0.4229	0.4177	0.4227	20832000.0
2001-05-14 13:00:00	AAPL	Stock	0.4229	0.4229	0.4173	0.4173	18132800.0
2001-05-14 14:00:00	AAPL	Stock	0.4173	0.4198	0.4089	0.4138	42610400.0
2001-05-14 15:00:00	AAPL	Stock	0.4138	0.4213	0.4107	0.4164	49000000.0
2001-05-14 16:00:00	AAPL	Stock	0.4159	0.4193	0.415	0.4154	55255200.0
2001-05-14 17:00:00	AAPL	Stock	0.4155	0.4159	0.4155	0.4159	347200.0
2001-05-14 08:00:00	MSFT	Stock	34.53	34.7	34.5	34.69	41400.0
2001-05-14 09:00:00	MSFT	Stock	34.625	34.725	34.1	34.375	6047800.0
2001-05-14 10:00:00	MSFT	Stock	34.345	34.46	34.22	34.315	7484400.0
2001-05-14 11:00:00	MSFT	Stock	34.31	34.385	34.23	34.275	6075000.0
2001-05-14 12:00:00	MSFT	Stock	34.275	34.47	34.25	34.41	4402200.0
2001-05-14 13:00:00	MSFT	Stock	34.41	34.425	34.285	34.32	4294600.0
2001-05-14 14:00:00	MSFT	Stock	34.325	34.345	34.15	34.275	5484800.0
2001-05-14 15:00:00	MSFT	Stock	34.265	34.465	34.155	34.36	8264000.0
2001-05-14 16:00:00	MSFT	Stock	34.355	34.415	34.31	34.36	1151800.0
2001-05-14 17:00:00	MSFT	Stock	34.36	34.4	34.36	34.4	73800.0
2001-05-14 18:00:00	MSFT	Stock	34.365	34.365	34.365	34.365	600.0
2001-05-14 08:00:00	NVDA	Stock	0.3328	0.3328	0.3229	0.3256	1440000.0
2001-05-14 09:00:00	NVDA	Stock	0.3246	0.3287	0.3178	0.3181	96408000.0
2001-05-14 10:00:00	NVDA	Stock	0.3184	0.3242	0.3184	0.3206	125400000.0
2001-05-14 11:00:00	NVDA	Stock	0.3206	0.3206	0.3152	0.3167	114864000.0
2001-05-14 12:00:00	NVDA	Stock	0.3167	0.3204	0.3165	0.3193	44544000.0
2001-05-14 13:00:00	NVDA	Stock	0.3192	0.32	0.3169	0.3173	38736000.0
2001-05-14 14:00:00	NVDA	Stock	0.3173	0.3203	0.3156	0.3178	82392000.0
2001-05-14 15:00:00	NVDA	Stock	0.3179	0.3323	0.3176	0.3284	169680000.0
2001-05-14 16:00:00	NVDA	Stock	0.3282	0.3313	0.3275	0.3292	8352000.0
2001-05-14 17:00:00	NVDA	Stock	0.3292	0.3333	0.3292	0.3333	1128000.0
2001-05-14 18:00:00	NVDA	Stock	0.3333	0.3344	0.3333	0.3333	408000.0
2001-05-14 08:00:00	AMZN	Stock	0.74	0.74	0.7225	0.7225	10000.0
2001-05-14 09:00:00	AMZN	Stock	0.7325	0.734	0.7025	0.7085	8502000.0
2001-05-14 10:00:00	AMZN	Stock	0.709	0.7125	0.688	0.691	12462000.0
2001-05-14 11:00:00	AMZN	Stock	0.691	0.6975	0.6865	0.694	8978000.0
2001-05-14 12:00:00	AMZN	Stock	0.694	0.701	0.6935	0.6975	23472000.0
2001-05-14 13:00:00	AMZN	Stock	0.6975	0.698	0.675	0.677	12158000.0
2001-05-14 14:00:00	AMZN	Stock	0.6775	0.68	0.66	0.6675	23028000.0
2001-05-14 15:00:00	AMZN	Stock	0.6675	0.6725	0.658	0.6665	23222000.0
2001-05-14 16:00:00	AMZN	Stock	0.6665	0.695	0.6575	0.6715	3400000.0
2001-05-14 17:00:00	AMZN	Stock	0.6665	0.6715	0.6665	0.6715	248000.0
2001-05-14 18:00:00	AMZN	Stock	0.6715	0.6715	0.6715	0.6715	4000.0
2001-05-14 09:00:00	CL	Stock	29.175	29.19	29.1	29.12	149000.0
2001-05-14 10:00:00	CL	Stock	29.15	29.175	28.95	29.055	272200.0
2001-05-14 11:00:00	CL	Stock	29.05	29.11	29.0	29.1	226400.0
2001-05-14 12:00:00	CL	Stock	29.1	29.175	29.0	29.0	538800.0
2001-05-14 13:00:00	CL	Stock	29.0	29.06	28.925	28.99	348200.0
2001-05-14 14:00:00	CL	Stock	28.965	29.05	28.94	28.99	135800.0
2001-05-14 15:00:00	CL	Stock	28.99	29.15	28.99	29.09	361000.0

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

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