PREVIEW / stock_5min / 2013-01-31
file: by_date/stock_5min/2013/2013-01-31.parquet size: 5.0 MB rows: 332,363 symbols: 3,460
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 |
|---|---|---|---|---|---|---|---|
| 2013-01-31 06:00:00 | AAPL | Stock | 16.2571 | 16.2571 | 16.2571 | 16.2571 | 5600.0 |
| 2013-01-31 06:50:00 | AAPL | Stock | 16.2679 | 16.2679 | 16.2679 | 16.2679 | 21840.0 |
| 2013-01-31 06:55:00 | AAPL | Stock | 16.2836 | 16.2836 | 16.2836 | 16.2836 | 2800.0 |
| 2013-01-31 07:00:00 | AAPL | Stock | 16.2536 | 16.2543 | 16.25 | 16.25 | 33600.0 |
| 2013-01-31 07:10:00 | AAPL | Stock | 16.2511 | 16.2511 | 16.2454 | 16.2493 | 13720.0 |
| 2013-01-31 07:20:00 | AAPL | Stock | 16.2411 | 16.2411 | 16.2343 | 16.2343 | 25200.0 |
| 2013-01-31 07:25:00 | AAPL | Stock | 16.25 | 16.25 | 16.25 | 16.25 | 2800.0 |
| 2013-01-31 07:30:00 | AAPL | Stock | 16.2696 | 16.2696 | 16.2679 | 16.2679 | 50400.0 |
| 2013-01-31 07:35:00 | AAPL | Stock | 16.2839 | 16.2857 | 16.2839 | 16.2857 | 14000.0 |
| 2013-01-31 07:45:00 | AAPL | Stock | 16.26 | 16.26 | 16.2589 | 16.2589 | 11200.0 |
| 2013-01-31 07:55:00 | AAPL | Stock | 16.2793 | 16.2857 | 16.2793 | 16.2857 | 56000.0 |
| 2013-01-31 08:00:00 | AAPL | Stock | 16.2857 | 16.3118 | 16.2343 | 16.2893 | 200032.0 |
| 2013-01-31 08:05:00 | AAPL | Stock | 16.2768 | 16.2768 | 16.25 | 16.25 | 89964.0 |
| 2013-01-31 08:10:00 | AAPL | Stock | 16.2561 | 16.2661 | 16.2539 | 16.2661 | 16800.0 |
| 2013-01-31 08:15:00 | AAPL | Stock | 16.2761 | 16.2761 | 16.2761 | 16.2761 | 2800.0 |
| 2013-01-31 08:20:00 | AAPL | Stock | 16.2671 | 16.2768 | 16.265 | 16.265 | 57092.0 |
| 2013-01-31 08:25:00 | AAPL | Stock | 16.2714 | 16.2714 | 16.2654 | 16.2693 | 11200.0 |
| 2013-01-31 08:30:00 | AAPL | Stock | 16.2682 | 16.2779 | 16.2643 | 16.2679 | 68152.0 |
| 2013-01-31 08:35:00 | AAPL | Stock | 16.2664 | 16.2664 | 16.2611 | 16.2611 | 22400.0 |
| 2013-01-31 08:40:00 | AAPL | Stock | 16.2618 | 16.2621 | 16.25 | 16.2518 | 94360.0 |
| 2013-01-31 08:45:00 | AAPL | Stock | 16.2393 | 16.25 | 16.2389 | 16.25 | 104524.0 |
| 2013-01-31 08:50:00 | AAPL | Stock | 16.2664 | 16.2664 | 16.25 | 16.2575 | 40012.0 |
| 2013-01-31 08:55:00 | AAPL | Stock | 16.2604 | 16.2618 | 16.2554 | 16.2618 | 22400.0 |
| 2013-01-31 09:00:00 | AAPL | Stock | 16.2557 | 16.2979 | 16.2557 | 16.2968 | 147056.0 |
| 2013-01-31 09:05:00 | AAPL | Stock | 16.2971 | 16.3089 | 16.2857 | 16.3018 | 122920.0 |
| 2013-01-31 09:10:00 | AAPL | Stock | 16.3107 | 16.3379 | 16.3107 | 16.3379 | 312900.0 |
| 2013-01-31 09:15:00 | AAPL | Stock | 16.3379 | 16.3425 | 16.3225 | 16.3368 | 173068.0 |
| 2013-01-31 09:20:00 | AAPL | Stock | 16.3304 | 16.3375 | 16.3136 | 16.3136 | 225428.0 |
| 2013-01-31 09:25:00 | AAPL | Stock | 16.3146 | 16.3257 | 16.3057 | 16.3204 | 308336.0 |
| 2013-01-31 09:30:00 | AAPL | Stock | 16.3207 | 16.3614 | 16.2929 | 16.2955 | 13668368.0 |
| 2013-01-31 09:35:00 | AAPL | Stock | 16.2964 | 16.3229 | 16.255 | 16.3204 | 9012836.0 |
| 2013-01-31 09:40:00 | AAPL | Stock | 16.3203 | 16.3818 | 16.2979 | 16.3786 | 10305848.0 |
| 2013-01-31 09:45:00 | AAPL | Stock | 16.3804 | 16.4029 | 16.3699 | 16.3768 | 8788668.0 |
| 2013-01-31 09:50:00 | AAPL | Stock | 16.3736 | 16.3832 | 16.3443 | 16.3596 | 6946968.0 |
| 2013-01-31 09:55:00 | AAPL | Stock | 16.3604 | 16.3807 | 16.325 | 16.3529 | 6327720.0 |
| 2013-01-31 10:00:00 | AAPL | Stock | 16.3436 | 16.365 | 16.3293 | 16.3315 | 3218852.0 |
| 2013-01-31 10:05:00 | AAPL | Stock | 16.3307 | 16.3507 | 16.3146 | 16.3393 | 3925684.0 |
| 2013-01-31 10:10:00 | AAPL | Stock | 16.3393 | 16.3643 | 16.3339 | 16.3421 | 3175872.0 |
| 2013-01-31 10:15:00 | AAPL | Stock | 16.3393 | 16.3525 | 16.3064 | 16.3075 | 3076276.0 |
| 2013-01-31 10:20:00 | AAPL | Stock | 16.3079 | 16.3476 | 16.3057 | 16.3275 | 2937368.0 |
| 2013-01-31 10:25:00 | AAPL | Stock | 16.3285 | 16.3285 | 16.3086 | 16.3132 | 2632168.0 |
| 2013-01-31 10:30:00 | AAPL | Stock | 16.3118 | 16.3729 | 16.3068 | 16.3493 | 4360496.0 |
| 2013-01-31 10:35:00 | AAPL | Stock | 16.35 | 16.3607 | 16.3282 | 16.3318 | 2881648.0 |
| 2013-01-31 10:40:00 | AAPL | Stock | 16.3346 | 16.35 | 16.3304 | 16.3475 | 1743196.0 |
| 2013-01-31 10:45:00 | AAPL | Stock | 16.3407 | 16.3589 | 16.3346 | 16.3389 | 2922248.0 |
| 2013-01-31 10:50:00 | AAPL | Stock | 16.3425 | 16.355 | 16.3218 | 16.3425 | 3172708.0 |
| 2013-01-31 10:55:00 | AAPL | Stock | 16.3461 | 16.3461 | 16.3221 | 16.3261 | 1993488.0 |
| 2013-01-31 11:00:00 | AAPL | Stock | 16.3268 | 16.3439 | 16.3179 | 16.3257 | 2632448.0 |
| 2013-01-31 11:05:00 | AAPL | Stock | 16.3261 | 16.3411 | 16.3096 | 16.325 | 2208388.0 |
| 2013-01-31 11:10:00 | AAPL | Stock | 16.3232 | 16.3262 | 16.2857 | 16.2989 | 3135804.0 |
> showing 50 of 332,363 rows — these rows as CSV