PREVIEW / stock_5min / 2017-05-30
file: by_date/stock_5min/2017/2017-05-30.parquet size: 5.3 MB rows: 346,642 symbols: 3,051
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 |
|---|---|---|---|---|---|---|---|
| 2017-05-30 04:00:00 | AAPL | Stock | 38.4 | 38.4275 | 38.4 | 38.4275 | 5556.0 |
| 2017-05-30 04:20:00 | AAPL | Stock | 38.375 | 38.375 | 38.375 | 38.375 | 4400.0 |
| 2017-05-30 04:25:00 | AAPL | Stock | 38.35 | 38.35 | 38.35 | 38.35 | 800.0 |
| 2017-05-30 05:10:00 | AAPL | Stock | 38.3425 | 38.3425 | 38.3425 | 38.3425 | 1680.0 |
| 2017-05-30 05:20:00 | AAPL | Stock | 38.31 | 38.31 | 38.31 | 38.31 | 400.0 |
| 2017-05-30 06:00:00 | AAPL | Stock | 38.3325 | 38.3325 | 38.3325 | 38.3325 | 3416.0 |
| 2017-05-30 06:05:00 | AAPL | Stock | 38.3325 | 38.3325 | 38.3325 | 38.3325 | 1288.0 |
| 2017-05-30 06:10:00 | AAPL | Stock | 38.3475 | 38.3475 | 38.3475 | 38.3475 | 680.0 |
| 2017-05-30 06:20:00 | AAPL | Stock | 38.3375 | 38.3375 | 38.3325 | 38.3375 | 4240.0 |
| 2017-05-30 06:25:00 | AAPL | Stock | 38.3225 | 38.325 | 38.3225 | 38.325 | 10400.0 |
| 2017-05-30 06:35:00 | AAPL | Stock | 38.345 | 38.3475 | 38.3 | 38.3 | 2100.0 |
| 2017-05-30 06:45:00 | AAPL | Stock | 38.3375 | 38.3375 | 38.3375 | 38.3375 | 4400.0 |
| 2017-05-30 07:00:00 | AAPL | Stock | 38.3225 | 38.3225 | 38.29 | 38.29 | 6400.0 |
| 2017-05-30 07:10:00 | AAPL | Stock | 38.29 | 38.295 | 38.29 | 38.295 | 1180.0 |
| 2017-05-30 07:15:00 | AAPL | Stock | 38.295 | 38.295 | 38.29 | 38.29 | 1980.0 |
| 2017-05-30 07:20:00 | AAPL | Stock | 38.29 | 38.29 | 38.29 | 38.29 | 400.0 |
| 2017-05-30 07:25:00 | AAPL | Stock | 38.2975 | 38.3075 | 38.2975 | 38.3075 | 8400.0 |
| 2017-05-30 07:35:00 | AAPL | Stock | 38.3 | 38.3 | 38.2975 | 38.2975 | 2000.0 |
| 2017-05-30 07:40:00 | AAPL | Stock | 38.29 | 38.29 | 38.29 | 38.29 | 816.0 |
| 2017-05-30 07:45:00 | AAPL | Stock | 38.295 | 38.295 | 38.295 | 38.295 | 800.0 |
| 2017-05-30 07:50:00 | AAPL | Stock | 38.3 | 38.3075 | 38.29 | 38.29 | 4000.0 |
| 2017-05-30 07:55:00 | AAPL | Stock | 38.305 | 38.305 | 38.29 | 38.3 | 6400.0 |
| 2017-05-30 08:00:00 | AAPL | Stock | 38.305 | 38.31 | 38.29 | 38.305 | 82708.0 |
| 2017-05-30 08:05:00 | AAPL | Stock | 38.295 | 38.3125 | 38.2875 | 38.3 | 10908.0 |
| 2017-05-30 08:10:00 | AAPL | Stock | 38.3225 | 38.345 | 38.3175 | 38.33 | 11940.0 |
| 2017-05-30 08:15:00 | AAPL | Stock | 38.3375 | 38.3375 | 38.3375 | 38.3375 | 4400.0 |
| 2017-05-30 08:20:00 | AAPL | Stock | 38.3375 | 38.345 | 38.3375 | 38.345 | 7600.0 |
| 2017-05-30 08:25:00 | AAPL | Stock | 38.3225 | 38.3225 | 38.3225 | 38.3225 | 3736.0 |
| 2017-05-30 08:30:00 | AAPL | Stock | 38.33 | 38.3375 | 38.3225 | 38.33 | 21876.0 |
| 2017-05-30 08:35:00 | AAPL | Stock | 38.33 | 38.33 | 38.305 | 38.3075 | 7440.0 |
| 2017-05-30 08:40:00 | AAPL | Stock | 38.31 | 38.325 | 38.3075 | 38.3225 | 34140.0 |
| 2017-05-30 08:45:00 | AAPL | Stock | 38.3225 | 38.3225 | 38.3225 | 38.3225 | 4400.0 |
| 2017-05-30 08:50:00 | AAPL | Stock | 38.3225 | 38.325 | 38.3125 | 38.3125 | 8592.0 |
| 2017-05-30 08:55:00 | AAPL | Stock | 38.3125 | 38.32 | 38.3125 | 38.32 | 1600.0 |
| 2017-05-30 09:00:00 | AAPL | Stock | 38.31 | 38.3225 | 38.3075 | 38.3075 | 10776.0 |
| 2017-05-30 09:05:00 | AAPL | Stock | 38.3225 | 38.325 | 38.3075 | 38.3225 | 14608.0 |
| 2017-05-30 09:10:00 | AAPL | Stock | 38.3225 | 38.3225 | 38.3225 | 38.3225 | 2000.0 |
| 2017-05-30 09:15:00 | AAPL | Stock | 38.32 | 38.3225 | 38.3125 | 38.3225 | 3200.0 |
| 2017-05-30 09:20:00 | AAPL | Stock | 38.325 | 38.325 | 38.32 | 38.325 | 11848.0 |
| 2017-05-30 09:25:00 | AAPL | Stock | 38.33 | 38.3625 | 38.33 | 38.3575 | 11012.0 |
| 2017-05-30 09:30:00 | AAPL | Stock | 38.355 | 38.455 | 38.3325 | 38.4475 | 3223568.0 |
| 2017-05-30 09:35:00 | AAPL | Stock | 38.445 | 38.5175 | 38.44 | 38.4875 | 2064668.0 |
| 2017-05-30 09:40:00 | AAPL | Stock | 38.4925 | 38.515 | 38.4325 | 38.4632 | 2107016.0 |
| 2017-05-30 09:45:00 | AAPL | Stock | 38.464 | 38.4825 | 38.41 | 38.42 | 1385044.0 |
| 2017-05-30 09:50:00 | AAPL | Stock | 38.419 | 38.425 | 38.3925 | 38.4025 | 1104860.0 |
| 2017-05-30 09:55:00 | AAPL | Stock | 38.404 | 38.465 | 38.3975 | 38.4625 | 888772.0 |
| 2017-05-30 10:00:00 | AAPL | Stock | 38.4625 | 38.48 | 38.445 | 38.46 | 1056124.0 |
| 2017-05-30 10:05:00 | AAPL | Stock | 38.46 | 38.475 | 38.4075 | 38.41 | 986036.0 |
| 2017-05-30 10:10:00 | AAPL | Stock | 38.41 | 38.4105 | 38.3325 | 38.3638 | 1581104.0 |
| 2017-05-30 10:15:00 | AAPL | Stock | 38.365 | 38.3925 | 38.35 | 38.39 | 853644.0 |
> showing 50 of 346,642 rows — these rows as CSV