PREVIEW / stock_1hour / 2005-08-23

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-08-23.parquet
  size:    539 KB
  rows:    25,935
  symbols: 2,067

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-08-23 08:00:00	AAPL	Stock	1.6425	1.6496	1.6414	1.6421	130956.0
2005-08-23 09:00:00	AAPL	Stock	1.6421	1.6464	1.6307	1.6357	44122960.0
2005-08-23 10:00:00	AAPL	Stock	1.6357	1.6436	1.6307	1.6354	43011892.0
2005-08-23 11:00:00	AAPL	Stock	1.6354	1.6354	1.6214	1.6214	42460712.0
2005-08-23 12:00:00	AAPL	Stock	1.6218	1.6357	1.6186	1.6296	41677300.0
2005-08-23 13:00:00	AAPL	Stock	1.63	1.6321	1.625	1.6293	28162820.0
2005-08-23 14:00:00	AAPL	Stock	1.6293	1.6421	1.6271	1.6396	47857180.0
2005-08-23 15:00:00	AAPL	Stock	1.6396	1.6404	1.6307	1.6329	43157632.0
2005-08-23 16:00:00	AAPL	Stock	1.6332	1.6336	1.6318	1.6336	614012.0
2005-08-23 17:00:00	AAPL	Stock	1.6339	1.6339	1.6304	1.6304	58744.0
2005-08-23 18:00:00	AAPL	Stock	1.6304	1.6304	1.6304	1.6304	42000.0
2005-08-23 08:00:00	MSFT	Stock	26.92	26.92	26.82	26.89	8896.0
2005-08-23 09:00:00	MSFT	Stock	26.88	26.92	26.8	26.84	5856060.0
2005-08-23 10:00:00	MSFT	Stock	26.84	26.92	26.81	26.82	6610044.0
2005-08-23 11:00:00	MSFT	Stock	26.82	26.84	26.75	26.78	5353468.0
2005-08-23 12:00:00	MSFT	Stock	26.78	26.85	26.74	26.77	3651395.0
2005-08-23 13:00:00	MSFT	Stock	26.78	27.0	26.768	26.94	7419172.0
2005-08-23 14:00:00	MSFT	Stock	26.95	27.07	26.92	27.05	7675735.0
2005-08-23 15:00:00	MSFT	Stock	27.06	27.07	26.88	26.88	10438579.0
2005-08-23 16:00:00	MSFT	Stock	26.88	26.9	26.86	26.87	278500.0
2005-08-23 17:00:00	MSFT	Stock	26.89	26.89	26.86	26.86	2900.0
2005-08-23 18:00:00	MSFT	Stock	26.86	26.87	26.86	26.86	4245.0
2005-08-23 09:00:00	NVDA	Stock	0.2411	0.2437	0.2411	0.2418	34121880.0
2005-08-23 10:00:00	NVDA	Stock	0.242	0.2442	0.2418	0.2433	41373240.0
2005-08-23 11:00:00	NVDA	Stock	0.2433	0.2433	0.2408	0.241	28926120.0
2005-08-23 12:00:00	NVDA	Stock	0.241	0.2417	0.2408	0.2411	17909640.0
2005-08-23 13:00:00	NVDA	Stock	0.2411	0.2426	0.2402	0.2424	33348240.0
2005-08-23 14:00:00	NVDA	Stock	0.2422	0.2434	0.2418	0.2434	38826360.0
2005-08-23 15:00:00	NVDA	Stock	0.2434	0.2437	0.2425	0.2429	54276480.0
2005-08-23 16:00:00	NVDA	Stock	0.2427	0.2442	0.2426	0.2437	576000.0
2005-08-23 08:00:00	AMZN	Stock	2.192	2.192	2.192	2.192	2000.0
2005-08-23 09:00:00	AMZN	Stock	2.187	2.1985	2.1745	2.1755	8001760.0
2005-08-23 10:00:00	AMZN	Stock	2.175	2.1845	2.1715	2.179	9885660.0
2005-08-23 11:00:00	AMZN	Stock	2.179	2.179	2.1645	2.1775	12669160.0
2005-08-23 12:00:00	AMZN	Stock	2.177	2.183	2.167	2.172	7330100.0
2005-08-23 13:00:00	AMZN	Stock	2.1715	2.1795	2.168	2.1755	4398520.0
2005-08-23 14:00:00	AMZN	Stock	2.175	2.182	2.1665	2.168	7652220.0
2005-08-23 15:00:00	AMZN	Stock	2.168	2.1745	2.161	2.172	18087360.0
2005-08-23 16:00:00	AMZN	Stock	2.1725	2.179	2.1679	2.1775	1618620.0
2005-08-23 17:00:00	AMZN	Stock	2.175	2.175	2.175	2.175	28000.0
2005-08-23 18:00:00	AMZN	Stock	2.1655	2.1655	2.1635	2.1635	34000.0
2005-08-23 09:00:00	CL	Stock	26.225	26.32	26.2	26.23	308000.0
2005-08-23 10:00:00	CL	Stock	26.235	26.495	26.225	26.495	762000.0
2005-08-23 11:00:00	CL	Stock	26.495	26.52	26.355	26.445	621400.0
2005-08-23 12:00:00	CL	Stock	26.45	26.45	26.365	26.44	351600.0
2005-08-23 13:00:00	CL	Stock	26.445	26.465	26.36	26.46	374800.0
2005-08-23 14:00:00	CL	Stock	26.455	26.595	26.435	26.545	618600.0
2005-08-23 15:00:00	CL	Stock	26.545	26.62	26.505	26.525	820800.0

> showing 48 of 25,935 rows — these rows as CSV

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