PREVIEW / stock_5min / 2011-11-04
file: by_date/stock_5min/2011/2011-11-04.parquet size: 4.7 MB rows: 313,539 symbols: 3,488
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-11-04 04:25:00 | AAPL | Stock | 14.3571 | 14.3571 | 14.3571 | 14.3571 | 5600.0 |
| 2011-11-04 05:10:00 | AAPL | Stock | 14.3571 | 14.3571 | 14.3571 | 14.3571 | 19600.0 |
| 2011-11-04 05:35:00 | AAPL | Stock | 14.3929 | 14.3929 | 14.3929 | 14.3929 | 2800.0 |
| 2011-11-04 06:15:00 | AAPL | Stock | 14.4068 | 14.4068 | 14.4068 | 14.4068 | 2800.0 |
| 2011-11-04 07:00:00 | AAPL | Stock | 14.3929 | 14.3929 | 14.3832 | 14.3832 | 11200.0 |
| 2011-11-04 07:05:00 | AAPL | Stock | 14.385 | 14.385 | 14.385 | 14.385 | 5600.0 |
| 2011-11-04 07:15:00 | AAPL | Stock | 14.3907 | 14.3907 | 14.3907 | 14.3907 | 2800.0 |
| 2011-11-04 07:20:00 | AAPL | Stock | 14.39 | 14.3932 | 14.39 | 14.3932 | 36400.0 |
| 2011-11-04 07:30:00 | AAPL | Stock | 14.3939 | 14.4007 | 14.3929 | 14.4007 | 30800.0 |
| 2011-11-04 07:35:00 | AAPL | Stock | 14.4018 | 14.4036 | 14.4018 | 14.4036 | 9716.0 |
| 2011-11-04 07:40:00 | AAPL | Stock | 14.4011 | 14.4082 | 14.3989 | 14.4036 | 55328.0 |
| 2011-11-04 07:45:00 | AAPL | Stock | 14.4082 | 14.4118 | 14.4082 | 14.4118 | 8708.0 |
| 2011-11-04 07:50:00 | AAPL | Stock | 14.4168 | 14.4175 | 14.4143 | 14.4143 | 16800.0 |
| 2011-11-04 07:55:00 | AAPL | Stock | 14.3604 | 14.4111 | 14.3571 | 14.3571 | 168504.0 |
| 2011-11-04 08:00:00 | AAPL | Stock | 14.3696 | 14.3832 | 14.3214 | 14.3214 | 261520.0 |
| 2011-11-04 08:05:00 | AAPL | Stock | 14.3525 | 14.3557 | 14.3321 | 14.35 | 44800.0 |
| 2011-11-04 08:10:00 | AAPL | Stock | 14.3554 | 14.3607 | 14.3482 | 14.3571 | 65772.0 |
| 2011-11-04 08:15:00 | AAPL | Stock | 14.3604 | 14.3625 | 14.3482 | 14.3482 | 117152.0 |
| 2011-11-04 08:20:00 | AAPL | Stock | 14.3464 | 14.3554 | 14.3361 | 14.3532 | 60900.0 |
| 2011-11-04 08:25:00 | AAPL | Stock | 14.3439 | 14.3557 | 14.3375 | 14.3421 | 110320.0 |
| 2011-11-04 08:30:00 | AAPL | Stock | 14.3421 | 14.4057 | 14.2857 | 14.3929 | 1465744.0 |
| 2011-11-04 08:35:00 | AAPL | Stock | 14.3943 | 14.405 | 14.3486 | 14.3611 | 504812.0 |
| 2011-11-04 08:40:00 | AAPL | Stock | 14.3611 | 14.375 | 14.35 | 14.3707 | 136248.0 |
| 2011-11-04 08:45:00 | AAPL | Stock | 14.3704 | 14.3704 | 14.3536 | 14.3661 | 120036.0 |
| 2011-11-04 08:50:00 | AAPL | Stock | 14.3636 | 14.3711 | 14.3629 | 14.3629 | 28000.0 |
| 2011-11-04 08:55:00 | AAPL | Stock | 14.3646 | 14.3661 | 14.345 | 14.3554 | 73976.0 |
| 2011-11-04 09:00:00 | AAPL | Stock | 14.3461 | 14.3571 | 14.345 | 14.3571 | 69244.0 |
| 2011-11-04 09:05:00 | AAPL | Stock | 14.3571 | 14.3639 | 14.3246 | 14.3382 | 343672.0 |
| 2011-11-04 09:10:00 | AAPL | Stock | 14.3461 | 14.365 | 14.3357 | 14.3564 | 267036.0 |
| 2011-11-04 09:15:00 | AAPL | Stock | 14.3571 | 14.3668 | 14.3571 | 14.3657 | 81200.0 |
| 2011-11-04 09:20:00 | AAPL | Stock | 14.3671 | 14.3704 | 14.3571 | 14.3571 | 76188.0 |
| 2011-11-04 09:25:00 | AAPL | Stock | 14.3579 | 14.37 | 14.3536 | 14.3629 | 249312.0 |
| 2011-11-04 09:30:00 | AAPL | Stock | 14.3586 | 14.4086 | 14.3393 | 14.3611 | 15051568.0 |
| 2011-11-04 09:35:00 | AAPL | Stock | 14.3607 | 14.3832 | 14.3461 | 14.3493 | 7838992.0 |
| 2011-11-04 09:40:00 | AAPL | Stock | 14.3514 | 14.3929 | 14.3429 | 14.3789 | 9448824.0 |
| 2011-11-04 09:45:00 | AAPL | Stock | 14.3836 | 14.3911 | 14.3682 | 14.3714 | 6622952.0 |
| 2011-11-04 09:50:00 | AAPL | Stock | 14.3743 | 14.3836 | 14.3446 | 14.35 | 7704984.0 |
| 2011-11-04 09:55:00 | AAPL | Stock | 14.3507 | 14.3582 | 14.3182 | 14.3329 | 7449456.0 |
| 2011-11-04 10:00:00 | AAPL | Stock | 14.3286 | 14.3536 | 14.3229 | 14.3411 | 5087264.0 |
| 2011-11-04 10:05:00 | AAPL | Stock | 14.3413 | 14.3432 | 14.3218 | 14.3255 | 3522540.0 |
| 2011-11-04 10:10:00 | AAPL | Stock | 14.3248 | 14.3292 | 14.2996 | 14.3068 | 6670496.0 |
| 2011-11-04 10:15:00 | AAPL | Stock | 14.3054 | 14.3143 | 14.295 | 14.3086 | 5315772.0 |
| 2011-11-04 10:20:00 | AAPL | Stock | 14.3079 | 14.3079 | 14.2857 | 14.3036 | 5264980.0 |
| 2011-11-04 10:25:00 | AAPL | Stock | 14.3004 | 14.3064 | 14.2932 | 14.2964 | 4076408.0 |
| 2011-11-04 10:30:00 | AAPL | Stock | 14.295 | 14.2957 | 14.2857 | 14.2914 | 6148240.0 |
| 2011-11-04 10:35:00 | AAPL | Stock | 14.2914 | 14.3021 | 14.2857 | 14.2971 | 3610012.0 |
| 2011-11-04 10:40:00 | AAPL | Stock | 14.2971 | 14.3125 | 14.2904 | 14.3021 | 3926412.0 |
| 2011-11-04 10:45:00 | AAPL | Stock | 14.3043 | 14.3136 | 14.2979 | 14.3107 | 3073168.0 |
| 2011-11-04 10:50:00 | AAPL | Stock | 14.31 | 14.3111 | 14.2886 | 14.2982 | 3012660.0 |
| 2011-11-04 10:55:00 | AAPL | Stock | 14.2979 | 14.3018 | 14.2857 | 14.2957 | 4323452.0 |
> showing 50 of 313,539 rows — these rows as CSV