PREVIEW / stock_5min / 2020-07-06
file: by_date/stock_5min/2020/2020-07-06.parquet size: 6.7 MB rows: 425,675 symbols: 2,445
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-07-06 04:00:00 | AAPL | Stock | 92.255 | 92.5 | 92.255 | 92.5 | 6204.0 |
| 2020-07-06 04:05:00 | AAPL | Stock | 92.525 | 92.55 | 92.5125 | 92.5275 | 5172.0 |
| 2020-07-06 04:10:00 | AAPL | Stock | 92.55 | 92.6725 | 92.5 | 92.6725 | 14276.0 |
| 2020-07-06 04:15:00 | AAPL | Stock | 92.6975 | 92.75 | 92.675 | 92.675 | 9988.0 |
| 2020-07-06 04:20:00 | AAPL | Stock | 92.6825 | 92.6825 | 92.6275 | 92.6275 | 6788.0 |
| 2020-07-06 04:30:00 | AAPL | Stock | 92.6675 | 92.6675 | 92.5525 | 92.585 | 5108.0 |
| 2020-07-06 04:35:00 | AAPL | Stock | 92.5325 | 92.5325 | 92.5325 | 92.5325 | 1288.0 |
| 2020-07-06 04:40:00 | AAPL | Stock | 92.5 | 92.5 | 92.5 | 92.5 | 1660.0 |
| 2020-07-06 04:50:00 | AAPL | Stock | 92.4775 | 92.4775 | 92.4775 | 92.4775 | 400.0 |
| 2020-07-06 04:55:00 | AAPL | Stock | 92.4875 | 92.4875 | 92.4875 | 92.4875 | 1624.0 |
| 2020-07-06 05:00:00 | AAPL | Stock | 92.475 | 92.475 | 92.475 | 92.475 | 1200.0 |
| 2020-07-06 05:05:00 | AAPL | Stock | 92.4325 | 92.4325 | 92.425 | 92.425 | 2400.0 |
| 2020-07-06 05:10:00 | AAPL | Stock | 92.375 | 92.38 | 92.375 | 92.38 | 1200.0 |
| 2020-07-06 05:20:00 | AAPL | Stock | 92.4975 | 92.58 | 92.4975 | 92.5675 | 2400.0 |
| 2020-07-06 05:25:00 | AAPL | Stock | 92.4925 | 92.4925 | 92.475 | 92.475 | 7800.0 |
| 2020-07-06 05:30:00 | AAPL | Stock | 92.545 | 92.565 | 92.525 | 92.525 | 2072.0 |
| 2020-07-06 05:40:00 | AAPL | Stock | 92.5675 | 92.5675 | 92.5675 | 92.5675 | 712.0 |
| 2020-07-06 05:50:00 | AAPL | Stock | 92.5625 | 92.5625 | 92.5625 | 92.5625 | 1200.0 |
| 2020-07-06 06:00:00 | AAPL | Stock | 92.55 | 92.55 | 92.55 | 92.55 | 3200.0 |
| 2020-07-06 06:10:00 | AAPL | Stock | 92.625 | 92.625 | 92.625 | 92.625 | 400.0 |
| 2020-07-06 06:25:00 | AAPL | Stock | 92.575 | 92.575 | 92.575 | 92.575 | 1596.0 |
| 2020-07-06 06:30:00 | AAPL | Stock | 92.575 | 92.5775 | 92.575 | 92.575 | 7360.0 |
| 2020-07-06 06:35:00 | AAPL | Stock | 92.625 | 92.625 | 92.55 | 92.55 | 1948.0 |
| 2020-07-06 06:40:00 | AAPL | Stock | 92.55 | 92.55 | 92.5 | 92.5075 | 6076.0 |
| 2020-07-06 06:45:00 | AAPL | Stock | 92.525 | 92.585 | 92.525 | 92.585 | 2000.0 |
| 2020-07-06 06:50:00 | AAPL | Stock | 92.5375 | 92.6 | 92.5375 | 92.6 | 1712.0 |
| 2020-07-06 06:55:00 | AAPL | Stock | 92.6 | 92.6 | 92.6 | 92.6 | 412.0 |
| 2020-07-06 07:00:00 | AAPL | Stock | 92.55 | 92.55 | 92.325 | 92.3625 | 76356.0 |
| 2020-07-06 07:05:00 | AAPL | Stock | 92.3325 | 92.3625 | 92.3325 | 92.3625 | 10648.0 |
| 2020-07-06 07:10:00 | AAPL | Stock | 92.3525 | 92.3525 | 92.31 | 92.35 | 11200.0 |
| 2020-07-06 07:15:00 | AAPL | Stock | 92.3725 | 92.4 | 92.365 | 92.365 | 13032.0 |
| 2020-07-06 07:20:00 | AAPL | Stock | 92.375 | 92.375 | 92.2825 | 92.2825 | 40364.0 |
| 2020-07-06 07:25:00 | AAPL | Stock | 92.28 | 92.39 | 92.28 | 92.3875 | 6396.0 |
| 2020-07-06 07:30:00 | AAPL | Stock | 92.39 | 92.4 | 92.36 | 92.375 | 21184.0 |
| 2020-07-06 07:35:00 | AAPL | Stock | 92.3675 | 92.3875 | 92.3575 | 92.3875 | 14768.0 |
| 2020-07-06 07:40:00 | AAPL | Stock | 92.3975 | 92.425 | 92.3875 | 92.42 | 23668.0 |
| 2020-07-06 07:45:00 | AAPL | Stock | 92.4225 | 92.4725 | 92.42 | 92.4525 | 32816.0 |
| 2020-07-06 07:50:00 | AAPL | Stock | 92.4675 | 92.475 | 92.45 | 92.45 | 35616.0 |
| 2020-07-06 07:55:00 | AAPL | Stock | 92.465 | 92.465 | 92.43 | 92.4425 | 17168.0 |
| 2020-07-06 08:00:00 | AAPL | Stock | 92.2812 | 92.495 | 92.2775 | 92.4 | 143628.0 |
| 2020-07-06 08:05:00 | AAPL | Stock | 92.4 | 92.4475 | 92.375 | 92.4475 | 18240.0 |
| 2020-07-06 08:10:00 | AAPL | Stock | 92.45 | 92.45 | 92.4025 | 92.425 | 8892.0 |
| 2020-07-06 08:15:00 | AAPL | Stock | 92.425 | 92.4625 | 92.39 | 92.4625 | 17288.0 |
| 2020-07-06 08:20:00 | AAPL | Stock | 92.455 | 92.4625 | 92.4375 | 92.4525 | 24824.0 |
| 2020-07-06 08:25:00 | AAPL | Stock | 92.4625 | 92.4775 | 92.45 | 92.45 | 28516.0 |
| 2020-07-06 08:30:00 | AAPL | Stock | 92.46 | 92.475 | 92.435 | 92.45 | 15576.0 |
| 2020-07-06 08:35:00 | AAPL | Stock | 92.4375 | 92.45 | 92.425 | 92.4275 | 19068.0 |
| 2020-07-06 08:40:00 | AAPL | Stock | 92.4375 | 92.4375 | 92.4125 | 92.425 | 28384.0 |
| 2020-07-06 08:45:00 | AAPL | Stock | 92.405 | 92.425 | 92.375 | 92.4 | 19976.0 |
| 2020-07-06 08:50:00 | AAPL | Stock | 92.375 | 92.395 | 92.3275 | 92.3575 | 21416.0 |
> showing 50 of 425,675 rows — these rows as CSV