PREVIEW / stock_1hour / 2006-11-21

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-11-21.parquet
  size:    642 KB
  rows:    30,497
  symbols: 2,456

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-21 06:00:00	AAPL	Stock	3.0907	3.0907	3.0907	3.0907	5600.0
2006-11-21 07:00:00	AAPL	Stock	3.0904	3.0946	3.0904	3.0946	14000.0
2006-11-21 08:00:00	AAPL	Stock	3.0957	3.1446	3.0946	3.125	6910456.0
2006-11-21 09:00:00	AAPL	Stock	3.1264	3.13	3.1111	3.1214	102641728.0
2006-11-21 10:00:00	AAPL	Stock	3.1218	3.1411	3.1196	3.1343	128441572.0
2006-11-21 11:00:00	AAPL	Stock	3.1343	3.1386	3.1232	3.1371	80155768.0
2006-11-21 12:00:00	AAPL	Stock	3.1368	3.1429	3.1357	3.1404	55735540.0
2006-11-21 13:00:00	AAPL	Stock	3.1404	3.1571	3.1379	3.1461	84496132.0
2006-11-21 14:00:00	AAPL	Stock	3.1457	3.1554	3.1432	3.1521	50957032.0
2006-11-21 15:00:00	AAPL	Stock	3.1518	3.1643	3.1504	3.1643	103131532.0
2006-11-21 16:00:00	AAPL	Stock	3.1632	3.1775	3.1632	3.175	2081828.0
2006-11-21 17:00:00	AAPL	Stock	3.1732	3.1761	3.1732	3.1732	810684.0
2006-11-21 18:00:00	AAPL	Stock	3.175	3.1764	3.1714	3.175	127064.0
2006-11-21 19:00:00	AAPL	Stock	3.1739	3.1796	3.1739	3.1789	760256.0
2006-11-21 08:00:00	MSFT	Stock	29.94	29.98	29.9	29.94	34859.0
2006-11-21 09:00:00	MSFT	Stock	29.93	29.97	29.9	29.96	6003057.0
2006-11-21 10:00:00	MSFT	Stock	29.95	30.0	29.85	29.9	12251405.0
2006-11-21 11:00:00	MSFT	Stock	29.9	29.94	29.85	29.91	6670628.0
2006-11-21 12:00:00	MSFT	Stock	29.92	29.98	29.9	29.928	4953322.0
2006-11-21 13:00:00	MSFT	Stock	29.92	29.94	29.82	29.86	8789533.0
2006-11-21 14:00:00	MSFT	Stock	29.86	29.92	29.79	29.89	5539207.0
2006-11-21 15:00:00	MSFT	Stock	29.89	29.95	29.85	29.92	9504511.0
2006-11-21 16:00:00	MSFT	Stock	29.92	30.0	29.79	29.99	592766.0
2006-11-21 17:00:00	MSFT	Stock	29.99	29.99	29.95	29.99	259320.0
2006-11-21 18:00:00	MSFT	Stock	29.99	30.0	29.98	29.98	8766.0
2006-11-21 19:00:00	MSFT	Stock	29.99	30.0	29.94	29.94	7225.0
2006-11-21 08:00:00	NVDA	Stock	0.6132	0.615	0.6132	0.6135	246060.0
2006-11-21 09:00:00	NVDA	Stock	0.6135	0.6167	0.6067	0.6085	44047020.0
2006-11-21 10:00:00	NVDA	Stock	0.6085	0.61	0.599	0.6035	76521060.0
2006-11-21 11:00:00	NVDA	Stock	0.6037	0.604	0.5987	0.5993	56018580.0
2006-11-21 12:00:00	NVDA	Stock	0.5993	0.603	0.5993	0.6012	38014860.0
2006-11-21 13:00:00	NVDA	Stock	0.6012	0.6125	0.5988	0.5997	33980340.0
2006-11-21 14:00:00	NVDA	Stock	0.5995	0.6	0.5973	0.599	47627340.0
2006-11-21 15:00:00	NVDA	Stock	0.599	0.603	0.5985	0.6012	72467940.0
2006-11-21 16:00:00	NVDA	Stock	0.6015	0.6057	0.6003	0.605	1253100.0
2006-11-21 17:00:00	NVDA	Stock	0.6048	0.605	0.6042	0.605	36000.0
2006-11-21 18:00:00	NVDA	Stock	0.6042	0.605	0.6042	0.6042	150000.0
2006-11-21 19:00:00	NVDA	Stock	0.605	0.6053	0.6042	0.6052	228000.0
2006-11-21 08:00:00	AMZN	Stock	2.138	2.1385	2.1275	2.13	26000.0
2006-11-21 09:00:00	AMZN	Stock	2.131	2.159	2.1255	2.1535	19682940.0
2006-11-21 10:00:00	AMZN	Stock	2.154	2.155	2.14	2.1425	15311960.0
2006-11-21 11:00:00	AMZN	Stock	2.1425	2.1555	2.142	2.154	12936840.0
2006-11-21 12:00:00	AMZN	Stock	2.1545	2.1625	2.153	2.1595	10162580.0
2006-11-21 13:00:00	AMZN	Stock	2.1585	2.1585	2.1455	2.15	16574840.0
2006-11-21 14:00:00	AMZN	Stock	2.1495	2.1505	2.129	2.1305	22204040.0
2006-11-21 15:00:00	AMZN	Stock	2.1305	2.1305	2.106	2.127	37843060.0
2006-11-21 16:00:00	AMZN	Stock	2.1285	2.13	2.1225	2.127	406420.0
2006-11-21 18:00:00	AMZN	Stock	2.136	2.136	2.136	2.136	2000.0
2006-11-21 09:00:00	CL	Stock	32.925	33.255	32.925	33.23	735400.0
2006-11-21 10:00:00	CL	Stock	33.23	33.415	33.15	33.4	722800.0

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

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