PREVIEW / stock_1hour / 2007-01-22

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-01-22.parquet
  size:    642 KB
  rows:    30,649
  symbols: 2,501

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
2007-01-22 06:00:00	AAPL	Stock	3.1686	3.1714	3.1654	3.1714	25200.0
2007-01-22 07:00:00	AAPL	Stock	3.175	3.1861	3.1739	3.1832	469616.0
2007-01-22 08:00:00	AAPL	Stock	3.1821	3.1821	3.1679	3.1732	2247532.0
2007-01-22 09:00:00	AAPL	Stock	3.1743	3.1843	3.1314	3.14	155662304.0
2007-01-22 10:00:00	AAPL	Stock	3.1404	3.1429	3.0607	3.0682	457937564.0
2007-01-22 11:00:00	AAPL	Stock	3.0686	3.0964	3.0589	3.0746	211355816.0
2007-01-22 12:00:00	AAPL	Stock	3.0746	3.0914	3.0682	3.0779	141682828.0
2007-01-22 13:00:00	AAPL	Stock	3.0779	3.0914	3.0725	3.0821	83546344.0
2007-01-22 14:00:00	AAPL	Stock	3.0821	3.1161	3.0786	3.1154	207208820.0
2007-01-22 15:00:00	AAPL	Stock	3.1154	3.1157	3.0964	3.0989	163141020.0
2007-01-22 16:00:00	AAPL	Stock	3.0989	3.1036	3.0921	3.1	5375804.0
2007-01-22 17:00:00	AAPL	Stock	3.0996	3.1007	3.0964	3.1	3582796.0
2007-01-22 18:00:00	AAPL	Stock	3.0982	3.1007	3.0929	3.0961	261212.0
2007-01-22 19:00:00	AAPL	Stock	3.0946	3.0964	3.0929	3.0936	302428.0
2007-01-22 08:00:00	MSFT	Stock	31.13	31.18	31.11	31.11	3847.0
2007-01-22 09:00:00	MSFT	Stock	31.11	31.12	30.85	30.92	5585133.0
2007-01-22 10:00:00	MSFT	Stock	30.91	30.92	30.63	30.64	11394619.0
2007-01-22 11:00:00	MSFT	Stock	30.64	30.68	30.51	30.54	7629344.0
2007-01-22 12:00:00	MSFT	Stock	30.54	30.64	30.53	30.6	4776231.0
2007-01-22 13:00:00	MSFT	Stock	30.6	30.68	30.52	30.63	4741052.0
2007-01-22 14:00:00	MSFT	Stock	30.63	30.69	30.57	30.68	5255236.0
2007-01-22 15:00:00	MSFT	Stock	30.68	30.73	30.54	30.73	9395395.0
2007-01-22 16:00:00	MSFT	Stock	30.73	30.77	30.7	30.73	1447927.0
2007-01-22 17:00:00	MSFT	Stock	30.73	30.74	30.64	30.71	1010064.0
2007-01-22 18:00:00	MSFT	Stock	30.65	30.68	30.65	30.68	8200.0
2007-01-22 07:00:00	NVDA	Stock	0.5325	0.5357	0.5325	0.5357	12000.0
2007-01-22 08:00:00	NVDA	Stock	0.5338	0.5338	0.5333	0.5337	38400.0
2007-01-22 09:00:00	NVDA	Stock	0.5337	0.545	0.5293	0.5363	91677420.0
2007-01-22 10:00:00	NVDA	Stock	0.5365	0.5367	0.5297	0.5332	124516860.0
2007-01-22 11:00:00	NVDA	Stock	0.5333	0.5343	0.5308	0.5335	130319760.0
2007-01-22 12:00:00	NVDA	Stock	0.5335	0.5362	0.5327	0.5347	76421760.0
2007-01-22 13:00:00	NVDA	Stock	0.5348	0.5355	0.5332	0.5337	51692580.0
2007-01-22 14:00:00	NVDA	Stock	0.5337	0.5355	0.5333	0.5338	73555140.0
2007-01-22 15:00:00	NVDA	Stock	0.5337	0.534	0.5308	0.5313	103260120.0
2007-01-22 16:00:00	NVDA	Stock	0.531	0.5322	0.53	0.5322	1230300.0
2007-01-22 17:00:00	NVDA	Stock	0.5317	0.5342	0.5313	0.5342	2116620.0
2007-01-22 18:00:00	NVDA	Stock	0.5325	0.5325	0.5308	0.5323	444720.0
2007-01-22 19:00:00	NVDA	Stock	0.5327	0.5327	0.5327	0.5327	6000.0
2007-01-22 06:00:00	AMZN	Stock	1.895	1.895	1.895	1.895	10000.0
2007-01-22 07:00:00	AMZN	Stock	1.89	1.89	1.871	1.871	67960.0
2007-01-22 08:00:00	AMZN	Stock	1.875	1.8775	1.8705	1.875	451200.0
2007-01-22 09:00:00	AMZN	Stock	1.875	1.895	1.87	1.8875	21875300.0
2007-01-22 10:00:00	AMZN	Stock	1.8875	1.889	1.851	1.8655	40762000.0
2007-01-22 11:00:00	AMZN	Stock	1.8655	1.8655	1.848	1.849	17045380.0
2007-01-22 12:00:00	AMZN	Stock	1.8485	1.855	1.841	1.8425	19463720.0
2007-01-22 13:00:00	AMZN	Stock	1.8425	1.854	1.84	1.8475	12925080.0
2007-01-22 14:00:00	AMZN	Stock	1.848	1.8625	1.843	1.8525	13894760.0
2007-01-22 15:00:00	AMZN	Stock	1.8525	1.8545	1.847	1.847	32637320.0
2007-01-22 16:00:00	AMZN	Stock	1.8465	1.8508	1.8465	1.847	996000.0
2007-01-22 17:00:00	AMZN	Stock	1.8475	1.8495	1.8475	1.8495	11700.0

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

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