PREVIEW / stock_1hour / 2006-12-08

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-12-08.parquet
  size:    641 KB
  rows:    30,635
  symbols: 2,454

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-08 04:00:00	AAPL	Stock	3.1064	3.1064	3.1064	3.1064	2800.0
2006-12-08 07:00:00	AAPL	Stock	3.1064	3.1064	3.1032	3.1032	34748.0
2006-12-08 08:00:00	AAPL	Stock	3.1036	3.1332	3.1	3.125	7030632.0
2006-12-08 09:00:00	AAPL	Stock	3.1232	3.1643	3.1071	3.1236	162155252.0
2006-12-08 10:00:00	AAPL	Stock	3.1236	3.1614	3.1093	3.1593	163086000.0
2006-12-08 11:00:00	AAPL	Stock	3.1589	3.1925	3.155	3.1764	150698548.0
2006-12-08 12:00:00	AAPL	Stock	3.1761	3.1861	3.1675	3.1811	68194224.0
2006-12-08 13:00:00	AAPL	Stock	3.1811	3.185	3.1593	3.1636	65127580.0
2006-12-08 14:00:00	AAPL	Stock	3.1632	3.1675	3.1482	3.1611	79014544.0
2006-12-08 15:00:00	AAPL	Stock	3.1611	3.1611	3.1429	3.1529	82152560.0
2006-12-08 16:00:00	AAPL	Stock	3.1529	3.1557	3.1507	3.1557	1595916.0
2006-12-08 17:00:00	AAPL	Stock	3.1554	3.1621	3.1554	3.1607	268268.0
2006-12-08 18:00:00	AAPL	Stock	3.1589	3.1636	3.1575	3.1607	380912.0
2006-12-08 19:00:00	AAPL	Stock	3.1604	3.1661	3.16	3.1661	260484.0
2006-12-08 07:00:00	MSFT	Stock	28.81	28.81	28.81	28.81	500.0
2006-12-08 08:00:00	MSFT	Stock	28.84	28.9	28.79	28.88	1526037.0
2006-12-08 09:00:00	MSFT	Stock	28.88	28.93	28.8	28.88	4301548.0
2006-12-08 10:00:00	MSFT	Stock	28.89	28.94	28.85	28.89	6139632.0
2006-12-08 11:00:00	MSFT	Stock	28.89	28.99	28.89	28.95	7584347.0
2006-12-08 12:00:00	MSFT	Stock	28.95	29.0	28.82	28.96	10654477.0
2006-12-08 13:00:00	MSFT	Stock	28.95	28.96	28.87	28.88	3420249.0
2006-12-08 14:00:00	MSFT	Stock	28.877	28.95	28.87	28.93	5727826.0
2006-12-08 15:00:00	MSFT	Stock	28.94	29.11	28.8	29.08	39215256.0
2006-12-08 16:00:00	MSFT	Stock	29.11	29.4	29.07	29.2	5897074.0
2006-12-08 17:00:00	MSFT	Stock	29.19	29.2	29.15	29.19	107354.0
2006-12-08 18:00:00	MSFT	Stock	29.18	29.2	29.18	29.2	8202.0
2006-12-08 19:00:00	MSFT	Stock	29.2	29.2	29.2	29.2	4500.0
2006-12-08 08:00:00	NVDA	Stock	0.5925	0.5933	0.5908	0.5933	78000.0
2006-12-08 09:00:00	NVDA	Stock	0.5932	0.5955	0.5862	0.588	79790700.0
2006-12-08 10:00:00	NVDA	Stock	0.5878	0.5925	0.5817	0.5925	96592680.0
2006-12-08 11:00:00	NVDA	Stock	0.5925	0.6007	0.5925	0.5945	106667100.0
2006-12-08 12:00:00	NVDA	Stock	0.5947	0.5983	0.5917	0.5925	61469700.0
2006-12-08 13:00:00	NVDA	Stock	0.5925	0.5927	0.5903	0.5925	40176420.0
2006-12-08 14:00:00	NVDA	Stock	0.5925	0.5952	0.591	0.5945	53659740.0
2006-12-08 15:00:00	NVDA	Stock	0.5943	0.5948	0.5912	0.5927	111804120.0
2006-12-08 16:00:00	NVDA	Stock	0.5923	0.5932	0.5918	0.5927	614100.0
2006-12-08 17:00:00	NVDA	Stock	0.5927	0.5927	0.5927	0.5927	54000.0
2006-12-08 18:00:00	NVDA	Stock	0.592	0.5937	0.592	0.5937	102000.0
2006-12-08 08:00:00	AMZN	Stock	1.91	1.91	1.91	1.91	56000.0
2006-12-08 09:00:00	AMZN	Stock	1.893	1.9045	1.8865	1.9005	13660220.0
2006-12-08 10:00:00	AMZN	Stock	1.901	1.903	1.885	1.8965	14454100.0
2006-12-08 11:00:00	AMZN	Stock	1.8965	1.9475	1.8955	1.926	24264240.0
2006-12-08 12:00:00	AMZN	Stock	1.9255	1.937	1.9205	1.9355	9215500.0
2006-12-08 13:00:00	AMZN	Stock	1.935	1.9415	1.9305	1.931	11579440.0
2006-12-08 14:00:00	AMZN	Stock	1.931	1.933	1.9215	1.929	12102960.0
2006-12-08 15:00:00	AMZN	Stock	1.9285	1.9339	1.92	1.924	14211440.0
2006-12-08 16:00:00	AMZN	Stock	1.923	1.9255	1.92	1.923	218560.0
2006-12-08 18:00:00	AMZN	Stock	1.9225	1.9225	1.9225	1.9225	4000.0
2006-12-08 09:00:00	CL	Stock	32.825	32.845	32.64	32.705	188200.0
2006-12-08 10:00:00	CL	Stock	32.7	32.7	32.525	32.595	399200.0

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

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