PREVIEW / stock_1min / 2008-06-10
file: by_date/stock_1min/2008/2008-06-10.parquet size: 12.5 MB rows: 1,009,896 symbols: 2,702
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-06-10 04:42:00 | AAPL | Stock | 6.4518 | 6.4518 | 6.4518 | 6.4518 | 2800.0 |
| 2008-06-10 04:45:00 | AAPL | Stock | 6.4464 | 6.4464 | 6.4464 | 6.4464 | 2800.0 |
| 2008-06-10 05:58:00 | AAPL | Stock | 6.4754 | 6.4754 | 6.4754 | 6.4754 | 22400.0 |
| 2008-06-10 05:59:00 | AAPL | Stock | 6.4754 | 6.4821 | 6.4754 | 6.4821 | 14000.0 |
| 2008-06-10 06:33:00 | AAPL | Stock | 6.4804 | 6.4804 | 6.4804 | 6.4804 | 2800.0 |
| 2008-06-10 06:47:00 | AAPL | Stock | 6.5014 | 6.5014 | 6.5014 | 6.5014 | 2800.0 |
| 2008-06-10 07:00:00 | AAPL | Stock | 6.4825 | 6.5 | 6.4821 | 6.5 | 14000.0 |
| 2008-06-10 07:02:00 | AAPL | Stock | 6.4804 | 6.4804 | 6.4804 | 6.4804 | 14000.0 |
| 2008-06-10 07:11:00 | AAPL | Stock | 6.4682 | 6.4682 | 6.4579 | 6.4579 | 16240.0 |
| 2008-06-10 07:12:00 | AAPL | Stock | 6.4643 | 6.4643 | 6.4643 | 6.4643 | 5544.0 |
| 2008-06-10 07:13:00 | AAPL | Stock | 6.4643 | 6.4643 | 6.4643 | 6.4643 | 2800.0 |
| 2008-06-10 07:14:00 | AAPL | Stock | 6.4643 | 6.4643 | 6.4643 | 6.4643 | 2800.0 |
| 2008-06-10 07:22:00 | AAPL | Stock | 6.4664 | 6.4679 | 6.4664 | 6.4664 | 21672.0 |
| 2008-06-10 07:23:00 | AAPL | Stock | 6.4664 | 6.4664 | 6.4664 | 6.4664 | 6328.0 |
| 2008-06-10 07:25:00 | AAPL | Stock | 6.4668 | 6.4668 | 6.4654 | 6.4654 | 23128.0 |
| 2008-06-10 07:28:00 | AAPL | Stock | 6.4679 | 6.4679 | 6.4679 | 6.4679 | 8400.0 |
| 2008-06-10 07:29:00 | AAPL | Stock | 6.4682 | 6.4682 | 6.4661 | 6.4661 | 28000.0 |
| 2008-06-10 07:30:00 | AAPL | Stock | 6.4643 | 6.4643 | 6.4643 | 6.4643 | 2800.0 |
| 2008-06-10 07:31:00 | AAPL | Stock | 6.4646 | 6.4646 | 6.4639 | 6.4643 | 53340.0 |
| 2008-06-10 07:32:00 | AAPL | Stock | 6.4643 | 6.4643 | 6.4593 | 6.4607 | 64400.0 |
| 2008-06-10 07:33:00 | AAPL | Stock | 6.4643 | 6.4643 | 6.4625 | 6.4625 | 8260.0 |
| 2008-06-10 07:34:00 | AAPL | Stock | 6.4646 | 6.4646 | 6.4625 | 6.4629 | 16800.0 |
| 2008-06-10 07:35:00 | AAPL | Stock | 6.4625 | 6.4625 | 6.4625 | 6.4625 | 16520.0 |
| 2008-06-10 07:36:00 | AAPL | Stock | 6.4625 | 6.4625 | 6.4625 | 6.4625 | 5600.0 |
| 2008-06-10 07:38:00 | AAPL | Stock | 6.4629 | 6.4682 | 6.4629 | 6.4643 | 22400.0 |
| 2008-06-10 07:39:00 | AAPL | Stock | 6.4625 | 6.4739 | 6.4614 | 6.4739 | 39200.0 |
| 2008-06-10 07:41:00 | AAPL | Stock | 6.4729 | 6.4768 | 6.4729 | 6.4768 | 156884.0 |
| 2008-06-10 07:43:00 | AAPL | Stock | 6.4761 | 6.4786 | 6.4757 | 6.4786 | 64400.0 |
| 2008-06-10 07:45:00 | AAPL | Stock | 6.4761 | 6.4761 | 6.4729 | 6.4729 | 30800.0 |
| 2008-06-10 07:46:00 | AAPL | Stock | 6.4721 | 6.4821 | 6.4721 | 6.4821 | 50400.0 |
| 2008-06-10 07:47:00 | AAPL | Stock | 6.4839 | 6.4889 | 6.4839 | 6.4889 | 22400.0 |
| 2008-06-10 07:49:00 | AAPL | Stock | 6.4911 | 6.5 | 6.4911 | 6.4925 | 123200.0 |
| 2008-06-10 07:50:00 | AAPL | Stock | 6.4925 | 6.4925 | 6.4871 | 6.4925 | 36400.0 |
| 2008-06-10 07:51:00 | AAPL | Stock | 6.4961 | 6.5011 | 6.4961 | 6.5 | 47740.0 |
| 2008-06-10 07:52:00 | AAPL | Stock | 6.5011 | 6.5161 | 6.4996 | 6.5139 | 97804.0 |
| 2008-06-10 07:53:00 | AAPL | Stock | 6.5125 | 6.5411 | 6.5125 | 6.5411 | 196000.0 |
| 2008-06-10 07:54:00 | AAPL | Stock | 6.5232 | 6.5357 | 6.5207 | 6.5357 | 42616.0 |
| 2008-06-10 07:55:00 | AAPL | Stock | 6.5354 | 6.5357 | 6.5339 | 6.5339 | 50400.0 |
| 2008-06-10 07:56:00 | AAPL | Stock | 6.5339 | 6.5357 | 6.5207 | 6.5357 | 226800.0 |
| 2008-06-10 07:57:00 | AAPL | Stock | 6.5357 | 6.5464 | 6.5357 | 6.5436 | 268128.0 |
| 2008-06-10 07:58:00 | AAPL | Stock | 6.525 | 6.5257 | 6.5179 | 6.525 | 85400.0 |
| 2008-06-10 07:59:00 | AAPL | Stock | 6.5182 | 6.5182 | 6.5143 | 6.5179 | 16800.0 |
| 2008-06-10 08:00:00 | AAPL | Stock | 6.5179 | 6.5268 | 6.5021 | 6.525 | 476448.0 |
| 2008-06-10 08:01:00 | AAPL | Stock | 6.5246 | 6.5307 | 6.5182 | 6.5182 | 294280.0 |
| 2008-06-10 08:02:00 | AAPL | Stock | 6.5221 | 6.5307 | 6.5221 | 6.5286 | 245168.0 |
| 2008-06-10 08:03:00 | AAPL | Stock | 6.5286 | 6.5393 | 6.525 | 6.5268 | 718116.0 |
| 2008-06-10 08:04:00 | AAPL | Stock | 6.5268 | 6.5268 | 6.5107 | 6.5179 | 318836.0 |
| 2008-06-10 08:05:00 | AAPL | Stock | 6.5157 | 6.5225 | 6.5107 | 6.5129 | 463120.0 |
| 2008-06-10 08:06:00 | AAPL | Stock | 6.5179 | 6.5179 | 6.5114 | 6.5114 | 84000.0 |
| 2008-06-10 08:07:00 | AAPL | Stock | 6.5132 | 6.5132 | 6.5007 | 6.5036 | 162400.0 |
> showing 50 of 1,009,896 rows — these rows as CSV