PREVIEW / stock_5min / 2007-02-20
file: by_date/stock_5min/2007/2007-02-20.parquet size: 3.4 MB rows: 249,613 symbols: 2,535
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-20 06:40:00 | AAPL | Stock | 3.0304 | 3.0304 | 3.0304 | 3.0304 | 11200.0 |
| 2007-02-20 08:00:00 | AAPL | Stock | 3.0296 | 3.0296 | 3.0296 | 3.0296 | 2800.0 |
| 2007-02-20 08:05:00 | AAPL | Stock | 3.025 | 3.025 | 3.0193 | 3.0232 | 73444.0 |
| 2007-02-20 08:20:00 | AAPL | Stock | 3.0268 | 3.0296 | 3.0268 | 3.0296 | 5600.0 |
| 2007-02-20 08:30:00 | AAPL | Stock | 3.0321 | 3.0321 | 3.0321 | 3.0321 | 44800.0 |
| 2007-02-20 08:35:00 | AAPL | Stock | 3.0321 | 3.0321 | 3.0296 | 3.0296 | 32200.0 |
| 2007-02-20 08:40:00 | AAPL | Stock | 3.0321 | 3.0357 | 3.0321 | 3.0357 | 35000.0 |
| 2007-02-20 08:45:00 | AAPL | Stock | 3.0325 | 3.0325 | 3.0325 | 3.0325 | 2800.0 |
| 2007-02-20 08:50:00 | AAPL | Stock | 3.0321 | 3.0321 | 3.0321 | 3.0321 | 44800.0 |
| 2007-02-20 08:55:00 | AAPL | Stock | 3.0321 | 3.0321 | 3.0296 | 3.0321 | 198884.0 |
| 2007-02-20 09:00:00 | AAPL | Stock | 3.0321 | 3.0321 | 3.0304 | 3.0304 | 92316.0 |
| 2007-02-20 09:05:00 | AAPL | Stock | 3.0289 | 3.0318 | 3.0214 | 3.0318 | 136948.0 |
| 2007-02-20 09:10:00 | AAPL | Stock | 3.0261 | 3.0261 | 3.0257 | 3.0261 | 64736.0 |
| 2007-02-20 09:15:00 | AAPL | Stock | 3.0268 | 3.035 | 3.0268 | 3.035 | 109200.0 |
| 2007-02-20 09:20:00 | AAPL | Stock | 3.0321 | 3.0321 | 3.0261 | 3.0261 | 109200.0 |
| 2007-02-20 09:25:00 | AAPL | Stock | 3.0261 | 3.0261 | 3.0196 | 3.0232 | 349720.0 |
| 2007-02-20 09:30:00 | AAPL | Stock | 3.0232 | 3.025 | 3.0057 | 3.0143 | 18446344.0 |
| 2007-02-20 09:35:00 | AAPL | Stock | 3.0143 | 3.0243 | 3.01 | 3.0221 | 11102196.0 |
| 2007-02-20 09:40:00 | AAPL | Stock | 3.0221 | 3.0296 | 3.0175 | 3.0296 | 13803076.0 |
| 2007-02-20 09:45:00 | AAPL | Stock | 3.03 | 3.0382 | 3.0261 | 3.0361 | 18362484.0 |
| 2007-02-20 09:50:00 | AAPL | Stock | 3.0364 | 3.0429 | 3.0361 | 3.0382 | 19379752.0 |
| 2007-02-20 09:55:00 | AAPL | Stock | 3.0379 | 3.0489 | 3.0321 | 3.0482 | 20542592.0 |
| 2007-02-20 10:00:00 | AAPL | Stock | 3.0482 | 3.0489 | 3.0375 | 3.0407 | 16542540.0 |
| 2007-02-20 10:05:00 | AAPL | Stock | 3.0407 | 3.0411 | 3.0346 | 3.0371 | 11346104.0 |
| 2007-02-20 10:10:00 | AAPL | Stock | 3.0375 | 3.0389 | 3.0304 | 3.0329 | 9328844.0 |
| 2007-02-20 10:15:00 | AAPL | Stock | 3.0321 | 3.0361 | 3.03 | 3.0343 | 8583904.0 |
| 2007-02-20 10:20:00 | AAPL | Stock | 3.0343 | 3.0357 | 3.0239 | 3.0275 | 7750456.0 |
| 2007-02-20 10:25:00 | AAPL | Stock | 3.0275 | 3.0321 | 3.0214 | 3.0307 | 8877204.0 |
| 2007-02-20 10:30:00 | AAPL | Stock | 3.0304 | 3.0357 | 3.0279 | 3.0343 | 8323644.0 |
| 2007-02-20 10:35:00 | AAPL | Stock | 3.0346 | 3.0386 | 3.0329 | 3.0336 | 7344344.0 |
| 2007-02-20 10:40:00 | AAPL | Stock | 3.0336 | 3.0357 | 3.03 | 3.0318 | 5340944.0 |
| 2007-02-20 10:45:00 | AAPL | Stock | 3.0318 | 3.0461 | 3.0318 | 3.0429 | 10442152.0 |
| 2007-02-20 10:50:00 | AAPL | Stock | 3.0429 | 3.0446 | 3.0393 | 3.04 | 6455288.0 |
| 2007-02-20 10:55:00 | AAPL | Stock | 3.04 | 3.0429 | 3.0393 | 3.0418 | 3102400.0 |
| 2007-02-20 11:00:00 | AAPL | Stock | 3.0418 | 3.0443 | 3.0375 | 3.0382 | 5772340.0 |
| 2007-02-20 11:05:00 | AAPL | Stock | 3.0382 | 3.0414 | 3.0382 | 3.0394 | 2722244.0 |
| 2007-02-20 11:10:00 | AAPL | Stock | 3.0393 | 3.045 | 3.0393 | 3.0443 | 4310992.0 |
| 2007-02-20 11:15:00 | AAPL | Stock | 3.0443 | 3.0482 | 3.0439 | 3.045 | 11818828.0 |
| 2007-02-20 11:20:00 | AAPL | Stock | 3.045 | 3.0518 | 3.0446 | 3.0489 | 9621668.0 |
| 2007-02-20 11:25:00 | AAPL | Stock | 3.0493 | 3.0514 | 3.0457 | 3.0507 | 9201948.0 |
| 2007-02-20 11:30:00 | AAPL | Stock | 3.0507 | 3.0571 | 3.0507 | 3.0536 | 16717848.0 |
| 2007-02-20 11:35:00 | AAPL | Stock | 3.0532 | 3.0554 | 3.0529 | 3.0532 | 5344472.0 |
| 2007-02-20 11:40:00 | AAPL | Stock | 3.0532 | 3.055 | 3.0511 | 3.0542 | 3770788.0 |
| 2007-02-20 11:45:00 | AAPL | Stock | 3.0539 | 3.0571 | 3.0529 | 3.0543 | 7074704.0 |
| 2007-02-20 11:50:00 | AAPL | Stock | 3.0543 | 3.0582 | 3.0543 | 3.0557 | 7954044.0 |
| 2007-02-20 11:55:00 | AAPL | Stock | 3.0557 | 3.0557 | 3.0511 | 3.0529 | 5746832.0 |
| 2007-02-20 12:00:00 | AAPL | Stock | 3.0525 | 3.0607 | 3.0521 | 3.0607 | 8473024.0 |
| 2007-02-20 12:05:00 | AAPL | Stock | 3.0607 | 3.0657 | 3.0589 | 3.0636 | 9223256.0 |
| 2007-02-20 12:10:00 | AAPL | Stock | 3.0639 | 3.0671 | 3.0621 | 3.0629 | 6593496.0 |
| 2007-02-20 12:15:00 | AAPL | Stock | 3.0629 | 3.0679 | 3.0554 | 3.0668 | 6633620.0 |
> showing 50 of 249,613 rows — these rows as CSV