PREVIEW / stock_1min / 2009-11-09
file: by_date/stock_1min/2009/2009-11-09.parquet size: 12.7 MB rows: 955,005 symbols: 2,777
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 |
|---|---|---|---|---|---|---|---|
| 2009-11-09 04:15:00 | AAPL | Stock | 6.9582 | 6.9582 | 6.9582 | 6.9582 | 2800.0 |
| 2009-11-09 04:27:00 | AAPL | Stock | 6.9604 | 6.9604 | 6.9604 | 6.9604 | 2800.0 |
| 2009-11-09 04:32:00 | AAPL | Stock | 6.9675 | 6.9675 | 6.9675 | 6.9675 | 2800.0 |
| 2009-11-09 04:33:00 | AAPL | Stock | 6.9614 | 6.9614 | 6.9614 | 6.9614 | 2800.0 |
| 2009-11-09 05:08:00 | AAPL | Stock | 7.0139 | 7.0139 | 7.0139 | 7.0139 | 2800.0 |
| 2009-11-09 07:01:00 | AAPL | Stock | 7.0071 | 7.0071 | 7.0071 | 7.0071 | 2800.0 |
| 2009-11-09 07:05:00 | AAPL | Stock | 7.0 | 7.0029 | 6.9989 | 6.9989 | 111776.0 |
| 2009-11-09 07:10:00 | AAPL | Stock | 7.0154 | 7.0154 | 7.0154 | 7.0154 | 28000.0 |
| 2009-11-09 07:16:00 | AAPL | Stock | 7.0104 | 7.0107 | 7.0104 | 7.0107 | 11200.0 |
| 2009-11-09 07:26:00 | AAPL | Stock | 7.0011 | 7.0011 | 7.0011 | 7.0011 | 2800.0 |
| 2009-11-09 07:30:00 | AAPL | Stock | 7.0118 | 7.0121 | 7.0118 | 7.0121 | 7000.0 |
| 2009-11-09 07:33:00 | AAPL | Stock | 7.0114 | 7.0139 | 7.0114 | 7.0118 | 22316.0 |
| 2009-11-09 07:34:00 | AAPL | Stock | 7.0121 | 7.0139 | 7.0121 | 7.0139 | 14000.0 |
| 2009-11-09 07:35:00 | AAPL | Stock | 7.0043 | 7.0043 | 7.0043 | 7.0043 | 2800.0 |
| 2009-11-09 07:36:00 | AAPL | Stock | 7.0146 | 7.0171 | 7.0146 | 7.0161 | 30800.0 |
| 2009-11-09 07:40:00 | AAPL | Stock | 7.0179 | 7.0179 | 7.0179 | 7.0179 | 5040.0 |
| 2009-11-09 07:43:00 | AAPL | Stock | 7.0261 | 7.0261 | 7.0261 | 7.0261 | 5600.0 |
| 2009-11-09 07:46:00 | AAPL | Stock | 7.0246 | 7.0261 | 7.0246 | 7.0261 | 11956.0 |
| 2009-11-09 07:49:00 | AAPL | Stock | 7.035 | 7.0361 | 7.035 | 7.0357 | 62468.0 |
| 2009-11-09 08:00:00 | AAPL | Stock | 7.0268 | 7.0357 | 7.0179 | 7.0268 | 182476.0 |
| 2009-11-09 08:01:00 | AAPL | Stock | 7.0268 | 7.0357 | 7.0268 | 7.035 | 36680.0 |
| 2009-11-09 08:02:00 | AAPL | Stock | 7.0343 | 7.0357 | 7.0296 | 7.0296 | 70168.0 |
| 2009-11-09 08:03:00 | AAPL | Stock | 7.0354 | 7.0354 | 7.0287 | 7.0296 | 42000.0 |
| 2009-11-09 08:04:00 | AAPL | Stock | 7.0343 | 7.0343 | 7.0343 | 7.0343 | 2800.0 |
| 2009-11-09 08:05:00 | AAPL | Stock | 7.0343 | 7.0343 | 7.0307 | 7.0321 | 71540.0 |
| 2009-11-09 08:06:00 | AAPL | Stock | 7.0321 | 7.0339 | 7.0314 | 7.0339 | 45976.0 |
| 2009-11-09 08:07:00 | AAPL | Stock | 7.0321 | 7.0343 | 7.0296 | 7.0336 | 162764.0 |
| 2009-11-09 08:08:00 | AAPL | Stock | 7.0336 | 7.0336 | 7.0336 | 7.0336 | 101864.0 |
| 2009-11-09 08:09:00 | AAPL | Stock | 7.0336 | 7.0339 | 7.0329 | 7.0332 | 79940.0 |
| 2009-11-09 08:10:00 | AAPL | Stock | 7.0336 | 7.0339 | 7.0336 | 7.0339 | 51772.0 |
| 2009-11-09 08:11:00 | AAPL | Stock | 7.0339 | 7.0339 | 7.0339 | 7.0339 | 8400.0 |
| 2009-11-09 08:12:00 | AAPL | Stock | 7.0339 | 7.035 | 7.0339 | 7.035 | 11200.0 |
| 2009-11-09 08:13:00 | AAPL | Stock | 7.0346 | 7.0389 | 7.0346 | 7.0389 | 109368.0 |
| 2009-11-09 08:14:00 | AAPL | Stock | 7.0375 | 7.0404 | 7.0375 | 7.0404 | 29120.0 |
| 2009-11-09 08:15:00 | AAPL | Stock | 7.0389 | 7.0418 | 7.0389 | 7.0418 | 50400.0 |
| 2009-11-09 08:16:00 | AAPL | Stock | 7.0414 | 7.0471 | 7.0411 | 7.0471 | 72800.0 |
| 2009-11-09 08:17:00 | AAPL | Stock | 7.0471 | 7.0479 | 7.045 | 7.0457 | 34440.0 |
| 2009-11-09 08:18:00 | AAPL | Stock | 7.0429 | 7.0429 | 7.0429 | 7.0429 | 2800.0 |
| 2009-11-09 08:19:00 | AAPL | Stock | 7.0432 | 7.0432 | 7.0407 | 7.0407 | 63504.0 |
| 2009-11-09 08:20:00 | AAPL | Stock | 7.0429 | 7.0429 | 7.0368 | 7.0368 | 14000.0 |
| 2009-11-09 08:21:00 | AAPL | Stock | 7.0393 | 7.0393 | 7.0382 | 7.0382 | 6636.0 |
| 2009-11-09 08:22:00 | AAPL | Stock | 7.0375 | 7.0375 | 7.0357 | 7.0357 | 17640.0 |
| 2009-11-09 08:23:00 | AAPL | Stock | 7.0357 | 7.0357 | 7.0357 | 7.0357 | 14616.0 |
| 2009-11-09 08:24:00 | AAPL | Stock | 7.0357 | 7.0375 | 7.0357 | 7.0359 | 48160.0 |
| 2009-11-09 08:25:00 | AAPL | Stock | 7.0357 | 7.0375 | 7.0357 | 7.0357 | 83804.0 |
| 2009-11-09 08:26:00 | AAPL | Stock | 7.0357 | 7.0357 | 7.0357 | 7.0357 | 7196.0 |
| 2009-11-09 08:30:00 | AAPL | Stock | 7.0357 | 7.0375 | 7.0321 | 7.0321 | 120484.0 |
| 2009-11-09 08:31:00 | AAPL | Stock | 7.0354 | 7.0354 | 7.0354 | 7.0354 | 2800.0 |
| 2009-11-09 08:32:00 | AAPL | Stock | 7.0354 | 7.0354 | 7.0289 | 7.0289 | 85232.0 |
| 2009-11-09 08:33:00 | AAPL | Stock | 7.035 | 7.0357 | 7.0332 | 7.0357 | 24640.0 |
> showing 50 of 955,005 rows — these rows as CSV