PREVIEW / stock_5min / 2017-10-24
file: by_date/stock_5min/2017/2017-10-24.parquet size: 5.4 MB rows: 352,630 symbols: 2,936
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-10-24 04:00:00 | AAPL | Stock | 38.825 | 39.05 | 38.825 | 39.05 | 1200.0 |
| 2017-10-24 04:05:00 | AAPL | Stock | 39.0875 | 39.1375 | 39.0875 | 39.125 | 3200.0 |
| 2017-10-24 04:10:00 | AAPL | Stock | 39.125 | 39.125 | 39.125 | 39.125 | 2400.0 |
| 2017-10-24 04:15:00 | AAPL | Stock | 39.125 | 39.125 | 39.125 | 39.125 | 400.0 |
| 2017-10-24 04:20:00 | AAPL | Stock | 39.125 | 39.1875 | 39.125 | 39.1875 | 5520.0 |
| 2017-10-24 04:25:00 | AAPL | Stock | 39.125 | 39.125 | 39.125 | 39.125 | 14968.0 |
| 2017-10-24 04:30:00 | AAPL | Stock | 39.125 | 39.125 | 39.125 | 39.125 | 4000.0 |
| 2017-10-24 04:35:00 | AAPL | Stock | 39.125 | 39.125 | 39.125 | 39.125 | 800.0 |
| 2017-10-24 04:40:00 | AAPL | Stock | 39.125 | 39.125 | 39.1125 | 39.1125 | 3600.0 |
| 2017-10-24 05:15:00 | AAPL | Stock | 39.1125 | 39.1875 | 39.1125 | 39.1875 | 9768.0 |
| 2017-10-24 05:30:00 | AAPL | Stock | 39.1725 | 39.185 | 39.1725 | 39.185 | 3700.0 |
| 2017-10-24 05:45:00 | AAPL | Stock | 39.085 | 39.085 | 38.9 | 38.9 | 45660.0 |
| 2017-10-24 05:50:00 | AAPL | Stock | 38.925 | 38.925 | 38.85 | 38.85 | 3944.0 |
| 2017-10-24 05:55:00 | AAPL | Stock | 38.865 | 38.865 | 38.775 | 38.775 | 23272.0 |
| 2017-10-24 06:00:00 | AAPL | Stock | 38.7625 | 38.825 | 38.75 | 38.825 | 7052.0 |
| 2017-10-24 06:05:00 | AAPL | Stock | 38.7575 | 38.765 | 38.7325 | 38.7325 | 16460.0 |
| 2017-10-24 06:10:00 | AAPL | Stock | 38.7325 | 38.75 | 38.7325 | 38.75 | 4400.0 |
| 2017-10-24 06:15:00 | AAPL | Stock | 38.82 | 38.825 | 38.75 | 38.8125 | 18000.0 |
| 2017-10-24 06:20:00 | AAPL | Stock | 38.8 | 38.8 | 38.8 | 38.8 | 2800.0 |
| 2017-10-24 06:25:00 | AAPL | Stock | 38.8 | 38.8 | 38.8 | 38.8 | 1984.0 |
| 2017-10-24 06:30:00 | AAPL | Stock | 38.825 | 38.825 | 38.825 | 38.825 | 400.0 |
| 2017-10-24 06:35:00 | AAPL | Stock | 38.825 | 38.825 | 38.82 | 38.82 | 976.0 |
| 2017-10-24 06:40:00 | AAPL | Stock | 38.82 | 38.8875 | 38.82 | 38.8375 | 10984.0 |
| 2017-10-24 06:45:00 | AAPL | Stock | 38.87 | 38.885 | 38.87 | 38.885 | 5600.0 |
| 2017-10-24 06:50:00 | AAPL | Stock | 38.885 | 38.9 | 38.885 | 38.9 | 14400.0 |
| 2017-10-24 06:55:00 | AAPL | Stock | 38.9 | 38.9325 | 38.9 | 38.9325 | 13844.0 |
| 2017-10-24 07:00:00 | AAPL | Stock | 38.925 | 38.9875 | 38.925 | 38.97 | 22000.0 |
| 2017-10-24 07:05:00 | AAPL | Stock | 38.985 | 39.04 | 38.985 | 39.0 | 25628.0 |
| 2017-10-24 07:10:00 | AAPL | Stock | 39.0 | 39.0 | 38.975 | 39.0 | 46220.0 |
| 2017-10-24 07:15:00 | AAPL | Stock | 38.975 | 38.975 | 38.975 | 38.975 | 4388.0 |
| 2017-10-24 07:20:00 | AAPL | Stock | 39.0 | 39.0 | 39.0 | 39.0 | 4000.0 |
| 2017-10-24 07:25:00 | AAPL | Stock | 39.0 | 39.025 | 39.0 | 39.0 | 25864.0 |
| 2017-10-24 07:30:00 | AAPL | Stock | 39.0 | 39.0025 | 38.97 | 39.0025 | 25360.0 |
| 2017-10-24 07:35:00 | AAPL | Stock | 39.005 | 39.0125 | 39.0 | 39.0 | 20496.0 |
| 2017-10-24 07:40:00 | AAPL | Stock | 39.02 | 39.025 | 39.0 | 39.0 | 23040.0 |
| 2017-10-24 07:45:00 | AAPL | Stock | 39.0 | 39.025 | 39.0 | 39.0075 | 16400.0 |
| 2017-10-24 07:50:00 | AAPL | Stock | 39.0125 | 39.0125 | 38.9875 | 38.9875 | 16768.0 |
| 2017-10-24 07:55:00 | AAPL | Stock | 38.9875 | 39.0125 | 38.9875 | 39.0125 | 8208.0 |
| 2017-10-24 08:00:00 | AAPL | Stock | 39.02 | 39.0325 | 38.9162 | 39.0125 | 91608.0 |
| 2017-10-24 08:05:00 | AAPL | Stock | 39.0225 | 39.05 | 39.01 | 39.01 | 50544.0 |
| 2017-10-24 08:10:00 | AAPL | Stock | 39.01 | 39.07 | 39.01 | 39.07 | 78596.0 |
| 2017-10-24 08:15:00 | AAPL | Stock | 39.0525 | 39.085 | 39.05 | 39.06 | 21176.0 |
| 2017-10-24 08:20:00 | AAPL | Stock | 39.06 | 39.075 | 39.05 | 39.0525 | 22364.0 |
| 2017-10-24 08:25:00 | AAPL | Stock | 39.06 | 39.085 | 39.04 | 39.085 | 59376.0 |
| 2017-10-24 08:30:00 | AAPL | Stock | 39.0875 | 39.1125 | 39.0875 | 39.1125 | 39316.0 |
| 2017-10-24 08:35:00 | AAPL | Stock | 39.1125 | 39.175 | 39.1125 | 39.175 | 167876.0 |
| 2017-10-24 08:40:00 | AAPL | Stock | 39.1425 | 39.1625 | 39.1275 | 39.1275 | 17436.0 |
| 2017-10-24 08:45:00 | AAPL | Stock | 39.145 | 39.1975 | 39.1375 | 39.15 | 56040.0 |
| 2017-10-24 08:50:00 | AAPL | Stock | 39.1525 | 39.165 | 39.1525 | 39.155 | 13696.0 |
| 2017-10-24 08:55:00 | AAPL | Stock | 39.155 | 39.1675 | 39.15 | 39.155 | 17936.0 |
> showing 50 of 352,630 rows — these rows as CSV