PREVIEW / stock_5min / 2016-09-07
file: by_date/stock_5min/2016/2016-09-07.parquet size: 5.4 MB rows: 359,176 symbols: 3,264
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-09-07 04:00:00 | AAPL | Stock | 26.9875 | 26.9875 | 26.9875 | 26.9875 | 1600.0 |
| 2016-09-07 04:15:00 | AAPL | Stock | 26.995 | 26.995 | 26.995 | 26.995 | 800.0 |
| 2016-09-07 04:35:00 | AAPL | Stock | 26.995 | 26.995 | 26.995 | 26.995 | 800.0 |
| 2016-09-07 05:20:00 | AAPL | Stock | 26.995 | 26.995 | 26.995 | 26.995 | 1600.0 |
| 2016-09-07 05:30:00 | AAPL | Stock | 27.0175 | 27.0525 | 27.0175 | 27.0525 | 3600.0 |
| 2016-09-07 05:45:00 | AAPL | Stock | 27.03 | 27.03 | 27.03 | 27.03 | 800.0 |
| 2016-09-07 05:55:00 | AAPL | Stock | 27.0475 | 27.0475 | 27.0475 | 27.0475 | 400.0 |
| 2016-09-07 06:20:00 | AAPL | Stock | 27.0325 | 27.0425 | 27.02 | 27.025 | 6228.0 |
| 2016-09-07 06:25:00 | AAPL | Stock | 27.0425 | 27.0525 | 27.04 | 27.0525 | 32956.0 |
| 2016-09-07 06:30:00 | AAPL | Stock | 27.055 | 27.07 | 27.055 | 27.07 | 3360.0 |
| 2016-09-07 06:40:00 | AAPL | Stock | 27.0675 | 27.0675 | 27.0675 | 27.0675 | 400.0 |
| 2016-09-07 06:55:00 | AAPL | Stock | 27.0625 | 27.0675 | 27.0625 | 27.0675 | 6256.0 |
| 2016-09-07 07:00:00 | AAPL | Stock | 27.0675 | 27.0675 | 27.02 | 27.02 | 29944.0 |
| 2016-09-07 07:10:00 | AAPL | Stock | 27.025 | 27.0375 | 27.02 | 27.025 | 24720.0 |
| 2016-09-07 07:15:00 | AAPL | Stock | 27.03 | 27.035 | 27.0 | 27.0 | 25824.0 |
| 2016-09-07 07:20:00 | AAPL | Stock | 27.0 | 27.0225 | 27.0 | 27.0225 | 800.0 |
| 2016-09-07 07:25:00 | AAPL | Stock | 26.975 | 26.975 | 26.975 | 26.975 | 12880.0 |
| 2016-09-07 07:30:00 | AAPL | Stock | 26.995 | 27.0 | 26.995 | 27.0 | 5080.0 |
| 2016-09-07 07:35:00 | AAPL | Stock | 27.01 | 27.01 | 27.01 | 27.01 | 1600.0 |
| 2016-09-07 07:40:00 | AAPL | Stock | 27.01 | 27.0125 | 27.01 | 27.0125 | 8400.0 |
| 2016-09-07 07:45:00 | AAPL | Stock | 27.0125 | 27.0125 | 27.01 | 27.01 | 3900.0 |
| 2016-09-07 07:50:00 | AAPL | Stock | 27.0 | 27.0 | 26.9875 | 26.995 | 20172.0 |
| 2016-09-07 07:55:00 | AAPL | Stock | 26.995 | 27.0 | 26.9775 | 26.9775 | 24260.0 |
| 2016-09-07 08:00:00 | AAPL | Stock | 27.0625 | 27.0625 | 26.9725 | 26.975 | 114336.0 |
| 2016-09-07 08:05:00 | AAPL | Stock | 26.975 | 26.975 | 26.9725 | 26.975 | 8040.0 |
| 2016-09-07 08:10:00 | AAPL | Stock | 26.9725 | 26.975 | 26.9725 | 26.975 | 8832.0 |
| 2016-09-07 08:15:00 | AAPL | Stock | 26.97 | 26.98 | 26.97 | 26.98 | 6000.0 |
| 2016-09-07 08:20:00 | AAPL | Stock | 26.975 | 26.975 | 26.965 | 26.9725 | 23844.0 |
| 2016-09-07 08:25:00 | AAPL | Stock | 26.965 | 26.98 | 26.965 | 26.98 | 6364.0 |
| 2016-09-07 08:30:00 | AAPL | Stock | 26.9675 | 26.975 | 26.965 | 26.975 | 37492.0 |
| 2016-09-07 08:35:00 | AAPL | Stock | 26.975 | 26.985 | 26.9625 | 26.9725 | 31548.0 |
| 2016-09-07 08:40:00 | AAPL | Stock | 26.97 | 26.97 | 26.95 | 26.965 | 34924.0 |
| 2016-09-07 08:45:00 | AAPL | Stock | 26.9625 | 26.9725 | 26.9575 | 26.97 | 19148.0 |
| 2016-09-07 08:50:00 | AAPL | Stock | 26.965 | 26.9725 | 26.9625 | 26.9725 | 24260.0 |
| 2016-09-07 08:55:00 | AAPL | Stock | 26.9725 | 26.9725 | 26.97 | 26.97 | 15592.0 |
| 2016-09-07 09:00:00 | AAPL | Stock | 26.97 | 26.97 | 26.95 | 26.965 | 28088.0 |
| 2016-09-07 09:05:00 | AAPL | Stock | 26.9675 | 26.9675 | 26.9575 | 26.965 | 27652.0 |
| 2016-09-07 09:10:00 | AAPL | Stock | 26.965 | 26.97 | 26.96 | 26.97 | 25764.0 |
| 2016-09-07 09:15:00 | AAPL | Stock | 26.9675 | 26.9675 | 26.9425 | 26.955 | 51512.0 |
| 2016-09-07 09:20:00 | AAPL | Stock | 26.965 | 26.9675 | 26.955 | 26.955 | 25320.0 |
| 2016-09-07 09:25:00 | AAPL | Stock | 26.9675 | 26.97 | 26.9675 | 26.97 | 31616.0 |
| 2016-09-07 09:30:00 | AAPL | Stock | 26.9625 | 26.9975 | 26.94 | 26.985 | 3815900.0 |
| 2016-09-07 09:35:00 | AAPL | Stock | 26.9875 | 27.0 | 26.9625 | 26.9712 | 2199560.0 |
| 2016-09-07 09:40:00 | AAPL | Stock | 26.9712 | 26.9925 | 26.955 | 26.98 | 1966376.0 |
| 2016-09-07 09:45:00 | AAPL | Stock | 26.9785 | 26.9925 | 26.96 | 26.9625 | 1379324.0 |
| 2016-09-07 09:50:00 | AAPL | Stock | 26.9615 | 26.9615 | 26.895 | 26.9062 | 2873016.0 |
| 2016-09-07 09:55:00 | AAPL | Stock | 26.905 | 26.915 | 26.8725 | 26.8825 | 1831520.0 |
| 2016-09-07 10:00:00 | AAPL | Stock | 26.885 | 26.9325 | 26.885 | 26.9125 | 1593440.0 |
| 2016-09-07 10:05:00 | AAPL | Stock | 26.91 | 26.925 | 26.89 | 26.9075 | 1344920.0 |
| 2016-09-07 10:10:00 | AAPL | Stock | 26.9075 | 26.9475 | 26.9045 | 26.9352 | 1484816.0 |
> showing 50 of 359,176 rows — these rows as CSV