PREVIEW / stock_1hour / 2001-12-31

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-12-31.parquet
  size:    417 KB
  rows:    20,116
  symbols: 1,366

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-12-31 08:00:00	AAPL	Stock	0.4025	0.4025	0.4025	0.4025	22400.0
2001-12-31 09:00:00	AAPL	Stock	0.4027	0.4045	0.3968	0.4043	10572800.0
2001-12-31 10:00:00	AAPL	Stock	0.4043	0.4046	0.3991	0.4014	20400800.0
2001-12-31 11:00:00	AAPL	Stock	0.4014	0.4018	0.3995	0.3995	8355200.0
2001-12-31 12:00:00	AAPL	Stock	0.3995	0.4013	0.3984	0.3984	8461600.0
2001-12-31 13:00:00	AAPL	Stock	0.3984	0.3998	0.398	0.3986	8276800.0
2001-12-31 14:00:00	AAPL	Stock	0.3986	0.3988	0.3968	0.3973	14425600.0
2001-12-31 15:00:00	AAPL	Stock	0.3972	0.4002	0.3898	0.3911	52304000.0
2001-12-31 16:00:00	AAPL	Stock	0.3911	0.3913	0.3895	0.3912	12404000.0
2001-12-31 17:00:00	AAPL	Stock	0.3911	0.3911	0.3911	0.3911	789600.0
2001-12-31 18:00:00	AAPL	Stock	0.392	0.3921	0.3911	0.3911	425600.0
2001-12-31 08:00:00	MSFT	Stock	33.935	34.05	33.935	33.99	11600.0
2001-12-31 09:00:00	MSFT	Stock	34.0	34.1705	33.7745	34.15	4727600.0
2001-12-31 10:00:00	MSFT	Stock	34.1495	34.24	33.77	33.95	5303400.0
2001-12-31 11:00:00	MSFT	Stock	33.965	33.995	33.59	33.645	3871200.0
2001-12-31 12:00:00	MSFT	Stock	33.655	33.715	33.505	33.54	3387400.0
2001-12-31 13:00:00	MSFT	Stock	33.54	33.615	33.43	33.505	3254200.0
2001-12-31 14:00:00	MSFT	Stock	33.505	33.525	33.3	33.31	4026800.0
2001-12-31 15:00:00	MSFT	Stock	33.305	33.43	33.125	33.14	9710600.0
2001-12-31 16:00:00	MSFT	Stock	33.125	33.6572	33.05	33.1382	7827400.0
2001-12-31 17:00:00	MSFT	Stock	33.13	33.16	33.1	33.135	245400.0
2001-12-31 18:00:00	MSFT	Stock	33.135	33.175	33.125	33.14	35600.0
2001-12-31 08:00:00	NVDA	Stock	0.5658	0.5683	0.5658	0.5679	216000.0
2001-12-31 09:00:00	NVDA	Stock	0.5679	0.5696	0.5605	0.5637	80424000.0
2001-12-31 10:00:00	NVDA	Stock	0.5638	0.5652	0.5562	0.5647	114504000.0
2001-12-31 11:00:00	NVDA	Stock	0.565	0.5667	0.5637	0.5647	67380000.0
2001-12-31 12:00:00	NVDA	Stock	0.5649	0.5686	0.5639	0.5658	54516000.0
2001-12-31 13:00:00	NVDA	Stock	0.5659	0.5717	0.5659	0.5686	52452000.0
2001-12-31 14:00:00	NVDA	Stock	0.5686	0.5697	0.5617	0.5624	60324000.0
2001-12-31 15:00:00	NVDA	Stock	0.5625	0.5663	0.5571	0.5576	218616000.0
2001-12-31 16:00:00	NVDA	Stock	0.5576	0.5617	0.5517	0.5577	57336000.0
2001-12-31 17:00:00	NVDA	Stock	0.5567	0.5583	0.5562	0.5575	864000.0
2001-12-31 18:00:00	NVDA	Stock	0.5575	0.5598	0.5575	0.5598	144000.0
2001-12-31 08:00:00	AMZN	Stock	0.54	0.56	0.54	0.556	520000.0
2001-12-31 09:00:00	AMZN	Stock	0.5565	0.56	0.543	0.5495	16252000.0
2001-12-31 10:00:00	AMZN	Stock	0.5485	0.55	0.544	0.5445	13920000.0
2001-12-31 11:00:00	AMZN	Stock	0.5445	0.5465	0.543	0.5465	9674000.0
2001-12-31 12:00:00	AMZN	Stock	0.5465	0.5525	0.545	0.55	14760000.0
2001-12-31 13:00:00	AMZN	Stock	0.55	0.5575	0.55	0.555	12032000.0
2001-12-31 14:00:00	AMZN	Stock	0.555	0.5595	0.55	0.5525	12394000.0
2001-12-31 15:00:00	AMZN	Stock	0.551	0.5565	0.537	0.5405	26568000.0
2001-12-31 16:00:00	AMZN	Stock	0.5405	0.5535	0.5315	0.541	7676000.0
2001-12-31 17:00:00	AMZN	Stock	0.5415	0.544	0.5399	0.544	1158000.0
2001-12-31 18:00:00	AMZN	Stock	0.541	0.5425	0.541	0.5425	32000.0
2001-12-31 09:00:00	CL	Stock	29.0	29.0	28.875	28.91	189800.0
2001-12-31 10:00:00	CL	Stock	28.915	28.925	28.845	28.91	196600.0
2001-12-31 11:00:00	CL	Stock	28.91	28.955	28.825	28.845	143400.0
2001-12-31 12:00:00	CL	Stock	28.86	28.88	28.775	28.84	106800.0
2001-12-31 13:00:00	CL	Stock	28.84	29.195	28.805	29.165	295800.0
2001-12-31 14:00:00	CL	Stock	29.17	29.18	28.97	28.99	337400.0

> showing 50 of 20,116 rows — these rows as CSV

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