PREVIEW / stock_5min / 2019-08-30
file: by_date/stock_5min/2019/2019-08-30.parquet size: 5.5 MB rows: 352,058 symbols: 2,571
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-30 04:00:00 | AAPL | Stock | 52.4175 | 52.4375 | 52.4175 | 52.4375 | 4128.0 |
| 2019-08-30 04:15:00 | AAPL | Stock | 52.4025 | 52.4025 | 52.4 | 52.4 | 1600.0 |
| 2019-08-30 04:20:00 | AAPL | Stock | 52.43 | 52.43 | 52.43 | 52.43 | 2000.0 |
| 2019-08-30 04:25:00 | AAPL | Stock | 52.45 | 52.5 | 52.45 | 52.5 | 10148.0 |
| 2019-08-30 04:35:00 | AAPL | Stock | 52.48 | 52.48 | 52.4625 | 52.4625 | 1972.0 |
| 2019-08-30 04:45:00 | AAPL | Stock | 52.56 | 52.575 | 52.56 | 52.575 | 14436.0 |
| 2019-08-30 04:50:00 | AAPL | Stock | 52.575 | 52.575 | 52.5025 | 52.5025 | 1480.0 |
| 2019-08-30 05:00:00 | AAPL | Stock | 52.625 | 52.675 | 52.625 | 52.675 | 6736.0 |
| 2019-08-30 05:05:00 | AAPL | Stock | 52.6725 | 52.6725 | 52.6725 | 52.6725 | 400.0 |
| 2019-08-30 05:10:00 | AAPL | Stock | 52.7125 | 52.7125 | 52.7125 | 52.7125 | 644.0 |
| 2019-08-30 05:15:00 | AAPL | Stock | 52.7125 | 52.7125 | 52.7125 | 52.7125 | 1000.0 |
| 2019-08-30 05:20:00 | AAPL | Stock | 52.705 | 52.705 | 52.705 | 52.705 | 788.0 |
| 2019-08-30 05:25:00 | AAPL | Stock | 52.7475 | 52.755 | 52.7475 | 52.755 | 1200.0 |
| 2019-08-30 05:30:00 | AAPL | Stock | 52.73 | 52.73 | 52.73 | 52.73 | 400.0 |
| 2019-08-30 05:35:00 | AAPL | Stock | 52.705 | 52.705 | 52.7 | 52.7 | 800.0 |
| 2019-08-30 05:40:00 | AAPL | Stock | 52.665 | 52.665 | 52.665 | 52.665 | 1088.0 |
| 2019-08-30 05:45:00 | AAPL | Stock | 52.665 | 52.69 | 52.665 | 52.665 | 9200.0 |
| 2019-08-30 05:50:00 | AAPL | Stock | 52.7475 | 52.7475 | 52.625 | 52.7 | 4664.0 |
| 2019-08-30 06:00:00 | AAPL | Stock | 52.7025 | 52.725 | 52.7 | 52.725 | 1700.0 |
| 2019-08-30 06:15:00 | AAPL | Stock | 52.675 | 52.675 | 52.675 | 52.675 | 1600.0 |
| 2019-08-30 06:20:00 | AAPL | Stock | 52.65 | 52.6875 | 52.625 | 52.6875 | 3016.0 |
| 2019-08-30 06:25:00 | AAPL | Stock | 52.6875 | 52.6875 | 52.65 | 52.675 | 4000.0 |
| 2019-08-30 06:40:00 | AAPL | Stock | 52.675 | 52.695 | 52.675 | 52.695 | 4356.0 |
| 2019-08-30 06:50:00 | AAPL | Stock | 52.675 | 52.675 | 52.6475 | 52.6475 | 2772.0 |
| 2019-08-30 06:55:00 | AAPL | Stock | 52.6125 | 52.6975 | 52.6125 | 52.6975 | 4000.0 |
| 2019-08-30 07:00:00 | AAPL | Stock | 52.6975 | 52.6975 | 52.555 | 52.605 | 45892.0 |
| 2019-08-30 07:05:00 | AAPL | Stock | 52.605 | 52.625 | 52.6 | 52.6 | 12912.0 |
| 2019-08-30 07:10:00 | AAPL | Stock | 52.6 | 52.6 | 52.575 | 52.575 | 6460.0 |
| 2019-08-30 07:15:00 | AAPL | Stock | 52.5375 | 52.55 | 52.525 | 52.5275 | 9520.0 |
| 2019-08-30 07:20:00 | AAPL | Stock | 52.505 | 52.505 | 52.4975 | 52.4975 | 8488.0 |
| 2019-08-30 07:25:00 | AAPL | Stock | 52.525 | 52.525 | 52.4875 | 52.4875 | 10388.0 |
| 2019-08-30 07:30:00 | AAPL | Stock | 52.5125 | 52.5675 | 52.5125 | 52.5675 | 8544.0 |
| 2019-08-30 07:35:00 | AAPL | Stock | 52.53 | 52.6225 | 52.53 | 52.59 | 14240.0 |
| 2019-08-30 07:40:00 | AAPL | Stock | 52.5625 | 52.6 | 52.5625 | 52.565 | 4588.0 |
| 2019-08-30 07:45:00 | AAPL | Stock | 52.595 | 52.61 | 52.595 | 52.61 | 27044.0 |
| 2019-08-30 07:50:00 | AAPL | Stock | 52.575 | 52.6575 | 52.575 | 52.655 | 14908.0 |
| 2019-08-30 07:55:00 | AAPL | Stock | 52.65 | 52.6575 | 52.6375 | 52.6375 | 14252.0 |
| 2019-08-30 08:00:00 | AAPL | Stock | 52.595 | 52.655 | 52.4875 | 52.6025 | 89432.0 |
| 2019-08-30 08:05:00 | AAPL | Stock | 52.6 | 52.625 | 52.5875 | 52.625 | 15644.0 |
| 2019-08-30 08:10:00 | AAPL | Stock | 52.6075 | 52.6075 | 52.5675 | 52.575 | 4128.0 |
| 2019-08-30 08:15:00 | AAPL | Stock | 52.6 | 52.6125 | 52.575 | 52.6125 | 13808.0 |
| 2019-08-30 08:20:00 | AAPL | Stock | 52.595 | 52.6125 | 52.5775 | 52.5775 | 14200.0 |
| 2019-08-30 08:25:00 | AAPL | Stock | 52.5775 | 52.615 | 52.5775 | 52.615 | 10384.0 |
| 2019-08-30 08:30:00 | AAPL | Stock | 52.615 | 52.63 | 52.615 | 52.625 | 8400.0 |
| 2019-08-30 08:35:00 | AAPL | Stock | 52.6375 | 52.6572 | 52.6225 | 52.6225 | 24872.0 |
| 2019-08-30 08:40:00 | AAPL | Stock | 52.6175 | 52.645 | 52.5775 | 52.6125 | 16320.0 |
| 2019-08-30 08:45:00 | AAPL | Stock | 52.63 | 52.63 | 52.575 | 52.6 | 11600.0 |
| 2019-08-30 08:50:00 | AAPL | Stock | 52.59 | 52.6 | 52.59 | 52.6 | 12376.0 |
| 2019-08-30 08:55:00 | AAPL | Stock | 52.6075 | 52.615 | 52.5825 | 52.6125 | 3492.0 |
| 2019-08-30 09:00:00 | AAPL | Stock | 52.6075 | 52.6075 | 52.5825 | 52.5825 | 21628.0 |
> showing 50 of 352,058 rows — these rows as CSV