PREVIEW / stock_1hour / 2008-11-17

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-11-17.parquet
  size:    787 KB
  rows:    40,250
  symbols: 3,310

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
2008-11-17 07:00:00	AAPL	Stock	3.225	3.225	3.1786	3.1786	194600.0
2008-11-17 08:00:00	AAPL	Stock	3.1786	3.1921	3.1304	3.1393	4246704.0
2008-11-17 09:00:00	AAPL	Stock	3.1393	3.2082	3.135	3.1482	150317272.0
2008-11-17 10:00:00	AAPL	Stock	3.1489	3.1546	3.1164	3.1382	209089944.0
2008-11-17 11:00:00	AAPL	Stock	3.1375	3.2093	3.1361	3.1914	141568532.0
2008-11-17 12:00:00	AAPL	Stock	3.1904	3.2339	3.1732	3.2218	153896624.0
2008-11-17 13:00:00	AAPL	Stock	3.2221	3.2254	3.1729	3.1943	123539948.0
2008-11-17 14:00:00	AAPL	Stock	3.1943	3.2211	3.1725	3.2025	141500156.0
2008-11-17 15:00:00	AAPL	Stock	3.2018	3.2311	3.1329	3.1511	206707284.0
2008-11-17 16:00:00	AAPL	Stock	3.1505	3.1841	3.1443	3.16	25080048.0
2008-11-17 17:00:00	AAPL	Stock	3.1618	3.1625	3.1479	3.1596	339668.0
2008-11-17 18:00:00	AAPL	Stock	3.1561	3.1593	3.1536	3.1571	191660.0
2008-11-17 19:00:00	AAPL	Stock	3.1579	3.1639	3.1571	3.1636	221200.0
2008-11-17 08:00:00	MSFT	Stock	19.94	19.96	19.61	19.65	53086.0
2008-11-17 09:00:00	MSFT	Stock	19.65	19.85	19.16	19.47	10504590.0
2008-11-17 10:00:00	MSFT	Stock	19.48	19.49	19.15	19.15	14340690.0
2008-11-17 11:00:00	MSFT	Stock	19.16	19.97	19.15	19.92	11185993.0
2008-11-17 12:00:00	MSFT	Stock	19.92	20.24	19.86	20.015	10969628.0
2008-11-17 13:00:00	MSFT	Stock	20.02	20.06	19.87	19.93	10505521.0
2008-11-17 14:00:00	MSFT	Stock	19.93	19.97	19.69	19.79	9807522.0
2008-11-17 15:00:00	MSFT	Stock	19.79	19.955	19.31	19.32	17049202.0
2008-11-17 16:00:00	MSFT	Stock	19.33	19.75	19.25	19.4	12298541.0
2008-11-17 17:00:00	MSFT	Stock	19.42	19.48	19.32	19.45	16310.0
2008-11-17 18:00:00	MSFT	Stock	19.43	19.43	19.38	19.4	5458.0
2008-11-17 19:00:00	MSFT	Stock	19.44	19.45	19.38	19.42	6810.0
2008-11-17 08:00:00	NVDA	Stock	0.1793	0.1793	0.1793	0.1793	210000.0
2008-11-17 09:00:00	NVDA	Stock	0.179	0.1823	0.1748	0.1773	55213040.0
2008-11-17 10:00:00	NVDA	Stock	0.1773	0.1775	0.1738	0.1743	59919080.0
2008-11-17 11:00:00	NVDA	Stock	0.1743	0.1798	0.1743	0.179	37996040.0
2008-11-17 12:00:00	NVDA	Stock	0.179	0.1803	0.1773	0.179	31707160.0
2008-11-17 13:00:00	NVDA	Stock	0.1788	0.179	0.1763	0.177	24883600.0
2008-11-17 14:00:00	NVDA	Stock	0.1768	0.1773	0.175	0.1755	58004720.0
2008-11-17 15:00:00	NVDA	Stock	0.1758	0.1783	0.175	0.1755	88148120.0
2008-11-17 16:00:00	NVDA	Stock	0.1753	0.1783	0.175	0.1763	30408240.0
2008-11-17 17:00:00	NVDA	Stock	0.1763	0.1763	0.175	0.175	60600.0
2008-11-17 06:00:00	AMZN	Stock	2.05	2.05	2.05	2.05	12000.0
2008-11-17 08:00:00	AMZN	Stock	2.075	2.075	1.999	1.999	231120.0
2008-11-17 09:00:00	AMZN	Stock	2.0	2.0607	1.9775	2.0435	26059720.0
2008-11-17 10:00:00	AMZN	Stock	2.0445	2.063	1.995	2.0105	39804340.0
2008-11-17 11:00:00	AMZN	Stock	2.0105	2.0375	2.0045	2.021	22262780.0
2008-11-17 12:00:00	AMZN	Stock	2.022	2.0425	2.0045	2.016	26617920.0
2008-11-17 13:00:00	AMZN	Stock	2.016	2.0355	1.957	1.9676	27199640.0
2008-11-17 14:00:00	AMZN	Stock	1.967	2.028	1.9535	2.005	32456680.0
2008-11-17 15:00:00	AMZN	Stock	2.006	2.043	1.98	1.983	32864040.0
2008-11-17 16:00:00	AMZN	Stock	1.993	2.0454	1.9785	1.9845	1751640.0
2008-11-17 17:00:00	AMZN	Stock	1.9915	1.9915	1.9825	1.9825	58800.0
2008-11-17 19:00:00	AMZN	Stock	1.985	1.997	1.9825	1.9825	38000.0
2008-11-17 09:00:00	TLT	Stock	95.68	95.68	95.31	95.45	23971.0
2008-11-17 10:00:00	TLT	Stock	95.46	96.03	95.44	95.95	89928.0
2008-11-17 11:00:00	TLT	Stock	95.95	96.0	95.43	95.51	74048.0

> showing 50 of 40,250 rows — these rows as CSV

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