PREVIEW / stock_5min / 2020-01-09
file: by_date/stock_5min/2020/2020-01-09.parquet size: 6.0 MB rows: 371,941 symbols: 2,491
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 |
|---|---|---|---|---|---|---|---|
| 2020-01-09 04:00:00 | AAPL | Stock | 76.2975 | 76.49 | 76.255 | 76.47 | 27204.0 |
| 2020-01-09 04:05:00 | AAPL | Stock | 76.45 | 76.45 | 76.45 | 76.45 | 8000.0 |
| 2020-01-09 04:10:00 | AAPL | Stock | 76.445 | 76.445 | 76.3875 | 76.3875 | 4788.0 |
| 2020-01-09 04:15:00 | AAPL | Stock | 76.44 | 76.475 | 76.44 | 76.475 | 15916.0 |
| 2020-01-09 04:25:00 | AAPL | Stock | 76.4375 | 76.4375 | 76.3775 | 76.3875 | 21160.0 |
| 2020-01-09 04:30:00 | AAPL | Stock | 76.4125 | 76.4475 | 76.4125 | 76.4475 | 1560.0 |
| 2020-01-09 04:35:00 | AAPL | Stock | 76.4125 | 76.4625 | 76.4125 | 76.4625 | 2252.0 |
| 2020-01-09 04:40:00 | AAPL | Stock | 76.4125 | 76.4125 | 76.4125 | 76.4125 | 1008.0 |
| 2020-01-09 04:45:00 | AAPL | Stock | 76.4425 | 76.4475 | 76.4425 | 76.4475 | 2400.0 |
| 2020-01-09 04:50:00 | AAPL | Stock | 76.425 | 76.425 | 76.425 | 76.425 | 400.0 |
| 2020-01-09 04:55:00 | AAPL | Stock | 76.45 | 76.4625 | 76.45 | 76.4625 | 2488.0 |
| 2020-01-09 05:00:00 | AAPL | Stock | 76.4575 | 76.4575 | 76.455 | 76.455 | 1200.0 |
| 2020-01-09 05:05:00 | AAPL | Stock | 76.475 | 76.5 | 76.475 | 76.5 | 1832.0 |
| 2020-01-09 05:10:00 | AAPL | Stock | 76.475 | 76.475 | 76.475 | 76.475 | 400.0 |
| 2020-01-09 05:15:00 | AAPL | Stock | 76.485 | 76.5 | 76.4375 | 76.4375 | 13652.0 |
| 2020-01-09 05:20:00 | AAPL | Stock | 76.4375 | 76.4375 | 76.4075 | 76.4225 | 6580.0 |
| 2020-01-09 05:25:00 | AAPL | Stock | 76.4325 | 76.4375 | 76.4075 | 76.4075 | 18620.0 |
| 2020-01-09 05:30:00 | AAPL | Stock | 76.4 | 76.425 | 76.35 | 76.425 | 14840.0 |
| 2020-01-09 05:35:00 | AAPL | Stock | 76.425 | 76.425 | 76.425 | 76.425 | 892.0 |
| 2020-01-09 05:40:00 | AAPL | Stock | 76.425 | 76.4275 | 76.425 | 76.4275 | 1576.0 |
| 2020-01-09 05:45:00 | AAPL | Stock | 76.4275 | 76.4275 | 76.425 | 76.425 | 1788.0 |
| 2020-01-09 05:50:00 | AAPL | Stock | 76.4175 | 76.425 | 76.4175 | 76.425 | 11960.0 |
| 2020-01-09 05:55:00 | AAPL | Stock | 76.42 | 76.4225 | 76.42 | 76.4225 | 3772.0 |
| 2020-01-09 06:00:00 | AAPL | Stock | 76.4225 | 76.4225 | 76.35 | 76.35 | 1300.0 |
| 2020-01-09 06:05:00 | AAPL | Stock | 76.35 | 76.35 | 76.3475 | 76.3475 | 1640.0 |
| 2020-01-09 06:10:00 | AAPL | Stock | 76.355 | 76.355 | 76.3525 | 76.3525 | 1456.0 |
| 2020-01-09 06:15:00 | AAPL | Stock | 76.3475 | 76.3475 | 76.3475 | 76.3475 | 776.0 |
| 2020-01-09 06:20:00 | AAPL | Stock | 76.3925 | 76.4 | 76.3925 | 76.4 | 3416.0 |
| 2020-01-09 06:30:00 | AAPL | Stock | 76.4025 | 76.4025 | 76.4025 | 76.4025 | 1200.0 |
| 2020-01-09 06:35:00 | AAPL | Stock | 76.37 | 76.4625 | 76.3675 | 76.4625 | 4516.0 |
| 2020-01-09 06:40:00 | AAPL | Stock | 76.3825 | 76.3825 | 76.35 | 76.35 | 8376.0 |
| 2020-01-09 06:45:00 | AAPL | Stock | 76.355 | 76.355 | 76.355 | 76.355 | 3668.0 |
| 2020-01-09 06:50:00 | AAPL | Stock | 76.355 | 76.355 | 76.35 | 76.35 | 3876.0 |
| 2020-01-09 06:55:00 | AAPL | Stock | 76.355 | 76.355 | 76.35 | 76.35 | 2308.0 |
| 2020-01-09 07:00:00 | AAPL | Stock | 76.35 | 76.5625 | 76.31 | 76.4925 | 154120.0 |
| 2020-01-09 07:05:00 | AAPL | Stock | 76.4725 | 76.55 | 76.4725 | 76.53 | 62876.0 |
| 2020-01-09 07:10:00 | AAPL | Stock | 76.5625 | 76.6 | 76.5525 | 76.6 | 47888.0 |
| 2020-01-09 07:15:00 | AAPL | Stock | 76.6 | 76.66 | 76.6 | 76.6125 | 62436.0 |
| 2020-01-09 07:20:00 | AAPL | Stock | 76.6225 | 76.6725 | 76.5825 | 76.625 | 77980.0 |
| 2020-01-09 07:25:00 | AAPL | Stock | 76.625 | 76.625 | 76.5 | 76.57 | 76012.0 |
| 2020-01-09 07:30:00 | AAPL | Stock | 76.595 | 76.595 | 76.4525 | 76.5 | 97376.0 |
| 2020-01-09 07:35:00 | AAPL | Stock | 76.5325 | 76.56 | 76.52 | 76.5375 | 27536.0 |
| 2020-01-09 07:40:00 | AAPL | Stock | 76.5625 | 76.5925 | 76.5475 | 76.585 | 42288.0 |
| 2020-01-09 07:45:00 | AAPL | Stock | 76.6125 | 76.6425 | 76.525 | 76.525 | 64616.0 |
| 2020-01-09 07:50:00 | AAPL | Stock | 76.55 | 76.575 | 76.5275 | 76.5375 | 16260.0 |
| 2020-01-09 07:55:00 | AAPL | Stock | 76.515 | 76.59 | 76.5075 | 76.575 | 29608.0 |
| 2020-01-09 08:00:00 | AAPL | Stock | 76.5 | 76.645 | 76.385 | 76.6 | 174684.0 |
| 2020-01-09 08:05:00 | AAPL | Stock | 76.6225 | 76.6425 | 76.585 | 76.625 | 26600.0 |
| 2020-01-09 08:10:00 | AAPL | Stock | 76.6 | 76.6775 | 76.6 | 76.6775 | 82156.0 |
| 2020-01-09 08:15:00 | AAPL | Stock | 76.6875 | 76.7 | 76.595 | 76.6725 | 125564.0 |
> showing 50 of 371,941 rows — these rows as CSV