PREVIEW / stock_5min / 2013-03-11
file: by_date/stock_5min/2013/2013-03-11.parquet size: 5.0 MB rows: 332,608 symbols: 3,469
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-11 05:55:00 | AAPL | Stock | 15.3589 | 15.3589 | 15.3589 | 15.3589 | 2800.0 |
| 2013-03-11 06:00:00 | AAPL | Stock | 15.3589 | 15.3589 | 15.3589 | 15.3589 | 8400.0 |
| 2013-03-11 06:15:00 | AAPL | Stock | 15.3393 | 15.3393 | 15.3393 | 15.3393 | 2800.0 |
| 2013-03-11 07:20:00 | AAPL | Stock | 15.3839 | 15.3839 | 15.3839 | 15.3839 | 5600.0 |
| 2013-03-11 07:30:00 | AAPL | Stock | 15.3618 | 15.3618 | 15.3571 | 15.3571 | 11200.0 |
| 2013-03-11 07:35:00 | AAPL | Stock | 15.3475 | 15.3475 | 15.3071 | 15.3214 | 61600.0 |
| 2013-03-11 07:40:00 | AAPL | Stock | 15.3214 | 15.3271 | 15.3036 | 15.3036 | 51016.0 |
| 2013-03-11 07:45:00 | AAPL | Stock | 15.3036 | 15.3036 | 15.25 | 15.2857 | 65604.0 |
| 2013-03-11 07:50:00 | AAPL | Stock | 15.2857 | 15.2882 | 15.285 | 15.2857 | 22988.0 |
| 2013-03-11 07:55:00 | AAPL | Stock | 15.3018 | 15.3214 | 15.3018 | 15.3214 | 46200.0 |
| 2013-03-11 08:00:00 | AAPL | Stock | 15.2786 | 15.3354 | 15.2786 | 15.3171 | 111412.0 |
| 2013-03-11 08:05:00 | AAPL | Stock | 15.3211 | 15.3214 | 15.2857 | 15.2857 | 221116.0 |
| 2013-03-11 08:10:00 | AAPL | Stock | 15.3036 | 15.3225 | 15.3036 | 15.3211 | 44912.0 |
| 2013-03-11 08:15:00 | AAPL | Stock | 15.3214 | 15.3304 | 15.3214 | 15.3214 | 25200.0 |
| 2013-03-11 08:20:00 | AAPL | Stock | 15.3157 | 15.3879 | 15.3143 | 15.3293 | 179676.0 |
| 2013-03-11 08:25:00 | AAPL | Stock | 15.3221 | 15.3318 | 15.3179 | 15.3314 | 45948.0 |
| 2013-03-11 08:30:00 | AAPL | Stock | 15.3232 | 15.3321 | 15.3214 | 15.3221 | 120204.0 |
| 2013-03-11 08:35:00 | AAPL | Stock | 15.3275 | 15.3361 | 15.3275 | 15.3361 | 193032.0 |
| 2013-03-11 08:40:00 | AAPL | Stock | 15.3332 | 15.3332 | 15.3304 | 15.3321 | 155260.0 |
| 2013-03-11 08:45:00 | AAPL | Stock | 15.3325 | 15.3325 | 15.3286 | 15.3286 | 106260.0 |
| 2013-03-11 08:50:00 | AAPL | Stock | 15.3286 | 15.3357 | 15.3286 | 15.3321 | 180040.0 |
| 2013-03-11 08:55:00 | AAPL | Stock | 15.3257 | 15.3361 | 15.3257 | 15.3361 | 77000.0 |
| 2013-03-11 09:00:00 | AAPL | Stock | 15.3361 | 15.3361 | 15.3143 | 15.3214 | 203280.0 |
| 2013-03-11 09:05:00 | AAPL | Stock | 15.3221 | 15.3361 | 15.3221 | 15.325 | 59920.0 |
| 2013-03-11 09:10:00 | AAPL | Stock | 15.3354 | 15.3361 | 15.3321 | 15.3361 | 21028.0 |
| 2013-03-11 09:15:00 | AAPL | Stock | 15.3311 | 15.3336 | 15.3143 | 15.3143 | 133728.0 |
| 2013-03-11 09:20:00 | AAPL | Stock | 15.3143 | 15.3214 | 15.3036 | 15.3179 | 96572.0 |
| 2013-03-11 09:25:00 | AAPL | Stock | 15.3214 | 15.3482 | 15.3114 | 15.3407 | 875700.0 |
| 2013-03-11 09:30:00 | AAPL | Stock | 15.3414 | 15.3482 | 15.2536 | 15.295 | 19021912.0 |
| 2013-03-11 09:35:00 | AAPL | Stock | 15.2932 | 15.3029 | 15.2393 | 15.2646 | 9278444.0 |
| 2013-03-11 09:40:00 | AAPL | Stock | 15.2679 | 15.2775 | 15.2264 | 15.2679 | 7545356.0 |
| 2013-03-11 09:45:00 | AAPL | Stock | 15.2675 | 15.305 | 15.2582 | 15.2697 | 5643596.0 |
| 2013-03-11 09:50:00 | AAPL | Stock | 15.2732 | 15.3 | 15.2625 | 15.2841 | 4746504.0 |
| 2013-03-11 09:55:00 | AAPL | Stock | 15.2854 | 15.2904 | 15.2432 | 15.2732 | 5585104.0 |
| 2013-03-11 10:00:00 | AAPL | Stock | 15.2689 | 15.2836 | 15.2446 | 15.2479 | 4519508.0 |
| 2013-03-11 10:05:00 | AAPL | Stock | 15.2486 | 15.255 | 15.2236 | 15.2482 | 7897764.0 |
| 2013-03-11 10:10:00 | AAPL | Stock | 15.2475 | 15.2493 | 15.2321 | 15.2411 | 4285540.0 |
| 2013-03-11 10:15:00 | AAPL | Stock | 15.24 | 15.2532 | 15.2346 | 15.2457 | 3848404.0 |
| 2013-03-11 10:20:00 | AAPL | Stock | 15.2471 | 15.2471 | 15.2271 | 15.2314 | 3225096.0 |
| 2013-03-11 10:25:00 | AAPL | Stock | 15.2334 | 15.2414 | 15.2151 | 15.2161 | 3914792.0 |
| 2013-03-11 10:30:00 | AAPL | Stock | 15.2182 | 15.2214 | 15.1982 | 15.2029 | 6642272.0 |
| 2013-03-11 10:35:00 | AAPL | Stock | 15.2029 | 15.2211 | 15.1971 | 15.2207 | 4472412.0 |
| 2013-03-11 10:40:00 | AAPL | Stock | 15.2212 | 15.2304 | 15.2043 | 15.215 | 4626692.0 |
| 2013-03-11 10:45:00 | AAPL | Stock | 15.2171 | 15.2296 | 15.2036 | 15.2081 | 3888612.0 |
| 2013-03-11 10:50:00 | AAPL | Stock | 15.2082 | 15.2179 | 15.2057 | 15.2107 | 2996224.0 |
| 2013-03-11 10:55:00 | AAPL | Stock | 15.2077 | 15.2104 | 15.1836 | 15.205 | 5201532.0 |
| 2013-03-11 11:00:00 | AAPL | Stock | 15.2055 | 15.225 | 15.1946 | 15.225 | 4159232.0 |
| 2013-03-11 11:05:00 | AAPL | Stock | 15.2221 | 15.2425 | 15.2179 | 15.2336 | 5546072.0 |
| 2013-03-11 11:10:00 | AAPL | Stock | 15.2339 | 15.2421 | 15.2293 | 15.2382 | 2590784.0 |
| 2013-03-11 11:15:00 | AAPL | Stock | 15.2393 | 15.2618 | 15.2389 | 15.2536 | 4587884.0 |
> showing 50 of 332,608 rows — these rows as CSV