PREVIEW / stock_1hour / 2008-12-03

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-12-03.parquet
  size:    799 KB
  rows:    40,815
  symbols: 3,345

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-03 06:00:00	AAPL	Stock	3.2321	3.2321	3.2143	3.2143	36400.0
2008-12-03 07:00:00	AAPL	Stock	3.1839	3.2161	3.1743	3.2146	509656.0
2008-12-03 08:00:00	AAPL	Stock	3.2229	3.2407	3.2054	3.2082	2328172.0
2008-12-03 09:00:00	AAPL	Stock	3.2082	3.2311	3.1714	3.2129	130147696.0
2008-12-03 10:00:00	AAPL	Stock	3.2121	3.3361	3.2029	3.3289	217906528.0
2008-12-03 11:00:00	AAPL	Stock	3.3296	3.3604	3.3107	3.3443	144874632.0
2008-12-03 12:00:00	AAPL	Stock	3.3446	3.375	3.3146	3.3671	123158728.0
2008-12-03 13:00:00	AAPL	Stock	3.3679	3.3679	3.2632	3.2854	139860896.0
2008-12-03 14:00:00	AAPL	Stock	3.2843	3.3957	3.2725	3.3693	223844040.0
2008-12-03 15:00:00	AAPL	Stock	3.3679	3.4368	3.3429	3.4257	303254980.0
2008-12-03 16:00:00	AAPL	Stock	3.425	3.4275	3.3251	3.425	32918844.0
2008-12-03 17:00:00	AAPL	Stock	3.4221	3.425	3.3744	3.4196	149688.0
2008-12-03 18:00:00	AAPL	Stock	3.4179	3.425	3.4157	3.4196	1145732.0
2008-12-03 19:00:00	AAPL	Stock	3.4179	3.4193	3.4154	3.4179	421120.0
2008-12-03 07:00:00	MSFT	Stock	18.93	18.93	18.92	18.92	500.0
2008-12-03 08:00:00	MSFT	Stock	18.87	18.91	18.75	18.82	28031.0
2008-12-03 09:00:00	MSFT	Stock	18.82	19.17	18.6	18.94	7255564.0
2008-12-03 10:00:00	MSFT	Stock	18.94	19.51	18.83	19.5	9974569.0
2008-12-03 11:00:00	MSFT	Stock	19.5	19.76	19.37	19.73	9730527.0
2008-12-03 12:00:00	MSFT	Stock	19.73	19.74	19.39	19.622	7154586.0
2008-12-03 13:00:00	MSFT	Stock	19.63	19.65	19.06	19.16	6960787.0
2008-12-03 14:00:00	MSFT	Stock	19.15	19.57	18.92	19.45	12664227.0
2008-12-03 15:00:00	MSFT	Stock	19.45	19.9	19.3	19.83	21525763.0
2008-12-03 16:00:00	MSFT	Stock	19.87	19.957	19.15	19.82	4485542.0
2008-12-03 17:00:00	MSFT	Stock	19.473	19.87	19.473	19.76	14840.0
2008-12-03 18:00:00	MSFT	Stock	19.76	19.76	19.67	19.72	13584.0
2008-12-03 19:00:00	MSFT	Stock	19.71	19.72	19.69	19.72	7150.0
2008-12-03 08:00:00	NVDA	Stock	0.1763	0.1763	0.1738	0.1738	19000.0
2008-12-03 09:00:00	NVDA	Stock	0.1738	0.1798	0.1718	0.179	60837240.0
2008-12-03 10:00:00	NVDA	Stock	0.1788	0.1873	0.1753	0.1868	98438040.0
2008-12-03 11:00:00	NVDA	Stock	0.187	0.189	0.1825	0.1875	70616360.0
2008-12-03 12:00:00	NVDA	Stock	0.1875	0.188	0.182	0.185	49494200.0
2008-12-03 13:00:00	NVDA	Stock	0.185	0.1853	0.179	0.1798	43761840.0
2008-12-03 14:00:00	NVDA	Stock	0.1798	0.1873	0.1788	0.1853	94196000.0
2008-12-03 15:00:00	NVDA	Stock	0.1853	0.1898	0.1828	0.1895	139878880.0
2008-12-03 16:00:00	NVDA	Stock	0.1888	0.1893	0.1868	0.1868	519360.0
2008-12-03 17:00:00	NVDA	Stock	0.187	0.1888	0.187	0.1888	46840.0
2008-12-03 18:00:00	NVDA	Stock	0.189	0.189	0.189	0.189	36000.0
2008-12-03 08:00:00	AMZN	Stock	2.05	2.05	2.0205	2.03	193800.0
2008-12-03 09:00:00	AMZN	Stock	2.0235	2.1405	1.975	2.1305	27281380.0
2008-12-03 10:00:00	AMZN	Stock	2.129	2.2545	2.119	2.2185	85561140.0
2008-12-03 11:00:00	AMZN	Stock	2.218	2.275	2.2165	2.2475	35997780.0
2008-12-03 12:00:00	AMZN	Stock	2.246	2.247	2.191	2.197	18619440.0
2008-12-03 13:00:00	AMZN	Stock	2.1965	2.2175	2.1625	2.178	25805200.0
2008-12-03 14:00:00	AMZN	Stock	2.1785	2.259	2.156	2.235	34455120.0
2008-12-03 15:00:00	AMZN	Stock	2.235	2.294	2.1935	2.262	75545020.0
2008-12-03 16:00:00	AMZN	Stock	2.2655	2.281	2.253	2.2645	1969240.0
2008-12-03 17:00:00	AMZN	Stock	2.26	2.26	2.252	2.252	82200.0
2008-12-03 18:00:00	AMZN	Stock	2.252	2.2605	2.25	2.2605	33200.0
2008-12-03 19:00:00	AMZN	Stock	2.251	2.2605	2.251	2.251	44800.0

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

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