PREVIEW / stock_5min / 2016-11-15
file: by_date/stock_5min/2016/2016-11-15.parquet size: 5.6 MB rows: 368,123 symbols: 3,197
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-15 04:30:00 | AAPL | Stock | 26.4675 | 26.4675 | 26.4675 | 26.4675 | 1680.0 |
| 2016-11-15 06:15:00 | AAPL | Stock | 26.475 | 26.475 | 26.475 | 26.475 | 512.0 |
| 2016-11-15 06:25:00 | AAPL | Stock | 26.4375 | 26.45 | 26.4375 | 26.45 | 3200.0 |
| 2016-11-15 06:35:00 | AAPL | Stock | 26.4725 | 26.4825 | 26.4725 | 26.4825 | 19928.0 |
| 2016-11-15 06:40:00 | AAPL | Stock | 26.4725 | 26.4725 | 26.4575 | 26.4575 | 9668.0 |
| 2016-11-15 06:45:00 | AAPL | Stock | 26.4825 | 26.4825 | 26.4825 | 26.4825 | 920.0 |
| 2016-11-15 06:55:00 | AAPL | Stock | 26.4625 | 26.4625 | 26.4625 | 26.4625 | 2544.0 |
| 2016-11-15 07:00:00 | AAPL | Stock | 26.47 | 26.47 | 26.4 | 26.4 | 9720.0 |
| 2016-11-15 07:05:00 | AAPL | Stock | 26.41 | 26.41 | 26.4 | 26.4 | 3236.0 |
| 2016-11-15 07:10:00 | AAPL | Stock | 26.45 | 26.45 | 26.45 | 26.45 | 800.0 |
| 2016-11-15 07:15:00 | AAPL | Stock | 26.45 | 26.45 | 26.45 | 26.45 | 3800.0 |
| 2016-11-15 07:25:00 | AAPL | Stock | 26.5 | 26.5 | 26.5 | 26.5 | 1200.0 |
| 2016-11-15 07:30:00 | AAPL | Stock | 26.4875 | 26.495 | 26.4875 | 26.495 | 4840.0 |
| 2016-11-15 07:35:00 | AAPL | Stock | 26.45 | 26.4625 | 26.45 | 26.45 | 21708.0 |
| 2016-11-15 07:40:00 | AAPL | Stock | 26.45 | 26.45 | 26.45 | 26.45 | 476.0 |
| 2016-11-15 07:55:00 | AAPL | Stock | 26.425 | 26.4375 | 26.4025 | 26.4375 | 3600.0 |
| 2016-11-15 08:00:00 | AAPL | Stock | 26.45 | 26.45 | 26.4025 | 26.4275 | 54468.0 |
| 2016-11-15 08:05:00 | AAPL | Stock | 26.4275 | 26.47 | 26.425 | 26.45 | 28716.0 |
| 2016-11-15 08:10:00 | AAPL | Stock | 26.45 | 26.49 | 26.45 | 26.4875 | 13100.0 |
| 2016-11-15 08:15:00 | AAPL | Stock | 26.49 | 26.5275 | 26.49 | 26.5275 | 40716.0 |
| 2016-11-15 08:20:00 | AAPL | Stock | 26.5375 | 26.5625 | 26.5375 | 26.5625 | 35148.0 |
| 2016-11-15 08:25:00 | AAPL | Stock | 26.575 | 26.6 | 26.575 | 26.6 | 16016.0 |
| 2016-11-15 08:30:00 | AAPL | Stock | 26.58 | 26.625 | 26.575 | 26.625 | 23408.0 |
| 2016-11-15 08:35:00 | AAPL | Stock | 26.6375 | 26.6625 | 26.5375 | 26.625 | 99040.0 |
| 2016-11-15 08:40:00 | AAPL | Stock | 26.625 | 26.65 | 26.5875 | 26.65 | 15480.0 |
| 2016-11-15 08:45:00 | AAPL | Stock | 26.6475 | 26.675 | 26.6375 | 26.675 | 57796.0 |
| 2016-11-15 08:50:00 | AAPL | Stock | 26.6675 | 26.675 | 26.6525 | 26.6625 | 14076.0 |
| 2016-11-15 08:55:00 | AAPL | Stock | 26.67 | 26.6725 | 26.6525 | 26.665 | 30280.0 |
| 2016-11-15 09:00:00 | AAPL | Stock | 26.6675 | 26.6725 | 26.605 | 26.62 | 56992.0 |
| 2016-11-15 09:05:00 | AAPL | Stock | 26.62 | 26.645 | 26.6 | 26.645 | 30592.0 |
| 2016-11-15 09:10:00 | AAPL | Stock | 26.6425 | 26.645 | 26.625 | 26.6375 | 66516.0 |
| 2016-11-15 09:15:00 | AAPL | Stock | 26.65 | 26.655 | 26.635 | 26.635 | 39440.0 |
| 2016-11-15 09:20:00 | AAPL | Stock | 26.645 | 26.655 | 26.6425 | 26.65 | 91620.0 |
| 2016-11-15 09:25:00 | AAPL | Stock | 26.65 | 26.6625 | 26.6125 | 26.635 | 124372.0 |
| 2016-11-15 09:30:00 | AAPL | Stock | 26.6425 | 26.72 | 26.5398 | 26.6025 | 5639092.0 |
| 2016-11-15 09:35:00 | AAPL | Stock | 26.605 | 26.775 | 26.605 | 26.7172 | 4086680.0 |
| 2016-11-15 09:40:00 | AAPL | Stock | 26.7175 | 26.825 | 26.705 | 26.755 | 3360808.0 |
| 2016-11-15 09:45:00 | AAPL | Stock | 26.7475 | 26.7675 | 26.705 | 26.7125 | 2273112.0 |
| 2016-11-15 09:50:00 | AAPL | Stock | 26.7125 | 26.7198 | 26.6275 | 26.6812 | 3796860.0 |
| 2016-11-15 09:55:00 | AAPL | Stock | 26.6825 | 26.745 | 26.675 | 26.7425 | 2330604.0 |
| 2016-11-15 10:00:00 | AAPL | Stock | 26.7412 | 26.8425 | 26.7325 | 26.825 | 3486836.0 |
| 2016-11-15 10:05:00 | AAPL | Stock | 26.825 | 26.865 | 26.82 | 26.8525 | 2711904.0 |
| 2016-11-15 10:10:00 | AAPL | Stock | 26.855 | 26.9 | 26.8525 | 26.875 | 3075236.0 |
| 2016-11-15 10:15:00 | AAPL | Stock | 26.8775 | 26.92 | 26.8675 | 26.88 | 2176976.0 |
| 2016-11-15 10:20:00 | AAPL | Stock | 26.88 | 26.9075 | 26.845 | 26.8825 | 2044772.0 |
| 2016-11-15 10:25:00 | AAPL | Stock | 26.8825 | 26.895 | 26.755 | 26.7825 | 2242940.0 |
| 2016-11-15 10:30:00 | AAPL | Stock | 26.7825 | 26.79 | 26.705 | 26.7262 | 2180372.0 |
| 2016-11-15 10:35:00 | AAPL | Stock | 26.7275 | 26.7375 | 26.6925 | 26.705 | 2440972.0 |
| 2016-11-15 10:40:00 | AAPL | Stock | 26.705 | 26.72 | 26.6825 | 26.6975 | 1497972.0 |
| 2016-11-15 10:45:00 | AAPL | Stock | 26.6975 | 26.7375 | 26.6912 | 26.7212 | 1453024.0 |
> showing 50 of 368,123 rows — these rows as CSV