PREVIEW / stock_5min / 2020-06-30
file: by_date/stock_5min/2020/2020-06-30.parquet size: 6.6 MB rows: 422,875 symbols: 2,456
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-30 04:00:00 | AAPL | Stock | 90.675 | 90.675 | 90.625 | 90.625 | 4304.0 |
| 2020-06-30 04:05:00 | AAPL | Stock | 90.625 | 90.625 | 90.5725 | 90.5725 | 2600.0 |
| 2020-06-30 04:10:00 | AAPL | Stock | 90.5725 | 90.575 | 90.57 | 90.575 | 5100.0 |
| 2020-06-30 04:15:00 | AAPL | Stock | 90.575 | 90.575 | 90.575 | 90.575 | 1136.0 |
| 2020-06-30 04:25:00 | AAPL | Stock | 90.6575 | 90.665 | 90.6575 | 90.665 | 2800.0 |
| 2020-06-30 04:30:00 | AAPL | Stock | 90.665 | 90.665 | 90.665 | 90.665 | 400.0 |
| 2020-06-30 04:35:00 | AAPL | Stock | 90.6275 | 90.6275 | 90.6275 | 90.6275 | 2400.0 |
| 2020-06-30 04:40:00 | AAPL | Stock | 90.56 | 90.56 | 90.5575 | 90.5575 | 1104.0 |
| 2020-06-30 05:10:00 | AAPL | Stock | 90.565 | 90.565 | 90.565 | 90.565 | 1348.0 |
| 2020-06-30 05:30:00 | AAPL | Stock | 90.685 | 90.6875 | 90.685 | 90.6875 | 1240.0 |
| 2020-06-30 05:35:00 | AAPL | Stock | 90.6825 | 90.6875 | 90.6375 | 90.6375 | 2392.0 |
| 2020-06-30 05:45:00 | AAPL | Stock | 90.5275 | 90.5275 | 90.5275 | 90.5275 | 688.0 |
| 2020-06-30 06:10:00 | AAPL | Stock | 90.535 | 90.555 | 90.525 | 90.525 | 4508.0 |
| 2020-06-30 06:20:00 | AAPL | Stock | 90.45 | 90.45 | 90.15 | 90.25 | 18284.0 |
| 2020-06-30 06:25:00 | AAPL | Stock | 90.25 | 90.25 | 89.75 | 89.9375 | 34836.0 |
| 2020-06-30 06:30:00 | AAPL | Stock | 89.9425 | 89.975 | 89.8575 | 89.9375 | 19492.0 |
| 2020-06-30 06:35:00 | AAPL | Stock | 89.825 | 89.83 | 89.64 | 89.675 | 12476.0 |
| 2020-06-30 06:40:00 | AAPL | Stock | 89.7425 | 89.91 | 89.625 | 89.7925 | 21240.0 |
| 2020-06-30 06:45:00 | AAPL | Stock | 89.7125 | 89.7625 | 89.65 | 89.65 | 15984.0 |
| 2020-06-30 06:50:00 | AAPL | Stock | 89.65 | 89.655 | 89.625 | 89.65 | 13196.0 |
| 2020-06-30 07:00:00 | AAPL | Stock | 89.7875 | 90.0475 | 89.7875 | 90.0475 | 40136.0 |
| 2020-06-30 07:05:00 | AAPL | Stock | 90.0375 | 90.2 | 90.0375 | 90.1175 | 21376.0 |
| 2020-06-30 07:10:00 | AAPL | Stock | 90.0875 | 90.125 | 90.075 | 90.075 | 10564.0 |
| 2020-06-30 07:15:00 | AAPL | Stock | 90.15 | 90.36 | 90.15 | 90.3 | 13072.0 |
| 2020-06-30 07:20:00 | AAPL | Stock | 90.3275 | 90.375 | 90.1375 | 90.1425 | 33120.0 |
| 2020-06-30 07:25:00 | AAPL | Stock | 90.1875 | 90.27 | 90.1875 | 90.225 | 10016.0 |
| 2020-06-30 07:30:00 | AAPL | Stock | 90.25 | 90.4 | 90.25 | 90.4 | 16256.0 |
| 2020-06-30 07:35:00 | AAPL | Stock | 90.42 | 90.425 | 90.33 | 90.375 | 20216.0 |
| 2020-06-30 07:40:00 | AAPL | Stock | 90.3625 | 90.375 | 90.3225 | 90.3225 | 13424.0 |
| 2020-06-30 07:45:00 | AAPL | Stock | 90.35 | 90.435 | 90.25 | 90.255 | 16572.0 |
| 2020-06-30 07:50:00 | AAPL | Stock | 90.25 | 90.25 | 90.175 | 90.185 | 7764.0 |
| 2020-06-30 07:55:00 | AAPL | Stock | 90.2025 | 90.2125 | 90.1625 | 90.1625 | 10108.0 |
| 2020-06-30 08:00:00 | AAPL | Stock | 90.355 | 90.4245 | 89.7775 | 90.175 | 97804.0 |
| 2020-06-30 08:05:00 | AAPL | Stock | 90.1475 | 90.19 | 90.1 | 90.1 | 10492.0 |
| 2020-06-30 08:10:00 | AAPL | Stock | 90.075 | 90.079 | 90.025 | 90.0398 | 22432.0 |
| 2020-06-30 08:15:00 | AAPL | Stock | 90.0325 | 90.125 | 90.03 | 90.0542 | 8932.0 |
| 2020-06-30 08:20:00 | AAPL | Stock | 90.0995 | 90.1 | 90.05 | 90.0925 | 4800.0 |
| 2020-06-30 08:25:00 | AAPL | Stock | 90.0875 | 90.0988 | 90.055 | 90.055 | 5700.0 |
| 2020-06-30 08:30:00 | AAPL | Stock | 90.03 | 90.05 | 89.9375 | 89.955 | 43268.0 |
| 2020-06-30 08:35:00 | AAPL | Stock | 89.955 | 89.9825 | 89.8925 | 89.9 | 20512.0 |
| 2020-06-30 08:40:00 | AAPL | Stock | 89.915 | 89.9825 | 89.915 | 89.97 | 13804.0 |
| 2020-06-30 08:45:00 | AAPL | Stock | 89.97 | 90.0475 | 89.97 | 90.0475 | 3200.0 |
| 2020-06-30 08:50:00 | AAPL | Stock | 90.035 | 90.035 | 89.9725 | 90.0125 | 26240.0 |
| 2020-06-30 08:55:00 | AAPL | Stock | 90.0175 | 90.0625 | 90.0 | 90.015 | 19492.0 |
| 2020-06-30 09:00:00 | AAPL | Stock | 90.05 | 90.0935 | 90.0 | 90.0 | 30812.0 |
| 2020-06-30 09:05:00 | AAPL | Stock | 90.0 | 90.01 | 89.8875 | 89.9 | 32376.0 |
| 2020-06-30 09:10:00 | AAPL | Stock | 89.9 | 89.925 | 89.9 | 89.905 | 7264.0 |
| 2020-06-30 09:15:00 | AAPL | Stock | 89.925 | 89.9875 | 89.91 | 89.91 | 4800.0 |
| 2020-06-30 09:20:00 | AAPL | Stock | 89.925 | 89.985 | 89.925 | 89.9625 | 2888.0 |
| 2020-06-30 09:25:00 | AAPL | Stock | 89.98 | 90.125 | 89.915 | 90.015 | 43752.0 |
> showing 50 of 422,875 rows — these rows as CSV