PREVIEW / stock_5min / 2011-01-13
file: by_date/stock_5min/2011/2011-01-13.parquet size: 4.8 MB rows: 329,655 symbols: 3,506
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-01-13 04:20:00 | AAPL | Stock | 12.3332 | 12.3332 | 12.3214 | 12.3218 | 8400.0 |
| 2011-01-13 04:35:00 | AAPL | Stock | 12.3336 | 12.3336 | 12.3336 | 12.3336 | 2800.0 |
| 2011-01-13 05:35:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3393 | 12.3393 | 2800.0 |
| 2011-01-13 05:45:00 | AAPL | Stock | 12.3571 | 12.375 | 12.3571 | 12.375 | 5600.0 |
| 2011-01-13 05:55:00 | AAPL | Stock | 12.35 | 12.35 | 12.35 | 12.35 | 8400.0 |
| 2011-01-13 06:05:00 | AAPL | Stock | 12.3704 | 12.3704 | 12.3704 | 12.3704 | 14000.0 |
| 2011-01-13 06:25:00 | AAPL | Stock | 12.3643 | 12.3657 | 12.3643 | 12.3643 | 30800.0 |
| 2011-01-13 06:30:00 | AAPL | Stock | 12.3607 | 12.3607 | 12.3607 | 12.3607 | 2800.0 |
| 2011-01-13 06:35:00 | AAPL | Stock | 12.3607 | 12.3607 | 12.3607 | 12.3607 | 8400.0 |
| 2011-01-13 06:40:00 | AAPL | Stock | 12.375 | 12.375 | 12.375 | 12.375 | 14000.0 |
| 2011-01-13 06:55:00 | AAPL | Stock | 12.375 | 12.375 | 12.375 | 12.375 | 30800.0 |
| 2011-01-13 07:00:00 | AAPL | Stock | 12.375 | 12.375 | 12.3571 | 12.3714 | 80780.0 |
| 2011-01-13 07:05:00 | AAPL | Stock | 12.3571 | 12.3682 | 12.3536 | 12.3536 | 55860.0 |
| 2011-01-13 07:10:00 | AAPL | Stock | 12.3564 | 12.3564 | 12.3396 | 12.34 | 63000.0 |
| 2011-01-13 07:15:00 | AAPL | Stock | 12.3261 | 12.335 | 12.3261 | 12.335 | 8400.0 |
| 2011-01-13 07:20:00 | AAPL | Stock | 12.3396 | 12.3479 | 12.3396 | 12.3479 | 56000.0 |
| 2011-01-13 07:25:00 | AAPL | Stock | 12.3464 | 12.3482 | 12.3443 | 12.3443 | 18200.0 |
| 2011-01-13 07:30:00 | AAPL | Stock | 12.3489 | 12.3489 | 12.335 | 12.335 | 31500.0 |
| 2011-01-13 07:40:00 | AAPL | Stock | 12.3393 | 12.3393 | 12.3393 | 12.3393 | 14000.0 |
| 2011-01-13 07:45:00 | AAPL | Stock | 12.3457 | 12.3475 | 12.3396 | 12.3471 | 53480.0 |
| 2011-01-13 07:50:00 | AAPL | Stock | 12.3468 | 12.3468 | 12.3446 | 12.3446 | 8400.0 |
| 2011-01-13 07:55:00 | AAPL | Stock | 12.3479 | 12.3511 | 12.3446 | 12.3446 | 69720.0 |
| 2011-01-13 08:00:00 | AAPL | Stock | 12.3446 | 12.3446 | 12.3257 | 12.3314 | 495712.0 |
| 2011-01-13 08:05:00 | AAPL | Stock | 12.3304 | 12.3357 | 12.3261 | 12.3261 | 298200.0 |
| 2011-01-13 08:10:00 | AAPL | Stock | 12.3264 | 12.3286 | 12.3214 | 12.3214 | 278040.0 |
| 2011-01-13 08:15:00 | AAPL | Stock | 12.3214 | 12.3357 | 12.3007 | 12.3357 | 221676.0 |
| 2011-01-13 08:20:00 | AAPL | Stock | 12.3286 | 12.3329 | 12.3257 | 12.3293 | 274708.0 |
| 2011-01-13 08:25:00 | AAPL | Stock | 12.3329 | 12.3339 | 12.3243 | 12.3243 | 192080.0 |
| 2011-01-13 08:30:00 | AAPL | Stock | 12.3243 | 12.3243 | 12.2893 | 12.3036 | 2358664.0 |
| 2011-01-13 08:35:00 | AAPL | Stock | 12.3096 | 12.3118 | 12.3007 | 12.3118 | 197932.0 |
| 2011-01-13 08:40:00 | AAPL | Stock | 12.3118 | 12.3157 | 12.3021 | 12.3136 | 87696.0 |
| 2011-01-13 08:45:00 | AAPL | Stock | 12.3129 | 12.3193 | 12.3075 | 12.3075 | 218624.0 |
| 2011-01-13 08:50:00 | AAPL | Stock | 12.3143 | 12.3146 | 12.3071 | 12.3107 | 70000.0 |
| 2011-01-13 08:55:00 | AAPL | Stock | 12.3079 | 12.3079 | 12.3011 | 12.3018 | 110880.0 |
| 2011-01-13 09:00:00 | AAPL | Stock | 12.3004 | 12.3089 | 12.3 | 12.3071 | 137704.0 |
| 2011-01-13 09:05:00 | AAPL | Stock | 12.3021 | 12.3125 | 12.3021 | 12.3107 | 182000.0 |
| 2011-01-13 09:10:00 | AAPL | Stock | 12.3143 | 12.3161 | 12.3132 | 12.3161 | 170688.0 |
| 2011-01-13 09:15:00 | AAPL | Stock | 12.3161 | 12.3214 | 12.315 | 12.3175 | 206052.0 |
| 2011-01-13 09:20:00 | AAPL | Stock | 12.3175 | 12.3179 | 12.3143 | 12.3143 | 159852.0 |
| 2011-01-13 09:25:00 | AAPL | Stock | 12.3143 | 12.3264 | 12.3107 | 12.3264 | 712768.0 |
| 2011-01-13 09:30:00 | AAPL | Stock | 12.3254 | 12.3325 | 12.3007 | 12.3075 | 12808796.0 |
| 2011-01-13 09:35:00 | AAPL | Stock | 12.3075 | 12.3139 | 12.3007 | 12.3029 | 5853372.0 |
| 2011-01-13 09:40:00 | AAPL | Stock | 12.3036 | 12.3107 | 12.2979 | 12.3022 | 5076848.0 |
| 2011-01-13 09:45:00 | AAPL | Stock | 12.3021 | 12.3089 | 12.2857 | 12.2968 | 10043376.0 |
| 2011-01-13 09:50:00 | AAPL | Stock | 12.2966 | 12.3004 | 12.2804 | 12.2882 | 8941548.0 |
| 2011-01-13 09:55:00 | AAPL | Stock | 12.2882 | 12.2971 | 12.2814 | 12.295 | 4853464.0 |
| 2011-01-13 10:00:00 | AAPL | Stock | 12.2957 | 12.3021 | 12.2825 | 12.2918 | 5018188.0 |
| 2011-01-13 10:05:00 | AAPL | Stock | 12.2929 | 12.3125 | 12.29 | 12.3075 | 5401732.0 |
| 2011-01-13 10:10:00 | AAPL | Stock | 12.309 | 12.3211 | 12.2954 | 12.3154 | 5952800.0 |
| 2011-01-13 10:15:00 | AAPL | Stock | 12.3153 | 12.3204 | 12.3125 | 12.3171 | 4478516.0 |
> showing 50 of 329,655 rows — these rows as CSV