PREVIEW / stock_5min / 2009-10-26
file: by_date/stock_5min/2009/2009-10-26.parquet size: 4.8 MB rows: 324,638 symbols: 3,393
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-10-26 05:10:00 | AAPL | Stock | 7.3161 | 7.3161 | 7.3161 | 7.3161 | 2800.0 |
| 2009-10-26 05:20:00 | AAPL | Stock | 7.3125 | 7.3125 | 7.3125 | 7.3125 | 2800.0 |
| 2009-10-26 07:05:00 | AAPL | Stock | 7.3089 | 7.3089 | 7.3089 | 7.3089 | 2800.0 |
| 2009-10-26 07:25:00 | AAPL | Stock | 7.3054 | 7.3054 | 7.3054 | 7.3054 | 2800.0 |
| 2009-10-26 07:30:00 | AAPL | Stock | 7.31 | 7.31 | 7.31 | 7.31 | 2800.0 |
| 2009-10-26 08:00:00 | AAPL | Stock | 7.3 | 7.3036 | 7.2789 | 7.285 | 72436.0 |
| 2009-10-26 08:05:00 | AAPL | Stock | 7.2857 | 7.2857 | 7.2786 | 7.2836 | 63420.0 |
| 2009-10-26 08:10:00 | AAPL | Stock | 7.2832 | 7.2929 | 7.2814 | 7.2929 | 129472.0 |
| 2009-10-26 08:15:00 | AAPL | Stock | 7.2936 | 7.2946 | 7.2861 | 7.2861 | 88900.0 |
| 2009-10-26 08:20:00 | AAPL | Stock | 7.2943 | 7.2964 | 7.2918 | 7.2943 | 184520.0 |
| 2009-10-26 08:25:00 | AAPL | Stock | 7.2946 | 7.3036 | 7.2946 | 7.3021 | 50400.0 |
| 2009-10-26 08:30:00 | AAPL | Stock | 7.2968 | 7.2975 | 7.2811 | 7.2821 | 155260.0 |
| 2009-10-26 08:35:00 | AAPL | Stock | 7.2879 | 7.2879 | 7.2871 | 7.2875 | 14000.0 |
| 2009-10-26 08:40:00 | AAPL | Stock | 7.2929 | 7.2929 | 7.2921 | 7.2921 | 11284.0 |
| 2009-10-26 08:45:00 | AAPL | Stock | 7.2896 | 7.2982 | 7.2896 | 7.2896 | 99904.0 |
| 2009-10-26 08:50:00 | AAPL | Stock | 7.2896 | 7.2896 | 7.2893 | 7.2896 | 29120.0 |
| 2009-10-26 08:55:00 | AAPL | Stock | 7.2896 | 7.2896 | 7.2879 | 7.2879 | 34580.0 |
| 2009-10-26 09:00:00 | AAPL | Stock | 7.2857 | 7.2861 | 7.2857 | 7.2857 | 63280.0 |
| 2009-10-26 09:05:00 | AAPL | Stock | 7.2857 | 7.2929 | 7.2857 | 7.2889 | 96180.0 |
| 2009-10-26 09:10:00 | AAPL | Stock | 7.2889 | 7.2925 | 7.2857 | 7.2893 | 154028.0 |
| 2009-10-26 09:15:00 | AAPL | Stock | 7.29 | 7.29 | 7.29 | 7.29 | 4200.0 |
| 2009-10-26 09:20:00 | AAPL | Stock | 7.2936 | 7.2939 | 7.2782 | 7.2782 | 145628.0 |
| 2009-10-26 09:25:00 | AAPL | Stock | 7.2768 | 7.285 | 7.2646 | 7.2675 | 498428.0 |
| 2009-10-26 09:30:00 | AAPL | Stock | 7.2675 | 7.3461 | 7.1464 | 7.3372 | 21482272.0 |
| 2009-10-26 09:35:00 | AAPL | Stock | 7.3371 | 7.3561 | 7.3268 | 7.3518 | 16929640.0 |
| 2009-10-26 09:40:00 | AAPL | Stock | 7.3511 | 7.3632 | 7.3425 | 7.35 | 11529896.0 |
| 2009-10-26 09:45:00 | AAPL | Stock | 7.3489 | 7.3639 | 7.3429 | 7.3514 | 9372104.0 |
| 2009-10-26 09:50:00 | AAPL | Stock | 7.3514 | 7.3729 | 7.3475 | 7.3657 | 10471104.0 |
| 2009-10-26 09:55:00 | AAPL | Stock | 7.3661 | 7.375 | 7.3629 | 7.3675 | 9552620.0 |
| 2009-10-26 10:00:00 | AAPL | Stock | 7.3664 | 7.3821 | 7.3664 | 7.375 | 7533932.0 |
| 2009-10-26 10:05:00 | AAPL | Stock | 7.3761 | 7.3839 | 7.3675 | 7.3679 | 8447348.0 |
| 2009-10-26 10:10:00 | AAPL | Stock | 7.3679 | 7.3771 | 7.3596 | 7.3704 | 6296108.0 |
| 2009-10-26 10:15:00 | AAPL | Stock | 7.3704 | 7.3786 | 7.3661 | 7.3682 | 6668396.0 |
| 2009-10-26 10:20:00 | AAPL | Stock | 7.3696 | 7.37 | 7.3571 | 7.3625 | 5487384.0 |
| 2009-10-26 10:25:00 | AAPL | Stock | 7.3625 | 7.3679 | 7.3489 | 7.3496 | 4744208.0 |
| 2009-10-26 10:30:00 | AAPL | Stock | 7.3496 | 7.3607 | 7.345 | 7.3529 | 5481140.0 |
| 2009-10-26 10:35:00 | AAPL | Stock | 7.35 | 7.3557 | 7.3279 | 7.3314 | 8106784.0 |
| 2009-10-26 10:40:00 | AAPL | Stock | 7.3318 | 7.3411 | 7.3304 | 7.3375 | 6592712.0 |
| 2009-10-26 10:45:00 | AAPL | Stock | 7.3375 | 7.3446 | 7.3346 | 7.3399 | 4009768.0 |
| 2009-10-26 10:50:00 | AAPL | Stock | 7.3382 | 7.355 | 7.3332 | 7.3536 | 5922896.0 |
| 2009-10-26 10:55:00 | AAPL | Stock | 7.3521 | 7.3554 | 7.3368 | 7.3493 | 5252380.0 |
| 2009-10-26 11:00:00 | AAPL | Stock | 7.3486 | 7.35 | 7.3393 | 7.3471 | 4965016.0 |
| 2009-10-26 11:05:00 | AAPL | Stock | 7.3468 | 7.355 | 7.3457 | 7.3525 | 6214460.0 |
| 2009-10-26 11:10:00 | AAPL | Stock | 7.3525 | 7.3579 | 7.3329 | 7.3364 | 7518616.0 |
| 2009-10-26 11:15:00 | AAPL | Stock | 7.3357 | 7.3382 | 7.3218 | 7.3304 | 7406644.0 |
| 2009-10-26 11:20:00 | AAPL | Stock | 7.3296 | 7.3464 | 7.3296 | 7.3383 | 3673684.0 |
| 2009-10-26 11:25:00 | AAPL | Stock | 7.3389 | 7.3496 | 7.3346 | 7.3354 | 5472404.0 |
| 2009-10-26 11:30:00 | AAPL | Stock | 7.335 | 7.3354 | 7.3071 | 7.3104 | 16272256.0 |
| 2009-10-26 11:35:00 | AAPL | Stock | 7.3111 | 7.3186 | 7.2914 | 7.3068 | 9097956.0 |
| 2009-10-26 11:40:00 | AAPL | Stock | 7.3061 | 7.3157 | 7.2939 | 7.2939 | 6280904.0 |
> showing 50 of 324,638 rows — these rows as CSV