PREVIEW / stock_1hour / 2005-09-16

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-09-16.parquet
  size:    596 KB
  rows:    28,633
  symbols: 2,068

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-09-16 07:00:00	AAPL	Stock	1.7861	1.7932	1.7861	1.7932	45920.0
2005-09-16 08:00:00	AAPL	Stock	1.7932	1.8043	1.7911	1.7996	1423632.0
2005-09-16 09:00:00	AAPL	Stock	1.8	1.8036	1.7864	1.7932	144108664.0
2005-09-16 10:00:00	AAPL	Stock	1.7932	1.7986	1.7854	1.79	62048812.0
2005-09-16 11:00:00	AAPL	Stock	1.79	1.7975	1.7839	1.7918	51887808.0
2005-09-16 12:00:00	AAPL	Stock	1.7918	1.8036	1.7911	1.8	51136512.0
2005-09-16 13:00:00	AAPL	Stock	1.8	1.8036	1.7971	1.8018	28796488.0
2005-09-16 14:00:00	AAPL	Stock	1.8018	1.8161	1.7989	1.8143	56238532.0
2005-09-16 15:00:00	AAPL	Stock	1.8146	1.8286	1.8121	1.8286	121364348.0
2005-09-16 16:00:00	AAPL	Stock	1.8279	1.8289	1.8196	1.8268	4406444.0
2005-09-16 17:00:00	AAPL	Stock	1.8275	1.8304	1.8057	1.8289	1822800.0
2005-09-16 18:00:00	AAPL	Stock	1.8289	1.8289	1.8268	1.8268	499268.0
2005-09-16 08:00:00	MSFT	Stock	26.35	26.37	26.31	26.31	21740.0
2005-09-16 09:00:00	MSFT	Stock	26.35	26.4	26.2	26.29	27014140.0
2005-09-16 10:00:00	MSFT	Stock	26.28	26.33	26.15	26.172	8677320.0
2005-09-16 11:00:00	MSFT	Stock	26.18	26.299	26.06	26.11	10672374.0
2005-09-16 12:00:00	MSFT	Stock	26.11	26.12	26.02	26.078	8424116.0
2005-09-16 13:00:00	MSFT	Stock	26.07	26.08	25.97	26.04	10096835.0
2005-09-16 14:00:00	MSFT	Stock	26.04	26.15	26.03	26.12	10239959.0
2005-09-16 15:00:00	MSFT	Stock	26.12	26.24	25.99	26.06	29746063.0
2005-09-16 16:00:00	MSFT	Stock	26.07	26.16	26.05	26.13	6787121.0
2005-09-16 17:00:00	MSFT	Stock	26.13	26.14	26.07	26.11	1992814.0
2005-09-16 18:00:00	MSFT	Stock	26.14	26.14	26.06	26.07	3820399.0
2005-09-16 08:00:00	NVDA	Stock	0.2791	0.2791	0.2789	0.2789	48000.0
2005-09-16 09:00:00	NVDA	Stock	0.2788	0.2807	0.2768	0.278	78699120.0
2005-09-16 10:00:00	NVDA	Stock	0.278	0.2784	0.277	0.278	70915440.0
2005-09-16 11:00:00	NVDA	Stock	0.278	0.2782	0.2762	0.2774	77163000.0
2005-09-16 12:00:00	NVDA	Stock	0.2774	0.2784	0.2766	0.2779	55910760.0
2005-09-16 13:00:00	NVDA	Stock	0.2779	0.2779	0.2748	0.2762	61768920.0
2005-09-16 14:00:00	NVDA	Stock	0.2762	0.2773	0.2753	0.2772	24337200.0
2005-09-16 15:00:00	NVDA	Stock	0.2773	0.2777	0.2757	0.2771	100224720.0
2005-09-16 16:00:00	NVDA	Stock	0.2768	0.2782	0.2768	0.2774	6743280.0
2005-09-16 17:00:00	NVDA	Stock	0.2782	0.2782	0.2769	0.277	3817080.0
2005-09-16 18:00:00	NVDA	Stock	0.2771	0.2782	0.277	0.277	163680.0
2005-09-16 08:00:00	AMZN	Stock	2.1425	2.1425	2.1425	2.1425	2000.0
2005-09-16 09:00:00	AMZN	Stock	2.1435	2.1495	2.106	2.1255	24673200.0
2005-09-16 10:00:00	AMZN	Stock	2.1255	2.131	2.12	2.123	9414720.0
2005-09-16 11:00:00	AMZN	Stock	2.123	2.132	2.1205	2.13	10310260.0
2005-09-16 12:00:00	AMZN	Stock	2.1305	2.1315	2.1215	2.129	5225560.0
2005-09-16 13:00:00	AMZN	Stock	2.1295	2.1295	2.125	2.127	2473460.0
2005-09-16 14:00:00	AMZN	Stock	2.1265	2.1305	2.1255	2.127	4967040.0
2005-09-16 15:00:00	AMZN	Stock	2.127	2.1435	2.1235	2.1395	20891600.0
2005-09-16 16:00:00	AMZN	Stock	2.14	2.141	2.135	2.14	2122220.0
2005-09-16 17:00:00	AMZN	Stock	2.1395	2.14	2.1272	2.1272	68900.0
2005-09-16 18:00:00	AMZN	Stock	2.14	2.14	2.14	2.14	132000.0
2005-09-16 09:00:00	CL	Stock	26.6	26.745	26.4	26.476	1370600.0
2005-09-16 10:00:00	CL	Stock	26.48	26.575	26.435	26.5	306800.0
2005-09-16 11:00:00	CL	Stock	26.505	26.505	26.375	26.485	291800.0
2005-09-16 12:00:00	CL	Stock	26.485	26.53	26.46	26.5	305800.0
2005-09-16 13:00:00	CL	Stock	26.5	26.665	26.495	26.65	438000.0

> showing 50 of 28,633 rows — these rows as CSV

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