PREVIEW / stock_1hour / 2006-11-03

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-11-03.parquet
  size:    623 KB
  rows:    29,925
  symbols: 2,422

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-03 07:00:00	AAPL	Stock	2.8357	2.8357	2.8261	2.8314	46508.0
2006-11-03 08:00:00	AAPL	Stock	2.8314	2.8464	2.825	2.8393	2576420.0
2006-11-03 09:00:00	AAPL	Stock	2.8407	2.8429	2.8186	2.8307	55226752.0
2006-11-03 10:00:00	AAPL	Stock	2.8309	2.8343	2.8154	2.82	98208096.0
2006-11-03 11:00:00	AAPL	Stock	2.8196	2.8204	2.7932	2.8039	62016528.0
2006-11-03 12:00:00	AAPL	Stock	2.8036	2.8082	2.7946	2.796	36850604.0
2006-11-03 13:00:00	AAPL	Stock	2.7957	2.8025	2.7782	2.8011	62599236.0
2006-11-03 14:00:00	AAPL	Stock	2.8008	2.8082	2.7904	2.7993	41937196.0
2006-11-03 15:00:00	AAPL	Stock	2.7989	2.8021	2.7904	2.7957	64482292.0
2006-11-03 16:00:00	AAPL	Stock	2.7989	2.7989	2.7929	2.7954	1452584.0
2006-11-03 17:00:00	AAPL	Stock	2.7964	2.7964	2.7946	2.7961	83300.0
2006-11-03 18:00:00	AAPL	Stock	2.7961	2.7961	2.7961	2.7961	17080.0
2006-11-03 19:00:00	AAPL	Stock	2.7964	2.7964	2.7964	2.7964	13160.0
2006-11-03 08:00:00	MSFT	Stock	28.8	28.82	28.74	28.82	50011.0
2006-11-03 09:00:00	MSFT	Stock	28.82	28.93	28.67	28.68	7080357.0
2006-11-03 10:00:00	MSFT	Stock	28.68	28.77	28.61	28.73	10040530.0
2006-11-03 11:00:00	MSFT	Stock	28.73	28.76	28.65	28.72	4033861.0
2006-11-03 12:00:00	MSFT	Stock	28.72	28.74	28.69	28.7	2486695.0
2006-11-03 13:00:00	MSFT	Stock	28.69	28.76	28.65	28.68	3330939.0
2006-11-03 14:00:00	MSFT	Stock	28.69	28.73	28.66	28.68	3836041.0
2006-11-03 15:00:00	MSFT	Stock	28.68	28.78	28.67	28.73	7280209.0
2006-11-03 16:00:00	MSFT	Stock	28.75	28.75	28.7	28.72	208627.0
2006-11-03 17:00:00	MSFT	Stock	28.71	28.72	28.7	28.72	3200.0
2006-11-03 18:00:00	MSFT	Stock	28.7	28.7	28.7	28.7	225.0
2006-11-03 08:00:00	NVDA	Stock	0.5348	0.5398	0.5348	0.539	387000.0
2006-11-03 09:00:00	NVDA	Stock	0.5397	0.5418	0.5335	0.5372	81616560.0
2006-11-03 10:00:00	NVDA	Stock	0.5368	0.5385	0.53	0.5338	99307860.0
2006-11-03 11:00:00	NVDA	Stock	0.534	0.5383	0.534	0.5372	66485520.0
2006-11-03 12:00:00	NVDA	Stock	0.5373	0.5383	0.5343	0.5347	50536200.0
2006-11-03 13:00:00	NVDA	Stock	0.5348	0.5362	0.5325	0.5335	41188440.0
2006-11-03 14:00:00	NVDA	Stock	0.5338	0.5383	0.5328	0.5377	76841640.0
2006-11-03 15:00:00	NVDA	Stock	0.5375	0.544	0.5363	0.5423	122075520.0
2006-11-03 16:00:00	NVDA	Stock	0.543	0.545	0.5417	0.5425	2045160.0
2006-11-03 17:00:00	NVDA	Stock	0.5447	0.545	0.5433	0.5433	120000.0
2006-11-03 18:00:00	NVDA	Stock	0.5433	0.545	0.5433	0.5433	30000.0
2006-11-03 19:00:00	NVDA	Stock	0.5433	0.545	0.5433	0.545	81000.0
2006-11-03 09:00:00	AMZN	Stock	1.8775	1.8855	1.868	1.876	10731660.0
2006-11-03 10:00:00	AMZN	Stock	1.876	1.882	1.8565	1.864	19637300.0
2006-11-03 11:00:00	AMZN	Stock	1.8639	1.8665	1.8555	1.8605	10733600.0
2006-11-03 12:00:00	AMZN	Stock	1.8605	1.8605	1.848	1.8505	12688980.0
2006-11-03 13:00:00	AMZN	Stock	1.85	1.86	1.8435	1.853	12239200.0
2006-11-03 14:00:00	AMZN	Stock	1.854	1.875	1.8535	1.871	15278280.0
2006-11-03 15:00:00	AMZN	Stock	1.871	1.8795	1.8625	1.875	16582180.0
2006-11-03 16:00:00	AMZN	Stock	1.8745	1.875	1.8705	1.873	358200.0
2006-11-03 18:00:00	AMZN	Stock	1.873	1.8745	1.873	1.8745	4000.0
2006-11-03 09:00:00	CL	Stock	31.835	31.925	31.73	31.905	269400.0
2006-11-03 10:00:00	CL	Stock	31.9	31.945	31.795	31.905	256200.0
2006-11-03 11:00:00	CL	Stock	31.915	31.985	31.89	31.965	565600.0
2006-11-03 12:00:00	CL	Stock	31.965	31.965	31.74	31.755	377600.0
2006-11-03 13:00:00	CL	Stock	31.75	31.8	31.71	31.71	415400.0

> showing 50 of 29,925 rows — these rows as CSV

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