PREVIEW / stock_5min / 2013-03-04
file: by_date/stock_5min/2013/2013-03-04.parquet size: 5.0 MB rows: 333,937 symbols: 3,497
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-03-04 04:00:00 | AAPL | Stock | 15.3929 | 15.3929 | 15.2857 | 15.3179 | 37604.0 |
| 2013-03-04 04:05:00 | AAPL | Stock | 15.3214 | 15.3214 | 15.3214 | 15.3214 | 6160.0 |
| 2013-03-04 04:15:00 | AAPL | Stock | 15.3107 | 15.3214 | 15.3107 | 15.3214 | 28000.0 |
| 2013-03-04 04:20:00 | AAPL | Stock | 15.3214 | 15.3214 | 15.3214 | 15.3214 | 5040.0 |
| 2013-03-04 04:30:00 | AAPL | Stock | 15.3232 | 15.3232 | 15.3214 | 15.3214 | 10948.0 |
| 2013-03-04 04:45:00 | AAPL | Stock | 15.3393 | 15.3393 | 15.3393 | 15.3393 | 9800.0 |
| 2013-03-04 04:50:00 | AAPL | Stock | 15.3393 | 15.3393 | 15.3393 | 15.3393 | 4088.0 |
| 2013-03-04 05:05:00 | AAPL | Stock | 15.35 | 15.35 | 15.35 | 15.35 | 8400.0 |
| 2013-03-04 05:10:00 | AAPL | Stock | 15.3357 | 15.35 | 15.3357 | 15.35 | 5600.0 |
| 2013-03-04 05:15:00 | AAPL | Stock | 15.3507 | 15.3507 | 15.3507 | 15.3507 | 2800.0 |
| 2013-03-04 05:45:00 | AAPL | Stock | 15.3571 | 15.3571 | 15.3571 | 15.3571 | 2800.0 |
| 2013-03-04 06:15:00 | AAPL | Stock | 15.3518 | 15.3518 | 15.3357 | 15.3357 | 33796.0 |
| 2013-03-04 06:30:00 | AAPL | Stock | 15.3357 | 15.3357 | 15.3357 | 15.3357 | 5740.0 |
| 2013-03-04 06:35:00 | AAPL | Stock | 15.325 | 15.325 | 15.3214 | 15.3214 | 20328.0 |
| 2013-03-04 07:05:00 | AAPL | Stock | 15.3118 | 15.3118 | 15.3118 | 15.3118 | 11088.0 |
| 2013-03-04 07:10:00 | AAPL | Stock | 15.3125 | 15.3125 | 15.2857 | 15.2893 | 139636.0 |
| 2013-03-04 07:15:00 | AAPL | Stock | 15.2968 | 15.2968 | 15.2857 | 15.2893 | 152096.0 |
| 2013-03-04 07:20:00 | AAPL | Stock | 15.2964 | 15.3036 | 15.2857 | 15.3036 | 151256.0 |
| 2013-03-04 07:25:00 | AAPL | Stock | 15.3104 | 15.3214 | 15.3104 | 15.3214 | 22400.0 |
| 2013-03-04 07:30:00 | AAPL | Stock | 15.3161 | 15.3175 | 15.3107 | 15.3161 | 17360.0 |
| 2013-03-04 07:35:00 | AAPL | Stock | 15.3125 | 15.3214 | 15.3125 | 15.3175 | 42000.0 |
| 2013-03-04 07:40:00 | AAPL | Stock | 15.3179 | 15.3286 | 15.3179 | 15.3179 | 68488.0 |
| 2013-03-04 07:45:00 | AAPL | Stock | 15.3168 | 15.3168 | 15.3082 | 15.3125 | 78400.0 |
| 2013-03-04 07:50:00 | AAPL | Stock | 15.3193 | 15.3193 | 15.3193 | 15.3193 | 5600.0 |
| 2013-03-04 07:55:00 | AAPL | Stock | 15.3104 | 15.3357 | 15.3104 | 15.3286 | 79800.0 |
| 2013-03-04 08:00:00 | AAPL | Stock | 15.3393 | 15.3557 | 15.2857 | 15.3557 | 201880.0 |
| 2013-03-04 08:05:00 | AAPL | Stock | 15.3357 | 15.3536 | 15.3321 | 15.3357 | 112476.0 |
| 2013-03-04 08:10:00 | AAPL | Stock | 15.3293 | 15.3293 | 15.3179 | 15.3279 | 116144.0 |
| 2013-03-04 08:15:00 | AAPL | Stock | 15.3221 | 15.3464 | 15.3221 | 15.3464 | 80080.0 |
| 2013-03-04 08:20:00 | AAPL | Stock | 15.3464 | 15.3786 | 15.3411 | 15.3482 | 184828.0 |
| 2013-03-04 08:25:00 | AAPL | Stock | 15.3514 | 15.365 | 15.3357 | 15.365 | 261716.0 |
| 2013-03-04 08:30:00 | AAPL | Stock | 15.3675 | 15.3811 | 15.34 | 15.34 | 217616.0 |
| 2013-03-04 08:35:00 | AAPL | Stock | 15.3414 | 15.3429 | 15.3214 | 15.3243 | 255080.0 |
| 2013-03-04 08:40:00 | AAPL | Stock | 15.3236 | 15.3236 | 15.3021 | 15.3021 | 351260.0 |
| 2013-03-04 08:45:00 | AAPL | Stock | 15.3036 | 15.305 | 15.2875 | 15.2904 | 341516.0 |
| 2013-03-04 08:50:00 | AAPL | Stock | 15.2893 | 15.2982 | 15.2864 | 15.2864 | 404180.0 |
| 2013-03-04 08:55:00 | AAPL | Stock | 15.2864 | 15.2982 | 15.2857 | 15.2939 | 439768.0 |
| 2013-03-04 09:00:00 | AAPL | Stock | 15.2971 | 15.3121 | 15.2882 | 15.2986 | 253540.0 |
| 2013-03-04 09:05:00 | AAPL | Stock | 15.3025 | 15.3036 | 15.2914 | 15.2961 | 81480.0 |
| 2013-03-04 09:10:00 | AAPL | Stock | 15.3 | 15.3093 | 15.2957 | 15.3093 | 74228.0 |
| 2013-03-04 09:15:00 | AAPL | Stock | 15.3071 | 15.3161 | 15.3032 | 15.3161 | 283976.0 |
| 2013-03-04 09:20:00 | AAPL | Stock | 15.3125 | 15.3296 | 15.3125 | 15.3214 | 222180.0 |
| 2013-03-04 09:25:00 | AAPL | Stock | 15.3236 | 15.3239 | 15.2786 | 15.2786 | 972944.0 |
| 2013-03-04 09:30:00 | AAPL | Stock | 15.2786 | 15.2929 | 15.2279 | 15.2711 | 31301900.0 |
| 2013-03-04 09:35:00 | AAPL | Stock | 15.2711 | 15.2893 | 15.2075 | 15.225 | 16527280.0 |
| 2013-03-04 09:40:00 | AAPL | Stock | 15.225 | 15.2643 | 15.2071 | 15.2436 | 13312712.0 |
| 2013-03-04 09:45:00 | AAPL | Stock | 15.2404 | 15.2543 | 15.2071 | 15.2269 | 9244060.0 |
| 2013-03-04 09:50:00 | AAPL | Stock | 15.2232 | 15.2232 | 15.1939 | 15.2041 | 11034184.0 |
| 2013-03-04 09:55:00 | AAPL | Stock | 15.2036 | 15.2231 | 15.1893 | 15.2168 | 8562064.0 |
| 2013-03-04 10:00:00 | AAPL | Stock | 15.2161 | 15.2471 | 15.2143 | 15.22 | 7267596.0 |
> showing 50 of 333,937 rows — these rows as CSV