PREVIEW / stock_5min / 2017-11-01
file: by_date/stock_5min/2017/2017-11-01.parquet size: 5.5 MB rows: 356,476 symbols: 2,928
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-11-01 04:00:00 | AAPL | Stock | 42.375 | 42.375 | 42.375 | 42.375 | 1100.0 |
| 2017-11-01 04:05:00 | AAPL | Stock | 42.4025 | 42.4025 | 42.4025 | 42.4025 | 1080.0 |
| 2017-11-01 04:10:00 | AAPL | Stock | 42.455 | 42.455 | 42.455 | 42.455 | 400.0 |
| 2017-11-01 04:15:00 | AAPL | Stock | 42.455 | 42.455 | 42.455 | 42.455 | 1348.0 |
| 2017-11-01 04:20:00 | AAPL | Stock | 42.4625 | 42.4625 | 42.435 | 42.435 | 18804.0 |
| 2017-11-01 04:25:00 | AAPL | Stock | 42.44 | 42.44 | 42.435 | 42.435 | 4484.0 |
| 2017-11-01 04:35:00 | AAPL | Stock | 42.4375 | 42.4375 | 42.4375 | 42.4375 | 1200.0 |
| 2017-11-01 04:40:00 | AAPL | Stock | 42.4375 | 42.4375 | 42.4375 | 42.4375 | 700.0 |
| 2017-11-01 04:50:00 | AAPL | Stock | 42.425 | 42.425 | 42.425 | 42.425 | 796.0 |
| 2017-11-01 04:55:00 | AAPL | Stock | 42.3975 | 42.3975 | 42.39 | 42.39 | 1368.0 |
| 2017-11-01 05:25:00 | AAPL | Stock | 42.405 | 42.405 | 42.405 | 42.405 | 800.0 |
| 2017-11-01 05:40:00 | AAPL | Stock | 42.38 | 42.38 | 42.38 | 42.38 | 400.0 |
| 2017-11-01 05:45:00 | AAPL | Stock | 42.43 | 42.5 | 42.43 | 42.5 | 19788.0 |
| 2017-11-01 05:55:00 | AAPL | Stock | 42.4925 | 42.4925 | 42.405 | 42.405 | 5960.0 |
| 2017-11-01 06:00:00 | AAPL | Stock | 42.485 | 42.5075 | 42.485 | 42.5075 | 39420.0 |
| 2017-11-01 06:05:00 | AAPL | Stock | 42.525 | 42.525 | 42.525 | 42.525 | 516.0 |
| 2017-11-01 06:10:00 | AAPL | Stock | 42.525 | 42.525 | 42.5125 | 42.525 | 2684.0 |
| 2017-11-01 06:15:00 | AAPL | Stock | 42.5475 | 42.5475 | 42.5 | 42.5225 | 6408.0 |
| 2017-11-01 06:20:00 | AAPL | Stock | 42.5225 | 42.5225 | 42.5225 | 42.5225 | 800.0 |
| 2017-11-01 06:25:00 | AAPL | Stock | 42.52 | 42.52 | 42.52 | 42.52 | 400.0 |
| 2017-11-01 06:30:00 | AAPL | Stock | 42.52 | 42.52 | 42.4525 | 42.4525 | 4956.0 |
| 2017-11-01 06:35:00 | AAPL | Stock | 42.485 | 42.485 | 42.485 | 42.485 | 6800.0 |
| 2017-11-01 06:40:00 | AAPL | Stock | 42.47 | 42.47 | 42.4675 | 42.4675 | 800.0 |
| 2017-11-01 06:45:00 | AAPL | Stock | 42.455 | 42.455 | 42.44 | 42.44 | 3200.0 |
| 2017-11-01 06:50:00 | AAPL | Stock | 42.46 | 42.46 | 42.44 | 42.44 | 8016.0 |
| 2017-11-01 06:55:00 | AAPL | Stock | 42.4375 | 42.4375 | 42.425 | 42.4325 | 10456.0 |
| 2017-11-01 07:00:00 | AAPL | Stock | 42.4375 | 42.46 | 42.4175 | 42.4425 | 66588.0 |
| 2017-11-01 07:05:00 | AAPL | Stock | 42.4575 | 42.47 | 42.45 | 42.465 | 35212.0 |
| 2017-11-01 07:10:00 | AAPL | Stock | 42.4625 | 42.485 | 42.4625 | 42.4725 | 44628.0 |
| 2017-11-01 07:15:00 | AAPL | Stock | 42.475 | 42.4975 | 42.475 | 42.4975 | 30980.0 |
| 2017-11-01 07:20:00 | AAPL | Stock | 42.4975 | 42.515 | 42.4875 | 42.49 | 42908.0 |
| 2017-11-01 07:25:00 | AAPL | Stock | 42.4875 | 42.5225 | 42.485 | 42.485 | 46428.0 |
| 2017-11-01 07:30:00 | AAPL | Stock | 42.49 | 42.5025 | 42.4425 | 42.4425 | 116592.0 |
| 2017-11-01 07:35:00 | AAPL | Stock | 42.4375 | 42.4675 | 42.3725 | 42.3725 | 76580.0 |
| 2017-11-01 07:40:00 | AAPL | Stock | 42.365 | 42.375 | 42.315 | 42.34 | 53460.0 |
| 2017-11-01 07:45:00 | AAPL | Stock | 42.325 | 42.35 | 42.205 | 42.205 | 87408.0 |
| 2017-11-01 07:50:00 | AAPL | Stock | 42.2 | 42.26 | 42.2 | 42.26 | 30632.0 |
| 2017-11-01 07:55:00 | AAPL | Stock | 42.265 | 42.275 | 42.265 | 42.275 | 6544.0 |
| 2017-11-01 08:00:00 | AAPL | Stock | 42.2775 | 42.525 | 42.2275 | 42.35 | 183852.0 |
| 2017-11-01 08:05:00 | AAPL | Stock | 42.3475 | 42.4 | 42.3275 | 42.3825 | 49280.0 |
| 2017-11-01 08:10:00 | AAPL | Stock | 42.38 | 42.39 | 42.3375 | 42.39 | 78508.0 |
| 2017-11-01 08:15:00 | AAPL | Stock | 42.39 | 42.395 | 42.35 | 42.365 | 29108.0 |
| 2017-11-01 08:20:00 | AAPL | Stock | 42.365 | 42.365 | 42.3275 | 42.3625 | 33476.0 |
| 2017-11-01 08:25:00 | AAPL | Stock | 42.3625 | 42.37 | 42.34 | 42.34 | 23940.0 |
| 2017-11-01 08:30:00 | AAPL | Stock | 42.3475 | 42.3675 | 42.3425 | 42.345 | 39708.0 |
| 2017-11-01 08:35:00 | AAPL | Stock | 42.345 | 42.3725 | 42.3425 | 42.36 | 26164.0 |
| 2017-11-01 08:40:00 | AAPL | Stock | 42.36 | 42.365 | 42.35 | 42.35 | 35316.0 |
| 2017-11-01 08:45:00 | AAPL | Stock | 42.35 | 42.3725 | 42.35 | 42.3725 | 15624.0 |
| 2017-11-01 08:50:00 | AAPL | Stock | 42.375 | 42.395 | 42.3725 | 42.395 | 37652.0 |
| 2017-11-01 08:55:00 | AAPL | Stock | 42.385 | 42.4175 | 42.38 | 42.3925 | 15744.0 |
> showing 50 of 356,476 rows — these rows as CSV