PREVIEW / stock_5min / 2011-02-25
file: by_date/stock_5min/2011/2011-02-25.parquet size: 4.9 MB rows: 339,046 symbols: 3,538
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-02-25 04:20:00 | AAPL | Stock | 12.3196 | 12.3196 | 12.3196 | 12.3196 | 2800.0 |
| 2011-02-25 04:35:00 | AAPL | Stock | 12.3386 | 12.3386 | 12.3386 | 12.3386 | 2800.0 |
| 2011-02-25 04:45:00 | AAPL | Stock | 12.3393 | 12.3525 | 12.3393 | 12.3525 | 5600.0 |
| 2011-02-25 05:05:00 | AAPL | Stock | 12.3429 | 12.3429 | 12.3429 | 12.3429 | 19516.0 |
| 2011-02-25 05:10:00 | AAPL | Stock | 12.3429 | 12.3429 | 12.3429 | 12.3429 | 2800.0 |
| 2011-02-25 05:20:00 | AAPL | Stock | 12.3536 | 12.3536 | 12.3536 | 12.3536 | 19600.0 |
| 2011-02-25 05:40:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3393 | 12.3393 | 13440.0 |
| 2011-02-25 05:50:00 | AAPL | Stock | 12.3479 | 12.3479 | 12.3479 | 12.3479 | 2800.0 |
| 2011-02-25 06:00:00 | AAPL | Stock | 12.3564 | 12.3564 | 12.3564 | 12.3564 | 2800.0 |
| 2011-02-25 06:15:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3393 | 12.3393 | 16800.0 |
| 2011-02-25 06:20:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3393 | 12.3393 | 2800.0 |
| 2011-02-25 06:25:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3393 | 12.3393 | 5600.0 |
| 2011-02-25 06:30:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3393 | 12.3393 | 26796.0 |
| 2011-02-25 06:40:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3393 | 12.3393 | 7840.0 |
| 2011-02-25 06:45:00 | AAPL | Stock | 12.3529 | 12.3529 | 12.3529 | 12.3529 | 2800.0 |
| 2011-02-25 06:55:00 | AAPL | Stock | 12.3532 | 12.3568 | 12.3532 | 12.3568 | 27720.0 |
| 2011-02-25 07:00:00 | AAPL | Stock | 12.35 | 12.3536 | 12.3393 | 12.3393 | 27244.0 |
| 2011-02-25 07:05:00 | AAPL | Stock | 12.3429 | 12.35 | 12.3393 | 12.3393 | 28476.0 |
| 2011-02-25 07:10:00 | AAPL | Stock | 12.3482 | 12.3554 | 12.3482 | 12.3554 | 7000.0 |
| 2011-02-25 07:15:00 | AAPL | Stock | 12.35 | 12.3518 | 12.35 | 12.3518 | 8400.0 |
| 2011-02-25 07:20:00 | AAPL | Stock | 12.3396 | 12.3464 | 12.3393 | 12.3393 | 39200.0 |
| 2011-02-25 07:25:00 | AAPL | Stock | 12.3393 | 12.3464 | 12.3393 | 12.3393 | 76692.0 |
| 2011-02-25 07:30:00 | AAPL | Stock | 12.3354 | 12.3393 | 12.3354 | 12.3393 | 35000.0 |
| 2011-02-25 07:35:00 | AAPL | Stock | 12.3375 | 12.3375 | 12.3257 | 12.3286 | 14000.0 |
| 2011-02-25 07:40:00 | AAPL | Stock | 12.3264 | 12.3264 | 12.3179 | 12.3179 | 219100.0 |
| 2011-02-25 07:45:00 | AAPL | Stock | 12.3179 | 12.3264 | 12.3136 | 12.3264 | 66640.0 |
| 2011-02-25 07:50:00 | AAPL | Stock | 12.3268 | 12.33 | 12.3214 | 12.33 | 11200.0 |
| 2011-02-25 07:55:00 | AAPL | Stock | 12.33 | 12.33 | 12.33 | 12.33 | 22820.0 |
| 2011-02-25 08:00:00 | AAPL | Stock | 12.3293 | 12.3368 | 12.3114 | 12.3139 | 216552.0 |
| 2011-02-25 08:05:00 | AAPL | Stock | 12.3143 | 12.3211 | 12.3114 | 12.3121 | 112000.0 |
| 2011-02-25 08:10:00 | AAPL | Stock | 12.3125 | 12.3196 | 12.3114 | 12.3125 | 126560.0 |
| 2011-02-25 08:15:00 | AAPL | Stock | 12.3132 | 12.3132 | 12.2996 | 12.3071 | 195440.0 |
| 2011-02-25 08:20:00 | AAPL | Stock | 12.3093 | 12.3196 | 12.3089 | 12.3196 | 105504.0 |
| 2011-02-25 08:25:00 | AAPL | Stock | 12.3196 | 12.3271 | 12.3171 | 12.3196 | 193956.0 |
| 2011-02-25 08:30:00 | AAPL | Stock | 12.3193 | 12.3207 | 12.3079 | 12.3189 | 163800.0 |
| 2011-02-25 08:35:00 | AAPL | Stock | 12.3179 | 12.3196 | 12.3125 | 12.3125 | 53900.0 |
| 2011-02-25 08:40:00 | AAPL | Stock | 12.3146 | 12.3179 | 12.3104 | 12.3179 | 33600.0 |
| 2011-02-25 08:45:00 | AAPL | Stock | 12.3196 | 12.3268 | 12.3179 | 12.3268 | 153888.0 |
| 2011-02-25 08:50:00 | AAPL | Stock | 12.3286 | 12.3286 | 12.2457 | 12.3179 | 142548.0 |
| 2011-02-25 08:55:00 | AAPL | Stock | 12.3175 | 12.325 | 12.3125 | 12.3232 | 125804.0 |
| 2011-02-25 09:00:00 | AAPL | Stock | 12.3168 | 12.3286 | 12.3161 | 12.3271 | 84560.0 |
| 2011-02-25 09:05:00 | AAPL | Stock | 12.3268 | 12.3279 | 12.3171 | 12.3236 | 117264.0 |
| 2011-02-25 09:10:00 | AAPL | Stock | 12.3257 | 12.3261 | 12.3171 | 12.3175 | 49000.0 |
| 2011-02-25 09:15:00 | AAPL | Stock | 12.3179 | 12.3232 | 12.3179 | 12.3232 | 93548.0 |
| 2011-02-25 09:20:00 | AAPL | Stock | 12.3243 | 12.3243 | 12.3193 | 12.3214 | 118300.0 |
| 2011-02-25 09:25:00 | AAPL | Stock | 12.32 | 12.3382 | 12.3175 | 12.3311 | 489272.0 |
| 2011-02-25 09:30:00 | AAPL | Stock | 12.33 | 12.3557 | 12.3175 | 12.35 | 20745032.0 |
| 2011-02-25 09:35:00 | AAPL | Stock | 12.3496 | 12.3696 | 12.3407 | 12.3407 | 13348916.0 |
| 2011-02-25 09:40:00 | AAPL | Stock | 12.3407 | 12.345 | 12.3143 | 12.3314 | 12459860.0 |
| 2011-02-25 09:45:00 | AAPL | Stock | 12.3321 | 12.3504 | 12.325 | 12.3388 | 7168112.0 |
> showing 50 of 339,046 rows — these rows as CSV