PREVIEW / stock_1min / 2007-02-16
file: by_date/stock_1min/2007/2007-02-16.parquet size: 9.2 MB rows: 750,959 symbols: 2,049
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-02-16 07:37:00 | AAPL | Stock | 3.045 | 3.045 | 3.045 | 3.045 | 11200.0 |
| 2007-02-16 07:45:00 | AAPL | Stock | 3.0357 | 3.0375 | 3.0357 | 3.0375 | 5600.0 |
| 2007-02-16 08:00:00 | AAPL | Stock | 3.0379 | 3.0379 | 3.0379 | 3.0379 | 4200.0 |
| 2007-02-16 08:04:00 | AAPL | Stock | 3.0411 | 3.0411 | 3.0411 | 3.0411 | 8400.0 |
| 2007-02-16 08:05:00 | AAPL | Stock | 3.0411 | 3.0411 | 3.0411 | 3.0411 | 33600.0 |
| 2007-02-16 08:06:00 | AAPL | Stock | 3.0414 | 3.0414 | 3.0404 | 3.0404 | 48300.0 |
| 2007-02-16 08:09:00 | AAPL | Stock | 3.0393 | 3.0393 | 3.0393 | 3.0393 | 38080.0 |
| 2007-02-16 08:10:00 | AAPL | Stock | 3.0357 | 3.0357 | 3.0357 | 3.0357 | 29120.0 |
| 2007-02-16 08:11:00 | AAPL | Stock | 3.0364 | 3.0375 | 3.0364 | 3.0375 | 70000.0 |
| 2007-02-16 08:12:00 | AAPL | Stock | 3.0386 | 3.0386 | 3.0386 | 3.0386 | 8400.0 |
| 2007-02-16 08:17:00 | AAPL | Stock | 3.0375 | 3.0386 | 3.0375 | 3.0386 | 14644.0 |
| 2007-02-16 08:18:00 | AAPL | Stock | 3.0382 | 3.0386 | 3.0382 | 3.0386 | 11200.0 |
| 2007-02-16 08:23:00 | AAPL | Stock | 3.0393 | 3.0393 | 3.0393 | 3.0393 | 10556.0 |
| 2007-02-16 08:24:00 | AAPL | Stock | 3.0364 | 3.0364 | 3.0361 | 3.0361 | 38276.0 |
| 2007-02-16 08:29:00 | AAPL | Stock | 3.0361 | 3.0364 | 3.0361 | 3.0364 | 7000.0 |
| 2007-02-16 08:33:00 | AAPL | Stock | 3.0361 | 3.0361 | 3.0361 | 3.0361 | 2800.0 |
| 2007-02-16 08:38:00 | AAPL | Stock | 3.0393 | 3.04 | 3.0393 | 3.04 | 5600.0 |
| 2007-02-16 08:39:00 | AAPL | Stock | 3.0404 | 3.0411 | 3.0404 | 3.0411 | 58800.0 |
| 2007-02-16 08:43:00 | AAPL | Stock | 3.0421 | 3.0421 | 3.0407 | 3.0407 | 5600.0 |
| 2007-02-16 08:49:00 | AAPL | Stock | 3.0411 | 3.0411 | 3.0411 | 3.0411 | 4200.0 |
| 2007-02-16 08:51:00 | AAPL | Stock | 3.0411 | 3.0411 | 3.0411 | 3.0411 | 22400.0 |
| 2007-02-16 08:52:00 | AAPL | Stock | 3.0411 | 3.0411 | 3.0411 | 3.0411 | 144900.0 |
| 2007-02-16 08:53:00 | AAPL | Stock | 3.0411 | 3.0411 | 3.0411 | 3.0411 | 47600.0 |
| 2007-02-16 08:54:00 | AAPL | Stock | 3.0411 | 3.0411 | 3.0411 | 3.0411 | 106904.0 |
| 2007-02-16 08:55:00 | AAPL | Stock | 3.0411 | 3.0411 | 3.0411 | 3.0411 | 14000.0 |
| 2007-02-16 08:56:00 | AAPL | Stock | 3.0382 | 3.0382 | 3.0382 | 3.0382 | 2800.0 |
| 2007-02-16 08:58:00 | AAPL | Stock | 3.0379 | 3.0393 | 3.0368 | 3.0371 | 83160.0 |
| 2007-02-16 09:02:00 | AAPL | Stock | 3.0371 | 3.0371 | 3.0357 | 3.0357 | 21672.0 |
| 2007-02-16 09:03:00 | AAPL | Stock | 3.0368 | 3.0368 | 3.0368 | 3.0368 | 7896.0 |
| 2007-02-16 09:07:00 | AAPL | Stock | 3.0368 | 3.0368 | 3.0368 | 3.0368 | 19544.0 |
| 2007-02-16 09:09:00 | AAPL | Stock | 3.0364 | 3.0368 | 3.0357 | 3.0368 | 48916.0 |
| 2007-02-16 09:12:00 | AAPL | Stock | 3.0361 | 3.0361 | 3.0361 | 3.0361 | 17416.0 |
| 2007-02-16 09:18:00 | AAPL | Stock | 3.0375 | 3.0375 | 3.0375 | 3.0375 | 16800.0 |
| 2007-02-16 09:19:00 | AAPL | Stock | 3.0375 | 3.0382 | 3.0375 | 3.0382 | 28000.0 |
| 2007-02-16 09:20:00 | AAPL | Stock | 3.0389 | 3.0389 | 3.0389 | 3.0389 | 28000.0 |
| 2007-02-16 09:26:00 | AAPL | Stock | 3.0386 | 3.0386 | 3.0386 | 3.0386 | 8400.0 |
| 2007-02-16 09:28:00 | AAPL | Stock | 3.0386 | 3.0386 | 3.0318 | 3.0318 | 155680.0 |
| 2007-02-16 09:29:00 | AAPL | Stock | 3.0329 | 3.0446 | 3.0329 | 3.0446 | 249760.0 |
| 2007-02-16 09:30:00 | AAPL | Stock | 3.0446 | 3.0504 | 3.0364 | 3.0393 | 32634448.0 |
| 2007-02-16 09:31:00 | AAPL | Stock | 3.0393 | 3.04 | 3.0371 | 3.0389 | 3845212.0 |
| 2007-02-16 09:32:00 | AAPL | Stock | 3.0389 | 3.0393 | 3.0375 | 3.0379 | 2025100.0 |
| 2007-02-16 09:33:00 | AAPL | Stock | 3.0386 | 3.0386 | 3.0321 | 3.0339 | 2450028.0 |
| 2007-02-16 09:34:00 | AAPL | Stock | 3.0339 | 3.0339 | 3.0296 | 3.0321 | 1979572.0 |
| 2007-02-16 09:35:00 | AAPL | Stock | 3.0321 | 3.0368 | 3.0318 | 3.0339 | 1754872.0 |
| 2007-02-16 09:36:00 | AAPL | Stock | 3.0339 | 3.0386 | 3.0336 | 3.0379 | 2874984.0 |
| 2007-02-16 09:37:00 | AAPL | Stock | 3.0379 | 3.0389 | 3.0368 | 3.0382 | 1895712.0 |
| 2007-02-16 09:38:00 | AAPL | Stock | 3.0379 | 3.0386 | 3.035 | 3.0357 | 1917608.0 |
| 2007-02-16 09:39:00 | AAPL | Stock | 3.0354 | 3.0357 | 3.0332 | 3.0343 | 1514324.0 |
| 2007-02-16 09:40:00 | AAPL | Stock | 3.0346 | 3.035 | 3.0339 | 3.0346 | 2836372.0 |
| 2007-02-16 09:41:00 | AAPL | Stock | 3.035 | 3.0364 | 3.0346 | 3.0354 | 1692124.0 |
> showing 50 of 750,959 rows — these rows as CSV