PREVIEW / stock_5min / 2019-09-13
file: by_date/stock_5min/2019/2019-09-13.parquet size: 5.8 MB rows: 369,630 symbols: 2,550
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-09-13 04:05:00 | AAPL | Stock | 55.925 | 55.94 | 55.9 | 55.9 | 4160.0 |
| 2019-09-13 04:10:00 | AAPL | Stock | 55.9025 | 55.9025 | 55.9025 | 55.9025 | 2456.0 |
| 2019-09-13 04:20:00 | AAPL | Stock | 55.9025 | 55.9025 | 55.9 | 55.9 | 2680.0 |
| 2019-09-13 04:25:00 | AAPL | Stock | 55.8725 | 55.8725 | 55.8725 | 55.8725 | 400.0 |
| 2019-09-13 04:30:00 | AAPL | Stock | 55.835 | 55.835 | 55.835 | 55.835 | 440.0 |
| 2019-09-13 04:40:00 | AAPL | Stock | 55.835 | 55.835 | 55.835 | 55.835 | 3328.0 |
| 2019-09-13 04:45:00 | AAPL | Stock | 55.8375 | 55.8375 | 55.8375 | 55.8375 | 1200.0 |
| 2019-09-13 05:00:00 | AAPL | Stock | 55.8375 | 55.8375 | 55.8375 | 55.8375 | 400.0 |
| 2019-09-13 05:15:00 | AAPL | Stock | 55.85 | 55.85 | 55.8375 | 55.8375 | 4020.0 |
| 2019-09-13 05:25:00 | AAPL | Stock | 55.865 | 55.865 | 55.865 | 55.865 | 700.0 |
| 2019-09-13 05:30:00 | AAPL | Stock | 55.8525 | 55.8525 | 55.8525 | 55.8525 | 960.0 |
| 2019-09-13 05:35:00 | AAPL | Stock | 55.835 | 55.8425 | 55.835 | 55.835 | 8328.0 |
| 2019-09-13 05:40:00 | AAPL | Stock | 55.825 | 55.825 | 55.825 | 55.825 | 1600.0 |
| 2019-09-13 05:45:00 | AAPL | Stock | 55.825 | 55.825 | 55.825 | 55.825 | 7296.0 |
| 2019-09-13 05:50:00 | AAPL | Stock | 55.8 | 55.85 | 55.8 | 55.85 | 16236.0 |
| 2019-09-13 05:55:00 | AAPL | Stock | 55.8225 | 55.8225 | 55.7875 | 55.7875 | 6400.0 |
| 2019-09-13 06:00:00 | AAPL | Stock | 55.7575 | 55.7575 | 55.325 | 55.325 | 32828.0 |
| 2019-09-13 06:05:00 | AAPL | Stock | 55.3375 | 55.405 | 55.3375 | 55.405 | 4580.0 |
| 2019-09-13 06:10:00 | AAPL | Stock | 55.4575 | 55.4575 | 55.375 | 55.375 | 18160.0 |
| 2019-09-13 06:15:00 | AAPL | Stock | 55.355 | 55.355 | 55.175 | 55.175 | 31464.0 |
| 2019-09-13 06:20:00 | AAPL | Stock | 55.265 | 55.4 | 55.265 | 55.37 | 8168.0 |
| 2019-09-13 06:25:00 | AAPL | Stock | 55.3725 | 55.3725 | 55.325 | 55.3725 | 13464.0 |
| 2019-09-13 06:30:00 | AAPL | Stock | 55.33 | 55.3775 | 55.325 | 55.3275 | 15596.0 |
| 2019-09-13 06:35:00 | AAPL | Stock | 55.325 | 55.3575 | 55.3125 | 55.3575 | 6000.0 |
| 2019-09-13 06:40:00 | AAPL | Stock | 55.355 | 55.355 | 55.3475 | 55.3475 | 4944.0 |
| 2019-09-13 06:45:00 | AAPL | Stock | 55.315 | 55.3675 | 55.3025 | 55.3525 | 13212.0 |
| 2019-09-13 06:50:00 | AAPL | Stock | 55.3275 | 55.4475 | 55.3275 | 55.44 | 6012.0 |
| 2019-09-13 06:55:00 | AAPL | Stock | 55.44 | 55.4625 | 55.3975 | 55.4425 | 28432.0 |
| 2019-09-13 07:00:00 | AAPL | Stock | 55.4425 | 55.625 | 55.4225 | 55.425 | 145088.0 |
| 2019-09-13 07:05:00 | AAPL | Stock | 55.425 | 55.475 | 55.4 | 55.4 | 63700.0 |
| 2019-09-13 07:10:00 | AAPL | Stock | 55.425 | 55.44 | 55.42 | 55.435 | 9436.0 |
| 2019-09-13 07:15:00 | AAPL | Stock | 55.435 | 55.435 | 55.3875 | 55.3875 | 32640.0 |
| 2019-09-13 07:20:00 | AAPL | Stock | 55.42 | 55.425 | 55.3775 | 55.3925 | 46552.0 |
| 2019-09-13 07:25:00 | AAPL | Stock | 55.4 | 55.445 | 55.4 | 55.445 | 9392.0 |
| 2019-09-13 07:30:00 | AAPL | Stock | 55.4425 | 55.545 | 55.4425 | 55.545 | 55516.0 |
| 2019-09-13 07:35:00 | AAPL | Stock | 55.5625 | 55.5625 | 55.5 | 55.5 | 27512.0 |
| 2019-09-13 07:40:00 | AAPL | Stock | 55.4975 | 55.5 | 55.4525 | 55.475 | 24876.0 |
| 2019-09-13 07:45:00 | AAPL | Stock | 55.4675 | 55.4775 | 55.465 | 55.465 | 2400.0 |
| 2019-09-13 07:50:00 | AAPL | Stock | 55.4775 | 55.4775 | 55.4275 | 55.4275 | 66460.0 |
| 2019-09-13 07:55:00 | AAPL | Stock | 55.45 | 55.4625 | 55.4375 | 55.4625 | 7428.0 |
| 2019-09-13 08:00:00 | AAPL | Stock | 55.4775 | 55.6225 | 55.3875 | 55.5 | 265036.0 |
| 2019-09-13 08:05:00 | AAPL | Stock | 55.525 | 55.525 | 55.48 | 55.4975 | 16016.0 |
| 2019-09-13 08:10:00 | AAPL | Stock | 55.5225 | 55.55 | 55.4825 | 55.54 | 19356.0 |
| 2019-09-13 08:15:00 | AAPL | Stock | 55.545 | 55.545 | 55.45 | 55.465 | 70892.0 |
| 2019-09-13 08:20:00 | AAPL | Stock | 55.495 | 55.495 | 55.4175 | 55.425 | 34048.0 |
| 2019-09-13 08:25:00 | AAPL | Stock | 55.425 | 55.47 | 55.425 | 55.4388 | 44560.0 |
| 2019-09-13 08:30:00 | AAPL | Stock | 55.44 | 55.5 | 55.4125 | 55.4375 | 96236.0 |
| 2019-09-13 08:35:00 | AAPL | Stock | 55.4375 | 55.445 | 55.3375 | 55.365 | 160364.0 |
| 2019-09-13 08:40:00 | AAPL | Stock | 55.3625 | 55.3775 | 55.305 | 55.325 | 132872.0 |
| 2019-09-13 08:45:00 | AAPL | Stock | 55.3175 | 55.335 | 55.2 | 55.205 | 287604.0 |
> showing 50 of 369,630 rows — these rows as CSV