PREVIEW / stock_5min / 2018-11-15
file: by_date/stock_5min/2018/2018-11-15.parquet size: 5.8 MB rows: 363,640 symbols: 2,756
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-11-15 04:00:00 | AAPL | Stock | 47.0 | 47.0 | 46.9 | 46.9725 | 6820.0 |
| 2018-11-15 04:05:00 | AAPL | Stock | 46.975 | 47.15 | 46.975 | 47.0 | 6400.0 |
| 2018-11-15 04:10:00 | AAPL | Stock | 47.0625 | 47.0625 | 47.0625 | 47.0625 | 2800.0 |
| 2018-11-15 04:15:00 | AAPL | Stock | 47.025 | 47.0275 | 46.965 | 46.965 | 3200.0 |
| 2018-11-15 04:20:00 | AAPL | Stock | 46.935 | 47.0475 | 46.93 | 47.0425 | 5820.0 |
| 2018-11-15 04:30:00 | AAPL | Stock | 46.9375 | 46.9375 | 46.9375 | 46.9375 | 400.0 |
| 2018-11-15 04:45:00 | AAPL | Stock | 46.8375 | 46.8375 | 46.8375 | 46.8375 | 400.0 |
| 2018-11-15 04:50:00 | AAPL | Stock | 46.835 | 46.835 | 46.835 | 46.835 | 400.0 |
| 2018-11-15 05:00:00 | AAPL | Stock | 46.7525 | 46.7525 | 46.75 | 46.75 | 800.0 |
| 2018-11-15 05:15:00 | AAPL | Stock | 46.79 | 46.925 | 46.79 | 46.925 | 9760.0 |
| 2018-11-15 05:20:00 | AAPL | Stock | 46.9225 | 46.925 | 46.9225 | 46.925 | 4000.0 |
| 2018-11-15 05:25:00 | AAPL | Stock | 46.925 | 46.93 | 46.925 | 46.925 | 3600.0 |
| 2018-11-15 05:35:00 | AAPL | Stock | 46.9225 | 46.94 | 46.9225 | 46.94 | 4280.0 |
| 2018-11-15 05:40:00 | AAPL | Stock | 46.95 | 46.95 | 46.875 | 46.925 | 8912.0 |
| 2018-11-15 05:55:00 | AAPL | Stock | 46.995 | 46.995 | 46.995 | 46.995 | 4000.0 |
| 2018-11-15 06:00:00 | AAPL | Stock | 47.0225 | 47.0225 | 47.0225 | 47.0225 | 800.0 |
| 2018-11-15 06:05:00 | AAPL | Stock | 47.0375 | 47.0375 | 47.0375 | 47.0375 | 4000.0 |
| 2018-11-15 06:10:00 | AAPL | Stock | 47.05 | 47.05 | 47.05 | 47.05 | 3596.0 |
| 2018-11-15 06:15:00 | AAPL | Stock | 47.09 | 47.09 | 47.085 | 47.085 | 2000.0 |
| 2018-11-15 06:20:00 | AAPL | Stock | 47.095 | 47.095 | 47.095 | 47.095 | 1200.0 |
| 2018-11-15 06:30:00 | AAPL | Stock | 47.015 | 47.015 | 47.0 | 47.0 | 4596.0 |
| 2018-11-15 06:35:00 | AAPL | Stock | 47.0025 | 47.0025 | 47.0 | 47.0 | 1200.0 |
| 2018-11-15 06:40:00 | AAPL | Stock | 46.98 | 47.0 | 46.98 | 47.0 | 1920.0 |
| 2018-11-15 06:45:00 | AAPL | Stock | 47.0025 | 47.025 | 46.965 | 46.965 | 4248.0 |
| 2018-11-15 06:50:00 | AAPL | Stock | 46.9975 | 46.9975 | 46.9975 | 46.9975 | 800.0 |
| 2018-11-15 06:55:00 | AAPL | Stock | 47.0475 | 47.0475 | 47.0475 | 47.0475 | 2000.0 |
| 2018-11-15 07:00:00 | AAPL | Stock | 47.08 | 47.0825 | 46.98 | 47.05 | 30568.0 |
| 2018-11-15 07:05:00 | AAPL | Stock | 47.045 | 47.0875 | 47.045 | 47.08 | 20516.0 |
| 2018-11-15 07:10:00 | AAPL | Stock | 47.075 | 47.1 | 47.0025 | 47.0025 | 37660.0 |
| 2018-11-15 07:15:00 | AAPL | Stock | 47.025 | 47.05 | 47.005 | 47.05 | 14272.0 |
| 2018-11-15 07:20:00 | AAPL | Stock | 47.045 | 47.07 | 47.045 | 47.0525 | 9004.0 |
| 2018-11-15 07:25:00 | AAPL | Stock | 47.0725 | 47.1725 | 47.0725 | 47.09 | 43120.0 |
| 2018-11-15 07:30:00 | AAPL | Stock | 47.1 | 47.175 | 47.1 | 47.15 | 54504.0 |
| 2018-11-15 07:35:00 | AAPL | Stock | 47.15 | 47.1625 | 47.1025 | 47.125 | 20660.0 |
| 2018-11-15 07:40:00 | AAPL | Stock | 47.125 | 47.1525 | 47.05 | 47.125 | 27092.0 |
| 2018-11-15 07:45:00 | AAPL | Stock | 47.1 | 47.1275 | 47.075 | 47.1275 | 27904.0 |
| 2018-11-15 07:50:00 | AAPL | Stock | 47.1475 | 47.17 | 47.115 | 47.15 | 52320.0 |
| 2018-11-15 07:55:00 | AAPL | Stock | 47.1425 | 47.1425 | 47.0375 | 47.05 | 23952.0 |
| 2018-11-15 08:00:00 | AAPL | Stock | 47.065 | 47.175 | 47.0025 | 47.0125 | 233460.0 |
| 2018-11-15 08:05:00 | AAPL | Stock | 47.005 | 47.0625 | 46.93 | 46.945 | 80808.0 |
| 2018-11-15 08:10:00 | AAPL | Stock | 46.945 | 47.0375 | 46.9325 | 47.0375 | 74164.0 |
| 2018-11-15 08:15:00 | AAPL | Stock | 47.0 | 47.0375 | 46.9375 | 46.9375 | 30924.0 |
| 2018-11-15 08:20:00 | AAPL | Stock | 46.9375 | 47.01 | 46.9375 | 46.975 | 46804.0 |
| 2018-11-15 08:25:00 | AAPL | Stock | 46.975 | 47.125 | 46.975 | 47.0725 | 55576.0 |
| 2018-11-15 08:30:00 | AAPL | Stock | 47.065 | 47.1175 | 47.0 | 47.0375 | 113964.0 |
| 2018-11-15 08:35:00 | AAPL | Stock | 47.0375 | 47.1525 | 47.0375 | 47.13 | 75248.0 |
| 2018-11-15 08:40:00 | AAPL | Stock | 47.125 | 47.1775 | 47.075 | 47.075 | 62472.0 |
| 2018-11-15 08:45:00 | AAPL | Stock | 47.0625 | 47.1225 | 47.0275 | 47.0275 | 49020.0 |
| 2018-11-15 08:50:00 | AAPL | Stock | 47.0625 | 47.0692 | 46.95 | 47.0 | 148416.0 |
| 2018-11-15 08:55:00 | AAPL | Stock | 47.0125 | 47.1125 | 46.9875 | 47.1 | 71948.0 |
> showing 50 of 363,640 rows — these rows as CSV