PREVIEW / stock_5min / 2008-08-13
file: by_date/stock_5min/2008/2008-08-13.parquet size: 4.4 MB rows: 315,881 symbols: 3,327
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-13 04:55:00 | AAPL | Stock | 6.2996 | 6.2996 | 6.2996 | 6.2996 | 2800.0 |
| 2008-08-13 06:05:00 | AAPL | Stock | 6.2804 | 6.2804 | 6.2804 | 6.2804 | 5936.0 |
| 2008-08-13 06:40:00 | AAPL | Stock | 6.2804 | 6.2804 | 6.2804 | 6.2804 | 11200.0 |
| 2008-08-13 06:45:00 | AAPL | Stock | 6.2804 | 6.2804 | 6.2804 | 6.2804 | 7000.0 |
| 2008-08-13 06:50:00 | AAPL | Stock | 6.2804 | 6.2804 | 6.2804 | 6.2804 | 2800.0 |
| 2008-08-13 07:00:00 | AAPL | Stock | 6.2979 | 6.3318 | 6.2979 | 6.3036 | 36400.0 |
| 2008-08-13 07:05:00 | AAPL | Stock | 6.3143 | 6.3143 | 6.3118 | 6.3118 | 11200.0 |
| 2008-08-13 07:25:00 | AAPL | Stock | 6.3043 | 6.3043 | 6.3043 | 6.3043 | 4200.0 |
| 2008-08-13 07:35:00 | AAPL | Stock | 6.3043 | 6.3214 | 6.2939 | 6.3214 | 28000.0 |
| 2008-08-13 07:40:00 | AAPL | Stock | 6.3214 | 6.3214 | 6.3214 | 6.3214 | 28000.0 |
| 2008-08-13 07:45:00 | AAPL | Stock | 6.3336 | 6.3382 | 6.3321 | 6.3321 | 60760.0 |
| 2008-08-13 07:50:00 | AAPL | Stock | 6.3357 | 6.3464 | 6.3357 | 6.3464 | 210000.0 |
| 2008-08-13 07:55:00 | AAPL | Stock | 6.3579 | 6.3786 | 6.3482 | 6.3482 | 434700.0 |
| 2008-08-13 08:00:00 | AAPL | Stock | 6.3536 | 6.3732 | 6.3286 | 6.3486 | 770644.0 |
| 2008-08-13 08:05:00 | AAPL | Stock | 6.3482 | 6.3679 | 6.345 | 6.3589 | 625352.0 |
| 2008-08-13 08:10:00 | AAPL | Stock | 6.3607 | 6.3607 | 6.3493 | 6.3496 | 172312.0 |
| 2008-08-13 08:15:00 | AAPL | Stock | 6.35 | 6.3561 | 6.3414 | 6.3532 | 171752.0 |
| 2008-08-13 08:20:00 | AAPL | Stock | 6.35 | 6.3518 | 6.3393 | 6.3496 | 305340.0 |
| 2008-08-13 08:25:00 | AAPL | Stock | 6.3457 | 6.3518 | 6.3454 | 6.3504 | 127680.0 |
| 2008-08-13 08:30:00 | AAPL | Stock | 6.3504 | 6.3643 | 6.3446 | 6.3446 | 295820.0 |
| 2008-08-13 08:35:00 | AAPL | Stock | 6.3446 | 6.3457 | 6.3439 | 6.3446 | 86156.0 |
| 2008-08-13 08:40:00 | AAPL | Stock | 6.3446 | 6.3496 | 6.3446 | 6.3446 | 130368.0 |
| 2008-08-13 08:45:00 | AAPL | Stock | 6.345 | 6.35 | 6.3357 | 6.3364 | 490560.0 |
| 2008-08-13 08:50:00 | AAPL | Stock | 6.3393 | 6.3421 | 6.3364 | 6.3393 | 125664.0 |
| 2008-08-13 08:55:00 | AAPL | Stock | 6.3393 | 6.3393 | 6.3304 | 6.3318 | 216384.0 |
| 2008-08-13 09:00:00 | AAPL | Stock | 6.3371 | 6.3371 | 6.3318 | 6.3321 | 176680.0 |
| 2008-08-13 09:05:00 | AAPL | Stock | 6.3321 | 6.3396 | 6.3321 | 6.3396 | 142072.0 |
| 2008-08-13 09:10:00 | AAPL | Stock | 6.3393 | 6.3446 | 6.3389 | 6.34 | 319480.0 |
| 2008-08-13 09:15:00 | AAPL | Stock | 6.3411 | 6.345 | 6.3411 | 6.3446 | 86800.0 |
| 2008-08-13 09:20:00 | AAPL | Stock | 6.3421 | 6.3507 | 6.3421 | 6.3507 | 285488.0 |
| 2008-08-13 09:25:00 | AAPL | Stock | 6.3514 | 6.3632 | 6.3507 | 6.3564 | 1118236.0 |
| 2008-08-13 09:30:00 | AAPL | Stock | 6.3539 | 6.4214 | 6.3536 | 6.3789 | 37253944.0 |
| 2008-08-13 09:35:00 | AAPL | Stock | 6.3787 | 6.3993 | 6.345 | 6.3836 | 28084392.0 |
| 2008-08-13 09:40:00 | AAPL | Stock | 6.3854 | 6.3861 | 6.3239 | 6.3675 | 25201764.0 |
| 2008-08-13 09:45:00 | AAPL | Stock | 6.3675 | 6.3911 | 6.3521 | 6.3896 | 16499588.0 |
| 2008-08-13 09:50:00 | AAPL | Stock | 6.3896 | 6.3986 | 6.3707 | 6.3889 | 15367604.0 |
| 2008-08-13 09:55:00 | AAPL | Stock | 6.388 | 6.3907 | 6.3707 | 6.3886 | 9998856.0 |
| 2008-08-13 10:00:00 | AAPL | Stock | 6.3882 | 6.4196 | 6.375 | 6.4193 | 21025396.0 |
| 2008-08-13 10:05:00 | AAPL | Stock | 6.4198 | 6.4268 | 6.4111 | 6.4189 | 15800260.0 |
| 2008-08-13 10:10:00 | AAPL | Stock | 6.4186 | 6.4196 | 6.4 | 6.4018 | 13173300.0 |
| 2008-08-13 10:15:00 | AAPL | Stock | 6.4025 | 6.4043 | 6.3804 | 6.3979 | 13405476.0 |
| 2008-08-13 10:20:00 | AAPL | Stock | 6.3979 | 6.4189 | 6.3967 | 6.4175 | 11781280.0 |
| 2008-08-13 10:25:00 | AAPL | Stock | 6.4178 | 6.4179 | 6.3704 | 6.3996 | 9761780.0 |
| 2008-08-13 10:30:00 | AAPL | Stock | 6.3996 | 6.3996 | 6.3789 | 6.38 | 12635084.0 |
| 2008-08-13 10:35:00 | AAPL | Stock | 6.3804 | 6.3929 | 6.3646 | 6.3782 | 14623896.0 |
| 2008-08-13 10:40:00 | AAPL | Stock | 6.3768 | 6.3825 | 6.3546 | 6.3575 | 13017760.0 |
| 2008-08-13 10:45:00 | AAPL | Stock | 6.3582 | 6.38 | 6.3571 | 6.3786 | 8727068.0 |
| 2008-08-13 10:50:00 | AAPL | Stock | 6.3782 | 6.3954 | 6.3689 | 6.3954 | 9282896.0 |
| 2008-08-13 10:55:00 | AAPL | Stock | 6.3936 | 6.4089 | 6.39 | 6.4025 | 9139116.0 |
| 2008-08-13 11:00:00 | AAPL | Stock | 6.4025 | 6.4032 | 6.3868 | 6.3925 | 5533556.0 |
> showing 50 of 315,881 rows — these rows as CSV