PREVIEW / stock_1hour / 2008-12-01

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-12-01.parquet
  size:    811 KB
  rows:    41,144
  symbols: 3,346

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-12-01 07:00:00	AAPL	Stock	3.25	3.26	3.2261	3.2582	51828.0
2008-12-01 08:00:00	AAPL	Stock	3.25	3.3096	3.2321	3.2514	1419908.0
2008-12-01 09:00:00	AAPL	Stock	3.2514	3.2954	3.2204	3.2231	144412324.0
2008-12-01 10:00:00	AAPL	Stock	3.2221	3.2464	3.1861	3.1861	154134568.0
2008-12-01 11:00:00	AAPL	Stock	3.1871	3.225	3.1786	3.2171	95866232.0
2008-12-01 12:00:00	AAPL	Stock	3.2179	3.2268	3.1961	3.2157	85812916.0
2008-12-01 13:00:00	AAPL	Stock	3.2157	3.2414	3.2129	3.2329	75762512.0
2008-12-01 14:00:00	AAPL	Stock	3.2332	3.2707	3.2261	3.2607	124740560.0
2008-12-01 15:00:00	AAPL	Stock	3.26	3.2696	3.1786	3.1786	182676032.0
2008-12-01 16:00:00	AAPL	Stock	3.1786	3.3096	3.1746	3.1846	34171200.0
2008-12-01 17:00:00	AAPL	Stock	3.1864	3.2253	3.1761	3.1839	14615048.0
2008-12-01 18:00:00	AAPL	Stock	3.1786	3.1964	3.1786	3.1839	333564.0
2008-12-01 19:00:00	AAPL	Stock	3.1957	3.1964	3.1811	3.1964	264824.0
2008-12-01 07:00:00	MSFT	Stock	19.75	19.76	19.75	19.76	2000.0
2008-12-01 08:00:00	MSFT	Stock	19.87	20.22	19.82	19.87	26472.0
2008-12-01 09:00:00	MSFT	Stock	19.87	19.95	19.59	19.64	6908728.0
2008-12-01 10:00:00	MSFT	Stock	19.64	19.74	19.488	19.538	9505349.0
2008-12-01 11:00:00	MSFT	Stock	19.53	19.6	19.44	19.5	7515197.0
2008-12-01 12:00:00	MSFT	Stock	19.5	19.54	19.33	19.34	5021134.0
2008-12-01 13:00:00	MSFT	Stock	19.35	19.38	19.1	19.17	9052256.0
2008-12-01 14:00:00	MSFT	Stock	19.17	19.289	19.03	19.17	10302399.0
2008-12-01 15:00:00	MSFT	Stock	19.18	19.25	18.61	18.62	18936937.0
2008-12-01 16:00:00	MSFT	Stock	18.62	20.22	18.61	18.62	7858524.0
2008-12-01 17:00:00	MSFT	Stock	18.66	18.66	18.61	18.66	2381839.0
2008-12-01 18:00:00	MSFT	Stock	18.68	20.16	18.63	18.78	222868.0
2008-12-01 19:00:00	MSFT	Stock	18.76	18.8	18.7	18.8	23100.0
2008-12-01 08:00:00	NVDA	Stock	0.1838	0.1868	0.1813	0.1868	168560.0
2008-12-01 09:00:00	NVDA	Stock	0.1803	0.181	0.1758	0.1763	65056280.0
2008-12-01 10:00:00	NVDA	Stock	0.1765	0.18	0.176	0.1785	81444960.0
2008-12-01 11:00:00	NVDA	Stock	0.1785	0.1805	0.1763	0.18	55528120.0
2008-12-01 12:00:00	NVDA	Stock	0.18	0.1805	0.177	0.1788	46834360.0
2008-12-01 13:00:00	NVDA	Stock	0.1788	0.18	0.1778	0.1798	36267560.0
2008-12-01 14:00:00	NVDA	Stock	0.1798	0.181	0.1783	0.179	73933560.0
2008-12-01 15:00:00	NVDA	Stock	0.1788	0.179	0.1708	0.1708	154255800.0
2008-12-01 16:00:00	NVDA	Stock	0.1713	0.1728	0.17	0.17	2102960.0
2008-12-01 18:00:00	NVDA	Stock	0.1703	0.1703	0.1703	0.1703	30000.0
2008-12-01 07:00:00	AMZN	Stock	2.1	2.1	2.1	2.1	2000.0
2008-12-01 08:00:00	AMZN	Stock	2.135	2.135	2.075	2.1	65680.0
2008-12-01 09:00:00	AMZN	Stock	2.1	2.163	2.038	2.143	44381900.0
2008-12-01 10:00:00	AMZN	Stock	2.1415	2.1585	2.0935	2.0939	40177900.0
2008-12-01 11:00:00	AMZN	Stock	2.0945	2.12	2.072	2.1155	23646920.0
2008-12-01 12:00:00	AMZN	Stock	2.1155	2.1305	2.0635	2.075	20426300.0
2008-12-01 13:00:00	AMZN	Stock	2.0755	2.113	2.071	2.0865	18885320.0
2008-12-01 14:00:00	AMZN	Stock	2.087	2.1125	2.065	2.0995	22814760.0
2008-12-01 15:00:00	AMZN	Stock	2.0995	2.1045	2.019	2.0255	41406980.0
2008-12-01 16:00:00	AMZN	Stock	2.0315	2.043	2.02	2.02	149260.0
2008-12-01 17:00:00	AMZN	Stock	2.0195	2.027	2.0195	2.027	14000.0
2008-12-01 18:00:00	AMZN	Stock	2.027	2.027	2.027	2.027	2000.0
2008-12-01 19:00:00	AMZN	Stock	2.0205	2.025	2.0205	2.0205	32000.0
2008-12-01 08:00:00	TLT	Stock	105.72	107.35	105.72	107.1	21290.0

> showing 50 of 41,144 rows — these rows as CSV

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