PREVIEW / stock_5min / 2019-08-02
file: by_date/stock_5min/2019/2019-08-02.parquet size: 5.6 MB rows: 356,564 symbols: 2,561
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-08-02 04:00:00 | AAPL | Stock | 51.55 | 51.55 | 51.4275 | 51.525 | 9704.0 |
| 2019-08-02 04:10:00 | AAPL | Stock | 51.535 | 51.535 | 51.535 | 51.535 | 800.0 |
| 2019-08-02 04:15:00 | AAPL | Stock | 51.5375 | 51.5375 | 51.5 | 51.5 | 6736.0 |
| 2019-08-02 04:20:00 | AAPL | Stock | 51.4525 | 51.5 | 51.4525 | 51.5 | 3600.0 |
| 2019-08-02 04:30:00 | AAPL | Stock | 51.405 | 51.45 | 51.3775 | 51.3775 | 6760.0 |
| 2019-08-02 04:35:00 | AAPL | Stock | 51.45 | 51.45 | 51.45 | 51.45 | 1332.0 |
| 2019-08-02 04:40:00 | AAPL | Stock | 51.45 | 51.45 | 51.45 | 51.45 | 1592.0 |
| 2019-08-02 04:45:00 | AAPL | Stock | 51.4925 | 51.4925 | 51.4925 | 51.4925 | 400.0 |
| 2019-08-02 04:50:00 | AAPL | Stock | 51.4925 | 51.4925 | 51.45 | 51.45 | 4216.0 |
| 2019-08-02 04:55:00 | AAPL | Stock | 51.4425 | 51.4425 | 51.4425 | 51.4425 | 3196.0 |
| 2019-08-02 05:05:00 | AAPL | Stock | 51.385 | 51.385 | 51.385 | 51.385 | 400.0 |
| 2019-08-02 05:15:00 | AAPL | Stock | 51.3925 | 51.3925 | 51.3725 | 51.3825 | 5028.0 |
| 2019-08-02 05:35:00 | AAPL | Stock | 51.4075 | 51.4075 | 51.3875 | 51.3875 | 4320.0 |
| 2019-08-02 05:40:00 | AAPL | Stock | 51.39 | 51.39 | 51.39 | 51.39 | 404.0 |
| 2019-08-02 05:45:00 | AAPL | Stock | 51.4125 | 51.4125 | 51.4 | 51.4 | 928.0 |
| 2019-08-02 05:55:00 | AAPL | Stock | 51.4 | 51.4 | 51.4 | 51.4 | 400.0 |
| 2019-08-02 06:00:00 | AAPL | Stock | 51.3875 | 51.425 | 51.3875 | 51.425 | 3708.0 |
| 2019-08-02 06:05:00 | AAPL | Stock | 51.4725 | 51.485 | 51.415 | 51.415 | 4792.0 |
| 2019-08-02 06:15:00 | AAPL | Stock | 51.535 | 51.58 | 51.535 | 51.58 | 2000.0 |
| 2019-08-02 06:20:00 | AAPL | Stock | 51.5875 | 51.5875 | 51.55 | 51.55 | 2144.0 |
| 2019-08-02 06:25:00 | AAPL | Stock | 51.575 | 51.575 | 51.5 | 51.5 | 10896.0 |
| 2019-08-02 06:30:00 | AAPL | Stock | 51.5 | 51.5475 | 51.5 | 51.5 | 6500.0 |
| 2019-08-02 06:35:00 | AAPL | Stock | 51.575 | 51.575 | 51.5 | 51.5 | 3788.0 |
| 2019-08-02 06:40:00 | AAPL | Stock | 51.45 | 51.45 | 51.45 | 51.45 | 4552.0 |
| 2019-08-02 06:45:00 | AAPL | Stock | 51.5 | 51.515 | 51.5 | 51.515 | 2000.0 |
| 2019-08-02 06:50:00 | AAPL | Stock | 51.515 | 51.6125 | 51.515 | 51.6125 | 5856.0 |
| 2019-08-02 06:55:00 | AAPL | Stock | 51.655 | 51.66 | 51.655 | 51.66 | 2400.0 |
| 2019-08-02 07:00:00 | AAPL | Stock | 51.5875 | 51.6375 | 51.515 | 51.515 | 43208.0 |
| 2019-08-02 07:05:00 | AAPL | Stock | 51.55 | 51.5825 | 51.5025 | 51.5475 | 30140.0 |
| 2019-08-02 07:10:00 | AAPL | Stock | 51.55 | 51.6 | 51.55 | 51.58 | 24596.0 |
| 2019-08-02 07:15:00 | AAPL | Stock | 51.62 | 51.625 | 51.5925 | 51.6225 | 21408.0 |
| 2019-08-02 07:20:00 | AAPL | Stock | 51.6225 | 51.6225 | 51.575 | 51.575 | 3792.0 |
| 2019-08-02 07:25:00 | AAPL | Stock | 51.58 | 51.615 | 51.575 | 51.615 | 4200.0 |
| 2019-08-02 07:30:00 | AAPL | Stock | 51.6025 | 51.6025 | 51.55 | 51.5625 | 28236.0 |
| 2019-08-02 07:35:00 | AAPL | Stock | 51.6125 | 51.6125 | 51.595 | 51.605 | 3200.0 |
| 2019-08-02 07:40:00 | AAPL | Stock | 51.6175 | 51.64 | 51.605 | 51.635 | 15760.0 |
| 2019-08-02 07:45:00 | AAPL | Stock | 51.66 | 51.66 | 51.6 | 51.6 | 19092.0 |
| 2019-08-02 07:50:00 | AAPL | Stock | 51.595 | 51.595 | 51.5125 | 51.55 | 11588.0 |
| 2019-08-02 07:55:00 | AAPL | Stock | 51.5575 | 51.5625 | 51.53 | 51.53 | 21356.0 |
| 2019-08-02 08:00:00 | AAPL | Stock | 51.5275 | 51.6625 | 51.5075 | 51.545 | 126452.0 |
| 2019-08-02 08:05:00 | AAPL | Stock | 51.525 | 51.55 | 51.525 | 51.5275 | 14140.0 |
| 2019-08-02 08:10:00 | AAPL | Stock | 51.5275 | 51.6 | 51.5275 | 51.5875 | 151004.0 |
| 2019-08-02 08:15:00 | AAPL | Stock | 51.5875 | 51.625 | 51.575 | 51.6175 | 58176.0 |
| 2019-08-02 08:20:00 | AAPL | Stock | 51.6375 | 52.1075 | 51.6 | 51.625 | 13200.0 |
| 2019-08-02 08:25:00 | AAPL | Stock | 51.625 | 51.65 | 51.6025 | 51.61 | 33896.0 |
| 2019-08-02 08:30:00 | AAPL | Stock | 51.6025 | 51.6125 | 51.395 | 51.4125 | 157896.0 |
| 2019-08-02 08:35:00 | AAPL | Stock | 51.4125 | 51.55 | 51.37 | 51.5 | 72628.0 |
| 2019-08-02 08:40:00 | AAPL | Stock | 51.5 | 51.575 | 51.5 | 51.53 | 40976.0 |
| 2019-08-02 08:45:00 | AAPL | Stock | 51.5375 | 51.6075 | 51.5 | 51.5975 | 49000.0 |
| 2019-08-02 08:50:00 | AAPL | Stock | 51.5975 | 51.5975 | 51.5 | 51.5 | 31488.0 |
> showing 50 of 356,564 rows — these rows as CSV