PREVIEW / stock_5min / 2011-06-06
file: by_date/stock_5min/2011/2011-06-06.parquet size: 5.0 MB rows: 340,962 symbols: 3,562
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 |
|---|---|---|---|---|---|---|---|
| 2011-06-06 07:10:00 | AAPL | Stock | 12.2857 | 12.2857 | 12.2857 | 12.2857 | 2800.0 |
| 2011-06-06 07:15:00 | AAPL | Stock | 12.3 | 12.3 | 12.3 | 12.3 | 11200.0 |
| 2011-06-06 07:20:00 | AAPL | Stock | 12.2964 | 12.2982 | 12.2964 | 12.2982 | 28000.0 |
| 2011-06-06 07:25:00 | AAPL | Stock | 12.2982 | 12.3125 | 12.2982 | 12.3125 | 25200.0 |
| 2011-06-06 07:30:00 | AAPL | Stock | 12.3129 | 12.3286 | 12.3114 | 12.325 | 39760.0 |
| 2011-06-06 07:35:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.3211 | 12.3211 | 30800.0 |
| 2011-06-06 07:40:00 | AAPL | Stock | 12.3011 | 12.3011 | 12.3011 | 12.3011 | 2800.0 |
| 2011-06-06 07:45:00 | AAPL | Stock | 12.3179 | 12.3179 | 12.3114 | 12.3125 | 8400.0 |
| 2011-06-06 07:50:00 | AAPL | Stock | 12.3175 | 12.3175 | 12.3046 | 12.3046 | 8400.0 |
| 2011-06-06 07:55:00 | AAPL | Stock | 12.3125 | 12.3186 | 12.3071 | 12.3179 | 62160.0 |
| 2011-06-06 08:00:00 | AAPL | Stock | 12.3125 | 12.3214 | 12.2961 | 12.3143 | 419048.0 |
| 2011-06-06 08:05:00 | AAPL | Stock | 12.3214 | 12.3393 | 12.3054 | 12.3375 | 284704.0 |
| 2011-06-06 08:10:00 | AAPL | Stock | 12.3393 | 12.3475 | 12.3332 | 12.3389 | 115892.0 |
| 2011-06-06 08:15:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3254 | 12.3254 | 232848.0 |
| 2011-06-06 08:20:00 | AAPL | Stock | 12.3357 | 12.3393 | 12.3286 | 12.3357 | 188216.0 |
| 2011-06-06 08:25:00 | AAPL | Stock | 12.3332 | 12.3532 | 12.3332 | 12.3482 | 187460.0 |
| 2011-06-06 08:30:00 | AAPL | Stock | 12.3464 | 12.3546 | 12.3464 | 12.3464 | 182644.0 |
| 2011-06-06 08:35:00 | AAPL | Stock | 12.35 | 12.3711 | 12.3471 | 12.3711 | 432740.0 |
| 2011-06-06 08:40:00 | AAPL | Stock | 12.3698 | 12.3711 | 12.3629 | 12.3643 | 228592.0 |
| 2011-06-06 08:45:00 | AAPL | Stock | 12.3607 | 12.3625 | 12.3521 | 12.3571 | 231868.0 |
| 2011-06-06 08:50:00 | AAPL | Stock | 12.3571 | 12.3579 | 12.3536 | 12.3536 | 125048.0 |
| 2011-06-06 08:55:00 | AAPL | Stock | 12.3518 | 12.3536 | 12.3429 | 12.3429 | 109284.0 |
| 2011-06-06 09:00:00 | AAPL | Stock | 12.3532 | 12.3557 | 12.35 | 12.355 | 84000.0 |
| 2011-06-06 09:05:00 | AAPL | Stock | 12.3546 | 12.3546 | 12.3489 | 12.35 | 36400.0 |
| 2011-06-06 09:10:00 | AAPL | Stock | 12.3507 | 12.3543 | 12.3468 | 12.3468 | 14000.0 |
| 2011-06-06 09:15:00 | AAPL | Stock | 12.3468 | 12.3468 | 12.3468 | 12.3468 | 35840.0 |
| 2011-06-06 09:20:00 | AAPL | Stock | 12.3529 | 12.3536 | 12.3518 | 12.3532 | 62244.0 |
| 2011-06-06 09:25:00 | AAPL | Stock | 12.3518 | 12.3554 | 12.3393 | 12.3464 | 129164.0 |
| 2011-06-06 09:30:00 | AAPL | Stock | 12.3464 | 12.3778 | 12.3218 | 12.3464 | 15836996.0 |
| 2011-06-06 09:35:00 | AAPL | Stock | 12.3475 | 12.35 | 12.3096 | 12.3264 | 11012876.0 |
| 2011-06-06 09:40:00 | AAPL | Stock | 12.325 | 12.3671 | 12.325 | 12.3621 | 8373260.0 |
| 2011-06-06 09:45:00 | AAPL | Stock | 12.3596 | 12.36 | 12.3454 | 12.3568 | 5435668.0 |
| 2011-06-06 09:50:00 | AAPL | Stock | 12.3571 | 12.375 | 12.3409 | 12.3425 | 7846188.0 |
| 2011-06-06 09:55:00 | AAPL | Stock | 12.3421 | 12.3721 | 12.3357 | 12.3686 | 7072520.0 |
| 2011-06-06 10:00:00 | AAPL | Stock | 12.3689 | 12.3946 | 12.3643 | 12.3711 | 11748212.0 |
| 2011-06-06 10:05:00 | AAPL | Stock | 12.3714 | 12.3804 | 12.35 | 12.3507 | 6966764.0 |
| 2011-06-06 10:10:00 | AAPL | Stock | 12.3521 | 12.3679 | 12.3446 | 12.3593 | 4604796.0 |
| 2011-06-06 10:15:00 | AAPL | Stock | 12.36 | 12.3636 | 12.3157 | 12.3357 | 7858116.0 |
| 2011-06-06 10:20:00 | AAPL | Stock | 12.3357 | 12.3543 | 12.3279 | 12.3488 | 4642176.0 |
| 2011-06-06 10:25:00 | AAPL | Stock | 12.3474 | 12.3618 | 12.3446 | 12.3464 | 5354496.0 |
| 2011-06-06 10:30:00 | AAPL | Stock | 12.3464 | 12.3479 | 12.3004 | 12.3129 | 7286244.0 |
| 2011-06-06 10:35:00 | AAPL | Stock | 12.311 | 12.325 | 12.3054 | 12.31 | 3221904.0 |
| 2011-06-06 10:40:00 | AAPL | Stock | 12.31 | 12.3111 | 12.2679 | 12.2882 | 7755636.0 |
| 2011-06-06 10:45:00 | AAPL | Stock | 12.2882 | 12.2979 | 12.2807 | 12.2914 | 3738308.0 |
| 2011-06-06 10:50:00 | AAPL | Stock | 12.2911 | 12.3089 | 12.2879 | 12.2971 | 2435580.0 |
| 2011-06-06 10:55:00 | AAPL | Stock | 12.2957 | 12.3059 | 12.2807 | 12.3 | 2742376.0 |
| 2011-06-06 11:00:00 | AAPL | Stock | 12.2993 | 12.3182 | 12.2861 | 12.3182 | 2541616.0 |
| 2011-06-06 11:05:00 | AAPL | Stock | 12.3182 | 12.3307 | 12.3179 | 12.3264 | 3286360.0 |
| 2011-06-06 11:10:00 | AAPL | Stock | 12.3261 | 12.3375 | 12.3179 | 12.3207 | 2613800.0 |
| 2011-06-06 11:15:00 | AAPL | Stock | 12.3203 | 12.3214 | 12.3054 | 12.3071 | 1888936.0 |
> showing 50 of 340,962 rows — these rows as CSV