PREVIEW / stock_1hour / 2006-11-02

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-11-02.parquet
  size:    631 KB
  rows:    30,275
  symbols: 2,440

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
2006-11-02 08:00:00	AAPL	Stock	2.8421	2.8514	2.8193	2.8193	3341856.0
2006-11-02 09:00:00	AAPL	Stock	2.8193	2.8304	2.8036	2.8168	82634972.0
2006-11-02 10:00:00	AAPL	Stock	2.8171	2.8304	2.8125	2.82	90350344.0
2006-11-02 11:00:00	AAPL	Stock	2.82	2.8329	2.8111	2.8136	71539020.0
2006-11-02 12:00:00	AAPL	Stock	2.8129	2.8196	2.8129	2.8189	41137460.0
2006-11-02 13:00:00	AAPL	Stock	2.8189	2.8207	2.8154	2.8182	41745984.0
2006-11-02 14:00:00	AAPL	Stock	2.8182	2.8286	2.8171	2.8171	50975848.0
2006-11-02 15:00:00	AAPL	Stock	2.8171	2.8264	2.8129	2.8189	59318140.0
2006-11-02 16:00:00	AAPL	Stock	2.82	2.8232	2.8189	2.8196	1662220.0
2006-11-02 17:00:00	AAPL	Stock	2.8207	2.8214	2.8186	2.8214	1002596.0
2006-11-02 18:00:00	AAPL	Stock	2.8214	2.8214	2.8214	2.8214	64400.0
2006-11-02 19:00:00	AAPL	Stock	2.8221	2.8221	2.8221	2.8221	27664.0
2006-11-02 07:00:00	MSFT	Stock	28.81	28.81	28.81	28.81	1000.0
2006-11-02 08:00:00	MSFT	Stock	28.81	28.81	28.67	28.67	46968.0
2006-11-02 09:00:00	MSFT	Stock	28.66	28.8	28.58	28.75	7285352.0
2006-11-02 10:00:00	MSFT	Stock	28.76	28.83	28.74	28.76	7316037.0
2006-11-02 11:00:00	MSFT	Stock	28.76	28.86	28.74	28.79	10461446.0
2006-11-02 12:00:00	MSFT	Stock	28.8	28.82	28.76	28.79	4646776.0
2006-11-02 13:00:00	MSFT	Stock	28.8	28.8	28.68	28.76	6903900.0
2006-11-02 14:00:00	MSFT	Stock	28.76	28.82	28.73	28.79	4186106.0
2006-11-02 15:00:00	MSFT	Stock	28.8	28.82	28.73	28.75	6481343.0
2006-11-02 16:00:00	MSFT	Stock	28.76	28.77	28.73	28.74	77360.0
2006-11-02 17:00:00	MSFT	Stock	28.75	28.81	28.74	28.81	297384.0
2006-11-02 18:00:00	MSFT	Stock	28.79	28.81	28.79	28.81	222.0
2006-11-02 06:00:00	NVDA	Stock	0.5363	0.5363	0.5363	0.5363	6000.0
2006-11-02 07:00:00	NVDA	Stock	0.54	0.5442	0.54	0.5442	18000.0
2006-11-02 08:00:00	NVDA	Stock	0.5383	0.5435	0.5383	0.5388	1075200.0
2006-11-02 09:00:00	NVDA	Stock	0.5388	0.5505	0.5347	0.5503	143437500.0
2006-11-02 10:00:00	NVDA	Stock	0.55	0.5503	0.5422	0.5485	154659660.0
2006-11-02 11:00:00	NVDA	Stock	0.5487	0.5487	0.5413	0.5425	81787860.0
2006-11-02 12:00:00	NVDA	Stock	0.5425	0.545	0.5318	0.5322	115950420.0
2006-11-02 13:00:00	NVDA	Stock	0.5322	0.5382	0.53	0.5328	81153600.0
2006-11-02 14:00:00	NVDA	Stock	0.5328	0.5338	0.5263	0.5272	80621400.0
2006-11-02 15:00:00	NVDA	Stock	0.5272	0.5345	0.5253	0.5313	140283420.0
2006-11-02 16:00:00	NVDA	Stock	0.532	0.5348	0.53	0.5347	2532300.0
2006-11-02 17:00:00	NVDA	Stock	0.5333	0.535	0.533	0.5337	552300.0
2006-11-02 08:00:00	AMZN	Stock	1.879	1.879	1.861	1.861	365400.0
2006-11-02 09:00:00	AMZN	Stock	1.86	1.881	1.8555	1.879	19924680.0
2006-11-02 10:00:00	AMZN	Stock	1.878	1.8885	1.8625	1.881	23692220.0
2006-11-02 11:00:00	AMZN	Stock	1.8805	1.886	1.8765	1.8795	11943600.0
2006-11-02 12:00:00	AMZN	Stock	1.8795	1.885	1.872	1.873	7923040.0
2006-11-02 13:00:00	AMZN	Stock	1.873	1.875	1.869	1.8725	10231880.0
2006-11-02 14:00:00	AMZN	Stock	1.8725	1.8775	1.8692	1.8715	11310540.0
2006-11-02 15:00:00	AMZN	Stock	1.871	1.875	1.8655	1.872	20466660.0
2006-11-02 16:00:00	AMZN	Stock	1.873	1.873	1.87	1.87	87040.0
2006-11-02 17:00:00	AMZN	Stock	1.8725	1.875	1.8725	1.875	32500.0
2006-11-02 08:00:00	CL	Stock	32.005	32.005	32.005	32.005	90000.0
2006-11-02 09:00:00	CL	Stock	31.95	32.04	31.85	31.86	347000.0
2006-11-02 10:00:00	CL	Stock	31.855	31.895	31.825	31.88	415000.0
2006-11-02 11:00:00	CL	Stock	31.875	31.94	31.66	31.685	457200.0

> showing 50 of 30,275 rows — these rows as CSV

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