PREVIEW / stock_5min / 2005-01-31
file: by_date/stock_5min/2005/2005-01-31.parquet size: 2.7 MB rows: 194,914 symbols: 1,930
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 |
|---|---|---|---|---|---|---|---|
| 2005-01-31 08:00:00 | AAPL | Stock | 1.3263 | 1.3395 | 1.3263 | 1.3393 | 1693440.0 |
| 2005-01-31 08:05:00 | AAPL | Stock | 1.3389 | 1.3393 | 1.3357 | 1.3357 | 498400.0 |
| 2005-01-31 08:10:00 | AAPL | Stock | 1.3366 | 1.3411 | 1.3366 | 1.3411 | 1090096.0 |
| 2005-01-31 08:15:00 | AAPL | Stock | 1.3421 | 1.3434 | 1.3393 | 1.3402 | 702576.0 |
| 2005-01-31 08:20:00 | AAPL | Stock | 1.3393 | 1.3411 | 1.3391 | 1.3411 | 520800.0 |
| 2005-01-31 08:25:00 | AAPL | Stock | 1.3393 | 1.3411 | 1.3393 | 1.34 | 548800.0 |
| 2005-01-31 08:30:00 | AAPL | Stock | 1.34 | 1.3411 | 1.3384 | 1.3393 | 1421000.0 |
| 2005-01-31 08:35:00 | AAPL | Stock | 1.3393 | 1.3395 | 1.3375 | 1.3393 | 572040.0 |
| 2005-01-31 08:40:00 | AAPL | Stock | 1.3377 | 1.3384 | 1.3357 | 1.3375 | 544376.0 |
| 2005-01-31 08:45:00 | AAPL | Stock | 1.3366 | 1.3377 | 1.3357 | 1.3373 | 156800.0 |
| 2005-01-31 08:50:00 | AAPL | Stock | 1.337 | 1.337 | 1.337 | 1.337 | 19600.0 |
| 2005-01-31 08:55:00 | AAPL | Stock | 1.3377 | 1.3393 | 1.3371 | 1.3393 | 407680.0 |
| 2005-01-31 09:00:00 | AAPL | Stock | 1.3393 | 1.3393 | 1.3375 | 1.3375 | 578368.0 |
| 2005-01-31 09:05:00 | AAPL | Stock | 1.3375 | 1.3393 | 1.3371 | 1.338 | 896000.0 |
| 2005-01-31 09:10:00 | AAPL | Stock | 1.338 | 1.3382 | 1.3375 | 1.3379 | 244552.0 |
| 2005-01-31 09:15:00 | AAPL | Stock | 1.3375 | 1.3382 | 1.3375 | 1.3382 | 169120.0 |
| 2005-01-31 09:20:00 | AAPL | Stock | 1.3377 | 1.3377 | 1.3371 | 1.3371 | 165760.0 |
| 2005-01-31 09:25:00 | AAPL | Stock | 1.3214 | 1.3386 | 1.3214 | 1.332 | 4783016.0 |
| 2005-01-31 09:30:00 | AAPL | Stock | 1.3318 | 1.3393 | 1.3305 | 1.3384 | 57596952.0 |
| 2005-01-31 09:35:00 | AAPL | Stock | 1.3384 | 1.3393 | 1.3355 | 1.3391 | 34890072.0 |
| 2005-01-31 09:40:00 | AAPL | Stock | 1.3391 | 1.3393 | 1.3343 | 1.3361 | 32965240.0 |
| 2005-01-31 09:45:00 | AAPL | Stock | 1.3361 | 1.3463 | 1.3346 | 1.3446 | 54833408.0 |
| 2005-01-31 09:50:00 | AAPL | Stock | 1.3448 | 1.348 | 1.3389 | 1.3448 | 47695032.0 |
| 2005-01-31 09:55:00 | AAPL | Stock | 1.345 | 1.3463 | 1.3413 | 1.3445 | 30044840.0 |
| 2005-01-31 10:00:00 | AAPL | Stock | 1.3445 | 1.3471 | 1.3423 | 1.3457 | 23060128.0 |
| 2005-01-31 10:05:00 | AAPL | Stock | 1.3457 | 1.352 | 1.343 | 1.3516 | 38574592.0 |
| 2005-01-31 10:10:00 | AAPL | Stock | 1.3518 | 1.3532 | 1.345 | 1.3514 | 32822440.0 |
| 2005-01-31 10:15:00 | AAPL | Stock | 1.3514 | 1.3523 | 1.3466 | 1.3475 | 23602376.0 |
| 2005-01-31 10:20:00 | AAPL | Stock | 1.3477 | 1.3504 | 1.347 | 1.3493 | 24919496.0 |
| 2005-01-31 10:25:00 | AAPL | Stock | 1.3493 | 1.3543 | 1.3475 | 1.353 | 19248992.0 |
| 2005-01-31 10:30:00 | AAPL | Stock | 1.353 | 1.3545 | 1.3509 | 1.3532 | 23025632.0 |
| 2005-01-31 10:35:00 | AAPL | Stock | 1.3533 | 1.3564 | 1.3521 | 1.3557 | 24214736.0 |
| 2005-01-31 10:40:00 | AAPL | Stock | 1.3557 | 1.358 | 1.3545 | 1.3554 | 25837056.0 |
| 2005-01-31 10:45:00 | AAPL | Stock | 1.3554 | 1.3566 | 1.353 | 1.3557 | 15432816.0 |
| 2005-01-31 10:50:00 | AAPL | Stock | 1.3557 | 1.3568 | 1.353 | 1.3568 | 22531880.0 |
| 2005-01-31 10:55:00 | AAPL | Stock | 1.3568 | 1.3598 | 1.3552 | 1.3571 | 34901384.0 |
| 2005-01-31 11:00:00 | AAPL | Stock | 1.3571 | 1.3621 | 1.3563 | 1.3598 | 27150648.0 |
| 2005-01-31 11:05:00 | AAPL | Stock | 1.3604 | 1.3625 | 1.3582 | 1.3614 | 20063120.0 |
| 2005-01-31 11:10:00 | AAPL | Stock | 1.3614 | 1.3632 | 1.3598 | 1.3618 | 19189576.0 |
| 2005-01-31 11:15:00 | AAPL | Stock | 1.3618 | 1.3661 | 1.3618 | 1.3654 | 24331888.0 |
| 2005-01-31 11:20:00 | AAPL | Stock | 1.3655 | 1.3738 | 1.3652 | 1.3729 | 48119680.0 |
| 2005-01-31 11:25:00 | AAPL | Stock | 1.3727 | 1.3741 | 1.3702 | 1.3716 | 33907552.0 |
| 2005-01-31 11:30:00 | AAPL | Stock | 1.3716 | 1.3795 | 1.3707 | 1.3775 | 35016408.0 |
| 2005-01-31 11:35:00 | AAPL | Stock | 1.3773 | 1.3804 | 1.375 | 1.3784 | 35393960.0 |
| 2005-01-31 11:40:00 | AAPL | Stock | 1.378 | 1.3832 | 1.3766 | 1.3804 | 36304632.0 |
| 2005-01-31 11:45:00 | AAPL | Stock | 1.3804 | 1.3848 | 1.3804 | 1.382 | 32185160.0 |
| 2005-01-31 11:50:00 | AAPL | Stock | 1.3818 | 1.382 | 1.3754 | 1.3784 | 31431288.0 |
| 2005-01-31 11:55:00 | AAPL | Stock | 1.378 | 1.3784 | 1.3729 | 1.3754 | 24492720.0 |
| 2005-01-31 12:00:00 | AAPL | Stock | 1.3754 | 1.3757 | 1.3725 | 1.3745 | 12450088.0 |
| 2005-01-31 12:05:00 | AAPL | Stock | 1.3745 | 1.3802 | 1.3741 | 1.3786 | 17242960.0 |
> showing 50 of 194,914 rows — these rows as CSV