PREVIEW / stock_1hour / 2001-05-01

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-05-01.parquet
  size:    359 KB
  rows:    16,913
  symbols: 1,289

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-01 08:00:00	AAPL	Stock	0.4536	0.4554	0.4523	0.4536	134400.0
2001-05-01 09:00:00	AAPL	Stock	0.4536	0.4625	0.4509	0.4605	41832000.0
2001-05-01 10:00:00	AAPL	Stock	0.4609	0.4673	0.45	0.4634	56319200.0
2001-05-01 11:00:00	AAPL	Stock	0.4632	0.4732	0.457	0.47	70711200.0
2001-05-01 12:00:00	AAPL	Stock	0.4696	0.47	0.4595	0.4611	33056800.0
2001-05-01 13:00:00	AAPL	Stock	0.4613	0.4729	0.4571	0.4625	40712000.0
2001-05-01 14:00:00	AAPL	Stock	0.4614	0.4691	0.4571	0.4688	55904800.0
2001-05-01 15:00:00	AAPL	Stock	0.4688	0.4704	0.4593	0.463	75936000.0
2001-05-01 16:00:00	AAPL	Stock	0.4629	0.4688	0.4618	0.4668	16318400.0
2001-05-01 17:00:00	AAPL	Stock	0.4668	0.4696	0.4625	0.4661	2654400.0
2001-05-01 18:00:00	AAPL	Stock	0.4664	0.4704	0.4664	0.4704	33600.0
2001-05-01 08:00:00	MSFT	Stock	33.68	33.795	33.495	33.76	117200.0
2001-05-01 09:00:00	MSFT	Stock	33.76	34.345	33.32	34.295	9680200.0
2001-05-01 10:00:00	MSFT	Stock	34.295	34.48	34.01	34.445	12024600.0
2001-05-01 11:00:00	MSFT	Stock	34.445	34.54	34.125	34.5	9248000.0
2001-05-01 12:00:00	MSFT	Stock	34.5	34.675	34.465	34.665	6082200.0
2001-05-01 13:00:00	MSFT	Stock	34.665	34.83	34.25	34.73	7981800.0
2001-05-01 14:00:00	MSFT	Stock	34.73	35.025	34.69	34.99	15220200.0
2001-05-01 15:00:00	MSFT	Stock	34.99	35.15	34.875	35.085	14163600.0
2001-05-01 16:00:00	MSFT	Stock	35.08	35.29	34.69	35.18	2778800.0
2001-05-01 17:00:00	MSFT	Stock	35.065	35.23	35.065	35.23	484400.0
2001-05-01 18:00:00	MSFT	Stock	35.24	35.3	35.19	35.25	14000.0
2001-05-01 08:00:00	NVDA	Stock	0.3453	0.3458	0.3406	0.3458	504000.0
2001-05-01 09:00:00	NVDA	Stock	0.3479	0.3552	0.3433	0.3535	149904000.0
2001-05-01 10:00:00	NVDA	Stock	0.3536	0.3554	0.3427	0.3532	286416000.0
2001-05-01 11:00:00	NVDA	Stock	0.3534	0.3638	0.3519	0.3634	257040000.0
2001-05-01 12:00:00	NVDA	Stock	0.3638	0.3655	0.3598	0.3646	156648000.0
2001-05-01 13:00:00	NVDA	Stock	0.3647	0.3704	0.3617	0.3638	221544000.0
2001-05-01 14:00:00	NVDA	Stock	0.3641	0.3702	0.3632	0.3695	211992000.0
2001-05-01 15:00:00	NVDA	Stock	0.3695	0.3804	0.3683	0.3795	437808000.0
2001-05-01 16:00:00	NVDA	Stock	0.3795	0.3865	0.3793	0.3837	33528000.0
2001-05-01 17:00:00	NVDA	Stock	0.3837	0.3869	0.3795	0.3869	1200000.0
2001-05-01 18:00:00	NVDA	Stock	0.3867	0.3874	0.3854	0.3874	408000.0
2001-05-01 08:00:00	AMZN	Stock	0.79	0.7915	0.7825	0.7915	58000.0
2001-05-01 09:00:00	AMZN	Stock	0.8015	0.803	0.775	0.7995	11862000.0
2001-05-01 10:00:00	AMZN	Stock	0.799	0.8145	0.7965	0.8025	21300000.0
2001-05-01 11:00:00	AMZN	Stock	0.803	0.805	0.795	0.799	8930000.0
2001-05-01 12:00:00	AMZN	Stock	0.798	0.8015	0.79	0.796	6212000.0
2001-05-01 13:00:00	AMZN	Stock	0.796	0.805	0.7955	0.802	5718000.0
2001-05-01 14:00:00	AMZN	Stock	0.802	0.8125	0.802	0.8115	11050000.0
2001-05-01 15:00:00	AMZN	Stock	0.8115	0.8465	0.81	0.845	24698000.0
2001-05-01 16:00:00	AMZN	Stock	0.845	0.8525	0.839	0.8425	3754000.0
2001-05-01 17:00:00	AMZN	Stock	0.8445	0.8625	0.843	0.8625	820000.0
2001-05-01 18:00:00	AMZN	Stock	0.86	0.8615	0.8445	0.86	94000.0
2001-05-01 09:00:00	CL	Stock	28.25	28.525	28.225	28.5	564000.0
2001-05-01 10:00:00	CL	Stock	28.5	28.51	28.2	28.475	395200.0
2001-05-01 11:00:00	CL	Stock	28.45	28.495	28.2	28.225	365800.0
2001-05-01 12:00:00	CL	Stock	28.235	28.235	28.025	28.03	315000.0
2001-05-01 13:00:00	CL	Stock	28.03	28.05	27.75	27.98	746200.0
2001-05-01 14:00:00	CL	Stock	27.98	28.08	27.975	28.02	422200.0

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

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