PREVIEW / stock_5min / 2016-05-11
file: by_date/stock_5min/2016/2016-05-11.parquet size: 5.3 MB rows: 353,554 symbols: 3,288
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 |
|---|---|---|---|---|---|---|---|
| 2016-05-11 04:30:00 | AAPL | Stock | 23.2775 | 23.28 | 23.2775 | 23.28 | 1600.0 |
| 2016-05-11 05:10:00 | AAPL | Stock | 23.2125 | 23.2375 | 23.2125 | 23.2375 | 2400.0 |
| 2016-05-11 05:50:00 | AAPL | Stock | 23.2375 | 23.2375 | 23.2375 | 23.2375 | 800.0 |
| 2016-05-11 05:55:00 | AAPL | Stock | 23.2225 | 23.2225 | 23.2225 | 23.2225 | 400.0 |
| 2016-05-11 06:10:00 | AAPL | Stock | 23.2375 | 23.2375 | 23.2375 | 23.2375 | 400.0 |
| 2016-05-11 06:25:00 | AAPL | Stock | 23.275 | 23.275 | 23.275 | 23.275 | 404.0 |
| 2016-05-11 06:50:00 | AAPL | Stock | 23.2525 | 23.2525 | 23.2525 | 23.2525 | 540.0 |
| 2016-05-11 07:10:00 | AAPL | Stock | 23.285 | 23.285 | 23.2825 | 23.2825 | 1788.0 |
| 2016-05-11 07:15:00 | AAPL | Stock | 23.2775 | 23.2775 | 23.2775 | 23.2775 | 1200.0 |
| 2016-05-11 07:20:00 | AAPL | Stock | 23.285 | 23.295 | 23.285 | 23.295 | 4408.0 |
| 2016-05-11 07:25:00 | AAPL | Stock | 23.295 | 23.295 | 23.295 | 23.295 | 884.0 |
| 2016-05-11 07:35:00 | AAPL | Stock | 23.295 | 23.295 | 23.295 | 23.295 | 4000.0 |
| 2016-05-11 07:40:00 | AAPL | Stock | 23.2875 | 23.2875 | 23.2875 | 23.2875 | 1992.0 |
| 2016-05-11 07:55:00 | AAPL | Stock | 23.29 | 23.29 | 23.29 | 23.29 | 1180.0 |
| 2016-05-11 08:00:00 | AAPL | Stock | 23.3 | 23.31 | 23.25 | 23.3 | 22836.0 |
| 2016-05-11 08:05:00 | AAPL | Stock | 23.3 | 23.305 | 23.3 | 23.3 | 4564.0 |
| 2016-05-11 08:10:00 | AAPL | Stock | 23.2975 | 23.2975 | 23.2875 | 23.2875 | 18780.0 |
| 2016-05-11 08:15:00 | AAPL | Stock | 23.28 | 23.285 | 23.28 | 23.285 | 7712.0 |
| 2016-05-11 08:20:00 | AAPL | Stock | 23.2875 | 23.2875 | 23.2875 | 23.2875 | 920.0 |
| 2016-05-11 08:25:00 | AAPL | Stock | 23.3125 | 23.3125 | 23.2925 | 23.3125 | 2200.0 |
| 2016-05-11 08:30:00 | AAPL | Stock | 23.315 | 23.315 | 23.3125 | 23.3125 | 3976.0 |
| 2016-05-11 08:35:00 | AAPL | Stock | 23.3075 | 23.3475 | 23.3075 | 23.3225 | 9892.0 |
| 2016-05-11 08:40:00 | AAPL | Stock | 23.3125 | 23.3175 | 23.3075 | 23.3075 | 5500.0 |
| 2016-05-11 08:45:00 | AAPL | Stock | 23.3125 | 23.32 | 23.3125 | 23.315 | 6316.0 |
| 2016-05-11 08:50:00 | AAPL | Stock | 23.3125 | 23.325 | 23.31 | 23.3125 | 24812.0 |
| 2016-05-11 08:55:00 | AAPL | Stock | 23.3125 | 23.3125 | 23.3075 | 23.3125 | 2228.0 |
| 2016-05-11 09:00:00 | AAPL | Stock | 23.305 | 23.305 | 23.295 | 23.295 | 3200.0 |
| 2016-05-11 09:10:00 | AAPL | Stock | 23.3 | 23.3025 | 23.29 | 23.29 | 9980.0 |
| 2016-05-11 09:20:00 | AAPL | Stock | 23.295 | 23.295 | 23.2875 | 23.2875 | 3600.0 |
| 2016-05-11 09:25:00 | AAPL | Stock | 23.275 | 23.3675 | 23.2725 | 23.3675 | 386168.0 |
| 2016-05-11 09:30:00 | AAPL | Stock | 23.365 | 23.375 | 23.255 | 23.2575 | 3954912.0 |
| 2016-05-11 09:35:00 | AAPL | Stock | 23.2578 | 23.3065 | 23.165 | 23.2975 | 4004140.0 |
| 2016-05-11 09:40:00 | AAPL | Stock | 23.295 | 23.2975 | 23.1875 | 23.21 | 2377204.0 |
| 2016-05-11 09:45:00 | AAPL | Stock | 23.21 | 23.27 | 23.195 | 23.23 | 1756488.0 |
| 2016-05-11 09:50:00 | AAPL | Stock | 23.23 | 23.2362 | 23.175 | 23.1762 | 1664892.0 |
| 2016-05-11 09:55:00 | AAPL | Stock | 23.1762 | 23.28 | 23.1762 | 23.2575 | 2050640.0 |
| 2016-05-11 10:00:00 | AAPL | Stock | 23.2575 | 23.2675 | 23.2105 | 23.2555 | 1729928.0 |
| 2016-05-11 10:05:00 | AAPL | Stock | 23.2565 | 23.2575 | 23.2175 | 23.2275 | 1284700.0 |
| 2016-05-11 10:10:00 | AAPL | Stock | 23.2275 | 23.245 | 23.2175 | 23.239 | 1148880.0 |
| 2016-05-11 10:15:00 | AAPL | Stock | 23.2385 | 23.245 | 23.215 | 23.225 | 1412408.0 |
| 2016-05-11 10:20:00 | AAPL | Stock | 23.2225 | 23.25 | 23.2 | 23.25 | 1099836.0 |
| 2016-05-11 10:25:00 | AAPL | Stock | 23.2475 | 23.3225 | 23.2375 | 23.2962 | 2211976.0 |
| 2016-05-11 10:30:00 | AAPL | Stock | 23.2975 | 23.355 | 23.2975 | 23.3412 | 2223308.0 |
| 2016-05-11 10:35:00 | AAPL | Stock | 23.3425 | 23.3925 | 23.3425 | 23.3572 | 2330608.0 |
| 2016-05-11 10:40:00 | AAPL | Stock | 23.355 | 23.36 | 23.2825 | 23.3 | 1658868.0 |
| 2016-05-11 10:45:00 | AAPL | Stock | 23.3 | 23.3275 | 23.2925 | 23.295 | 996224.0 |
| 2016-05-11 10:50:00 | AAPL | Stock | 23.2975 | 23.3088 | 23.285 | 23.3 | 1036996.0 |
| 2016-05-11 10:55:00 | AAPL | Stock | 23.3 | 23.335 | 23.295 | 23.305 | 1228384.0 |
| 2016-05-11 11:00:00 | AAPL | Stock | 23.3025 | 23.31 | 23.245 | 23.25 | 1331216.0 |
| 2016-05-11 11:05:00 | AAPL | Stock | 23.25 | 23.285 | 23.2325 | 23.285 | 1269608.0 |
> showing 50 of 353,554 rows — these rows as CSV