PREVIEW / stock_1hour / 2005-06-24

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-06-24.parquet
  size:    610 KB
  rows:    27,967
  symbols: 1,994

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
2005-06-24 08:00:00	AAPL	Stock	1.3925	1.3929	1.3893	1.3907	510440.0
2005-06-24 09:00:00	AAPL	Stock	1.3911	1.3971	1.3704	1.3821	48943944.0
2005-06-24 10:00:00	AAPL	Stock	1.3821	1.3861	1.3732	1.3807	52138464.0
2005-06-24 11:00:00	AAPL	Stock	1.3814	1.3846	1.3704	1.3746	33583648.0
2005-06-24 12:00:00	AAPL	Stock	1.3749	1.3757	1.3661	1.3661	24577672.0
2005-06-24 13:00:00	AAPL	Stock	1.3661	1.3714	1.3479	1.3511	70349720.0
2005-06-24 14:00:00	AAPL	Stock	1.3507	1.3557	1.3457	1.3496	42819476.0
2005-06-24 15:00:00	AAPL	Stock	1.3496	1.3571	1.3482	1.35	76129340.0
2005-06-24 16:00:00	AAPL	Stock	1.3511	1.3511	1.3454	1.3485	15979880.0
2005-06-24 17:00:00	AAPL	Stock	1.3486	1.3489	1.3471	1.3489	8382892.0
2005-06-24 18:00:00	AAPL	Stock	1.3489	1.3493	1.3475	1.3488	21157024.0
2005-06-24 08:00:00	MSFT	Stock	25.45	25.45	25.31	25.35	64960.0
2005-06-24 09:00:00	MSFT	Stock	25.35	25.4	25.21	25.39	6815575.0
2005-06-24 10:00:00	MSFT	Stock	25.39	25.4	25.2	25.26	6558342.0
2005-06-24 11:00:00	MSFT	Stock	25.26	25.3	25.2	25.21	6050827.0
2005-06-24 12:00:00	MSFT	Stock	25.21	25.29	25.18	25.26	4735819.0
2005-06-24 13:00:00	MSFT	Stock	25.26	25.31	25.19	25.21	5794817.0
2005-06-24 14:00:00	MSFT	Stock	25.21	25.24	25.15	25.17	6115207.0
2005-06-24 15:00:00	MSFT	Stock	25.17	25.17	25.05	25.09	14323861.0
2005-06-24 16:00:00	MSFT	Stock	25.08	25.1	25.02	25.08	3523842.0
2005-06-24 17:00:00	MSFT	Stock	25.08	25.09	25.037	25.09	1732474.0
2005-06-24 18:00:00	MSFT	Stock	25.08	25.09	25.033	25.09	2493664.0
2005-06-24 08:00:00	NVDA	Stock	0.2329	0.2329	0.2329	0.2329	12000.0
2005-06-24 09:00:00	NVDA	Stock	0.2329	0.2329	0.2296	0.2302	48443520.0
2005-06-24 10:00:00	NVDA	Stock	0.2303	0.231	0.2277	0.2287	85835280.0
2005-06-24 11:00:00	NVDA	Stock	0.2287	0.2303	0.228	0.2284	38134440.0
2005-06-24 12:00:00	NVDA	Stock	0.2284	0.2294	0.2282	0.2287	27704760.0
2005-06-24 13:00:00	NVDA	Stock	0.2287	0.2292	0.2281	0.2284	38429400.0
2005-06-24 14:00:00	NVDA	Stock	0.2284	0.2285	0.2272	0.228	39863280.0
2005-06-24 15:00:00	NVDA	Stock	0.2279	0.2282	0.2245	0.2257	163194360.0
2005-06-24 16:00:00	NVDA	Stock	0.2261	0.2261	0.2255	0.2258	2937480.0
2005-06-24 17:00:00	NVDA	Stock	0.2258	0.2259	0.2256	0.2259	5924160.0
2005-06-24 18:00:00	NVDA	Stock	0.2262	0.2262	0.2258	0.2258	391680.0
2005-06-24 09:00:00	AMZN	Stock	1.7625	1.7715	1.7535	1.768	8652260.0
2005-06-24 10:00:00	AMZN	Stock	1.7685	1.772	1.754	1.7565	13344160.0
2005-06-24 11:00:00	AMZN	Stock	1.757	1.768	1.7505	1.754	8242860.0
2005-06-24 12:00:00	AMZN	Stock	1.753	1.7545	1.751	1.7525	7633900.0
2005-06-24 13:00:00	AMZN	Stock	1.7525	1.7535	1.7475	1.7485	7980180.0
2005-06-24 14:00:00	AMZN	Stock	1.7485	1.752	1.744	1.7505	9901200.0
2005-06-24 15:00:00	AMZN	Stock	1.7505	1.766	1.7485	1.7515	15317040.0
2005-06-24 16:00:00	AMZN	Stock	1.7515	1.7545	1.75	1.751	395660.0
2005-06-24 17:00:00	AMZN	Stock	1.7511	1.7524	1.7505	1.7522	337200.0
2005-06-24 18:00:00	AMZN	Stock	1.7509	1.7514	1.7506	1.7514	319940.0
2005-06-24 08:00:00	CL	Stock	25.8	25.8	25.8	25.8	400.0
2005-06-24 09:00:00	CL	Stock	25.725	25.8	25.63	25.655	580600.0
2005-06-24 10:00:00	CL	Stock	25.65	25.655	25.525	25.565	932600.0
2005-06-24 11:00:00	CL	Stock	25.55	25.58	25.34	25.355	747200.0
2005-06-24 12:00:00	CL	Stock	25.355	25.415	25.3	25.35	505400.0
2005-06-24 13:00:00	CL	Stock	25.345	25.375	25.26	25.34	574000.0
2005-06-24 14:00:00	CL	Stock	25.34	25.34	25.155	25.305	751800.0

> showing 50 of 27,967 rows — these rows as CSV

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