PREVIEW / stock_1min / 2006-06-29
file: by_date/stock_1min/2006/2006-06-29.parquet size: 8.9 MB rows: 731,747 symbols: 1,868
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 |
|---|---|---|---|---|---|---|---|
| 2006-06-29 08:01:00 | AAPL | Stock | 2.0082 | 2.0082 | 2.0082 | 2.0082 | 8400.0 |
| 2006-06-29 08:02:00 | AAPL | Stock | 2.0086 | 2.0086 | 2.0086 | 2.0086 | 26404.0 |
| 2006-06-29 08:03:00 | AAPL | Stock | 2.0089 | 2.0089 | 2.0089 | 2.0089 | 11200.0 |
| 2006-06-29 08:05:00 | AAPL | Stock | 2.0086 | 2.0086 | 2.0086 | 2.0086 | 42000.0 |
| 2006-06-29 08:07:00 | AAPL | Stock | 2.0082 | 2.0082 | 2.0054 | 2.0054 | 30800.0 |
| 2006-06-29 08:14:00 | AAPL | Stock | 2.0057 | 2.0057 | 2.0054 | 2.0054 | 50400.0 |
| 2006-06-29 08:15:00 | AAPL | Stock | 2.0057 | 2.0057 | 2.005 | 2.005 | 98000.0 |
| 2006-06-29 08:18:00 | AAPL | Stock | 2.0057 | 2.0071 | 2.0057 | 2.0071 | 22400.0 |
| 2006-06-29 08:23:00 | AAPL | Stock | 2.0082 | 2.0082 | 2.0082 | 2.0082 | 14000.0 |
| 2006-06-29 08:25:00 | AAPL | Stock | 2.0082 | 2.0082 | 2.0082 | 2.0082 | 18200.0 |
| 2006-06-29 08:27:00 | AAPL | Stock | 2.0079 | 2.0079 | 2.0079 | 2.0079 | 5600.0 |
| 2006-06-29 08:28:00 | AAPL | Stock | 2.0079 | 2.0079 | 2.0079 | 2.0079 | 22400.0 |
| 2006-06-29 08:29:00 | AAPL | Stock | 2.0082 | 2.0082 | 2.0082 | 2.0082 | 8400.0 |
| 2006-06-29 08:31:00 | AAPL | Stock | 2.0086 | 2.0086 | 2.0086 | 2.0086 | 3696.0 |
| 2006-06-29 08:33:00 | AAPL | Stock | 2.0082 | 2.0082 | 2.0082 | 2.0082 | 8400.0 |
| 2006-06-29 08:34:00 | AAPL | Stock | 2.0082 | 2.0082 | 2.0082 | 2.0082 | 32564.0 |
| 2006-06-29 08:36:00 | AAPL | Stock | 2.0082 | 2.0082 | 2.0082 | 2.0082 | 5600.0 |
| 2006-06-29 08:37:00 | AAPL | Stock | 2.0082 | 2.0089 | 2.0082 | 2.0082 | 48104.0 |
| 2006-06-29 08:38:00 | AAPL | Stock | 2.0089 | 2.0089 | 2.0089 | 2.0089 | 11200.0 |
| 2006-06-29 08:40:00 | AAPL | Stock | 2.01 | 2.01 | 2.01 | 2.01 | 2800.0 |
| 2006-06-29 08:41:00 | AAPL | Stock | 2.01 | 2.0107 | 2.01 | 2.0107 | 5600.0 |
| 2006-06-29 08:42:00 | AAPL | Stock | 2.0089 | 2.0107 | 2.0082 | 2.0107 | 15400.0 |
| 2006-06-29 08:43:00 | AAPL | Stock | 2.01 | 2.0107 | 2.01 | 2.0107 | 16800.0 |
| 2006-06-29 08:44:00 | AAPL | Stock | 2.0107 | 2.0107 | 2.01 | 2.01 | 32200.0 |
| 2006-06-29 08:47:00 | AAPL | Stock | 2.0093 | 2.0093 | 2.0089 | 2.0089 | 30800.0 |
| 2006-06-29 08:48:00 | AAPL | Stock | 2.0082 | 2.0086 | 2.0075 | 2.0075 | 58800.0 |
| 2006-06-29 08:49:00 | AAPL | Stock | 2.0075 | 2.0075 | 2.0075 | 2.0075 | 30800.0 |
| 2006-06-29 08:50:00 | AAPL | Stock | 2.0075 | 2.0075 | 2.0071 | 2.0071 | 32620.0 |
| 2006-06-29 08:51:00 | AAPL | Stock | 2.0043 | 2.0043 | 2.0043 | 2.0043 | 11200.0 |
| 2006-06-29 08:52:00 | AAPL | Stock | 2.0036 | 2.01 | 2.0036 | 2.0086 | 51100.0 |
| 2006-06-29 08:54:00 | AAPL | Stock | 2.0071 | 2.0071 | 2.0071 | 2.0071 | 14000.0 |
| 2006-06-29 08:56:00 | AAPL | Stock | 2.0086 | 2.0086 | 2.0086 | 2.0086 | 35000.0 |
| 2006-06-29 08:57:00 | AAPL | Stock | 2.0089 | 2.0104 | 2.0079 | 2.0079 | 78988.0 |
| 2006-06-29 08:58:00 | AAPL | Stock | 2.0104 | 2.0107 | 2.0104 | 2.0104 | 39228.0 |
| 2006-06-29 08:59:00 | AAPL | Stock | 2.0104 | 2.0129 | 2.0096 | 2.0129 | 123200.0 |
| 2006-06-29 09:00:00 | AAPL | Stock | 2.0129 | 2.0143 | 2.0111 | 2.0125 | 176400.0 |
| 2006-06-29 09:01:00 | AAPL | Stock | 2.0125 | 2.0179 | 2.0121 | 2.0121 | 246680.0 |
| 2006-06-29 09:02:00 | AAPL | Stock | 2.0186 | 2.0268 | 2.0179 | 2.0257 | 384692.0 |
| 2006-06-29 09:03:00 | AAPL | Stock | 2.0257 | 2.0314 | 2.0257 | 2.0314 | 412580.0 |
| 2006-06-29 09:04:00 | AAPL | Stock | 2.0314 | 2.0364 | 2.0314 | 2.0357 | 943040.0 |
| 2006-06-29 09:05:00 | AAPL | Stock | 2.0357 | 2.0371 | 2.0357 | 2.0357 | 343000.0 |
| 2006-06-29 09:06:00 | AAPL | Stock | 2.0357 | 2.0357 | 2.03 | 2.0307 | 181972.0 |
| 2006-06-29 09:07:00 | AAPL | Stock | 2.0307 | 2.0321 | 2.0293 | 2.03 | 82600.0 |
| 2006-06-29 09:08:00 | AAPL | Stock | 2.03 | 2.0321 | 2.0293 | 2.0293 | 42000.0 |
| 2006-06-29 09:09:00 | AAPL | Stock | 2.0321 | 2.0329 | 2.0321 | 2.0321 | 131600.0 |
| 2006-06-29 09:10:00 | AAPL | Stock | 2.0321 | 2.0339 | 2.0321 | 2.0339 | 243040.0 |
| 2006-06-29 09:11:00 | AAPL | Stock | 2.0339 | 2.0343 | 2.0321 | 2.0321 | 57400.0 |
| 2006-06-29 09:12:00 | AAPL | Stock | 2.0332 | 2.0357 | 2.0332 | 2.0332 | 84000.0 |
| 2006-06-29 09:13:00 | AAPL | Stock | 2.0339 | 2.0339 | 2.0321 | 2.0321 | 58800.0 |
| 2006-06-29 09:14:00 | AAPL | Stock | 2.0325 | 2.0339 | 2.0318 | 2.0321 | 176120.0 |
> showing 50 of 731,747 rows — these rows as CSV