PREVIEW / stock_5min / 2018-05-15
file: by_date/stock_5min/2018/2018-05-15.parquet size: 5.6 MB rows: 359,836 symbols: 2,854
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-05-15 04:35:00 | AAPL | Stock | 46.86 | 46.86 | 46.86 | 46.86 | 400.0 |
| 2018-05-15 04:45:00 | AAPL | Stock | 46.755 | 46.755 | 46.755 | 46.755 | 400.0 |
| 2018-05-15 05:10:00 | AAPL | Stock | 46.795 | 46.8 | 46.795 | 46.8 | 3952.0 |
| 2018-05-15 05:40:00 | AAPL | Stock | 46.825 | 46.8275 | 46.8 | 46.8 | 15992.0 |
| 2018-05-15 05:45:00 | AAPL | Stock | 46.8 | 46.8 | 46.8 | 46.8 | 1200.0 |
| 2018-05-15 05:50:00 | AAPL | Stock | 46.8075 | 46.8075 | 46.8075 | 46.8075 | 700.0 |
| 2018-05-15 06:05:00 | AAPL | Stock | 46.8125 | 46.8125 | 46.8125 | 46.8125 | 1600.0 |
| 2018-05-15 06:15:00 | AAPL | Stock | 46.825 | 46.825 | 46.825 | 46.825 | 2000.0 |
| 2018-05-15 06:50:00 | AAPL | Stock | 46.825 | 46.8275 | 46.825 | 46.8275 | 2800.0 |
| 2018-05-15 07:00:00 | AAPL | Stock | 46.875 | 46.875 | 46.845 | 46.87 | 13648.0 |
| 2018-05-15 07:05:00 | AAPL | Stock | 46.885 | 46.9225 | 46.885 | 46.92 | 18856.0 |
| 2018-05-15 07:10:00 | AAPL | Stock | 46.92 | 46.9225 | 46.9125 | 46.9125 | 3600.0 |
| 2018-05-15 07:15:00 | AAPL | Stock | 46.8875 | 46.8875 | 46.85 | 46.85 | 10808.0 |
| 2018-05-15 07:20:00 | AAPL | Stock | 46.85 | 46.8625 | 46.85 | 46.8625 | 1980.0 |
| 2018-05-15 07:25:00 | AAPL | Stock | 46.845 | 46.845 | 46.825 | 46.825 | 3600.0 |
| 2018-05-15 07:30:00 | AAPL | Stock | 46.8375 | 46.85 | 46.8375 | 46.85 | 11772.0 |
| 2018-05-15 07:35:00 | AAPL | Stock | 46.8575 | 46.86 | 46.845 | 46.86 | 21408.0 |
| 2018-05-15 07:40:00 | AAPL | Stock | 46.8225 | 46.8225 | 46.8075 | 46.815 | 7040.0 |
| 2018-05-15 07:45:00 | AAPL | Stock | 46.8375 | 46.8375 | 46.825 | 46.83 | 6800.0 |
| 2018-05-15 07:50:00 | AAPL | Stock | 46.825 | 46.85 | 46.8 | 46.85 | 51432.0 |
| 2018-05-15 07:55:00 | AAPL | Stock | 46.8375 | 46.85 | 46.8375 | 46.85 | 6000.0 |
| 2018-05-15 08:00:00 | AAPL | Stock | 46.85 | 46.925 | 46.8118 | 46.83 | 93900.0 |
| 2018-05-15 08:05:00 | AAPL | Stock | 46.825 | 47.1375 | 46.8075 | 46.85 | 20820.0 |
| 2018-05-15 08:10:00 | AAPL | Stock | 46.8625 | 46.8625 | 46.815 | 46.8255 | 24536.0 |
| 2018-05-15 08:15:00 | AAPL | Stock | 46.83 | 46.85 | 46.83 | 46.84 | 5236.0 |
| 2018-05-15 08:20:00 | AAPL | Stock | 46.865 | 46.875 | 46.855 | 46.8625 | 7264.0 |
| 2018-05-15 08:25:00 | AAPL | Stock | 46.8875 | 46.91 | 46.8875 | 46.8875 | 43480.0 |
| 2018-05-15 08:30:00 | AAPL | Stock | 46.8925 | 46.8925 | 46.8275 | 46.875 | 19488.0 |
| 2018-05-15 08:35:00 | AAPL | Stock | 46.8625 | 46.8625 | 46.775 | 46.7775 | 52956.0 |
| 2018-05-15 08:40:00 | AAPL | Stock | 46.7775 | 46.8075 | 46.7725 | 46.7825 | 44048.0 |
| 2018-05-15 08:45:00 | AAPL | Stock | 46.78 | 46.79 | 46.7375 | 46.7375 | 162772.0 |
| 2018-05-15 08:50:00 | AAPL | Stock | 46.7325 | 46.755 | 46.72 | 46.72 | 93776.0 |
| 2018-05-15 08:55:00 | AAPL | Stock | 46.72 | 46.7475 | 46.6975 | 46.745 | 63516.0 |
| 2018-05-15 09:00:00 | AAPL | Stock | 46.7325 | 46.76 | 46.725 | 46.76 | 18152.0 |
| 2018-05-15 09:05:00 | AAPL | Stock | 46.76 | 46.76 | 46.7375 | 46.74 | 6204.0 |
| 2018-05-15 09:10:00 | AAPL | Stock | 46.75 | 46.75 | 46.725 | 46.725 | 14072.0 |
| 2018-05-15 09:15:00 | AAPL | Stock | 46.725 | 46.75 | 46.72 | 46.74 | 40424.0 |
| 2018-05-15 09:20:00 | AAPL | Stock | 46.7375 | 46.7475 | 46.69 | 46.7475 | 76060.0 |
| 2018-05-15 09:25:00 | AAPL | Stock | 46.7475 | 46.7925 | 46.7025 | 46.7025 | 52828.0 |
| 2018-05-15 09:30:00 | AAPL | Stock | 46.7025 | 46.7225 | 46.555 | 46.6425 | 4780920.0 |
| 2018-05-15 09:35:00 | AAPL | Stock | 46.63 | 46.7125 | 46.595 | 46.6 | 2048836.0 |
| 2018-05-15 09:40:00 | AAPL | Stock | 46.5975 | 46.6205 | 46.4075 | 46.5375 | 2833176.0 |
| 2018-05-15 09:45:00 | AAPL | Stock | 46.5375 | 46.54 | 46.425 | 46.5292 | 1736932.0 |
| 2018-05-15 09:50:00 | AAPL | Stock | 46.5275 | 46.5875 | 46.4975 | 46.55 | 1489156.0 |
| 2018-05-15 09:55:00 | AAPL | Stock | 46.55 | 46.55 | 46.4475 | 46.515 | 1397248.0 |
| 2018-05-15 10:00:00 | AAPL | Stock | 46.5175 | 46.5925 | 46.4775 | 46.5175 | 1242788.0 |
| 2018-05-15 10:05:00 | AAPL | Stock | 46.5175 | 46.5875 | 46.51 | 46.575 | 999660.0 |
| 2018-05-15 10:10:00 | AAPL | Stock | 46.5775 | 46.5975 | 46.5425 | 46.575 | 1129792.0 |
| 2018-05-15 10:15:00 | AAPL | Stock | 46.57 | 46.6375 | 46.515 | 46.6275 | 1477300.0 |
| 2018-05-15 10:20:00 | AAPL | Stock | 46.6275 | 46.65 | 46.575 | 46.6125 | 943628.0 |
> showing 50 of 359,836 rows — these rows as CSV