PREVIEW / stock_1hour / 2006-12-11

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-12-11.parquet
  size:    641 KB
  rows:    30,887
  symbols: 2,483

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-11 05:00:00	AAPL	Stock	3.1736	3.1736	3.1736	3.1736	2800.0
2006-12-11 07:00:00	AAPL	Stock	3.1714	3.1757	3.1714	3.1757	11200.0
2006-12-11 08:00:00	AAPL	Stock	3.1714	3.1907	3.1521	3.1521	1571276.0
2006-12-11 09:00:00	AAPL	Stock	3.1804	3.1846	3.1446	3.1782	80859856.0
2006-12-11 10:00:00	AAPL	Stock	3.1782	3.1893	3.165	3.1707	107633456.0
2006-12-11 11:00:00	AAPL	Stock	3.1707	3.1811	3.1686	3.1707	52223500.0
2006-12-11 12:00:00	AAPL	Stock	3.1707	3.1839	3.1518	3.1632	62316604.0
2006-12-11 13:00:00	AAPL	Stock	3.1632	3.1779	3.1582	3.1736	44200268.0
2006-12-11 14:00:00	AAPL	Stock	3.1736	3.1829	3.1689	3.1746	55755672.0
2006-12-11 15:00:00	AAPL	Stock	3.1746	3.1807	3.1646	3.1668	79018660.0
2006-12-11 16:00:00	AAPL	Stock	3.1696	3.1746	3.1696	3.1714	2812824.0
2006-12-11 17:00:00	AAPL	Stock	3.1729	3.1743	3.1696	3.1718	934332.0
2006-12-11 18:00:00	AAPL	Stock	3.1739	3.175	3.1696	3.175	185388.0
2006-12-11 19:00:00	AAPL	Stock	3.1768	3.1782	3.1721	3.1782	145124.0
2006-12-11 07:00:00	MSFT	Stock	29.19	29.25	29.19	29.25	800.0
2006-12-11 08:00:00	MSFT	Stock	29.2	29.4	29.2	29.28	57667.0
2006-12-11 09:00:00	MSFT	Stock	29.27	29.38	29.11	29.22	6211700.0
2006-12-11 10:00:00	MSFT	Stock	29.22	29.68	29.21	29.58	56090412.0
2006-12-11 11:00:00	MSFT	Stock	29.58	29.75	29.53	29.64	9131679.0
2006-12-11 12:00:00	MSFT	Stock	29.65	29.69	29.56	29.668	7787049.0
2006-12-11 13:00:00	MSFT	Stock	29.67	29.73	29.65	29.65	6448256.0
2006-12-11 14:00:00	MSFT	Stock	29.65	29.711	29.59	29.632	4756816.0
2006-12-11 15:00:00	MSFT	Stock	29.63	29.66	29.49	29.56	14529541.0
2006-12-11 16:00:00	MSFT	Stock	29.56	29.56	29.53	29.56	524349.0
2006-12-11 17:00:00	MSFT	Stock	29.56	29.56	29.444	29.56	264936.0
2006-12-11 18:00:00	MSFT	Stock	29.56	29.56	29.52	29.52	2278.0
2006-12-11 08:00:00	NVDA	Stock	0.5925	0.5925	0.5925	0.5925	27960.0
2006-12-11 09:00:00	NVDA	Stock	0.5922	0.5965	0.5913	0.5962	56537100.0
2006-12-11 10:00:00	NVDA	Stock	0.5962	0.6058	0.5957	0.6025	90574620.0
2006-12-11 11:00:00	NVDA	Stock	0.6024	0.6058	0.601	0.6043	60273300.0
2006-12-11 12:00:00	NVDA	Stock	0.6045	0.6087	0.6038	0.6068	78467460.0
2006-12-11 13:00:00	NVDA	Stock	0.6068	0.6085	0.6063	0.6083	35798160.0
2006-12-11 14:00:00	NVDA	Stock	0.6083	0.6098	0.607	0.6093	58974540.0
2006-12-11 15:00:00	NVDA	Stock	0.6093	0.6098	0.6013	0.6027	105968160.0
2006-12-11 16:00:00	NVDA	Stock	0.603	0.603	0.6018	0.6025	888000.0
2006-12-11 17:00:00	NVDA	Stock	0.6025	0.6027	0.6013	0.6013	282780.0
2006-12-11 18:00:00	NVDA	Stock	0.6013	0.6013	0.6013	0.6013	144000.0
2006-12-11 08:00:00	AMZN	Stock	1.923	1.923	1.923	1.923	7500.0
2006-12-11 09:00:00	AMZN	Stock	1.911	1.9425	1.904	1.9365	10421020.0
2006-12-11 10:00:00	AMZN	Stock	1.937	1.9575	1.9355	1.951	22412420.0
2006-12-11 11:00:00	AMZN	Stock	1.9505	1.954	1.9415	1.9465	10050460.0
2006-12-11 12:00:00	AMZN	Stock	1.9465	1.947	1.9325	1.9345	11177060.0
2006-12-11 13:00:00	AMZN	Stock	1.935	1.948	1.9315	1.945	11207500.0
2006-12-11 14:00:00	AMZN	Stock	1.945	1.9485	1.941	1.9455	6536440.0
2006-12-11 15:00:00	AMZN	Stock	1.9455	1.95	1.931	1.9345	19548200.0
2006-12-11 16:00:00	AMZN	Stock	1.9345	1.9345	1.9345	1.9345	8000.0
2006-12-11 17:00:00	AMZN	Stock	1.9345	1.9345	1.9345	1.9345	9080.0
2006-12-11 09:00:00	CL	Stock	32.83	32.955	32.735	32.92	323200.0
2006-12-11 10:00:00	CL	Stock	32.905	32.955	32.75	32.75	472400.0
2006-12-11 11:00:00	CL	Stock	32.755	32.815	32.735	32.79	218200.0

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

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