PREVIEW / stock_5min / 2013-05-13
file: by_date/stock_5min/2013/2013-05-13.parquet size: 5.0 MB rows: 331,151 symbols: 3,503
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-05-13 04:00:00 | AAPL | Stock | 16.1607 | 16.1607 | 16.1607 | 16.1607 | 2800.0 |
| 2013-05-13 05:50:00 | AAPL | Stock | 16.0964 | 16.0964 | 16.0964 | 16.0964 | 2800.0 |
| 2013-05-13 06:05:00 | AAPL | Stock | 16.0739 | 16.0743 | 16.0739 | 16.0739 | 15400.0 |
| 2013-05-13 06:45:00 | AAPL | Stock | 16.0643 | 16.0643 | 16.0643 | 16.0643 | 2800.0 |
| 2013-05-13 07:15:00 | AAPL | Stock | 16.0732 | 16.0732 | 16.0732 | 16.0732 | 22736.0 |
| 2013-05-13 07:20:00 | AAPL | Stock | 16.0761 | 16.0761 | 16.0761 | 16.0761 | 8400.0 |
| 2013-05-13 07:25:00 | AAPL | Stock | 16.0846 | 16.0861 | 16.0846 | 16.0861 | 14000.0 |
| 2013-05-13 07:30:00 | AAPL | Stock | 16.0911 | 16.0911 | 16.0911 | 16.0911 | 28000.0 |
| 2013-05-13 07:35:00 | AAPL | Stock | 16.0911 | 16.0982 | 16.0911 | 16.0982 | 22288.0 |
| 2013-05-13 07:45:00 | AAPL | Stock | 16.1061 | 16.1071 | 16.1061 | 16.1071 | 19600.0 |
| 2013-05-13 07:50:00 | AAPL | Stock | 16.1196 | 16.1196 | 16.1196 | 16.1196 | 2800.0 |
| 2013-05-13 07:55:00 | AAPL | Stock | 16.1196 | 16.125 | 16.1196 | 16.125 | 75880.0 |
| 2013-05-13 08:00:00 | AAPL | Stock | 16.1421 | 16.145 | 16.0661 | 16.1357 | 499884.0 |
| 2013-05-13 08:05:00 | AAPL | Stock | 16.1357 | 16.1393 | 16.1325 | 16.1325 | 39200.0 |
| 2013-05-13 08:10:00 | AAPL | Stock | 16.1257 | 16.1257 | 16.1107 | 16.125 | 109620.0 |
| 2013-05-13 08:15:00 | AAPL | Stock | 16.1243 | 16.1293 | 16.1179 | 16.1243 | 30352.0 |
| 2013-05-13 08:20:00 | AAPL | Stock | 16.1243 | 16.1289 | 16.1179 | 16.1254 | 55720.0 |
| 2013-05-13 08:25:00 | AAPL | Stock | 16.1296 | 16.1411 | 16.1254 | 16.1321 | 87416.0 |
| 2013-05-13 08:30:00 | AAPL | Stock | 16.14 | 16.2243 | 16.1339 | 16.2239 | 520268.0 |
| 2013-05-13 08:35:00 | AAPL | Stock | 16.2154 | 16.2196 | 16.1964 | 16.2104 | 157808.0 |
| 2013-05-13 08:40:00 | AAPL | Stock | 16.21 | 16.2464 | 16.21 | 16.2429 | 278600.0 |
| 2013-05-13 08:45:00 | AAPL | Stock | 16.2429 | 16.2464 | 16.2282 | 16.2411 | 567252.0 |
| 2013-05-13 08:50:00 | AAPL | Stock | 16.2425 | 16.2429 | 16.2268 | 16.2268 | 130172.0 |
| 2013-05-13 08:55:00 | AAPL | Stock | 16.2361 | 16.2375 | 16.2179 | 16.2179 | 255052.0 |
| 2013-05-13 09:00:00 | AAPL | Stock | 16.2211 | 16.2321 | 16.2196 | 16.2321 | 114212.0 |
| 2013-05-13 09:05:00 | AAPL | Stock | 16.24 | 16.2454 | 16.2368 | 16.2371 | 90160.0 |
| 2013-05-13 09:10:00 | AAPL | Stock | 16.2393 | 16.2393 | 16.2318 | 16.2325 | 138488.0 |
| 2013-05-13 09:15:00 | AAPL | Stock | 16.2357 | 16.2357 | 16.2304 | 16.2321 | 80192.0 |
| 2013-05-13 09:20:00 | AAPL | Stock | 16.2321 | 16.2386 | 16.2214 | 16.2214 | 338240.0 |
| 2013-05-13 09:25:00 | AAPL | Stock | 16.2264 | 16.2389 | 16.1275 | 16.1275 | 1390536.0 |
| 2013-05-13 09:30:00 | AAPL | Stock | 16.1254 | 16.2979 | 16.125 | 16.2946 | 21462280.0 |
| 2013-05-13 09:35:00 | AAPL | Stock | 16.2925 | 16.35 | 16.2791 | 16.3236 | 13884528.0 |
| 2013-05-13 09:40:00 | AAPL | Stock | 16.3254 | 16.3496 | 16.2686 | 16.3036 | 11225480.0 |
| 2013-05-13 09:45:00 | AAPL | Stock | 16.2964 | 16.3125 | 16.2414 | 16.2561 | 9962652.0 |
| 2013-05-13 09:50:00 | AAPL | Stock | 16.2616 | 16.2621 | 16.2071 | 16.2325 | 10411156.0 |
| 2013-05-13 09:55:00 | AAPL | Stock | 16.235 | 16.2586 | 16.2182 | 16.2357 | 5647376.0 |
| 2013-05-13 10:00:00 | AAPL | Stock | 16.235 | 16.2364 | 16.1904 | 16.22 | 5270888.0 |
| 2013-05-13 10:05:00 | AAPL | Stock | 16.2221 | 16.2696 | 16.2107 | 16.2536 | 7629132.0 |
| 2013-05-13 10:10:00 | AAPL | Stock | 16.261 | 16.2675 | 16.2357 | 16.2632 | 3293556.0 |
| 2013-05-13 10:15:00 | AAPL | Stock | 16.2654 | 16.2659 | 16.2379 | 16.2538 | 3534748.0 |
| 2013-05-13 10:20:00 | AAPL | Stock | 16.2554 | 16.2575 | 16.2071 | 16.2168 | 3462452.0 |
| 2013-05-13 10:25:00 | AAPL | Stock | 16.2168 | 16.2475 | 16.2096 | 16.2352 | 2975224.0 |
| 2013-05-13 10:30:00 | AAPL | Stock | 16.2361 | 16.2543 | 16.2332 | 16.25 | 2433928.0 |
| 2013-05-13 10:35:00 | AAPL | Stock | 16.2496 | 16.2836 | 16.2484 | 16.2604 | 4212544.0 |
| 2013-05-13 10:40:00 | AAPL | Stock | 16.2561 | 16.27 | 16.2504 | 16.2596 | 1354584.0 |
| 2013-05-13 10:45:00 | AAPL | Stock | 16.2568 | 16.2639 | 16.2364 | 16.2618 | 1864408.0 |
| 2013-05-13 10:50:00 | AAPL | Stock | 16.2639 | 16.2714 | 16.2407 | 16.255 | 2471420.0 |
| 2013-05-13 10:55:00 | AAPL | Stock | 16.255 | 16.2596 | 16.2389 | 16.2491 | 2223480.0 |
| 2013-05-13 11:00:00 | AAPL | Stock | 16.2489 | 16.2557 | 16.2393 | 16.2457 | 1187172.0 |
| 2013-05-13 11:05:00 | AAPL | Stock | 16.2432 | 16.2507 | 16.2375 | 16.2375 | 2556540.0 |
> showing 50 of 331,151 rows — these rows as CSV