PREVIEW / stock_5min / 2016-11-23
file: by_date/stock_5min/2016/2016-11-23.parquet size: 5.4 MB rows: 353,586 symbols: 3,170
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-11-23 04:00:00 | AAPL | Stock | 27.9475 | 27.9475 | 27.9475 | 27.9475 | 800.0 |
| 2016-11-23 04:20:00 | AAPL | Stock | 27.9425 | 27.945 | 27.9425 | 27.945 | 1600.0 |
| 2016-11-23 04:25:00 | AAPL | Stock | 27.9175 | 27.93 | 27.9175 | 27.93 | 1200.0 |
| 2016-11-23 04:30:00 | AAPL | Stock | 27.93 | 27.95 | 27.93 | 27.95 | 2852.0 |
| 2016-11-23 04:50:00 | AAPL | Stock | 27.925 | 27.925 | 27.925 | 27.925 | 2084.0 |
| 2016-11-23 05:00:00 | AAPL | Stock | 27.925 | 27.925 | 27.925 | 27.925 | 2400.0 |
| 2016-11-23 05:20:00 | AAPL | Stock | 27.925 | 27.925 | 27.925 | 27.925 | 400.0 |
| 2016-11-23 05:25:00 | AAPL | Stock | 27.925 | 27.925 | 27.925 | 27.925 | 640.0 |
| 2016-11-23 05:35:00 | AAPL | Stock | 27.9 | 27.9 | 27.9 | 27.9 | 548.0 |
| 2016-11-23 07:00:00 | AAPL | Stock | 27.9475 | 27.9475 | 27.9475 | 27.9475 | 1420.0 |
| 2016-11-23 07:05:00 | AAPL | Stock | 27.975 | 27.975 | 27.975 | 27.975 | 1056.0 |
| 2016-11-23 07:10:00 | AAPL | Stock | 27.95 | 27.95 | 27.95 | 27.95 | 400.0 |
| 2016-11-23 07:20:00 | AAPL | Stock | 27.95 | 27.95 | 27.95 | 27.95 | 800.0 |
| 2016-11-23 07:35:00 | AAPL | Stock | 27.93 | 27.93 | 27.93 | 27.93 | 1600.0 |
| 2016-11-23 07:40:00 | AAPL | Stock | 27.93 | 27.93 | 27.93 | 27.93 | 400.0 |
| 2016-11-23 08:00:00 | AAPL | Stock | 27.95 | 27.9525 | 27.9375 | 27.95 | 10684.0 |
| 2016-11-23 08:05:00 | AAPL | Stock | 27.95 | 27.95 | 27.9375 | 27.9375 | 800.0 |
| 2016-11-23 08:10:00 | AAPL | Stock | 27.9375 | 27.9375 | 27.9375 | 27.9375 | 1200.0 |
| 2016-11-23 08:15:00 | AAPL | Stock | 27.9375 | 27.9375 | 27.9375 | 27.9375 | 400.0 |
| 2016-11-23 08:20:00 | AAPL | Stock | 27.9375 | 27.94 | 27.925 | 27.925 | 6200.0 |
| 2016-11-23 08:25:00 | AAPL | Stock | 27.9175 | 27.9175 | 27.9 | 27.9 | 32792.0 |
| 2016-11-23 08:30:00 | AAPL | Stock | 27.885 | 27.9125 | 27.88 | 27.8975 | 22740.0 |
| 2016-11-23 08:35:00 | AAPL | Stock | 27.88 | 27.8875 | 27.875 | 27.8775 | 22272.0 |
| 2016-11-23 08:40:00 | AAPL | Stock | 27.9 | 27.9 | 27.8875 | 27.8875 | 1720.0 |
| 2016-11-23 08:45:00 | AAPL | Stock | 27.9 | 27.9 | 27.9 | 27.9 | 780.0 |
| 2016-11-23 08:50:00 | AAPL | Stock | 27.8875 | 27.8875 | 27.8875 | 27.8875 | 2000.0 |
| 2016-11-23 08:55:00 | AAPL | Stock | 27.8825 | 27.8825 | 27.8625 | 27.875 | 13172.0 |
| 2016-11-23 09:00:00 | AAPL | Stock | 27.8875 | 27.9 | 27.8825 | 27.9 | 5400.0 |
| 2016-11-23 09:05:00 | AAPL | Stock | 27.8975 | 27.915 | 27.875 | 27.875 | 61628.0 |
| 2016-11-23 09:10:00 | AAPL | Stock | 27.875 | 27.875 | 27.8675 | 27.8675 | 63716.0 |
| 2016-11-23 09:15:00 | AAPL | Stock | 27.85 | 27.85 | 27.85 | 27.85 | 1860.0 |
| 2016-11-23 09:20:00 | AAPL | Stock | 27.85 | 27.85 | 27.8375 | 27.8375 | 43268.0 |
| 2016-11-23 09:25:00 | AAPL | Stock | 27.84 | 27.86 | 27.8375 | 27.845 | 20596.0 |
| 2016-11-23 09:30:00 | AAPL | Stock | 27.84 | 27.8775 | 27.7752 | 27.8225 | 4767760.0 |
| 2016-11-23 09:35:00 | AAPL | Stock | 27.82 | 27.8475 | 27.7375 | 27.7375 | 2678748.0 |
| 2016-11-23 09:40:00 | AAPL | Stock | 27.7375 | 27.765 | 27.71 | 27.7375 | 2417308.0 |
| 2016-11-23 09:45:00 | AAPL | Stock | 27.735 | 27.75 | 27.6825 | 27.7288 | 1815192.0 |
| 2016-11-23 09:50:00 | AAPL | Stock | 27.7278 | 27.7388 | 27.7008 | 27.7325 | 1239404.0 |
| 2016-11-23 09:55:00 | AAPL | Stock | 27.7305 | 27.7825 | 27.7112 | 27.735 | 1634120.0 |
| 2016-11-23 10:00:00 | AAPL | Stock | 27.735 | 27.7675 | 27.735 | 27.7625 | 1763132.0 |
| 2016-11-23 10:05:00 | AAPL | Stock | 27.7575 | 27.7625 | 27.7175 | 27.7238 | 2597260.0 |
| 2016-11-23 10:10:00 | AAPL | Stock | 27.7238 | 27.7275 | 27.67 | 27.6738 | 1587472.0 |
| 2016-11-23 10:15:00 | AAPL | Stock | 27.675 | 27.725 | 27.6675 | 27.71 | 1345068.0 |
| 2016-11-23 10:20:00 | AAPL | Stock | 27.709 | 27.7188 | 27.688 | 27.6975 | 1271880.0 |
| 2016-11-23 10:25:00 | AAPL | Stock | 27.6975 | 27.7025 | 27.6412 | 27.6595 | 1497568.0 |
| 2016-11-23 10:30:00 | AAPL | Stock | 27.66 | 27.69 | 27.6575 | 27.6652 | 1119548.0 |
| 2016-11-23 10:35:00 | AAPL | Stock | 27.665 | 27.6662 | 27.6325 | 27.64 | 1481048.0 |
| 2016-11-23 10:40:00 | AAPL | Stock | 27.64 | 27.64 | 27.615 | 27.6225 | 1110244.0 |
| 2016-11-23 10:45:00 | AAPL | Stock | 27.625 | 27.6312 | 27.6 | 27.6185 | 1064952.0 |
| 2016-11-23 10:50:00 | AAPL | Stock | 27.62 | 27.6275 | 27.61 | 27.618 | 959164.0 |
> showing 50 of 353,586 rows — these rows as CSV