PREVIEW / stock_5min / 2020-03-10
file: by_date/stock_5min/2020/2020-03-10.parquet size: 6.6 MB rows: 411,284 symbols: 2,431
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-03-10 04:00:00 | AAPL | Stock | 68.85 | 69.255 | 68.75 | 68.775 | 14260.0 |
| 2020-03-10 04:05:00 | AAPL | Stock | 68.8925 | 69.4075 | 68.8925 | 69.3325 | 26724.0 |
| 2020-03-10 04:10:00 | AAPL | Stock | 69.3075 | 69.3075 | 68.75 | 68.75 | 17032.0 |
| 2020-03-10 04:15:00 | AAPL | Stock | 68.655 | 68.79 | 68.605 | 68.79 | 4904.0 |
| 2020-03-10 04:20:00 | AAPL | Stock | 69.0975 | 69.0975 | 69.0975 | 69.0975 | 2448.0 |
| 2020-03-10 04:25:00 | AAPL | Stock | 69.235 | 69.2475 | 69.1925 | 69.2475 | 1912.0 |
| 2020-03-10 04:30:00 | AAPL | Stock | 69.16 | 69.3975 | 69.1475 | 69.3975 | 3268.0 |
| 2020-03-10 04:40:00 | AAPL | Stock | 69.3525 | 69.3525 | 69.315 | 69.315 | 3132.0 |
| 2020-03-10 04:50:00 | AAPL | Stock | 69.475 | 69.5875 | 69.4025 | 69.585 | 18388.0 |
| 2020-03-10 04:55:00 | AAPL | Stock | 69.6125 | 69.75 | 69.6125 | 69.75 | 18880.0 |
| 2020-03-10 05:00:00 | AAPL | Stock | 69.755 | 69.755 | 69.6925 | 69.7175 | 7152.0 |
| 2020-03-10 05:05:00 | AAPL | Stock | 69.75 | 69.835 | 69.75 | 69.78 | 17468.0 |
| 2020-03-10 05:10:00 | AAPL | Stock | 69.75 | 69.75 | 69.695 | 69.695 | 4300.0 |
| 2020-03-10 05:15:00 | AAPL | Stock | 69.75 | 69.9325 | 69.75 | 69.925 | 11200.0 |
| 2020-03-10 05:20:00 | AAPL | Stock | 69.875 | 70.0525 | 69.875 | 70.05 | 7456.0 |
| 2020-03-10 05:25:00 | AAPL | Stock | 70.05 | 70.1125 | 70.0 | 70.1125 | 14412.0 |
| 2020-03-10 05:30:00 | AAPL | Stock | 70.055 | 70.135 | 70.055 | 70.135 | 4880.0 |
| 2020-03-10 05:35:00 | AAPL | Stock | 70.2475 | 70.25 | 70.245 | 70.25 | 3228.0 |
| 2020-03-10 05:40:00 | AAPL | Stock | 70.4025 | 70.4775 | 70.3625 | 70.4775 | 5384.0 |
| 2020-03-10 05:45:00 | AAPL | Stock | 70.375 | 70.4075 | 70.2875 | 70.325 | 24236.0 |
| 2020-03-10 05:50:00 | AAPL | Stock | 70.2775 | 70.2775 | 70.0625 | 70.0625 | 5944.0 |
| 2020-03-10 05:55:00 | AAPL | Stock | 70.0175 | 70.1175 | 69.825 | 70.0125 | 45536.0 |
| 2020-03-10 06:00:00 | AAPL | Stock | 70.085 | 70.085 | 69.875 | 69.925 | 9316.0 |
| 2020-03-10 06:05:00 | AAPL | Stock | 69.975 | 69.975 | 69.975 | 69.975 | 1720.0 |
| 2020-03-10 06:10:00 | AAPL | Stock | 70.025 | 70.2 | 70.025 | 70.125 | 24984.0 |
| 2020-03-10 06:15:00 | AAPL | Stock | 70.125 | 70.125 | 70.025 | 70.045 | 6200.0 |
| 2020-03-10 06:20:00 | AAPL | Stock | 70.0375 | 70.0375 | 69.925 | 69.9725 | 8876.0 |
| 2020-03-10 06:25:00 | AAPL | Stock | 69.85 | 69.8975 | 69.85 | 69.8975 | 3432.0 |
| 2020-03-10 06:30:00 | AAPL | Stock | 69.895 | 70.05 | 69.795 | 70.035 | 13836.0 |
| 2020-03-10 06:35:00 | AAPL | Stock | 69.9575 | 69.965 | 69.8 | 69.875 | 5376.0 |
| 2020-03-10 06:40:00 | AAPL | Stock | 69.87 | 69.925 | 69.87 | 69.925 | 4040.0 |
| 2020-03-10 06:45:00 | AAPL | Stock | 69.95 | 70.0725 | 69.935 | 70.06 | 5604.0 |
| 2020-03-10 06:50:00 | AAPL | Stock | 70.06 | 70.1475 | 70.06 | 70.1475 | 16560.0 |
| 2020-03-10 06:55:00 | AAPL | Stock | 70.2275 | 70.235 | 70.0875 | 70.1275 | 8344.0 |
| 2020-03-10 07:00:00 | AAPL | Stock | 70.195 | 70.2375 | 69.7875 | 69.84 | 107052.0 |
| 2020-03-10 07:05:00 | AAPL | Stock | 69.83 | 69.955 | 69.825 | 69.9225 | 56732.0 |
| 2020-03-10 07:10:00 | AAPL | Stock | 69.875 | 69.96 | 69.7875 | 69.7875 | 29524.0 |
| 2020-03-10 07:15:00 | AAPL | Stock | 69.79 | 69.805 | 69.575 | 69.625 | 59208.0 |
| 2020-03-10 07:20:00 | AAPL | Stock | 69.58 | 69.7125 | 69.5375 | 69.6375 | 43948.0 |
| 2020-03-10 07:25:00 | AAPL | Stock | 69.6725 | 69.7 | 69.4475 | 69.5225 | 52172.0 |
| 2020-03-10 07:30:00 | AAPL | Stock | 69.4975 | 69.65 | 69.4975 | 69.6225 | 43928.0 |
| 2020-03-10 07:35:00 | AAPL | Stock | 69.6225 | 69.845 | 69.605 | 69.775 | 58376.0 |
| 2020-03-10 07:40:00 | AAPL | Stock | 69.8025 | 69.8125 | 69.75 | 69.75 | 44984.0 |
| 2020-03-10 07:45:00 | AAPL | Stock | 69.6325 | 69.725 | 69.555 | 69.555 | 25732.0 |
| 2020-03-10 07:50:00 | AAPL | Stock | 69.5625 | 69.6625 | 69.555 | 69.5625 | 25492.0 |
| 2020-03-10 07:55:00 | AAPL | Stock | 69.5525 | 69.6625 | 69.5125 | 69.6025 | 19876.0 |
| 2020-03-10 08:00:00 | AAPL | Stock | 69.625 | 70.175 | 69.5 | 69.8625 | 404320.0 |
| 2020-03-10 08:05:00 | AAPL | Stock | 69.875 | 69.9075 | 69.0625 | 69.0625 | 128580.0 |
| 2020-03-10 08:10:00 | AAPL | Stock | 69.0375 | 69.3625 | 68.8125 | 69.25 | 220044.0 |
| 2020-03-10 08:15:00 | AAPL | Stock | 69.175 | 69.275 | 69.0 | 69.185 | 165712.0 |
> showing 50 of 411,284 rows — these rows as CSV