PREVIEW / stock_5min / 2011-05-12
file: by_date/stock_5min/2011/2011-05-12.parquet size: 4.9 MB rows: 332,058 symbols: 3,566
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-05-12 04:00:00 | AAPL | Stock | 12.3929 | 12.3929 | 12.3929 | 12.3929 | 5600.0 |
| 2011-05-12 04:45:00 | AAPL | Stock | 12.3293 | 12.3293 | 12.3293 | 12.3293 | 2800.0 |
| 2011-05-12 04:50:00 | AAPL | Stock | 12.3479 | 12.3479 | 12.3479 | 12.3479 | 2800.0 |
| 2011-05-12 05:25:00 | AAPL | Stock | 12.3457 | 12.3457 | 12.3457 | 12.3457 | 2800.0 |
| 2011-05-12 05:45:00 | AAPL | Stock | 12.33 | 12.33 | 12.3214 | 12.3214 | 5600.0 |
| 2011-05-12 06:00:00 | AAPL | Stock | 12.3307 | 12.3307 | 12.3307 | 12.3307 | 2800.0 |
| 2011-05-12 06:10:00 | AAPL | Stock | 12.3 | 12.3 | 12.3 | 12.3 | 2800.0 |
| 2011-05-12 06:15:00 | AAPL | Stock | 12.295 | 12.2954 | 12.295 | 12.2954 | 11200.0 |
| 2011-05-12 06:25:00 | AAPL | Stock | 12.3107 | 12.3107 | 12.3107 | 12.3107 | 8400.0 |
| 2011-05-12 06:45:00 | AAPL | Stock | 12.3046 | 12.3075 | 12.3046 | 12.3075 | 5600.0 |
| 2011-05-12 06:50:00 | AAPL | Stock | 12.3054 | 12.3107 | 12.3054 | 12.3107 | 24500.0 |
| 2011-05-12 07:00:00 | AAPL | Stock | 12.3214 | 12.3254 | 12.3214 | 12.3254 | 5600.0 |
| 2011-05-12 07:05:00 | AAPL | Stock | 12.325 | 12.325 | 12.325 | 12.325 | 2800.0 |
| 2011-05-12 07:10:00 | AAPL | Stock | 12.3275 | 12.3275 | 12.3143 | 12.3214 | 77700.0 |
| 2011-05-12 07:15:00 | AAPL | Stock | 12.3354 | 12.3354 | 12.3354 | 12.3354 | 5600.0 |
| 2011-05-12 07:20:00 | AAPL | Stock | 12.3286 | 12.3289 | 12.3268 | 12.3268 | 18200.0 |
| 2011-05-12 07:25:00 | AAPL | Stock | 12.3264 | 12.3307 | 12.3264 | 12.3307 | 14840.0 |
| 2011-05-12 07:30:00 | AAPL | Stock | 12.3275 | 12.3393 | 12.3275 | 12.3393 | 36876.0 |
| 2011-05-12 07:40:00 | AAPL | Stock | 12.3314 | 12.3314 | 12.315 | 12.315 | 64400.0 |
| 2011-05-12 07:45:00 | AAPL | Stock | 12.3214 | 12.3214 | 12.32 | 12.3214 | 56084.0 |
| 2011-05-12 07:50:00 | AAPL | Stock | 12.3214 | 12.3261 | 12.3175 | 12.3214 | 88200.0 |
| 2011-05-12 07:55:00 | AAPL | Stock | 12.3232 | 12.3336 | 12.3189 | 12.3336 | 37604.0 |
| 2011-05-12 08:00:00 | AAPL | Stock | 12.3321 | 12.34 | 12.3186 | 12.3186 | 439040.0 |
| 2011-05-12 08:05:00 | AAPL | Stock | 12.3207 | 12.3293 | 12.3196 | 12.3268 | 241276.0 |
| 2011-05-12 08:10:00 | AAPL | Stock | 12.3264 | 12.3382 | 12.3214 | 12.3218 | 259280.0 |
| 2011-05-12 08:15:00 | AAPL | Stock | 12.3218 | 12.3286 | 12.3214 | 12.3286 | 72800.0 |
| 2011-05-12 08:20:00 | AAPL | Stock | 12.3232 | 12.3357 | 12.3225 | 12.3357 | 120904.0 |
| 2011-05-12 08:25:00 | AAPL | Stock | 12.3236 | 12.3414 | 12.3236 | 12.3389 | 220500.0 |
| 2011-05-12 08:30:00 | AAPL | Stock | 12.3339 | 12.3389 | 12.3225 | 12.3389 | 225316.0 |
| 2011-05-12 08:35:00 | AAPL | Stock | 12.3389 | 12.3571 | 12.3389 | 12.3518 | 323176.0 |
| 2011-05-12 08:40:00 | AAPL | Stock | 12.3518 | 12.3614 | 12.3504 | 12.3557 | 383516.0 |
| 2011-05-12 08:45:00 | AAPL | Stock | 12.3525 | 12.3525 | 12.3464 | 12.3464 | 83636.0 |
| 2011-05-12 08:50:00 | AAPL | Stock | 12.3393 | 12.35 | 12.3393 | 12.35 | 75040.0 |
| 2011-05-12 08:55:00 | AAPL | Stock | 12.35 | 12.3554 | 12.3482 | 12.3504 | 94500.0 |
| 2011-05-12 09:00:00 | AAPL | Stock | 12.3479 | 12.35 | 12.3457 | 12.3464 | 117208.0 |
| 2011-05-12 09:05:00 | AAPL | Stock | 12.3486 | 12.3504 | 12.3471 | 12.3504 | 65100.0 |
| 2011-05-12 09:10:00 | AAPL | Stock | 12.3482 | 12.3596 | 12.3454 | 12.3564 | 148960.0 |
| 2011-05-12 09:15:00 | AAPL | Stock | 12.3571 | 12.3711 | 12.3571 | 12.3679 | 238560.0 |
| 2011-05-12 09:20:00 | AAPL | Stock | 12.3618 | 12.3632 | 12.3571 | 12.3571 | 106792.0 |
| 2011-05-12 09:25:00 | AAPL | Stock | 12.3575 | 12.3746 | 12.3529 | 12.3646 | 250376.0 |
| 2011-05-12 09:30:00 | AAPL | Stock | 12.3614 | 12.3732 | 12.2339 | 12.2904 | 26822880.0 |
| 2011-05-12 09:35:00 | AAPL | Stock | 12.2891 | 12.2911 | 12.2446 | 12.2814 | 14343560.0 |
| 2011-05-12 09:40:00 | AAPL | Stock | 12.2821 | 12.2857 | 12.2468 | 12.2582 | 11326980.0 |
| 2011-05-12 09:45:00 | AAPL | Stock | 12.2575 | 12.2671 | 12.24 | 12.2599 | 8191764.0 |
| 2011-05-12 09:50:00 | AAPL | Stock | 12.2586 | 12.3214 | 12.2575 | 12.2721 | 9833292.0 |
| 2011-05-12 09:55:00 | AAPL | Stock | 12.2739 | 12.2771 | 12.2561 | 12.2679 | 5307540.0 |
| 2011-05-12 10:00:00 | AAPL | Stock | 12.27 | 12.2775 | 12.2289 | 12.2425 | 8005060.0 |
| 2011-05-12 10:05:00 | AAPL | Stock | 12.2439 | 12.2843 | 12.2239 | 12.283 | 13625416.0 |
| 2011-05-12 10:10:00 | AAPL | Stock | 12.2832 | 12.3143 | 12.2768 | 12.3007 | 10196816.0 |
| 2011-05-12 10:15:00 | AAPL | Stock | 12.3029 | 12.3389 | 12.3004 | 12.32 | 7496776.0 |
> showing 50 of 332,058 rows — these rows as CSV