PREVIEW / stock_1hour / 2006-12-07

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-12-07.parquet
  size:    635 KB
  rows:    30,097
  symbols: 2,460

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-12-07 06:00:00	AAPL	Stock	3.2146	3.2146	3.2146	3.2146	2800.0
2006-12-07 07:00:00	AAPL	Stock	3.2125	3.2232	3.2125	3.2168	95200.0
2006-12-07 08:00:00	AAPL	Stock	3.2168	3.2232	3.2168	3.22	1422120.0
2006-12-07 09:00:00	AAPL	Stock	3.2211	3.2321	3.185	3.1904	139057604.0
2006-12-07 10:00:00	AAPL	Stock	3.1907	3.1943	3.1446	3.1465	244011572.0
2006-12-07 11:00:00	AAPL	Stock	3.1464	3.1679	3.1211	3.1575	171615752.0
2006-12-07 12:00:00	AAPL	Stock	3.1577	3.1618	3.1303	3.1418	80843364.0
2006-12-07 13:00:00	AAPL	Stock	3.1411	3.1564	3.1386	3.1482	57520456.0
2006-12-07 14:00:00	AAPL	Stock	3.1479	3.1486	3.125	3.1264	86194108.0
2006-12-07 15:00:00	AAPL	Stock	3.1264	3.1286	3.1036	3.1071	203665000.0
2006-12-07 16:00:00	AAPL	Stock	3.1079	3.1125	3.0968	3.0968	1838844.0
2006-12-07 17:00:00	AAPL	Stock	3.0982	3.1029	3.0957	3.0968	567756.0
2006-12-07 18:00:00	AAPL	Stock	3.0968	3.1025	3.0964	3.1025	365848.0
2006-12-07 19:00:00	AAPL	Stock	3.1025	3.1064	3.1	3.1064	449960.0
2006-12-07 08:00:00	MSFT	Stock	28.98	29.0	28.96	28.96	3665.0
2006-12-07 09:00:00	MSFT	Stock	28.99	29.07	28.89	28.953	4491182.0
2006-12-07 10:00:00	MSFT	Stock	28.952	28.99	28.81	28.87	9231203.0
2006-12-07 11:00:00	MSFT	Stock	28.87	28.94	28.86	28.91	5742547.0
2006-12-07 12:00:00	MSFT	Stock	28.902	28.97	28.87	28.92	3219286.0
2006-12-07 13:00:00	MSFT	Stock	28.921	28.97	28.9	28.92	2877961.0
2006-12-07 14:00:00	MSFT	Stock	28.93	28.94	28.86	28.88	3871461.0
2006-12-07 15:00:00	MSFT	Stock	28.88	28.93	28.81	28.87	12105175.0
2006-12-07 16:00:00	MSFT	Stock	28.87	28.89	28.85	28.86	1483622.0
2006-12-07 17:00:00	MSFT	Stock	28.85	28.88	28.85	28.86	677700.0
2006-12-07 18:00:00	MSFT	Stock	28.86	28.86	28.85	28.86	607.0
2006-12-07 08:00:00	NVDA	Stock	0.609	0.609	0.609	0.609	18000.0
2006-12-07 09:00:00	NVDA	Stock	0.6117	0.6125	0.6058	0.6065	53897280.0
2006-12-07 10:00:00	NVDA	Stock	0.6062	0.6062	0.5958	0.597	104915820.0
2006-12-07 11:00:00	NVDA	Stock	0.597	0.5997	0.596	0.5972	53676000.0
2006-12-07 12:00:00	NVDA	Stock	0.5973	0.5985	0.5958	0.5972	40382460.0
2006-12-07 13:00:00	NVDA	Stock	0.5972	0.5997	0.596	0.5978	39113280.0
2006-12-07 14:00:00	NVDA	Stock	0.5978	0.5985	0.5925	0.5935	58540740.0
2006-12-07 15:00:00	NVDA	Stock	0.5935	0.5962	0.5892	0.5945	111147420.0
2006-12-07 16:00:00	NVDA	Stock	0.5942	0.5948	0.5908	0.5908	1523640.0
2006-12-07 17:00:00	NVDA	Stock	0.5908	0.5917	0.5908	0.591	139740.0
2006-12-07 18:00:00	NVDA	Stock	0.5915	0.5915	0.59	0.5903	134580.0
2006-12-07 19:00:00	NVDA	Stock	0.5902	0.5902	0.5892	0.59	84600.0
2006-12-07 08:00:00	AMZN	Stock	1.95	1.95	1.95	1.95	7000.0
2006-12-07 09:00:00	AMZN	Stock	1.957	1.957	1.932	1.9356	11891600.0
2006-12-07 10:00:00	AMZN	Stock	1.9355	1.937	1.9125	1.9185	27993660.0
2006-12-07 11:00:00	AMZN	Stock	1.918	1.931	1.9135	1.9295	12626620.0
2006-12-07 12:00:00	AMZN	Stock	1.9295	1.938	1.9185	1.9355	6369740.0
2006-12-07 13:00:00	AMZN	Stock	1.9355	1.9455	1.9185	1.9355	8181280.0
2006-12-07 14:00:00	AMZN	Stock	1.9355	1.9365	1.9115	1.917	23527620.0
2006-12-07 15:00:00	AMZN	Stock	1.917	1.92	1.9025	1.904	37195880.0
2006-12-07 16:00:00	AMZN	Stock	1.9075	1.9075	1.8955	1.905	174800.0
2006-12-07 17:00:00	AMZN	Stock	1.9045	1.9045	1.9045	1.9045	6000.0
2006-12-07 18:00:00	AMZN	Stock	1.915	1.915	1.915	1.915	2000.0
2006-12-07 09:00:00	CL	Stock	32.85	33.07	32.835	33.025	170400.0
2006-12-07 10:00:00	CL	Stock	33.015	33.03	32.78	32.865	326400.0

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

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