PREVIEW / stock_5min / 2007-04-02
file: by_date/stock_5min/2007/2007-04-02.parquet size: 3.6 MB rows: 258,015 symbols: 2,562
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-04-02 05:10:00 | AAPL | Stock | 3.36 | 3.36 | 3.36 | 3.36 | 12040.0 |
| 2007-04-02 05:15:00 | AAPL | Stock | 3.3571 | 3.3571 | 3.3571 | 3.3571 | 2800.0 |
| 2007-04-02 07:35:00 | AAPL | Stock | 3.3468 | 3.3468 | 3.3468 | 3.3468 | 5880.0 |
| 2007-04-02 07:45:00 | AAPL | Stock | 3.3454 | 3.3568 | 3.3454 | 3.3568 | 220360.0 |
| 2007-04-02 07:55:00 | AAPL | Stock | 3.3525 | 3.3571 | 3.3525 | 3.3571 | 66640.0 |
| 2007-04-02 08:00:00 | AAPL | Stock | 3.3471 | 3.3554 | 3.3182 | 3.3464 | 708400.0 |
| 2007-04-02 08:05:00 | AAPL | Stock | 3.3464 | 3.3489 | 3.3446 | 3.3457 | 85176.0 |
| 2007-04-02 08:10:00 | AAPL | Stock | 3.3454 | 3.3482 | 3.3429 | 3.3464 | 125608.0 |
| 2007-04-02 08:15:00 | AAPL | Stock | 3.3479 | 3.3536 | 3.3468 | 3.3518 | 231196.0 |
| 2007-04-02 08:20:00 | AAPL | Stock | 3.35 | 3.35 | 3.3182 | 3.3182 | 88200.0 |
| 2007-04-02 08:25:00 | AAPL | Stock | 3.3504 | 3.3504 | 3.3482 | 3.3482 | 41804.0 |
| 2007-04-02 08:30:00 | AAPL | Stock | 3.3486 | 3.3486 | 3.3464 | 3.3464 | 72660.0 |
| 2007-04-02 08:35:00 | AAPL | Stock | 3.3464 | 3.3468 | 3.3357 | 3.3457 | 559132.0 |
| 2007-04-02 08:40:00 | AAPL | Stock | 3.3411 | 3.3464 | 3.3411 | 3.3464 | 188832.0 |
| 2007-04-02 08:45:00 | AAPL | Stock | 3.3464 | 3.3464 | 3.3429 | 3.3432 | 236348.0 |
| 2007-04-02 08:50:00 | AAPL | Stock | 3.3443 | 3.3464 | 3.3443 | 3.3457 | 129640.0 |
| 2007-04-02 08:55:00 | AAPL | Stock | 3.3457 | 3.3457 | 3.3429 | 3.3429 | 205940.0 |
| 2007-04-02 09:00:00 | AAPL | Stock | 3.3436 | 3.3525 | 3.3436 | 3.35 | 512204.0 |
| 2007-04-02 09:05:00 | AAPL | Stock | 3.35 | 3.3625 | 3.35 | 3.3589 | 1584492.0 |
| 2007-04-02 09:10:00 | AAPL | Stock | 3.3607 | 3.37 | 3.3586 | 3.3643 | 1615488.0 |
| 2007-04-02 09:15:00 | AAPL | Stock | 3.3625 | 3.3643 | 3.3539 | 3.3571 | 1034040.0 |
| 2007-04-02 09:20:00 | AAPL | Stock | 3.3589 | 3.3589 | 3.3568 | 3.3582 | 179900.0 |
| 2007-04-02 09:25:00 | AAPL | Stock | 3.3582 | 3.3643 | 3.3539 | 3.3625 | 1462104.0 |
| 2007-04-02 09:30:00 | AAPL | Stock | 3.3636 | 3.3661 | 3.3489 | 3.3493 | 26480272.0 |
| 2007-04-02 09:35:00 | AAPL | Stock | 3.3493 | 3.355 | 3.3436 | 3.345 | 16264976.0 |
| 2007-04-02 09:40:00 | AAPL | Stock | 3.345 | 3.3489 | 3.3364 | 3.3425 | 15489992.0 |
| 2007-04-02 09:45:00 | AAPL | Stock | 3.3425 | 3.345 | 3.3357 | 3.3407 | 11820732.0 |
| 2007-04-02 09:50:00 | AAPL | Stock | 3.3404 | 3.3479 | 3.3404 | 3.3429 | 8681120.0 |
| 2007-04-02 09:55:00 | AAPL | Stock | 3.3421 | 3.3621 | 3.3418 | 3.3475 | 11895688.0 |
| 2007-04-02 10:00:00 | AAPL | Stock | 3.3479 | 3.3479 | 3.3325 | 3.3386 | 16202116.0 |
| 2007-04-02 10:05:00 | AAPL | Stock | 3.3382 | 3.3404 | 3.3236 | 3.3254 | 18430440.0 |
| 2007-04-02 10:10:00 | AAPL | Stock | 3.3254 | 3.3354 | 3.3221 | 3.3286 | 13917988.0 |
| 2007-04-02 10:15:00 | AAPL | Stock | 3.3289 | 3.3293 | 3.3232 | 3.3256 | 10900820.0 |
| 2007-04-02 10:20:00 | AAPL | Stock | 3.3257 | 3.3379 | 3.3239 | 3.33 | 12100872.0 |
| 2007-04-02 10:25:00 | AAPL | Stock | 3.33 | 3.335 | 3.3296 | 3.3339 | 7246204.0 |
| 2007-04-02 10:30:00 | AAPL | Stock | 3.3339 | 3.3411 | 3.3339 | 3.3365 | 11241636.0 |
| 2007-04-02 10:35:00 | AAPL | Stock | 3.3371 | 3.3404 | 3.3361 | 3.3382 | 6471444.0 |
| 2007-04-02 10:40:00 | AAPL | Stock | 3.3384 | 3.3411 | 3.3321 | 3.3368 | 8881880.0 |
| 2007-04-02 10:45:00 | AAPL | Stock | 3.3371 | 3.3407 | 3.3371 | 3.3389 | 5063828.0 |
| 2007-04-02 10:50:00 | AAPL | Stock | 3.3389 | 3.3407 | 3.3354 | 3.3407 | 4918508.0 |
| 2007-04-02 10:55:00 | AAPL | Stock | 3.3411 | 3.3514 | 3.3407 | 3.3496 | 13756316.0 |
| 2007-04-02 11:00:00 | AAPL | Stock | 3.3496 | 3.3525 | 3.3471 | 3.35 | 9021152.0 |
| 2007-04-02 11:05:00 | AAPL | Stock | 3.35 | 3.3525 | 3.3475 | 3.3482 | 6064912.0 |
| 2007-04-02 11:10:00 | AAPL | Stock | 3.3482 | 3.3496 | 3.3457 | 3.3461 | 5785640.0 |
| 2007-04-02 11:15:00 | AAPL | Stock | 3.3461 | 3.3468 | 3.3439 | 3.3439 | 4734100.0 |
| 2007-04-02 11:20:00 | AAPL | Stock | 3.3436 | 3.3461 | 3.3418 | 3.3461 | 3853584.0 |
| 2007-04-02 11:25:00 | AAPL | Stock | 3.3461 | 3.3461 | 3.3418 | 3.3425 | 3755724.0 |
| 2007-04-02 11:30:00 | AAPL | Stock | 3.3422 | 3.3436 | 3.34 | 3.3429 | 5214104.0 |
| 2007-04-02 11:35:00 | AAPL | Stock | 3.3429 | 3.35 | 3.3414 | 3.3429 | 4665444.0 |
| 2007-04-02 11:40:00 | AAPL | Stock | 3.3432 | 3.345 | 3.3404 | 3.3418 | 3152156.0 |
> showing 50 of 258,015 rows — these rows as CSV