PREVIEW / stock_1hour / 2001-11-27

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-11-27.parquet
  size:    379 KB
  rows:    18,103
  symbols: 1,360

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-11-27 08:00:00	AAPL	Stock	0.3815	0.3816	0.3786	0.3786	1047200.0
2001-11-27 09:00:00	AAPL	Stock	0.3795	0.3813	0.375	0.377	38376800.0
2001-11-27 10:00:00	AAPL	Stock	0.3757	0.3766	0.3662	0.3675	45634400.0
2001-11-27 11:00:00	AAPL	Stock	0.3678	0.3713	0.367	0.3705	20686400.0
2001-11-27 12:00:00	AAPL	Stock	0.3704	0.3734	0.3698	0.3727	17354400.0
2001-11-27 13:00:00	AAPL	Stock	0.3727	0.3804	0.3725	0.3804	43808800.0
2001-11-27 14:00:00	AAPL	Stock	0.3804	0.3843	0.3782	0.3789	26280800.0
2001-11-27 15:00:00	AAPL	Stock	0.3789	0.38	0.3709	0.375	59836000.0
2001-11-27 16:00:00	AAPL	Stock	0.3754	0.3793	0.3711	0.375	5471200.0
2001-11-27 17:00:00	AAPL	Stock	0.375	0.375	0.375	0.375	498400.0
2001-11-27 08:00:00	MSFT	Stock	32.425	32.57	32.34	32.425	117600.0
2001-11-27 09:00:00	MSFT	Stock	32.45	32.57	32.15	32.165	7555800.0
2001-11-27 10:00:00	MSFT	Stock	32.17	32.175	31.425	31.445	15835000.0
2001-11-27 11:00:00	MSFT	Stock	31.445	31.64	31.375	31.492	10229200.0
2001-11-27 12:00:00	MSFT	Stock	31.49	31.855	31.485	31.8	11504800.0
2001-11-27 13:00:00	MSFT	Stock	31.805	32.375	31.775	32.37	14608600.0
2001-11-27 14:00:00	MSFT	Stock	32.37	32.5385	32.1205	32.125	11319000.0
2001-11-27 15:00:00	MSFT	Stock	32.135	32.29	31.7595	31.875	13372800.0
2001-11-27 16:00:00	MSFT	Stock	31.87	31.935	31.75	31.87	2362000.0
2001-11-27 17:00:00	MSFT	Stock	31.875	31.875	31.745	31.78	107000.0
2001-11-27 18:00:00	MSFT	Stock	31.8	31.875	31.8	31.875	2200.0
2001-11-27 08:00:00	NVDA	Stock	0.4496	0.4496	0.4417	0.4443	732000.0
2001-11-27 09:00:00	NVDA	Stock	0.4455	0.4537	0.4442	0.4521	198492000.0
2001-11-27 10:00:00	NVDA	Stock	0.4517	0.4529	0.4375	0.4421	236460000.0
2001-11-27 11:00:00	NVDA	Stock	0.442	0.4491	0.4417	0.449	112512000.0
2001-11-27 12:00:00	NVDA	Stock	0.4485	0.4546	0.4484	0.4543	102036000.0
2001-11-27 13:00:00	NVDA	Stock	0.4546	0.459	0.4529	0.4587	168576000.0
2001-11-27 14:00:00	NVDA	Stock	0.4583	0.4608	0.4552	0.457	139980000.0
2001-11-27 15:00:00	NVDA	Stock	0.457	0.4583	0.4459	0.4508	167700000.0
2001-11-27 16:00:00	NVDA	Stock	0.4504	0.4522	0.4501	0.4502	12252000.0
2001-11-27 17:00:00	NVDA	Stock	0.4502	0.4516	0.4491	0.4501	1020000.0
2001-11-27 18:00:00	NVDA	Stock	0.4512	0.4525	0.4512	0.4525	60000.0
2001-11-27 08:00:00	AMZN	Stock	0.611	0.6176	0.6	0.615	6574000.0
2001-11-27 09:00:00	AMZN	Stock	0.615	0.6175	0.578	0.58	166454000.0
2001-11-27 10:00:00	AMZN	Stock	0.58	0.5855	0.561	0.567	140520000.0
2001-11-27 11:00:00	AMZN	Stock	0.567	0.5825	0.565	0.5755	68800000.0
2001-11-27 12:00:00	AMZN	Stock	0.5755	0.5835	0.573	0.5765	44602000.0
2001-11-27 13:00:00	AMZN	Stock	0.577	0.6015	0.5765	0.5995	69170000.0
2001-11-27 14:00:00	AMZN	Stock	0.5995	0.6025	0.575	0.5815	67170000.0
2001-11-27 15:00:00	AMZN	Stock	0.582	0.587	0.5645	0.574	73120000.0
2001-11-27 16:00:00	AMZN	Stock	0.574	0.6035	0.5685	0.5825	20318000.0
2001-11-27 17:00:00	AMZN	Stock	0.5735	0.58	0.5735	0.5795	380000.0
2001-11-27 18:00:00	AMZN	Stock	0.5775	0.5775	0.5765	0.5775	186000.0
2001-11-27 09:00:00	CL	Stock	29.375	29.38	29.265	29.33	204800.0
2001-11-27 10:00:00	CL	Stock	29.33	29.33	29.15	29.165	366000.0
2001-11-27 11:00:00	CL	Stock	29.175	29.445	29.16	29.205	205800.0
2001-11-27 12:00:00	CL	Stock	29.205	29.205	29.015	29.035	197600.0
2001-11-27 13:00:00	CL	Stock	29.03	29.19	29.005	29.08	345800.0
2001-11-27 14:00:00	CL	Stock	29.08	29.205	29.0	29.05	638800.0
2001-11-27 15:00:00	CL	Stock	29.05	29.1	28.875	28.895	683400.0

> showing 50 of 18,103 rows — these rows as CSV

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