PREVIEW / stock_1hour / 2006-11-22

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-11-22.parquet
  size:    623 KB
  rows:    29,794
  symbols: 2,451

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-22 07:00:00	AAPL	Stock	3.1893	3.1925	3.1839	3.1839	30240.0
2006-11-22 08:00:00	AAPL	Stock	3.1821	3.1925	3.1807	3.1814	3265640.0
2006-11-22 09:00:00	AAPL	Stock	3.1811	3.1843	3.1607	3.17	84190148.0
2006-11-22 10:00:00	AAPL	Stock	3.17	3.1736	3.1375	3.1686	158515644.0
2006-11-22 11:00:00	AAPL	Stock	3.1686	3.2139	3.1664	3.1893	84772772.0
2006-11-22 12:00:00	AAPL	Stock	3.1893	3.2032	3.185	3.2011	74975208.0
2006-11-22 13:00:00	AAPL	Stock	3.201	3.2071	3.1893	3.2004	69851208.0
2006-11-22 14:00:00	AAPL	Stock	3.2001	3.2143	3.1936	3.2075	82058872.0
2006-11-22 15:00:00	AAPL	Stock	3.2079	3.2411	3.2076	3.2243	102035444.0
2006-11-22 16:00:00	AAPL	Stock	3.2243	3.2339	3.2207	3.2286	2937704.0
2006-11-22 17:00:00	AAPL	Stock	3.2286	3.2339	3.2286	3.2336	264040.0
2006-11-22 18:00:00	AAPL	Stock	3.2329	3.2339	3.2257	3.2296	255108.0
2006-11-22 19:00:00	AAPL	Stock	3.2336	3.2339	3.2329	3.2339	159152.0
2006-11-22 07:00:00	MSFT	Stock	30.01	30.01	30.0	30.0	1310.0
2006-11-22 08:00:00	MSFT	Stock	30.0	30.06	29.98	29.98	63658.0
2006-11-22 09:00:00	MSFT	Stock	29.98	30.0	29.92	29.93	6721215.0
2006-11-22 10:00:00	MSFT	Stock	29.92	29.95	29.82	29.921	9189506.0
2006-11-22 11:00:00	MSFT	Stock	29.93	29.96	29.89	29.91	4624019.0
2006-11-22 12:00:00	MSFT	Stock	29.91	29.93	29.85	29.86	3405097.0
2006-11-22 13:00:00	MSFT	Stock	29.86	29.9	29.83	29.86	4225917.0
2006-11-22 14:00:00	MSFT	Stock	29.87	29.94	29.86	29.91	4035306.0
2006-11-22 15:00:00	MSFT	Stock	29.91	29.94	29.89	29.91	5673191.0
2006-11-22 16:00:00	MSFT	Stock	29.92	29.93	29.89	29.89	579825.0
2006-11-22 18:00:00	MSFT	Stock	29.92	29.92	29.91	29.91	227000.0
2006-11-22 19:00:00	MSFT	Stock	29.91	29.91	29.86	29.86	3192.0
2006-11-22 08:00:00	NVDA	Stock	0.6057	0.6058	0.6047	0.6047	208620.0
2006-11-22 09:00:00	NVDA	Stock	0.6047	0.6078	0.6005	0.601	31159680.0
2006-11-22 10:00:00	NVDA	Stock	0.601	0.6085	0.6007	0.6078	58466640.0
2006-11-22 11:00:00	NVDA	Stock	0.6078	0.6123	0.6078	0.6105	43800540.0
2006-11-22 12:00:00	NVDA	Stock	0.6107	0.6122	0.6093	0.6115	20823600.0
2006-11-22 13:00:00	NVDA	Stock	0.6115	0.6125	0.6105	0.6115	16311240.0
2006-11-22 14:00:00	NVDA	Stock	0.6116	0.6125	0.6108	0.6115	25574820.0
2006-11-22 15:00:00	NVDA	Stock	0.6117	0.6125	0.611	0.612	36537360.0
2006-11-22 16:00:00	NVDA	Stock	0.6122	0.6123	0.6103	0.6123	385080.0
2006-11-22 19:00:00	NVDA	Stock	0.6122	0.6125	0.6122	0.6125	60000.0
2006-11-22 08:00:00	AMZN	Stock	2.1275	2.1275	2.12	2.12	9000.0
2006-11-22 09:00:00	AMZN	Stock	2.1105	2.1365	2.11	2.1275	14715660.0
2006-11-22 10:00:00	AMZN	Stock	2.1275	2.129	2.109	2.125	19243460.0
2006-11-22 11:00:00	AMZN	Stock	2.125	2.148	2.122	2.145	14481140.0
2006-11-22 12:00:00	AMZN	Stock	2.145	2.1455	2.1195	2.1235	10335280.0
2006-11-22 13:00:00	AMZN	Stock	2.124	2.139	2.122	2.1365	5540660.0
2006-11-22 14:00:00	AMZN	Stock	2.1365	2.1465	2.127	2.145	9588980.0
2006-11-22 15:00:00	AMZN	Stock	2.1455	2.149	2.1291	2.148	13655000.0
2006-11-22 16:00:00	AMZN	Stock	2.1475	2.1495	2.1475	2.1495	146400.0
2006-11-22 17:00:00	AMZN	Stock	2.1525	2.1545	2.1525	2.1535	116040.0
2006-11-22 18:00:00	AMZN	Stock	2.153	2.153	2.153	2.153	2000.0
2006-11-22 09:00:00	CL	Stock	33.12	33.4	33.12	33.25	304600.0
2006-11-22 10:00:00	CL	Stock	33.24	33.37	33.15	33.315	529400.0
2006-11-22 11:00:00	CL	Stock	33.3	33.385	33.1	33.105	427000.0
2006-11-22 12:00:00	CL	Stock	33.1	33.28	33.04	33.205	464200.0

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

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