PREVIEW / stock_1hour / 2001-01-23

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-01-23.parquet
  size:    322 KB
  rows:    16,500
  symbols: 1,265

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-01-23 08:00:00	AAPL	Stock	0.3432	0.3493	0.3398	0.3438	1024800.0
2001-01-23 09:00:00	AAPL	Stock	0.3438	0.3471	0.3404	0.3415	43472800.0
2001-01-23 10:00:00	AAPL	Stock	0.3404	0.3538	0.3404	0.3516	115600800.0
2001-01-23 11:00:00	AAPL	Stock	0.3516	0.3571	0.3482	0.3549	60849600.0
2001-01-23 12:00:00	AAPL	Stock	0.3549	0.3661	0.3538	0.3627	114419200.0
2001-01-23 13:00:00	AAPL	Stock	0.3616	0.3661	0.3616	0.3638	40303200.0
2001-01-23 14:00:00	AAPL	Stock	0.3627	0.3683	0.3627	0.3672	133492800.0
2001-01-23 15:00:00	AAPL	Stock	0.3683	0.3739	0.3638	0.3672	228872000.0
2001-01-23 16:00:00	AAPL	Stock	0.3672	0.3739	0.3571	0.3728	39972800.0
2001-01-23 17:00:00	AAPL	Stock	0.3733	0.375	0.3661	0.375	1982400.0
2001-01-23 18:00:00	AAPL	Stock	0.375	0.3761	0.375	0.3761	218400.0
2001-01-23 08:00:00	MSFT	Stock	30.0	30.1875	29.875	30.0625	117200.0
2001-01-23 09:00:00	MSFT	Stock	30.0625	30.1562	29.625	29.6875	7372600.0
2001-01-23 10:00:00	MSFT	Stock	29.7031	29.8125	29.4688	29.75	10974000.0
2001-01-23 11:00:00	MSFT	Stock	29.75	29.9688	29.625	29.8438	6485200.0
2001-01-23 12:00:00	MSFT	Stock	29.8125	30.0	29.7812	29.8125	5547000.0
2001-01-23 13:00:00	MSFT	Stock	29.8438	30.125	29.6875	30.0312	8707600.0
2001-01-23 14:00:00	MSFT	Stock	30.0312	30.4062	29.9688	30.3281	11689200.0
2001-01-23 15:00:00	MSFT	Stock	30.3281	30.4688	30.125	30.2812	11005600.0
2001-01-23 16:00:00	MSFT	Stock	30.2812	30.625	29.625	30.5625	2220600.0
2001-01-23 17:00:00	MSFT	Stock	30.5312	31.0625	29.875	30.6875	193000.0
2001-01-23 18:00:00	MSFT	Stock	30.8125	30.9375	30.8125	30.9375	7600.0
2001-01-23 09:00:00	NVDA	Stock	0.2078	0.2125	0.2049	0.2078	31704000.0
2001-01-23 10:00:00	NVDA	Stock	0.2073	0.21	0.2047	0.21	43512000.0
2001-01-23 11:00:00	NVDA	Stock	0.2096	0.2096	0.2055	0.2076	25032000.0
2001-01-23 12:00:00	NVDA	Stock	0.2078	0.2156	0.2073	0.2135	44160000.0
2001-01-23 13:00:00	NVDA	Stock	0.2146	0.2224	0.2138	0.2211	55104000.0
2001-01-23 14:00:00	NVDA	Stock	0.2214	0.225	0.2172	0.2245	51456000.0
2001-01-23 15:00:00	NVDA	Stock	0.2245	0.2333	0.2245	0.228	138816000.0
2001-01-23 16:00:00	NVDA	Stock	0.229	0.229	0.2253	0.2253	648000.0
2001-01-23 17:00:00	NVDA	Stock	0.2271	0.2271	0.2271	0.2271	96000.0
2001-01-23 18:00:00	NVDA	Stock	0.2281	0.2286	0.2281	0.2286	144000.0
2001-01-23 08:00:00	AMZN	Stock	0.9281	0.9281	0.925	0.925	58000.0
2001-01-23 09:00:00	AMZN	Stock	0.9188	0.9438	0.9094	0.9312	14310000.0
2001-01-23 10:00:00	AMZN	Stock	0.9281	0.95	0.9188	0.9375	7462000.0
2001-01-23 11:00:00	AMZN	Stock	0.9375	0.9594	0.9312	0.9469	15864000.0
2001-01-23 12:00:00	AMZN	Stock	0.95	0.9656	0.9469	0.9562	5170000.0
2001-01-23 13:00:00	AMZN	Stock	0.9562	0.9594	0.9438	0.9531	7816000.0
2001-01-23 14:00:00	AMZN	Stock	0.9531	0.9562	0.9344	0.9375	10194000.0
2001-01-23 15:00:00	AMZN	Stock	0.9375	0.9562	0.9188	0.95	21304000.0
2001-01-23 16:00:00	AMZN	Stock	0.95	0.95	0.9281	0.9469	2930000.0
2001-01-23 17:00:00	AMZN	Stock	0.9469	0.9469	0.9156	0.9375	146000.0
2001-01-23 18:00:00	AMZN	Stock	0.9406	0.9469	0.9406	0.9469	34000.0
2001-01-23 09:00:00	CL	Stock	28.515	28.97	28.41	28.76	281600.0
2001-01-23 10:00:00	CL	Stock	28.76	28.995	28.76	28.945	520200.0
2001-01-23 11:00:00	CL	Stock	28.945	29.03	28.925	29.025	380000.0
2001-01-23 12:00:00	CL	Stock	29.025	29.135	28.8	28.925	279600.0
2001-01-23 13:00:00	CL	Stock	28.92	29.0	28.8	28.84	248400.0
2001-01-23 14:00:00	CL	Stock	28.84	29.01	28.84	28.93	322400.0
2001-01-23 15:00:00	CL	Stock	28.93	29.0	28.87	28.87	431400.0

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

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