PREVIEW / stock_5min / 2016-08-30
file: by_date/stock_5min/2016/2016-08-30.parquet size: 5.2 MB rows: 344,273 symbols: 3,260
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-08-30 04:00:00 | AAPL | Stock | 26.6475 | 26.6475 | 26.6475 | 26.6475 | 1200.0 |
| 2016-08-30 04:15:00 | AAPL | Stock | 26.6225 | 26.6225 | 26.6225 | 26.6225 | 400.0 |
| 2016-08-30 04:20:00 | AAPL | Stock | 26.6275 | 26.6275 | 26.6275 | 26.6275 | 400.0 |
| 2016-08-30 04:30:00 | AAPL | Stock | 26.6225 | 26.6225 | 26.6225 | 26.6225 | 1600.0 |
| 2016-08-30 04:50:00 | AAPL | Stock | 26.61 | 26.61 | 26.61 | 26.61 | 800.0 |
| 2016-08-30 05:05:00 | AAPL | Stock | 26.5825 | 26.5825 | 26.5525 | 26.5525 | 7648.0 |
| 2016-08-30 05:15:00 | AAPL | Stock | 26.5875 | 26.5875 | 26.5875 | 26.5875 | 2232.0 |
| 2016-08-30 05:35:00 | AAPL | Stock | 26.575 | 26.575 | 26.48 | 26.48 | 1080.0 |
| 2016-08-30 05:40:00 | AAPL | Stock | 26.42 | 26.42 | 26.385 | 26.385 | 3280.0 |
| 2016-08-30 05:45:00 | AAPL | Stock | 26.4025 | 26.5 | 26.33 | 26.33 | 10068.0 |
| 2016-08-30 05:50:00 | AAPL | Stock | 26.355 | 26.3625 | 26.3325 | 26.3625 | 6820.0 |
| 2016-08-30 05:55:00 | AAPL | Stock | 26.3875 | 26.3875 | 26.2675 | 26.27 | 55836.0 |
| 2016-08-30 06:00:00 | AAPL | Stock | 26.2675 | 26.3 | 26.225 | 26.225 | 70748.0 |
| 2016-08-30 06:05:00 | AAPL | Stock | 26.225 | 26.225 | 25.875 | 25.925 | 166016.0 |
| 2016-08-30 06:10:00 | AAPL | Stock | 25.92 | 26.14 | 25.9075 | 26.1075 | 168468.0 |
| 2016-08-30 06:15:00 | AAPL | Stock | 26.09 | 26.115 | 26.055 | 26.115 | 100448.0 |
| 2016-08-30 06:20:00 | AAPL | Stock | 26.095 | 26.15 | 26.075 | 26.125 | 72356.0 |
| 2016-08-30 06:25:00 | AAPL | Stock | 26.15 | 26.25 | 26.15 | 26.19 | 47628.0 |
| 2016-08-30 06:30:00 | AAPL | Stock | 26.225 | 26.25 | 26.22 | 26.25 | 64736.0 |
| 2016-08-30 06:35:00 | AAPL | Stock | 26.25 | 26.2625 | 26.25 | 26.25 | 61928.0 |
| 2016-08-30 06:40:00 | AAPL | Stock | 26.25 | 26.25 | 26.2325 | 26.2325 | 16280.0 |
| 2016-08-30 06:45:00 | AAPL | Stock | 26.225 | 26.245 | 26.1975 | 26.1975 | 21200.0 |
| 2016-08-30 06:50:00 | AAPL | Stock | 26.22 | 26.225 | 26.19 | 26.195 | 12800.0 |
| 2016-08-30 06:55:00 | AAPL | Stock | 26.2225 | 26.225 | 26.215 | 26.225 | 3440.0 |
| 2016-08-30 07:00:00 | AAPL | Stock | 26.23 | 26.2475 | 26.175 | 26.175 | 55232.0 |
| 2016-08-30 07:05:00 | AAPL | Stock | 26.1925 | 26.2 | 26.1325 | 26.1325 | 42996.0 |
| 2016-08-30 07:10:00 | AAPL | Stock | 26.1575 | 26.195 | 26.1575 | 26.195 | 24960.0 |
| 2016-08-30 07:15:00 | AAPL | Stock | 26.195 | 26.275 | 26.195 | 26.25 | 144984.0 |
| 2016-08-30 07:20:00 | AAPL | Stock | 26.225 | 26.2375 | 26.2125 | 26.2125 | 24460.0 |
| 2016-08-30 07:25:00 | AAPL | Stock | 26.2225 | 26.2375 | 26.215 | 26.22 | 16904.0 |
| 2016-08-30 07:30:00 | AAPL | Stock | 26.215 | 26.24 | 26.2125 | 26.24 | 9716.0 |
| 2016-08-30 07:35:00 | AAPL | Stock | 26.23 | 26.3425 | 26.2275 | 26.3425 | 184744.0 |
| 2016-08-30 07:40:00 | AAPL | Stock | 26.3175 | 26.3975 | 26.315 | 26.325 | 87736.0 |
| 2016-08-30 07:45:00 | AAPL | Stock | 26.3475 | 26.37 | 26.345 | 26.3525 | 17340.0 |
| 2016-08-30 07:50:00 | AAPL | Stock | 26.345 | 26.3625 | 26.3 | 26.3 | 31092.0 |
| 2016-08-30 07:55:00 | AAPL | Stock | 26.3225 | 26.33 | 26.295 | 26.33 | 14940.0 |
| 2016-08-30 08:00:00 | AAPL | Stock | 26.3375 | 26.375 | 26.025 | 26.3475 | 365276.0 |
| 2016-08-30 08:05:00 | AAPL | Stock | 26.3175 | 26.41 | 26.3125 | 26.41 | 119768.0 |
| 2016-08-30 08:10:00 | AAPL | Stock | 26.43 | 26.4675 | 26.405 | 26.455 | 184056.0 |
| 2016-08-30 08:15:00 | AAPL | Stock | 26.45 | 26.47 | 26.4125 | 26.425 | 137048.0 |
| 2016-08-30 08:20:00 | AAPL | Stock | 26.4325 | 26.4325 | 26.405 | 26.405 | 24876.0 |
| 2016-08-30 08:25:00 | AAPL | Stock | 26.4025 | 26.4275 | 26.4025 | 26.425 | 89116.0 |
| 2016-08-30 08:30:00 | AAPL | Stock | 26.425 | 26.445 | 26.425 | 26.4375 | 76332.0 |
| 2016-08-30 08:35:00 | AAPL | Stock | 26.445 | 26.45 | 26.4175 | 26.4375 | 126764.0 |
| 2016-08-30 08:40:00 | AAPL | Stock | 26.4475 | 26.4475 | 26.425 | 26.425 | 61856.0 |
| 2016-08-30 08:45:00 | AAPL | Stock | 26.425 | 26.435 | 26.37 | 26.375 | 109340.0 |
| 2016-08-30 08:50:00 | AAPL | Stock | 26.375 | 26.4125 | 26.375 | 26.4125 | 54076.0 |
| 2016-08-30 08:55:00 | AAPL | Stock | 26.42 | 26.4625 | 26.39 | 26.445 | 124420.0 |
| 2016-08-30 09:00:00 | AAPL | Stock | 26.4475 | 26.4625 | 26.425 | 26.4475 | 165672.0 |
| 2016-08-30 09:05:00 | AAPL | Stock | 26.435 | 26.4425 | 26.3875 | 26.4325 | 225652.0 |
> showing 50 of 344,273 rows — these rows as CSV