PREVIEW / stock_5min / 2019-11-04
file: by_date/stock_5min/2019/2019-11-04.parquet size: 5.8 MB rows: 364,044 symbols: 2,498
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-04 04:00:00 | AAPL | Stock | 64.1375 | 64.1375 | 64.1375 | 64.1375 | 740.0 |
| 2019-11-04 04:05:00 | AAPL | Stock | 64.3725 | 64.3725 | 64.37 | 64.37 | 1212.0 |
| 2019-11-04 04:10:00 | AAPL | Stock | 64.3725 | 64.3725 | 64.3725 | 64.3725 | 720.0 |
| 2019-11-04 04:15:00 | AAPL | Stock | 64.31 | 64.31 | 64.31 | 64.31 | 2200.0 |
| 2019-11-04 04:25:00 | AAPL | Stock | 64.2575 | 64.35 | 64.2575 | 64.3 | 7960.0 |
| 2019-11-04 04:30:00 | AAPL | Stock | 64.325 | 64.325 | 64.3 | 64.3 | 4240.0 |
| 2019-11-04 04:35:00 | AAPL | Stock | 64.325 | 64.325 | 64.325 | 64.325 | 584.0 |
| 2019-11-04 04:40:00 | AAPL | Stock | 64.31 | 64.31 | 64.31 | 64.31 | 1200.0 |
| 2019-11-04 04:50:00 | AAPL | Stock | 64.325 | 64.325 | 64.25 | 64.25 | 4400.0 |
| 2019-11-04 04:55:00 | AAPL | Stock | 64.2425 | 64.2975 | 64.2425 | 64.2975 | 2396.0 |
| 2019-11-04 05:00:00 | AAPL | Stock | 64.2975 | 64.3075 | 64.25 | 64.3075 | 10796.0 |
| 2019-11-04 05:05:00 | AAPL | Stock | 64.325 | 64.325 | 64.3 | 64.3 | 2028.0 |
| 2019-11-04 05:15:00 | AAPL | Stock | 64.3225 | 64.325 | 64.3225 | 64.325 | 1480.0 |
| 2019-11-04 05:20:00 | AAPL | Stock | 64.32 | 64.37 | 64.32 | 64.35 | 9944.0 |
| 2019-11-04 05:25:00 | AAPL | Stock | 64.35 | 64.35 | 64.35 | 64.35 | 3792.0 |
| 2019-11-04 05:30:00 | AAPL | Stock | 64.35 | 64.35 | 64.35 | 64.35 | 4000.0 |
| 2019-11-04 05:35:00 | AAPL | Stock | 64.3 | 64.3 | 64.3 | 64.3 | 2000.0 |
| 2019-11-04 05:40:00 | AAPL | Stock | 64.3475 | 64.3475 | 64.3325 | 64.3325 | 2552.0 |
| 2019-11-04 05:45:00 | AAPL | Stock | 64.3375 | 64.3475 | 64.3375 | 64.3475 | 11364.0 |
| 2019-11-04 05:55:00 | AAPL | Stock | 64.36 | 64.375 | 64.36 | 64.375 | 3120.0 |
| 2019-11-04 06:00:00 | AAPL | Stock | 64.38 | 64.4475 | 64.375 | 64.4475 | 8216.0 |
| 2019-11-04 06:05:00 | AAPL | Stock | 64.37 | 64.3775 | 64.365 | 64.365 | 5920.0 |
| 2019-11-04 06:10:00 | AAPL | Stock | 64.375 | 64.3775 | 64.3725 | 64.375 | 3928.0 |
| 2019-11-04 06:15:00 | AAPL | Stock | 64.3725 | 64.3725 | 64.3725 | 64.3725 | 1200.0 |
| 2019-11-04 06:20:00 | AAPL | Stock | 64.3725 | 64.3725 | 64.325 | 64.325 | 4460.0 |
| 2019-11-04 06:25:00 | AAPL | Stock | 64.31 | 64.325 | 64.2875 | 64.31 | 11612.0 |
| 2019-11-04 06:30:00 | AAPL | Stock | 64.3175 | 64.3275 | 64.3175 | 64.325 | 9004.0 |
| 2019-11-04 06:35:00 | AAPL | Stock | 64.3175 | 64.3425 | 64.3175 | 64.3425 | 4884.0 |
| 2019-11-04 06:40:00 | AAPL | Stock | 64.35 | 64.35 | 64.35 | 64.35 | 4000.0 |
| 2019-11-04 06:45:00 | AAPL | Stock | 64.3625 | 64.3775 | 64.3625 | 64.3775 | 3788.0 |
| 2019-11-04 06:55:00 | AAPL | Stock | 64.3675 | 64.3675 | 64.325 | 64.325 | 7404.0 |
| 2019-11-04 07:00:00 | AAPL | Stock | 64.3625 | 64.415 | 64.3325 | 64.3875 | 63040.0 |
| 2019-11-04 07:05:00 | AAPL | Stock | 64.3975 | 64.4375 | 64.375 | 64.3875 | 66404.0 |
| 2019-11-04 07:10:00 | AAPL | Stock | 64.3875 | 64.3875 | 64.3625 | 64.3625 | 27400.0 |
| 2019-11-04 07:15:00 | AAPL | Stock | 64.365 | 64.365 | 64.345 | 64.3625 | 25332.0 |
| 2019-11-04 07:20:00 | AAPL | Stock | 64.355 | 64.355 | 64.3425 | 64.35 | 5508.0 |
| 2019-11-04 07:25:00 | AAPL | Stock | 64.35 | 64.3625 | 64.3325 | 64.3325 | 11472.0 |
| 2019-11-04 07:30:00 | AAPL | Stock | 64.335 | 64.355 | 64.3325 | 64.355 | 18920.0 |
| 2019-11-04 07:35:00 | AAPL | Stock | 64.3375 | 64.3625 | 64.325 | 64.3625 | 43976.0 |
| 2019-11-04 07:40:00 | AAPL | Stock | 64.3475 | 64.375 | 64.345 | 64.375 | 24008.0 |
| 2019-11-04 07:45:00 | AAPL | Stock | 64.375 | 64.4425 | 64.375 | 64.4425 | 63520.0 |
| 2019-11-04 07:50:00 | AAPL | Stock | 64.4425 | 64.47 | 64.4325 | 64.4325 | 90080.0 |
| 2019-11-04 07:55:00 | AAPL | Stock | 64.4325 | 64.445 | 64.415 | 64.435 | 47944.0 |
| 2019-11-04 08:00:00 | AAPL | Stock | 64.4 | 64.465 | 64.3325 | 64.435 | 134540.0 |
| 2019-11-04 08:05:00 | AAPL | Stock | 64.435 | 64.47 | 64.425 | 64.44 | 41040.0 |
| 2019-11-04 08:10:00 | AAPL | Stock | 64.455 | 64.4625 | 64.43 | 64.45 | 41056.0 |
| 2019-11-04 08:15:00 | AAPL | Stock | 64.4525 | 64.485 | 64.45 | 64.45 | 44552.0 |
| 2019-11-04 08:20:00 | AAPL | Stock | 64.445 | 64.4975 | 64.445 | 64.4925 | 75760.0 |
| 2019-11-04 08:25:00 | AAPL | Stock | 64.4625 | 64.4875 | 64.4375 | 64.45 | 51412.0 |
| 2019-11-04 08:30:00 | AAPL | Stock | 64.4425 | 64.5 | 64.44 | 64.4875 | 82060.0 |
> showing 50 of 364,044 rows — these rows as CSV