PREVIEW / stock_1min / 2010-06-08
file: by_date/stock_1min/2010/2010-06-08.parquet size: 13.6 MB rows: 1,043,976 symbols: 2,810
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 |
|---|---|---|---|---|---|---|---|
| 2010-06-08 04:15:00 | AAPL | Stock | 9.0696 | 9.0696 | 9.0696 | 9.0696 | 2800.0 |
| 2010-06-08 05:03:00 | AAPL | Stock | 9.0018 | 9.0018 | 9.0018 | 9.0018 | 11340.0 |
| 2010-06-08 05:48:00 | AAPL | Stock | 9.0229 | 9.0229 | 9.0229 | 9.0229 | 14000.0 |
| 2010-06-08 06:58:00 | AAPL | Stock | 9.0036 | 9.0036 | 9.0036 | 9.0036 | 13720.0 |
| 2010-06-08 07:04:00 | AAPL | Stock | 9.0089 | 9.0089 | 9.0086 | 9.0089 | 31696.0 |
| 2010-06-08 07:10:00 | AAPL | Stock | 9.0143 | 9.0143 | 9.0143 | 9.0143 | 2800.0 |
| 2010-06-08 07:13:00 | AAPL | Stock | 9.0146 | 9.0146 | 9.0146 | 9.0146 | 8400.0 |
| 2010-06-08 07:14:00 | AAPL | Stock | 9.0146 | 9.0179 | 9.0146 | 9.0179 | 8400.0 |
| 2010-06-08 07:17:00 | AAPL | Stock | 9.0214 | 9.0214 | 9.0214 | 9.0214 | 5600.0 |
| 2010-06-08 07:18:00 | AAPL | Stock | 9.0318 | 9.0321 | 9.0318 | 9.0321 | 25200.0 |
| 2010-06-08 07:21:00 | AAPL | Stock | 9.0214 | 9.0321 | 9.0214 | 9.0321 | 14000.0 |
| 2010-06-08 07:24:00 | AAPL | Stock | 9.0346 | 9.0354 | 9.0346 | 9.0354 | 5600.0 |
| 2010-06-08 07:25:00 | AAPL | Stock | 9.025 | 9.025 | 9.025 | 9.025 | 5600.0 |
| 2010-06-08 07:29:00 | AAPL | Stock | 9.0186 | 9.025 | 9.0186 | 9.025 | 26600.0 |
| 2010-06-08 07:32:00 | AAPL | Stock | 9.0236 | 9.0236 | 9.0236 | 9.0236 | 5600.0 |
| 2010-06-08 07:33:00 | AAPL | Stock | 9.0182 | 9.0329 | 9.0182 | 9.0325 | 45528.0 |
| 2010-06-08 07:34:00 | AAPL | Stock | 9.0293 | 9.0314 | 9.0293 | 9.0314 | 8400.0 |
| 2010-06-08 07:35:00 | AAPL | Stock | 9.0304 | 9.0304 | 9.0304 | 9.0304 | 28000.0 |
| 2010-06-08 07:37:00 | AAPL | Stock | 9.025 | 9.025 | 9.025 | 9.025 | 2800.0 |
| 2010-06-08 07:40:00 | AAPL | Stock | 9.0207 | 9.0207 | 9.0207 | 9.0207 | 2800.0 |
| 2010-06-08 07:41:00 | AAPL | Stock | 9.0207 | 9.0207 | 9.0207 | 9.0207 | 2800.0 |
| 2010-06-08 07:42:00 | AAPL | Stock | 9.0271 | 9.0271 | 9.0214 | 9.0214 | 16800.0 |
| 2010-06-08 07:47:00 | AAPL | Stock | 9.0179 | 9.0179 | 9.0161 | 9.0168 | 42000.0 |
| 2010-06-08 07:48:00 | AAPL | Stock | 9.0129 | 9.0129 | 9.0104 | 9.0129 | 39200.0 |
| 2010-06-08 07:49:00 | AAPL | Stock | 9.0125 | 9.0125 | 9.0089 | 9.0089 | 14000.0 |
| 2010-06-08 07:50:00 | AAPL | Stock | 9.0093 | 9.0129 | 9.0071 | 9.0071 | 16800.0 |
| 2010-06-08 07:51:00 | AAPL | Stock | 9.0107 | 9.0107 | 9.0107 | 9.0107 | 8400.0 |
| 2010-06-08 07:52:00 | AAPL | Stock | 9.0014 | 9.0014 | 9.0 | 9.0 | 25200.0 |
| 2010-06-08 07:53:00 | AAPL | Stock | 9.0 | 9.0054 | 9.0 | 9.0054 | 8456.0 |
| 2010-06-08 07:54:00 | AAPL | Stock | 9.0104 | 9.0107 | 9.0104 | 9.0107 | 5600.0 |
| 2010-06-08 07:56:00 | AAPL | Stock | 9.0096 | 9.0096 | 9.0096 | 9.0096 | 2800.0 |
| 2010-06-08 07:57:00 | AAPL | Stock | 9.0 | 9.0007 | 9.0 | 9.0 | 11200.0 |
| 2010-06-08 08:00:00 | AAPL | Stock | 9.0086 | 9.0321 | 8.9982 | 9.0179 | 177352.0 |
| 2010-06-08 08:01:00 | AAPL | Stock | 9.0214 | 9.0214 | 9.0146 | 9.0179 | 63000.0 |
| 2010-06-08 08:02:00 | AAPL | Stock | 9.0179 | 9.0286 | 9.0179 | 9.0286 | 102844.0 |
| 2010-06-08 08:03:00 | AAPL | Stock | 9.0286 | 9.0286 | 9.0214 | 9.0221 | 58800.0 |
| 2010-06-08 08:04:00 | AAPL | Stock | 9.0264 | 9.0282 | 9.0239 | 9.0239 | 31920.0 |
| 2010-06-08 08:05:00 | AAPL | Stock | 9.0282 | 9.0439 | 9.025 | 9.0343 | 227976.0 |
| 2010-06-08 08:06:00 | AAPL | Stock | 9.0425 | 9.0425 | 9.0361 | 9.037 | 33600.0 |
| 2010-06-08 08:07:00 | AAPL | Stock | 9.0393 | 9.0486 | 9.0368 | 9.0443 | 106400.0 |
| 2010-06-08 08:08:00 | AAPL | Stock | 9.0454 | 9.0461 | 9.0454 | 9.0461 | 14000.0 |
| 2010-06-08 08:09:00 | AAPL | Stock | 9.0461 | 9.0607 | 9.0457 | 9.0579 | 135380.0 |
| 2010-06-08 08:10:00 | AAPL | Stock | 9.0579 | 9.0611 | 9.0575 | 9.0611 | 37800.0 |
| 2010-06-08 08:11:00 | AAPL | Stock | 9.0575 | 9.0575 | 9.0536 | 9.0571 | 130144.0 |
| 2010-06-08 08:12:00 | AAPL | Stock | 9.0536 | 9.0589 | 9.0525 | 9.0589 | 43820.0 |
| 2010-06-08 08:13:00 | AAPL | Stock | 9.0589 | 9.0607 | 9.055 | 9.0586 | 87780.0 |
| 2010-06-08 08:14:00 | AAPL | Stock | 9.0546 | 9.0561 | 9.05 | 9.0536 | 172424.0 |
| 2010-06-08 08:15:00 | AAPL | Stock | 9.0536 | 9.0643 | 9.0532 | 9.0643 | 106400.0 |
| 2010-06-08 08:16:00 | AAPL | Stock | 9.0668 | 9.0693 | 9.0607 | 9.0654 | 132720.0 |
| 2010-06-08 08:17:00 | AAPL | Stock | 9.0693 | 9.0811 | 9.0682 | 9.0786 | 123928.0 |
> showing 50 of 1,043,976 rows — these rows as CSV