PREVIEW / stock_5min / 2006-08-29
file: by_date/stock_5min/2006/2006-08-29.parquet size: 3.1 MB rows: 226,992 symbols: 2,348
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 |
|---|---|---|---|---|---|---|---|
| 2006-08-29 07:25:00 | AAPL | Stock | 2.4036 | 2.4036 | 2.4036 | 2.4036 | 28000.0 |
| 2006-08-29 07:45:00 | AAPL | Stock | 2.3964 | 2.3964 | 2.3964 | 2.3964 | 14000.0 |
| 2006-08-29 08:00:00 | AAPL | Stock | 2.3979 | 2.4014 | 2.3979 | 2.4014 | 197400.0 |
| 2006-08-29 08:05:00 | AAPL | Stock | 2.4 | 2.4014 | 2.3982 | 2.3996 | 182000.0 |
| 2006-08-29 08:10:00 | AAPL | Stock | 2.3993 | 2.3993 | 2.3929 | 2.3932 | 231000.0 |
| 2006-08-29 08:15:00 | AAPL | Stock | 2.3946 | 2.3964 | 2.3946 | 2.3964 | 197400.0 |
| 2006-08-29 08:20:00 | AAPL | Stock | 2.3968 | 2.3968 | 2.3964 | 2.3964 | 42000.0 |
| 2006-08-29 08:30:00 | AAPL | Stock | 2.3946 | 2.3946 | 2.3911 | 2.3911 | 316456.0 |
| 2006-08-29 08:35:00 | AAPL | Stock | 2.3907 | 2.3929 | 2.3907 | 2.3907 | 61600.0 |
| 2006-08-29 08:40:00 | AAPL | Stock | 2.3911 | 2.3911 | 2.3907 | 2.3907 | 67900.0 |
| 2006-08-29 08:45:00 | AAPL | Stock | 2.3886 | 2.3893 | 2.3868 | 2.3893 | 128100.0 |
| 2006-08-29 08:50:00 | AAPL | Stock | 2.3886 | 2.3893 | 2.3886 | 2.3893 | 142800.0 |
| 2006-08-29 08:55:00 | AAPL | Stock | 2.3879 | 2.3882 | 2.3875 | 2.3882 | 69300.0 |
| 2006-08-29 09:00:00 | AAPL | Stock | 2.3886 | 2.3893 | 2.3882 | 2.3882 | 19600.0 |
| 2006-08-29 09:05:00 | AAPL | Stock | 2.3882 | 2.3886 | 2.3875 | 2.3875 | 144480.0 |
| 2006-08-29 09:10:00 | AAPL | Stock | 2.3882 | 2.3882 | 2.3871 | 2.3875 | 132440.0 |
| 2006-08-29 09:15:00 | AAPL | Stock | 2.3879 | 2.3946 | 2.3871 | 2.3946 | 207732.0 |
| 2006-08-29 09:20:00 | AAPL | Stock | 2.3964 | 2.3968 | 2.3929 | 2.3929 | 200312.0 |
| 2006-08-29 09:25:00 | AAPL | Stock | 2.3911 | 2.3971 | 2.39 | 2.3929 | 1650908.0 |
| 2006-08-29 09:30:00 | AAPL | Stock | 2.3925 | 2.4021 | 2.3839 | 2.3875 | 23870420.0 |
| 2006-08-29 09:35:00 | AAPL | Stock | 2.3864 | 2.3886 | 2.3607 | 2.3629 | 31331048.0 |
| 2006-08-29 09:40:00 | AAPL | Stock | 2.3629 | 2.375 | 2.3511 | 2.3575 | 40488336.0 |
| 2006-08-29 09:45:00 | AAPL | Stock | 2.3579 | 2.3671 | 2.3475 | 2.3532 | 27718040.0 |
| 2006-08-29 09:50:00 | AAPL | Stock | 2.3532 | 2.3625 | 2.3511 | 2.3614 | 16915024.0 |
| 2006-08-29 09:55:00 | AAPL | Stock | 2.3616 | 2.3686 | 2.36 | 2.3686 | 16637404.0 |
| 2006-08-29 10:00:00 | AAPL | Stock | 2.3682 | 2.3732 | 2.3571 | 2.3714 | 21721616.0 |
| 2006-08-29 10:05:00 | AAPL | Stock | 2.3718 | 2.3754 | 2.3664 | 2.3668 | 15712872.0 |
| 2006-08-29 10:10:00 | AAPL | Stock | 2.3668 | 2.3729 | 2.3664 | 2.3664 | 11807824.0 |
| 2006-08-29 10:15:00 | AAPL | Stock | 2.3664 | 2.3668 | 2.3529 | 2.3575 | 27459852.0 |
| 2006-08-29 10:20:00 | AAPL | Stock | 2.3575 | 2.3593 | 2.3454 | 2.3486 | 28113652.0 |
| 2006-08-29 10:25:00 | AAPL | Stock | 2.3486 | 2.3496 | 2.3421 | 2.3446 | 23358468.0 |
| 2006-08-29 10:30:00 | AAPL | Stock | 2.3447 | 2.3496 | 2.3421 | 2.3446 | 12097008.0 |
| 2006-08-29 10:35:00 | AAPL | Stock | 2.3439 | 2.3921 | 2.3393 | 2.3396 | 18272716.0 |
| 2006-08-29 10:40:00 | AAPL | Stock | 2.3393 | 2.3461 | 2.3393 | 2.3432 | 15230236.0 |
| 2006-08-29 10:45:00 | AAPL | Stock | 2.3425 | 2.3461 | 2.3404 | 2.3429 | 15255912.0 |
| 2006-08-29 10:50:00 | AAPL | Stock | 2.3429 | 2.3439 | 2.3375 | 2.3436 | 19995416.0 |
| 2006-08-29 10:55:00 | AAPL | Stock | 2.3436 | 2.3475 | 2.3421 | 2.3425 | 12086368.0 |
| 2006-08-29 11:00:00 | AAPL | Stock | 2.3425 | 2.345 | 2.3411 | 2.3418 | 9250556.0 |
| 2006-08-29 11:05:00 | AAPL | Stock | 2.3417 | 2.3436 | 2.3389 | 2.3404 | 9343012.0 |
| 2006-08-29 11:10:00 | AAPL | Stock | 2.3404 | 2.345 | 2.3382 | 2.3432 | 9305212.0 |
| 2006-08-29 11:15:00 | AAPL | Stock | 2.3432 | 2.3486 | 2.3429 | 2.3439 | 12464480.0 |
| 2006-08-29 11:20:00 | AAPL | Stock | 2.3439 | 2.345 | 2.3357 | 2.3364 | 12667088.0 |
| 2006-08-29 11:25:00 | AAPL | Stock | 2.3364 | 2.3421 | 2.3361 | 2.3382 | 10242736.0 |
| 2006-08-29 11:30:00 | AAPL | Stock | 2.3379 | 2.3411 | 2.3321 | 2.3325 | 14054068.0 |
| 2006-08-29 11:35:00 | AAPL | Stock | 2.3321 | 2.3361 | 2.3275 | 2.3318 | 9724540.0 |
| 2006-08-29 11:40:00 | AAPL | Stock | 2.3321 | 2.3339 | 2.3271 | 2.3284 | 10976980.0 |
| 2006-08-29 11:45:00 | AAPL | Stock | 2.3286 | 2.3293 | 2.3257 | 2.3275 | 11646320.0 |
| 2006-08-29 11:50:00 | AAPL | Stock | 2.3275 | 2.3339 | 2.3275 | 2.3339 | 7134624.0 |
| 2006-08-29 11:55:00 | AAPL | Stock | 2.3339 | 2.3343 | 2.3318 | 2.3321 | 4123000.0 |
| 2006-08-29 12:00:00 | AAPL | Stock | 2.3318 | 2.3321 | 2.3271 | 2.3293 | 7168252.0 |
> showing 50 of 226,992 rows — these rows as CSV