PREVIEW / stock_5min / 2020-06-29
file: by_date/stock_5min/2020/2020-06-29.parquet size: 6.7 MB rows: 428,390 symbols: 2,451
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-06-29 04:10:00 | AAPL | Stock | 88.5 | 88.5 | 88.47 | 88.475 | 3200.0 |
| 2020-06-29 04:15:00 | AAPL | Stock | 88.45 | 88.45 | 88.45 | 88.45 | 800.0 |
| 2020-06-29 04:20:00 | AAPL | Stock | 88.5 | 88.5 | 88.5 | 88.5 | 400.0 |
| 2020-06-29 04:35:00 | AAPL | Stock | 88.6625 | 88.6625 | 88.6625 | 88.6625 | 1200.0 |
| 2020-06-29 05:00:00 | AAPL | Stock | 88.6625 | 88.6625 | 88.6625 | 88.6625 | 600.0 |
| 2020-06-29 05:05:00 | AAPL | Stock | 88.695 | 88.695 | 88.575 | 88.575 | 1600.0 |
| 2020-06-29 05:20:00 | AAPL | Stock | 88.7375 | 88.75 | 88.7375 | 88.75 | 1600.0 |
| 2020-06-29 05:30:00 | AAPL | Stock | 88.75 | 88.75 | 88.575 | 88.575 | 2860.0 |
| 2020-06-29 05:40:00 | AAPL | Stock | 88.605 | 88.6475 | 88.6 | 88.6 | 2756.0 |
| 2020-06-29 05:45:00 | AAPL | Stock | 88.71 | 88.71 | 88.71 | 88.71 | 1804.0 |
| 2020-06-29 05:50:00 | AAPL | Stock | 88.7575 | 88.7575 | 88.75 | 88.75 | 1200.0 |
| 2020-06-29 05:55:00 | AAPL | Stock | 88.685 | 88.7725 | 88.685 | 88.7725 | 2392.0 |
| 2020-06-29 06:00:00 | AAPL | Stock | 88.6275 | 88.63 | 88.625 | 88.63 | 16732.0 |
| 2020-06-29 06:05:00 | AAPL | Stock | 88.6325 | 88.6375 | 88.625 | 88.625 | 30368.0 |
| 2020-06-29 06:10:00 | AAPL | Stock | 88.595 | 88.595 | 88.595 | 88.595 | 400.0 |
| 2020-06-29 06:15:00 | AAPL | Stock | 88.6 | 88.6 | 88.6 | 88.6 | 400.0 |
| 2020-06-29 06:35:00 | AAPL | Stock | 88.5875 | 88.6 | 88.5075 | 88.5075 | 12540.0 |
| 2020-06-29 06:40:00 | AAPL | Stock | 88.5125 | 88.5125 | 88.5125 | 88.5125 | 840.0 |
| 2020-06-29 06:45:00 | AAPL | Stock | 88.625 | 88.625 | 88.5625 | 88.5625 | 7576.0 |
| 2020-06-29 06:50:00 | AAPL | Stock | 88.6125 | 88.615 | 88.5675 | 88.5675 | 5912.0 |
| 2020-06-29 06:55:00 | AAPL | Stock | 88.5675 | 88.745 | 88.5675 | 88.745 | 13084.0 |
| 2020-06-29 07:00:00 | AAPL | Stock | 88.68 | 88.7625 | 88.3 | 88.3225 | 85964.0 |
| 2020-06-29 07:05:00 | AAPL | Stock | 88.3125 | 88.3675 | 88.2925 | 88.3375 | 9568.0 |
| 2020-06-29 07:10:00 | AAPL | Stock | 88.325 | 88.3375 | 88.17 | 88.1875 | 64400.0 |
| 2020-06-29 07:15:00 | AAPL | Stock | 88.225 | 88.325 | 88.0875 | 88.25 | 47728.0 |
| 2020-06-29 07:20:00 | AAPL | Stock | 88.265 | 88.3475 | 88.265 | 88.3475 | 12096.0 |
| 2020-06-29 07:25:00 | AAPL | Stock | 88.3975 | 88.425 | 88.375 | 88.425 | 8492.0 |
| 2020-06-29 07:30:00 | AAPL | Stock | 88.4525 | 88.4525 | 88.39 | 88.45 | 22160.0 |
| 2020-06-29 07:35:00 | AAPL | Stock | 88.4125 | 88.435 | 88.3875 | 88.435 | 18976.0 |
| 2020-06-29 07:40:00 | AAPL | Stock | 88.4 | 88.475 | 88.4 | 88.475 | 14236.0 |
| 2020-06-29 07:45:00 | AAPL | Stock | 88.465 | 88.6125 | 88.4225 | 88.6125 | 6284.0 |
| 2020-06-29 07:50:00 | AAPL | Stock | 88.5625 | 88.75 | 88.5625 | 88.75 | 34996.0 |
| 2020-06-29 07:55:00 | AAPL | Stock | 88.74 | 88.8 | 88.7 | 88.75 | 28212.0 |
| 2020-06-29 08:00:00 | AAPL | Stock | 88.755 | 88.7975 | 88.215 | 88.725 | 146248.0 |
| 2020-06-29 08:05:00 | AAPL | Stock | 88.75 | 88.8 | 88.75 | 88.7875 | 10904.0 |
| 2020-06-29 08:10:00 | AAPL | Stock | 88.775 | 88.8675 | 88.775 | 88.86 | 49524.0 |
| 2020-06-29 08:15:00 | AAPL | Stock | 88.8575 | 88.86 | 88.8125 | 88.8175 | 16712.0 |
| 2020-06-29 08:20:00 | AAPL | Stock | 88.7875 | 88.8 | 88.69 | 88.69 | 35516.0 |
| 2020-06-29 08:25:00 | AAPL | Stock | 88.705 | 88.745 | 88.61 | 88.66 | 16684.0 |
| 2020-06-29 08:30:00 | AAPL | Stock | 88.6075 | 88.735 | 88.6075 | 88.725 | 11076.0 |
| 2020-06-29 08:35:00 | AAPL | Stock | 88.7225 | 88.725 | 88.575 | 88.5825 | 26052.0 |
| 2020-06-29 08:40:00 | AAPL | Stock | 88.5625 | 88.5925 | 88.505 | 88.5925 | 25644.0 |
| 2020-06-29 08:45:00 | AAPL | Stock | 88.5425 | 88.595 | 88.5132 | 88.575 | 15248.0 |
| 2020-06-29 08:50:00 | AAPL | Stock | 88.5625 | 88.575 | 88.5125 | 88.5125 | 19016.0 |
| 2020-06-29 08:55:00 | AAPL | Stock | 88.5125 | 88.5125 | 88.4375 | 88.475 | 43352.0 |
| 2020-06-29 09:00:00 | AAPL | Stock | 88.48 | 88.6175 | 88.475 | 88.5125 | 26600.0 |
| 2020-06-29 09:05:00 | AAPL | Stock | 88.52 | 88.52 | 88.4575 | 88.475 | 26420.0 |
| 2020-06-29 09:10:00 | AAPL | Stock | 88.5 | 88.5375 | 88.385 | 88.3875 | 52460.0 |
| 2020-06-29 09:15:00 | AAPL | Stock | 88.49 | 88.49 | 88.3875 | 88.3925 | 13964.0 |
| 2020-06-29 09:20:00 | AAPL | Stock | 88.41 | 88.4502 | 88.3775 | 88.4502 | 21152.0 |
> showing 50 of 428,390 rows — these rows as CSV