PREVIEW / stock_5min / 2018-02-26
file: by_date/stock_5min/2018/2018-02-26.parquet size: 5.6 MB rows: 361,470 symbols: 2,895
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 |
|---|---|---|---|---|---|---|---|
| 2018-02-26 04:00:00 | AAPL | Stock | 44.0 | 44.0 | 44.0 | 44.0 | 3260.0 |
| 2018-02-26 04:10:00 | AAPL | Stock | 44.0375 | 44.0375 | 44.0375 | 44.0375 | 8008.0 |
| 2018-02-26 04:15:00 | AAPL | Stock | 44.0375 | 44.0375 | 44.0375 | 44.0375 | 1120.0 |
| 2018-02-26 04:20:00 | AAPL | Stock | 44.0375 | 44.0375 | 44.0375 | 44.0375 | 400.0 |
| 2018-02-26 04:35:00 | AAPL | Stock | 44.0475 | 44.0475 | 44.0475 | 44.0475 | 640.0 |
| 2018-02-26 04:40:00 | AAPL | Stock | 44.0475 | 44.0475 | 44.0475 | 44.0475 | 800.0 |
| 2018-02-26 04:45:00 | AAPL | Stock | 44.0425 | 44.05 | 44.0425 | 44.05 | 9072.0 |
| 2018-02-26 04:50:00 | AAPL | Stock | 44.025 | 44.025 | 44.025 | 44.025 | 400.0 |
| 2018-02-26 05:00:00 | AAPL | Stock | 44.02 | 44.02 | 44.02 | 44.02 | 1312.0 |
| 2018-02-26 05:05:00 | AAPL | Stock | 44.02 | 44.02 | 44.02 | 44.02 | 2400.0 |
| 2018-02-26 05:10:00 | AAPL | Stock | 44.0 | 44.0375 | 44.0 | 44.0375 | 5548.0 |
| 2018-02-26 05:15:00 | AAPL | Stock | 44.0375 | 44.045 | 44.0375 | 44.045 | 6800.0 |
| 2018-02-26 05:25:00 | AAPL | Stock | 44.035 | 44.035 | 44.0025 | 44.0025 | 3060.0 |
| 2018-02-26 05:30:00 | AAPL | Stock | 44.0025 | 44.0025 | 43.9825 | 43.9825 | 1840.0 |
| 2018-02-26 05:35:00 | AAPL | Stock | 44.0 | 44.0 | 44.0 | 44.0 | 800.0 |
| 2018-02-26 05:40:00 | AAPL | Stock | 44.0125 | 44.0125 | 44.0125 | 44.0125 | 400.0 |
| 2018-02-26 05:50:00 | AAPL | Stock | 44.0075 | 44.0075 | 44.0075 | 44.0075 | 1600.0 |
| 2018-02-26 05:55:00 | AAPL | Stock | 44.0125 | 44.0125 | 44.0125 | 44.0125 | 2800.0 |
| 2018-02-26 06:00:00 | AAPL | Stock | 44.0 | 44.0 | 44.0 | 44.0 | 2968.0 |
| 2018-02-26 06:05:00 | AAPL | Stock | 44.0225 | 44.05 | 44.0225 | 44.05 | 7832.0 |
| 2018-02-26 06:10:00 | AAPL | Stock | 44.025 | 44.025 | 44.025 | 44.025 | 11200.0 |
| 2018-02-26 06:15:00 | AAPL | Stock | 44.025 | 44.025 | 44.0 | 44.0 | 8292.0 |
| 2018-02-26 06:20:00 | AAPL | Stock | 44.0 | 44.0 | 43.9775 | 43.9775 | 2800.0 |
| 2018-02-26 06:25:00 | AAPL | Stock | 44.015 | 44.015 | 44.015 | 44.015 | 1600.0 |
| 2018-02-26 06:30:00 | AAPL | Stock | 44.0 | 44.0 | 44.0 | 44.0 | 3256.0 |
| 2018-02-26 06:40:00 | AAPL | Stock | 44.0 | 44.0 | 44.0 | 44.0 | 1820.0 |
| 2018-02-26 06:45:00 | AAPL | Stock | 43.9775 | 44.0 | 43.9775 | 44.0 | 6800.0 |
| 2018-02-26 06:50:00 | AAPL | Stock | 44.0175 | 44.0175 | 44.0175 | 44.0175 | 1200.0 |
| 2018-02-26 06:55:00 | AAPL | Stock | 44.0125 | 44.02 | 43.99 | 44.02 | 28000.0 |
| 2018-02-26 07:00:00 | AAPL | Stock | 44.0 | 44.0475 | 43.99 | 44.0475 | 43532.0 |
| 2018-02-26 07:05:00 | AAPL | Stock | 44.0475 | 44.06 | 44.035 | 44.05 | 43528.0 |
| 2018-02-26 07:10:00 | AAPL | Stock | 44.0575 | 44.06 | 44.0225 | 44.0225 | 26532.0 |
| 2018-02-26 07:15:00 | AAPL | Stock | 44.0125 | 44.025 | 44.0 | 44.025 | 26932.0 |
| 2018-02-26 07:20:00 | AAPL | Stock | 44.04 | 44.04 | 44.025 | 44.0375 | 7480.0 |
| 2018-02-26 07:25:00 | AAPL | Stock | 44.0325 | 44.045 | 44.0075 | 44.0075 | 12492.0 |
| 2018-02-26 07:30:00 | AAPL | Stock | 44.0025 | 44.0375 | 44.0025 | 44.035 | 21412.0 |
| 2018-02-26 07:35:00 | AAPL | Stock | 44.0375 | 44.05 | 44.025 | 44.045 | 16280.0 |
| 2018-02-26 07:40:00 | AAPL | Stock | 44.03 | 44.0475 | 44.0275 | 44.0475 | 16800.0 |
| 2018-02-26 07:45:00 | AAPL | Stock | 44.0425 | 44.0625 | 44.0425 | 44.0625 | 18240.0 |
| 2018-02-26 07:50:00 | AAPL | Stock | 44.075 | 44.1 | 44.06 | 44.1 | 92192.0 |
| 2018-02-26 07:55:00 | AAPL | Stock | 44.1 | 44.1075 | 44.09 | 44.1075 | 61120.0 |
| 2018-02-26 08:00:00 | AAPL | Stock | 44.11 | 44.125 | 44.0175 | 44.125 | 199672.0 |
| 2018-02-26 08:05:00 | AAPL | Stock | 44.1325 | 44.15 | 44.125 | 44.125 | 77412.0 |
| 2018-02-26 08:10:00 | AAPL | Stock | 44.1375 | 44.1375 | 44.1075 | 44.13 | 45232.0 |
| 2018-02-26 08:15:00 | AAPL | Stock | 44.1075 | 44.13 | 44.1075 | 44.12 | 19740.0 |
| 2018-02-26 08:20:00 | AAPL | Stock | 44.115 | 44.1225 | 44.0925 | 44.115 | 37324.0 |
| 2018-02-26 08:25:00 | AAPL | Stock | 44.1025 | 44.115 | 44.075 | 44.075 | 38368.0 |
| 2018-02-26 08:30:00 | AAPL | Stock | 44.0675 | 44.0875 | 44.065 | 44.0875 | 20472.0 |
| 2018-02-26 08:35:00 | AAPL | Stock | 44.1075 | 44.11 | 44.1 | 44.11 | 6024.0 |
| 2018-02-26 08:40:00 | AAPL | Stock | 44.11 | 44.125 | 44.1 | 44.1225 | 47712.0 |
> showing 50 of 361,470 rows — these rows as CSV