PREVIEW / stock_5min / 2016-12-13
file: by_date/stock_5min/2016/2016-12-13.parquet size: 5.6 MB rows: 368,733 symbols: 3,152
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-12-13 04:00:00 | AAPL | Stock | 28.2825 | 28.2825 | 28.2825 | 28.2825 | 1200.0 |
| 2016-12-13 04:35:00 | AAPL | Stock | 28.3325 | 28.3325 | 28.3325 | 28.3325 | 840.0 |
| 2016-12-13 05:35:00 | AAPL | Stock | 28.355 | 28.355 | 28.355 | 28.355 | 400.0 |
| 2016-12-13 05:55:00 | AAPL | Stock | 28.3775 | 28.4175 | 28.3775 | 28.4175 | 4760.0 |
| 2016-12-13 06:30:00 | AAPL | Stock | 28.3775 | 28.3775 | 28.3775 | 28.3775 | 2000.0 |
| 2016-12-13 06:35:00 | AAPL | Stock | 28.3875 | 28.3875 | 28.3875 | 28.3875 | 1632.0 |
| 2016-12-13 06:40:00 | AAPL | Stock | 28.3775 | 28.3775 | 28.3775 | 28.3775 | 1152.0 |
| 2016-12-13 06:45:00 | AAPL | Stock | 28.3775 | 28.3775 | 28.3775 | 28.3775 | 896.0 |
| 2016-12-13 07:00:00 | AAPL | Stock | 28.3625 | 28.3625 | 28.3625 | 28.3625 | 856.0 |
| 2016-12-13 07:10:00 | AAPL | Stock | 28.4 | 28.405 | 28.4 | 28.405 | 10740.0 |
| 2016-12-13 07:25:00 | AAPL | Stock | 28.4275 | 28.43 | 28.4275 | 28.43 | 5400.0 |
| 2016-12-13 07:30:00 | AAPL | Stock | 28.43 | 28.43 | 28.43 | 28.43 | 400.0 |
| 2016-12-13 07:40:00 | AAPL | Stock | 28.4275 | 28.4375 | 28.4275 | 28.4375 | 7476.0 |
| 2016-12-13 07:45:00 | AAPL | Stock | 28.4275 | 28.4275 | 28.41 | 28.41 | 2368.0 |
| 2016-12-13 08:00:00 | AAPL | Stock | 28.435 | 28.4375 | 28.325 | 28.425 | 91472.0 |
| 2016-12-13 08:05:00 | AAPL | Stock | 28.425 | 28.425 | 28.4025 | 28.41 | 13200.0 |
| 2016-12-13 08:10:00 | AAPL | Stock | 28.41 | 28.41 | 28.405 | 28.405 | 2000.0 |
| 2016-12-13 08:15:00 | AAPL | Stock | 28.42 | 28.42 | 28.41 | 28.41 | 8000.0 |
| 2016-12-13 08:20:00 | AAPL | Stock | 28.405 | 28.41 | 28.4 | 28.4 | 2936.0 |
| 2016-12-13 08:25:00 | AAPL | Stock | 28.41 | 28.42 | 28.4 | 28.42 | 30440.0 |
| 2016-12-13 08:30:00 | AAPL | Stock | 28.4 | 28.42 | 28.38 | 28.4025 | 30772.0 |
| 2016-12-13 08:40:00 | AAPL | Stock | 28.41 | 28.41 | 28.405 | 28.41 | 3680.0 |
| 2016-12-13 08:45:00 | AAPL | Stock | 28.4125 | 28.415 | 28.41 | 28.415 | 5808.0 |
| 2016-12-13 08:50:00 | AAPL | Stock | 28.4225 | 28.4425 | 28.4225 | 28.4375 | 21060.0 |
| 2016-12-13 08:55:00 | AAPL | Stock | 28.4175 | 28.42 | 28.4125 | 28.4125 | 17624.0 |
| 2016-12-13 09:00:00 | AAPL | Stock | 28.42 | 28.4375 | 28.42 | 28.435 | 18420.0 |
| 2016-12-13 09:05:00 | AAPL | Stock | 28.4375 | 28.44 | 28.43 | 28.435 | 19200.0 |
| 2016-12-13 09:10:00 | AAPL | Stock | 28.43 | 28.445 | 28.425 | 28.445 | 50124.0 |
| 2016-12-13 09:15:00 | AAPL | Stock | 28.4475 | 28.465 | 28.44 | 28.4425 | 43568.0 |
| 2016-12-13 09:20:00 | AAPL | Stock | 28.45 | 28.46 | 28.44 | 28.44 | 72524.0 |
| 2016-12-13 09:25:00 | AAPL | Stock | 28.4425 | 28.49 | 28.4375 | 28.4475 | 76640.0 |
| 2016-12-13 09:30:00 | AAPL | Stock | 28.445 | 28.5438 | 28.4375 | 28.4925 | 5287684.0 |
| 2016-12-13 09:35:00 | AAPL | Stock | 28.495 | 28.5825 | 28.475 | 28.5688 | 3299316.0 |
| 2016-12-13 09:40:00 | AAPL | Stock | 28.57 | 28.7375 | 28.5678 | 28.7 | 5230456.0 |
| 2016-12-13 09:45:00 | AAPL | Stock | 28.7025 | 28.7125 | 28.6575 | 28.685 | 2842820.0 |
| 2016-12-13 09:50:00 | AAPL | Stock | 28.6875 | 28.8075 | 28.6872 | 28.7725 | 7044988.0 |
| 2016-12-13 09:55:00 | AAPL | Stock | 28.771 | 28.79 | 28.7275 | 28.7732 | 2755908.0 |
| 2016-12-13 10:00:00 | AAPL | Stock | 28.7742 | 28.7775 | 28.7175 | 28.7225 | 2196252.0 |
| 2016-12-13 10:05:00 | AAPL | Stock | 28.72 | 28.78 | 28.71 | 28.78 | 2725228.0 |
| 2016-12-13 10:10:00 | AAPL | Stock | 28.782 | 28.8425 | 28.7675 | 28.815 | 3841760.0 |
| 2016-12-13 10:15:00 | AAPL | Stock | 28.8165 | 28.8375 | 28.76 | 28.76 | 2362140.0 |
| 2016-12-13 10:20:00 | AAPL | Stock | 28.7605 | 28.765 | 28.725 | 28.75 | 3187428.0 |
| 2016-12-13 10:25:00 | AAPL | Stock | 28.75 | 28.7925 | 28.7375 | 28.7688 | 2765828.0 |
| 2016-12-13 10:30:00 | AAPL | Stock | 28.7675 | 28.825 | 28.745 | 28.75 | 2449132.0 |
| 2016-12-13 10:35:00 | AAPL | Stock | 28.75 | 28.7825 | 28.7275 | 28.7725 | 1761504.0 |
| 2016-12-13 10:40:00 | AAPL | Stock | 28.7725 | 28.805 | 28.7475 | 28.75 | 1277004.0 |
| 2016-12-13 10:45:00 | AAPL | Stock | 28.75 | 28.762 | 28.705 | 28.745 | 2028088.0 |
| 2016-12-13 10:50:00 | AAPL | Stock | 28.747 | 28.76 | 28.725 | 28.7588 | 1479940.0 |
| 2016-12-13 10:55:00 | AAPL | Stock | 28.7575 | 28.785 | 28.7315 | 28.74 | 1628212.0 |
| 2016-12-13 11:00:00 | AAPL | Stock | 28.7412 | 28.7525 | 28.7225 | 28.7312 | 1064716.0 |
> showing 50 of 368,733 rows — these rows as CSV