PREVIEW / stock_5min / 2013-10-09
file: by_date/stock_5min/2013/2013-10-09.parquet size: 5.2 MB rows: 346,480 symbols: 3,539
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-10-09 04:00:00 | AAPL | Stock | 17.2857 | 17.2857 | 17.2536 | 17.2679 | 28000.0 |
| 2013-10-09 04:05:00 | AAPL | Stock | 17.2679 | 17.2679 | 17.2679 | 17.2679 | 5600.0 |
| 2013-10-09 04:40:00 | AAPL | Stock | 17.3036 | 17.3036 | 17.3036 | 17.3036 | 11200.0 |
| 2013-10-09 04:45:00 | AAPL | Stock | 17.2721 | 17.2721 | 17.2721 | 17.2721 | 2800.0 |
| 2013-10-09 05:00:00 | AAPL | Stock | 17.2857 | 17.2857 | 17.2857 | 17.2857 | 9912.0 |
| 2013-10-09 05:15:00 | AAPL | Stock | 17.2879 | 17.2879 | 17.2879 | 17.2879 | 2800.0 |
| 2013-10-09 05:20:00 | AAPL | Stock | 17.3 | 17.3 | 17.3 | 17.3 | 19600.0 |
| 2013-10-09 05:45:00 | AAPL | Stock | 17.33 | 17.3346 | 17.33 | 17.3346 | 5600.0 |
| 2013-10-09 06:00:00 | AAPL | Stock | 17.34 | 17.34 | 17.34 | 17.34 | 2800.0 |
| 2013-10-09 06:20:00 | AAPL | Stock | 17.34 | 17.34 | 17.34 | 17.34 | 10500.0 |
| 2013-10-09 06:40:00 | AAPL | Stock | 17.3475 | 17.3629 | 17.3475 | 17.3629 | 22400.0 |
| 2013-10-09 06:50:00 | AAPL | Stock | 17.3482 | 17.3482 | 17.3482 | 17.3482 | 8400.0 |
| 2013-10-09 06:55:00 | AAPL | Stock | 17.3393 | 17.3393 | 17.3393 | 17.3393 | 5600.0 |
| 2013-10-09 07:00:00 | AAPL | Stock | 17.3461 | 17.3543 | 17.34 | 17.34 | 14000.0 |
| 2013-10-09 07:05:00 | AAPL | Stock | 17.34 | 17.3418 | 17.34 | 17.3418 | 6440.0 |
| 2013-10-09 07:10:00 | AAPL | Stock | 17.3393 | 17.3393 | 17.3321 | 17.3321 | 5600.0 |
| 2013-10-09 07:15:00 | AAPL | Stock | 17.3286 | 17.3286 | 17.3214 | 17.3214 | 15540.0 |
| 2013-10-09 07:20:00 | AAPL | Stock | 17.3339 | 17.3357 | 17.3339 | 17.3357 | 9408.0 |
| 2013-10-09 07:25:00 | AAPL | Stock | 17.3325 | 17.3325 | 17.3121 | 17.3282 | 34412.0 |
| 2013-10-09 07:30:00 | AAPL | Stock | 17.3193 | 17.3193 | 17.3071 | 17.3071 | 22400.0 |
| 2013-10-09 07:35:00 | AAPL | Stock | 17.3129 | 17.3132 | 17.3129 | 17.3132 | 6552.0 |
| 2013-10-09 07:45:00 | AAPL | Stock | 17.3182 | 17.3371 | 17.3182 | 17.3361 | 86800.0 |
| 2013-10-09 07:50:00 | AAPL | Stock | 17.3357 | 17.3393 | 17.3339 | 17.3339 | 35280.0 |
| 2013-10-09 07:55:00 | AAPL | Stock | 17.3146 | 17.3304 | 17.3146 | 17.3157 | 44296.0 |
| 2013-10-09 08:00:00 | AAPL | Stock | 17.3114 | 17.3571 | 17.1786 | 17.3121 | 328916.0 |
| 2013-10-09 08:05:00 | AAPL | Stock | 17.3107 | 17.3179 | 17.3011 | 17.3029 | 168476.0 |
| 2013-10-09 08:10:00 | AAPL | Stock | 17.3029 | 17.3121 | 17.2861 | 17.3114 | 165312.0 |
| 2013-10-09 08:15:00 | AAPL | Stock | 17.3125 | 17.3293 | 17.3125 | 17.3214 | 137732.0 |
| 2013-10-09 08:20:00 | AAPL | Stock | 17.3304 | 17.3357 | 17.3214 | 17.3286 | 149800.0 |
| 2013-10-09 08:25:00 | AAPL | Stock | 17.3257 | 17.3429 | 17.3232 | 17.3393 | 231280.0 |
| 2013-10-09 08:30:00 | AAPL | Stock | 17.3386 | 17.3396 | 17.3289 | 17.3321 | 67200.0 |
| 2013-10-09 08:35:00 | AAPL | Stock | 17.3375 | 17.3421 | 17.325 | 17.3275 | 105840.0 |
| 2013-10-09 08:40:00 | AAPL | Stock | 17.3321 | 17.3321 | 17.3236 | 17.3236 | 30800.0 |
| 2013-10-09 08:45:00 | AAPL | Stock | 17.3229 | 17.3229 | 17.2914 | 17.3136 | 217364.0 |
| 2013-10-09 08:50:00 | AAPL | Stock | 17.3071 | 17.325 | 17.2964 | 17.32 | 175588.0 |
| 2013-10-09 08:55:00 | AAPL | Stock | 17.2968 | 17.3046 | 17.2968 | 17.3046 | 11200.0 |
| 2013-10-09 09:00:00 | AAPL | Stock | 17.2982 | 17.3171 | 17.2971 | 17.3171 | 36400.0 |
| 2013-10-09 09:05:00 | AAPL | Stock | 17.3143 | 17.3143 | 17.2989 | 17.3068 | 104916.0 |
| 2013-10-09 09:10:00 | AAPL | Stock | 17.3011 | 17.3075 | 17.3011 | 17.3075 | 5600.0 |
| 2013-10-09 09:15:00 | AAPL | Stock | 17.3107 | 17.3189 | 17.3046 | 17.3107 | 52444.0 |
| 2013-10-09 09:20:00 | AAPL | Stock | 17.3039 | 17.3136 | 17.3036 | 17.3036 | 79100.0 |
| 2013-10-09 09:25:00 | AAPL | Stock | 17.3093 | 17.3107 | 17.3039 | 17.3039 | 36400.0 |
| 2013-10-09 09:30:00 | AAPL | Stock | 17.3086 | 17.3118 | 17.2182 | 17.2229 | 9813104.0 |
| 2013-10-09 09:35:00 | AAPL | Stock | 17.2229 | 17.2918 | 17.2182 | 17.2764 | 6222524.0 |
| 2013-10-09 09:40:00 | AAPL | Stock | 17.2764 | 17.2857 | 17.2281 | 17.2429 | 4825604.0 |
| 2013-10-09 09:45:00 | AAPL | Stock | 17.2396 | 17.2439 | 17.18 | 17.1829 | 8327088.0 |
| 2013-10-09 09:50:00 | AAPL | Stock | 17.1796 | 17.2371 | 17.1796 | 17.2221 | 5595688.0 |
| 2013-10-09 09:55:00 | AAPL | Stock | 17.2218 | 17.285 | 17.2161 | 17.2696 | 6943636.0 |
| 2013-10-09 10:00:00 | AAPL | Stock | 17.2661 | 17.2771 | 17.2261 | 17.2404 | 4717356.0 |
| 2013-10-09 10:05:00 | AAPL | Stock | 17.2346 | 17.2775 | 17.2325 | 17.2543 | 3404856.0 |
> showing 50 of 346,480 rows — these rows as CSV