PREVIEW / stock_1hour / 2001-06-11

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-06-11.parquet
  size:    362 KB
  rows:    17,199
  symbols: 1,303

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-06-11 08:00:00	AAPL	Stock	0.3777	0.3821	0.3752	0.3754	33600.0
2001-06-11 09:00:00	AAPL	Stock	0.3795	0.3802	0.3707	0.372	19129600.0
2001-06-11 10:00:00	AAPL	Stock	0.3716	0.3725	0.358	0.3584	60939200.0
2001-06-11 11:00:00	AAPL	Stock	0.3582	0.3616	0.3571	0.36	33706400.0
2001-06-11 12:00:00	AAPL	Stock	0.3602	0.3625	0.3589	0.3609	19068000.0
2001-06-11 13:00:00	AAPL	Stock	0.3609	0.3638	0.3575	0.3588	17584000.0
2001-06-11 14:00:00	AAPL	Stock	0.3589	0.3629	0.3571	0.3577	28952000.0
2001-06-11 15:00:00	AAPL	Stock	0.3579	0.3602	0.3563	0.358	83188000.0
2001-06-11 16:00:00	AAPL	Stock	0.3582	0.3623	0.3571	0.358	16878400.0
2001-06-11 17:00:00	AAPL	Stock	0.3579	0.3579	0.3571	0.3579	6272000.0
2001-06-11 08:00:00	MSFT	Stock	36.45	36.55	36.45	36.525	56200.0
2001-06-11 09:00:00	MSFT	Stock	36.525	36.595	36.05	36.15	6156600.0
2001-06-11 10:00:00	MSFT	Stock	36.15	36.285	36.025	36.145	7050600.0
2001-06-11 11:00:00	MSFT	Stock	36.145	36.17	35.755	35.915	6982600.0
2001-06-11 12:00:00	MSFT	Stock	35.915	35.99	35.825	35.875	3217200.0
2001-06-11 13:00:00	MSFT	Stock	35.88	36.0	35.765	35.84	4791200.0
2001-06-11 14:00:00	MSFT	Stock	35.84	35.95	35.78	35.905	5595600.0
2001-06-11 15:00:00	MSFT	Stock	35.9	36.175	35.835	36.06	7996200.0
2001-06-11 16:00:00	MSFT	Stock	36.06	36.155	35.93	36.0	1717200.0
2001-06-11 17:00:00	MSFT	Stock	36.0	36.06	36.0	36.0	927600.0
2001-06-11 18:00:00	MSFT	Stock	36.06	36.095	36.02	36.095	1600.0
2001-06-11 08:00:00	NVDA	Stock	0.4022	0.4022	0.4022	0.4022	24000.0
2001-06-11 09:00:00	NVDA	Stock	0.4017	0.4045	0.3902	0.3916	91776000.0
2001-06-11 10:00:00	NVDA	Stock	0.3916	0.3935	0.3885	0.3896	103440000.0
2001-06-11 11:00:00	NVDA	Stock	0.3896	0.3898	0.3851	0.3888	87000000.0
2001-06-11 12:00:00	NVDA	Stock	0.3893	0.3923	0.3888	0.3917	49440000.0
2001-06-11 13:00:00	NVDA	Stock	0.3917	0.394	0.3898	0.3911	48216000.0
2001-06-11 14:00:00	NVDA	Stock	0.391	0.3965	0.3896	0.395	60240000.0
2001-06-11 15:00:00	NVDA	Stock	0.395	0.3962	0.3913	0.3915	89256000.0
2001-06-11 16:00:00	NVDA	Stock	0.3914	0.3929	0.3913	0.3913	8160000.0
2001-06-11 17:00:00	NVDA	Stock	0.3913	0.3925	0.391	0.3917	4776000.0
2001-06-11 18:00:00	NVDA	Stock	0.3918	0.3918	0.3918	0.3918	72000.0
2001-06-11 08:00:00	AMZN	Stock	0.785	0.785	0.78	0.78	4000.0
2001-06-11 09:00:00	AMZN	Stock	0.7825	0.7825	0.7625	0.7625	6074000.0
2001-06-11 10:00:00	AMZN	Stock	0.7625	0.77	0.7475	0.751	11484000.0
2001-06-11 11:00:00	AMZN	Stock	0.751	0.7555	0.7375	0.7375	14350000.0
2001-06-11 12:00:00	AMZN	Stock	0.7375	0.7375	0.7225	0.7265	15662000.0
2001-06-11 13:00:00	AMZN	Stock	0.7275	0.74	0.725	0.728	11332000.0
2001-06-11 14:00:00	AMZN	Stock	0.73	0.747	0.728	0.743	12876000.0
2001-06-11 15:00:00	AMZN	Stock	0.7425	0.755	0.7415	0.7435	18354000.0
2001-06-11 16:00:00	AMZN	Stock	0.7435	0.7435	0.739	0.7425	2090000.0
2001-06-11 17:00:00	AMZN	Stock	0.7425	0.749	0.7425	0.749	1196000.0
2001-06-11 09:00:00	CL	Stock	29.44	29.44	29.275	29.305	126800.0
2001-06-11 10:00:00	CL	Stock	29.305	29.345	29.2	29.255	197000.0
2001-06-11 11:00:00	CL	Stock	29.255	29.29	29.235	29.29	174000.0
2001-06-11 12:00:00	CL	Stock	29.305	29.375	29.275	29.305	82400.0
2001-06-11 13:00:00	CL	Stock	29.31	29.375	29.225	29.23	148800.0
2001-06-11 14:00:00	CL	Stock	29.245	29.34	29.245	29.3	176200.0
2001-06-11 15:00:00	CL	Stock	29.31	29.425	29.285	29.395	524400.0
2001-06-11 16:00:00	CL	Stock	29.4	29.41	29.4	29.41	125600.0

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

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