PREVIEW / stock_1hour / 2001-04-17

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-04-17.parquet
  size:    346 KB
  rows:    16,358
  symbols: 1,285

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-04-17 08:00:00	AAPL	Stock	0.3782	0.3791	0.3741	0.3789	705600.0
2001-04-17 09:00:00	AAPL	Stock	0.3791	0.3804	0.3705	0.3707	70106400.0
2001-04-17 10:00:00	AAPL	Stock	0.3705	0.3709	0.357	0.3577	155383200.0
2001-04-17 11:00:00	AAPL	Stock	0.3586	0.3627	0.3573	0.3577	69479200.0
2001-04-17 12:00:00	AAPL	Stock	0.3577	0.3618	0.3529	0.3605	65553600.0
2001-04-17 13:00:00	AAPL	Stock	0.36	0.3616	0.355	0.3571	59830400.0
2001-04-17 14:00:00	AAPL	Stock	0.357	0.3593	0.35	0.3561	64192800.0
2001-04-17 15:00:00	AAPL	Stock	0.3561	0.3659	0.3552	0.3643	120019200.0
2001-04-17 16:00:00	AAPL	Stock	0.363	0.3732	0.3584	0.373	25984000.0
2001-04-17 17:00:00	AAPL	Stock	0.3732	0.383	0.3625	0.3754	2587200.0
2001-04-17 18:00:00	AAPL	Stock	0.3777	0.3777	0.3754	0.3754	151200.0
2001-04-17 08:00:00	MSFT	Stock	29.925	30.25	29.65	30.175	212610.0
2001-04-17 09:00:00	MSFT	Stock	30.25	30.565	29.695	30.54	11598800.0
2001-04-17 10:00:00	MSFT	Stock	30.54	31.055	30.52	30.725	15993000.0
2001-04-17 11:00:00	MSFT	Stock	30.72	30.805	30.525	30.72	8851600.0
2001-04-17 12:00:00	MSFT	Stock	30.715	30.98	30.645	30.945	5168800.0
2001-04-17 13:00:00	MSFT	Stock	30.955	31.0	30.705	30.88	7662800.0
2001-04-17 14:00:00	MSFT	Stock	30.87	31.0	30.52	30.565	10746400.0
2001-04-17 15:00:00	MSFT	Stock	30.56	30.925	30.535	30.74	13913200.0
2001-04-17 16:00:00	MSFT	Stock	30.74	31.875	30.61	31.675	4619800.0
2001-04-17 17:00:00	MSFT	Stock	31.655	31.825	30.725	31.6	1638400.0
2001-04-17 18:00:00	MSFT	Stock	31.6	31.79	31.555	31.79	155600.0
2001-04-17 08:00:00	NVDA	Stock	0.2783	0.2833	0.2771	0.2833	936000.0
2001-04-17 09:00:00	NVDA	Stock	0.2833	0.2915	0.2812	0.2908	118128000.0
2001-04-17 10:00:00	NVDA	Stock	0.2908	0.3019	0.2896	0.3	325296000.0
2001-04-17 11:00:00	NVDA	Stock	0.3	0.3003	0.295	0.2956	100152000.0
2001-04-17 12:00:00	NVDA	Stock	0.2956	0.2978	0.2925	0.2967	70680000.0
2001-04-17 13:00:00	NVDA	Stock	0.2964	0.2992	0.2948	0.2975	52896000.0
2001-04-17 14:00:00	NVDA	Stock	0.2975	0.3	0.2956	0.2956	122064000.0
2001-04-17 15:00:00	NVDA	Stock	0.2959	0.3011	0.2956	0.3	224496000.0
2001-04-17 16:00:00	NVDA	Stock	0.2998	0.3123	0.2957	0.3112	44184000.0
2001-04-17 17:00:00	NVDA	Stock	0.3111	0.3125	0.3104	0.3125	1872000.0
2001-04-17 18:00:00	NVDA	Stock	0.3125	0.3144	0.3125	0.3125	864000.0
2001-04-17 08:00:00	AMZN	Stock	0.65	0.7015	0.65	0.6825	200000.0
2001-04-17 09:00:00	AMZN	Stock	0.6835	0.722	0.6835	0.7145	16196000.0
2001-04-17 10:00:00	AMZN	Stock	0.7175	0.7435	0.7135	0.7195	20968000.0
2001-04-17 11:00:00	AMZN	Stock	0.7195	0.734	0.7125	0.7285	9746000.0
2001-04-17 12:00:00	AMZN	Stock	0.7295	0.7345	0.717	0.727	11264000.0
2001-04-17 13:00:00	AMZN	Stock	0.728	0.7315	0.7195	0.7225	11682000.0
2001-04-17 14:00:00	AMZN	Stock	0.7225	0.725	0.7175	0.724	4934000.0
2001-04-17 15:00:00	AMZN	Stock	0.7225	0.7375	0.719	0.737	15176000.0
2001-04-17 16:00:00	AMZN	Stock	0.737	0.765	0.71	0.765	4924000.0
2001-04-17 17:00:00	AMZN	Stock	0.7525	0.8	0.7355	0.7755	300000.0
2001-04-17 18:00:00	AMZN	Stock	0.7755	0.7755	0.769	0.775	106000.0
2001-04-17 09:00:00	CL	Stock	26.35	26.55	26.25	26.255	325800.0
2001-04-17 10:00:00	CL	Stock	26.24	26.625	26.175	26.545	885800.0
2001-04-17 11:00:00	CL	Stock	26.525	26.53	26.225	26.25	481800.0
2001-04-17 12:00:00	CL	Stock	26.25	26.325	26.14	26.3	193600.0
2001-04-17 13:00:00	CL	Stock	26.3	26.375	26.18	26.25	284000.0
2001-04-17 14:00:00	CL	Stock	26.255	26.3	26.13	26.3	509000.0

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

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