PREVIEW / stock_5min / 2009-01-05
file: by_date/stock_5min/2009/2009-01-05.parquet size: 4.6 MB rows: 316,621 symbols: 3,335
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 |
|---|---|---|---|---|---|---|---|
| 2009-01-05 07:25:00 | AAPL | Stock | 3.2486 | 3.2486 | 3.2486 | 3.2486 | 11200.0 |
| 2009-01-05 07:30:00 | AAPL | Stock | 3.2568 | 3.2568 | 3.2568 | 3.2568 | 28000.0 |
| 2009-01-05 07:35:00 | AAPL | Stock | 3.2568 | 3.2568 | 3.2261 | 3.2261 | 120540.0 |
| 2009-01-05 08:00:00 | AAPL | Stock | 3.2332 | 3.2411 | 3.2325 | 3.2354 | 81508.0 |
| 2009-01-05 08:05:00 | AAPL | Stock | 3.2325 | 3.2325 | 3.2286 | 3.2286 | 108752.0 |
| 2009-01-05 08:10:00 | AAPL | Stock | 3.2318 | 3.2318 | 3.225 | 3.23 | 99400.0 |
| 2009-01-05 08:15:00 | AAPL | Stock | 3.2264 | 3.2286 | 3.2232 | 3.2232 | 59500.0 |
| 2009-01-05 08:20:00 | AAPL | Stock | 3.2232 | 3.2232 | 3.2107 | 3.2214 | 243600.0 |
| 2009-01-05 08:25:00 | AAPL | Stock | 3.2214 | 3.2214 | 3.2164 | 3.2211 | 107240.0 |
| 2009-01-05 08:30:00 | AAPL | Stock | 3.2211 | 3.3357 | 3.2211 | 3.2525 | 10224480.0 |
| 2009-01-05 08:35:00 | AAPL | Stock | 3.2525 | 3.3071 | 3.2504 | 3.2936 | 4932844.0 |
| 2009-01-05 08:40:00 | AAPL | Stock | 3.295 | 3.3429 | 3.2904 | 3.3261 | 6182960.0 |
| 2009-01-05 08:45:00 | AAPL | Stock | 3.325 | 3.3411 | 3.3168 | 3.3371 | 3480764.0 |
| 2009-01-05 08:50:00 | AAPL | Stock | 3.3371 | 3.3536 | 3.3332 | 3.3429 | 3014452.0 |
| 2009-01-05 08:55:00 | AAPL | Stock | 3.3429 | 3.3554 | 3.3411 | 3.3471 | 1962100.0 |
| 2009-01-05 09:00:00 | AAPL | Stock | 3.3464 | 3.3607 | 3.3446 | 3.35 | 2783872.0 |
| 2009-01-05 09:05:00 | AAPL | Stock | 3.35 | 3.355 | 3.3393 | 3.3482 | 1814316.0 |
| 2009-01-05 09:10:00 | AAPL | Stock | 3.3496 | 3.3536 | 3.3436 | 3.3436 | 1174264.0 |
| 2009-01-05 09:15:00 | AAPL | Stock | 3.3432 | 3.3493 | 3.3257 | 3.3286 | 2566144.0 |
| 2009-01-05 09:20:00 | AAPL | Stock | 3.3282 | 3.3321 | 3.3239 | 3.3296 | 2251256.0 |
| 2009-01-05 09:25:00 | AAPL | Stock | 3.3289 | 3.335 | 3.3232 | 3.3279 | 2189516.0 |
| 2009-01-05 09:30:00 | AAPL | Stock | 3.3286 | 3.345 | 3.3111 | 3.3446 | 44324504.0 |
| 2009-01-05 09:35:00 | AAPL | Stock | 3.3446 | 3.3721 | 3.3436 | 3.3504 | 54026560.0 |
| 2009-01-05 09:40:00 | AAPL | Stock | 3.3507 | 3.3771 | 3.3482 | 3.3654 | 36631672.0 |
| 2009-01-05 09:45:00 | AAPL | Stock | 3.3654 | 3.3682 | 3.3521 | 3.3543 | 28810180.0 |
| 2009-01-05 09:50:00 | AAPL | Stock | 3.3543 | 3.3596 | 3.3421 | 3.3461 | 21572348.0 |
| 2009-01-05 09:55:00 | AAPL | Stock | 3.3454 | 3.3539 | 3.3336 | 3.3375 | 19909484.0 |
| 2009-01-05 10:00:00 | AAPL | Stock | 3.3375 | 3.3443 | 3.3236 | 3.335 | 23607500.0 |
| 2009-01-05 10:05:00 | AAPL | Stock | 3.3354 | 3.3404 | 3.3218 | 3.3383 | 16863308.0 |
| 2009-01-05 10:10:00 | AAPL | Stock | 3.337 | 3.3493 | 3.3339 | 3.3479 | 18714472.0 |
| 2009-01-05 10:15:00 | AAPL | Stock | 3.3486 | 3.3514 | 3.3379 | 3.34 | 13837180.0 |
| 2009-01-05 10:20:00 | AAPL | Stock | 3.34 | 3.3486 | 3.3321 | 3.3422 | 11795532.0 |
| 2009-01-05 10:25:00 | AAPL | Stock | 3.3429 | 3.3636 | 3.3404 | 3.3607 | 22000692.0 |
| 2009-01-05 10:30:00 | AAPL | Stock | 3.3611 | 3.3739 | 3.355 | 3.3729 | 16556260.0 |
| 2009-01-05 10:35:00 | AAPL | Stock | 3.3729 | 3.3818 | 3.365 | 3.38 | 18275852.0 |
| 2009-01-05 10:40:00 | AAPL | Stock | 3.3804 | 3.385 | 3.3743 | 3.3789 | 15886388.0 |
| 2009-01-05 10:45:00 | AAPL | Stock | 3.3789 | 3.3896 | 3.3775 | 3.3804 | 14300888.0 |
| 2009-01-05 10:50:00 | AAPL | Stock | 3.3805 | 3.3854 | 3.3771 | 3.3771 | 9935884.0 |
| 2009-01-05 10:55:00 | AAPL | Stock | 3.3781 | 3.3804 | 3.3736 | 3.3757 | 9178400.0 |
| 2009-01-05 11:00:00 | AAPL | Stock | 3.3754 | 3.3832 | 3.3729 | 3.3794 | 9364348.0 |
| 2009-01-05 11:05:00 | AAPL | Stock | 3.38 | 3.39 | 3.3779 | 3.3868 | 9673496.0 |
| 2009-01-05 11:10:00 | AAPL | Stock | 3.3871 | 3.3879 | 3.3807 | 3.3814 | 9204860.0 |
| 2009-01-05 11:15:00 | AAPL | Stock | 3.3814 | 3.3911 | 3.3814 | 3.3867 | 11648532.0 |
| 2009-01-05 11:20:00 | AAPL | Stock | 3.3861 | 3.3871 | 3.375 | 3.3757 | 9913624.0 |
| 2009-01-05 11:25:00 | AAPL | Stock | 3.3757 | 3.3757 | 3.3679 | 3.3736 | 11026652.0 |
| 2009-01-05 11:30:00 | AAPL | Stock | 3.3729 | 3.3736 | 3.3646 | 3.3725 | 8834168.0 |
| 2009-01-05 11:35:00 | AAPL | Stock | 3.3721 | 3.375 | 3.3679 | 3.375 | 5583760.0 |
| 2009-01-05 11:40:00 | AAPL | Stock | 3.375 | 3.3839 | 3.3732 | 3.3818 | 7283052.0 |
| 2009-01-05 11:45:00 | AAPL | Stock | 3.3811 | 3.3857 | 3.3793 | 3.38 | 4454604.0 |
| 2009-01-05 11:50:00 | AAPL | Stock | 3.3804 | 3.3818 | 3.3725 | 3.3757 | 5478340.0 |
> showing 50 of 316,621 rows — these rows as CSV