PREVIEW / stock_5min / 2019-11-13
file: by_date/stock_5min/2019/2019-11-13.parquet size: 5.7 MB rows: 359,991 symbols: 2,512
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 |
|---|---|---|---|---|---|---|---|
| 2019-11-13 04:00:00 | AAPL | Stock | 65.3675 | 65.3775 | 65.155 | 65.155 | 5948.0 |
| 2019-11-13 04:05:00 | AAPL | Stock | 65.215 | 65.2875 | 65.2 | 65.25 | 7476.0 |
| 2019-11-13 04:10:00 | AAPL | Stock | 65.2325 | 65.235 | 65.21 | 65.235 | 7492.0 |
| 2019-11-13 04:20:00 | AAPL | Stock | 65.2375 | 65.2375 | 65.2375 | 65.2375 | 4400.0 |
| 2019-11-13 04:25:00 | AAPL | Stock | 65.2 | 65.2 | 65.2 | 65.2 | 400.0 |
| 2019-11-13 04:30:00 | AAPL | Stock | 65.195 | 65.2 | 65.195 | 65.2 | 800.0 |
| 2019-11-13 04:35:00 | AAPL | Stock | 65.1525 | 65.1525 | 65.1525 | 65.1525 | 400.0 |
| 2019-11-13 04:40:00 | AAPL | Stock | 65.1 | 65.1 | 65.05 | 65.05 | 4088.0 |
| 2019-11-13 04:45:00 | AAPL | Stock | 65.055 | 65.055 | 65.0475 | 65.0475 | 27388.0 |
| 2019-11-13 04:50:00 | AAPL | Stock | 65.01 | 65.01 | 65.0 | 65.0 | 2348.0 |
| 2019-11-13 04:55:00 | AAPL | Stock | 65.0075 | 65.0375 | 65.0075 | 65.0375 | 8720.0 |
| 2019-11-13 05:00:00 | AAPL | Stock | 65.085 | 65.085 | 65.085 | 65.085 | 3136.0 |
| 2019-11-13 05:05:00 | AAPL | Stock | 65.075 | 65.1075 | 65.075 | 65.1075 | 9328.0 |
| 2019-11-13 05:25:00 | AAPL | Stock | 65.145 | 65.145 | 65.145 | 65.145 | 1200.0 |
| 2019-11-13 05:30:00 | AAPL | Stock | 65.145 | 65.15 | 65.125 | 65.125 | 4144.0 |
| 2019-11-13 05:40:00 | AAPL | Stock | 65.1 | 65.1 | 65.095 | 65.095 | 800.0 |
| 2019-11-13 05:55:00 | AAPL | Stock | 65.1275 | 65.1275 | 65.055 | 65.095 | 19840.0 |
| 2019-11-13 06:00:00 | AAPL | Stock | 65.1 | 65.1 | 65.075 | 65.075 | 19880.0 |
| 2019-11-13 06:05:00 | AAPL | Stock | 65.135 | 65.135 | 65.135 | 65.135 | 400.0 |
| 2019-11-13 06:10:00 | AAPL | Stock | 65.1125 | 65.1125 | 65.1125 | 65.1125 | 3576.0 |
| 2019-11-13 06:15:00 | AAPL | Stock | 65.1175 | 65.1175 | 65.1175 | 65.1175 | 1200.0 |
| 2019-11-13 06:20:00 | AAPL | Stock | 65.1125 | 65.1175 | 65.0325 | 65.1175 | 7872.0 |
| 2019-11-13 06:25:00 | AAPL | Stock | 65.135 | 65.135 | 65.135 | 65.135 | 1200.0 |
| 2019-11-13 06:35:00 | AAPL | Stock | 65.1325 | 65.1325 | 65.13 | 65.1325 | 2264.0 |
| 2019-11-13 06:45:00 | AAPL | Stock | 65.135 | 65.135 | 65.135 | 65.135 | 400.0 |
| 2019-11-13 06:50:00 | AAPL | Stock | 65.1025 | 65.1025 | 65.1025 | 65.1025 | 3048.0 |
| 2019-11-13 07:00:00 | AAPL | Stock | 65.185 | 65.25 | 65.185 | 65.1925 | 41360.0 |
| 2019-11-13 07:05:00 | AAPL | Stock | 65.2425 | 65.2475 | 65.19 | 65.19 | 10280.0 |
| 2019-11-13 07:10:00 | AAPL | Stock | 65.2375 | 65.2375 | 65.225 | 65.225 | 2524.0 |
| 2019-11-13 07:15:00 | AAPL | Stock | 65.2375 | 65.25 | 65.2125 | 65.2125 | 20940.0 |
| 2019-11-13 07:20:00 | AAPL | Stock | 65.2025 | 65.2125 | 65.17 | 65.175 | 20136.0 |
| 2019-11-13 07:25:00 | AAPL | Stock | 65.195 | 65.225 | 65.195 | 65.225 | 19444.0 |
| 2019-11-13 07:30:00 | AAPL | Stock | 65.235 | 65.3 | 65.225 | 65.3 | 18716.0 |
| 2019-11-13 07:35:00 | AAPL | Stock | 65.3 | 65.3125 | 65.2625 | 65.2725 | 19680.0 |
| 2019-11-13 07:40:00 | AAPL | Stock | 65.265 | 65.2825 | 65.2525 | 65.2825 | 27584.0 |
| 2019-11-13 07:45:00 | AAPL | Stock | 65.2875 | 65.2975 | 65.2875 | 65.2975 | 11676.0 |
| 2019-11-13 07:50:00 | AAPL | Stock | 65.3 | 65.345 | 65.3 | 65.3275 | 25332.0 |
| 2019-11-13 07:55:00 | AAPL | Stock | 65.3125 | 65.34 | 65.295 | 65.3 | 36840.0 |
| 2019-11-13 08:00:00 | AAPL | Stock | 65.49 | 65.49 | 65.1375 | 65.3125 | 26476.0 |
| 2019-11-13 08:05:00 | AAPL | Stock | 65.32 | 65.32 | 65.2825 | 65.3 | 20200.0 |
| 2019-11-13 08:10:00 | AAPL | Stock | 65.3125 | 65.345 | 65.2875 | 65.345 | 13392.0 |
| 2019-11-13 08:15:00 | AAPL | Stock | 65.34 | 65.34 | 65.34 | 65.34 | 3544.0 |
| 2019-11-13 08:20:00 | AAPL | Stock | 65.34 | 65.35 | 65.3375 | 65.3475 | 7244.0 |
| 2019-11-13 08:25:00 | AAPL | Stock | 65.3375 | 65.3375 | 65.325 | 65.3375 | 10232.0 |
| 2019-11-13 08:30:00 | AAPL | Stock | 65.315 | 65.3475 | 65.3125 | 65.3375 | 8996.0 |
| 2019-11-13 08:35:00 | AAPL | Stock | 65.355 | 65.375 | 65.33 | 65.35 | 37052.0 |
| 2019-11-13 08:40:00 | AAPL | Stock | 65.325 | 65.36 | 65.315 | 65.35 | 19168.0 |
| 2019-11-13 08:45:00 | AAPL | Stock | 65.35 | 65.3725 | 65.35 | 65.3725 | 4400.0 |
| 2019-11-13 08:50:00 | AAPL | Stock | 65.3725 | 65.4 | 65.365 | 65.3995 | 23416.0 |
| 2019-11-13 08:55:00 | AAPL | Stock | 65.4 | 65.4 | 65.3625 | 65.3625 | 27680.0 |
> showing 50 of 359,991 rows — these rows as CSV