PREVIEW / stock_5min / 2020-08-14
file: by_date/stock_5min/2020/2020-08-14.parquet size: 6.4 MB rows: 402,202 symbols: 2,436
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-08-14 04:00:00 | AAPL | Stock | 114.8675 | 114.875 | 114.8025 | 114.8025 | 3572.0 |
| 2020-08-14 04:05:00 | AAPL | Stock | 114.87 | 114.87 | 114.8 | 114.8 | 3192.0 |
| 2020-08-14 04:10:00 | AAPL | Stock | 114.5825 | 114.63 | 114.5825 | 114.6275 | 1608.0 |
| 2020-08-14 04:15:00 | AAPL | Stock | 114.7425 | 114.76 | 114.7425 | 114.76 | 1208.0 |
| 2020-08-14 04:20:00 | AAPL | Stock | 114.65 | 114.65 | 114.6275 | 114.6275 | 1716.0 |
| 2020-08-14 04:25:00 | AAPL | Stock | 114.52 | 114.52 | 114.415 | 114.415 | 1116.0 |
| 2020-08-14 04:30:00 | AAPL | Stock | 114.605 | 114.605 | 114.605 | 114.605 | 400.0 |
| 2020-08-14 04:40:00 | AAPL | Stock | 114.5875 | 114.5875 | 114.5725 | 114.5725 | 2472.0 |
| 2020-08-14 04:45:00 | AAPL | Stock | 114.5225 | 114.5225 | 114.5225 | 114.5225 | 400.0 |
| 2020-08-14 04:55:00 | AAPL | Stock | 114.5275 | 114.5275 | 114.5275 | 114.5275 | 408.0 |
| 2020-08-14 05:00:00 | AAPL | Stock | 114.525 | 114.525 | 114.5 | 114.5 | 1216.0 |
| 2020-08-14 05:10:00 | AAPL | Stock | 114.3575 | 114.3575 | 114.3175 | 114.3175 | 2392.0 |
| 2020-08-14 05:15:00 | AAPL | Stock | 114.4 | 114.4 | 114.4 | 114.4 | 400.0 |
| 2020-08-14 05:20:00 | AAPL | Stock | 114.465 | 114.465 | 114.46 | 114.465 | 7968.0 |
| 2020-08-14 05:25:00 | AAPL | Stock | 114.4125 | 114.465 | 114.4125 | 114.465 | 2432.0 |
| 2020-08-14 05:30:00 | AAPL | Stock | 114.5575 | 114.5575 | 114.5575 | 114.5575 | 2280.0 |
| 2020-08-14 05:35:00 | AAPL | Stock | 114.5575 | 114.5575 | 114.5575 | 114.5575 | 600.0 |
| 2020-08-14 05:55:00 | AAPL | Stock | 114.65 | 114.65 | 114.65 | 114.65 | 400.0 |
| 2020-08-14 06:00:00 | AAPL | Stock | 114.6325 | 114.6325 | 114.6325 | 114.6325 | 644.0 |
| 2020-08-14 06:05:00 | AAPL | Stock | 114.575 | 114.575 | 114.4175 | 114.4175 | 11828.0 |
| 2020-08-14 06:10:00 | AAPL | Stock | 114.42 | 114.425 | 114.42 | 114.425 | 1080.0 |
| 2020-08-14 06:15:00 | AAPL | Stock | 114.52 | 114.52 | 114.52 | 114.52 | 400.0 |
| 2020-08-14 06:20:00 | AAPL | Stock | 114.5175 | 114.5175 | 114.5175 | 114.5175 | 1232.0 |
| 2020-08-14 06:45:00 | AAPL | Stock | 114.625 | 114.625 | 114.625 | 114.625 | 7860.0 |
| 2020-08-14 06:50:00 | AAPL | Stock | 114.6575 | 114.875 | 114.6575 | 114.8725 | 20024.0 |
| 2020-08-14 06:55:00 | AAPL | Stock | 114.935 | 114.9675 | 114.85 | 114.925 | 3636.0 |
| 2020-08-14 07:00:00 | AAPL | Stock | 114.915 | 114.975 | 114.6925 | 114.725 | 40808.0 |
| 2020-08-14 07:05:00 | AAPL | Stock | 114.675 | 114.725 | 114.5 | 114.6025 | 36704.0 |
| 2020-08-14 07:10:00 | AAPL | Stock | 114.6 | 114.72 | 114.5325 | 114.72 | 20356.0 |
| 2020-08-14 07:15:00 | AAPL | Stock | 114.72 | 114.755 | 114.665 | 114.75 | 12224.0 |
| 2020-08-14 07:20:00 | AAPL | Stock | 114.75 | 115.14 | 114.75 | 115.0625 | 38344.0 |
| 2020-08-14 07:25:00 | AAPL | Stock | 115.1075 | 115.3875 | 115.1075 | 115.2425 | 119472.0 |
| 2020-08-14 07:30:00 | AAPL | Stock | 115.2275 | 115.2425 | 115.165 | 115.2125 | 29360.0 |
| 2020-08-14 07:35:00 | AAPL | Stock | 115.2 | 115.225 | 115.125 | 115.225 | 26396.0 |
| 2020-08-14 07:40:00 | AAPL | Stock | 115.225 | 115.375 | 115.225 | 115.365 | 52340.0 |
| 2020-08-14 07:45:00 | AAPL | Stock | 115.375 | 115.395 | 115.1575 | 115.2025 | 51156.0 |
| 2020-08-14 07:50:00 | AAPL | Stock | 115.2175 | 115.32 | 115.2175 | 115.25 | 17548.0 |
| 2020-08-14 07:55:00 | AAPL | Stock | 115.235 | 115.2975 | 115.225 | 115.2875 | 45984.0 |
| 2020-08-14 08:00:00 | AAPL | Stock | 114.7932 | 115.385 | 114.575 | 115.23 | 168936.0 |
| 2020-08-14 08:05:00 | AAPL | Stock | 115.275 | 115.275 | 115.125 | 115.1522 | 59664.0 |
| 2020-08-14 08:10:00 | AAPL | Stock | 115.0885 | 115.165 | 115.0 | 115.1125 | 43712.0 |
| 2020-08-14 08:15:00 | AAPL | Stock | 115.095 | 115.1842 | 115.0875 | 115.13 | 15848.0 |
| 2020-08-14 08:20:00 | AAPL | Stock | 115.1575 | 115.1725 | 115.0175 | 115.0375 | 28144.0 |
| 2020-08-14 08:25:00 | AAPL | Stock | 115.045 | 115.16 | 115.045 | 115.1325 | 15316.0 |
| 2020-08-14 08:30:00 | AAPL | Stock | 115.1 | 115.3125 | 114.9875 | 115.2125 | 70560.0 |
| 2020-08-14 08:35:00 | AAPL | Stock | 115.2125 | 115.225 | 115.1375 | 115.15 | 34736.0 |
| 2020-08-14 08:40:00 | AAPL | Stock | 115.1385 | 115.209 | 115.1075 | 115.1075 | 17988.0 |
| 2020-08-14 08:45:00 | AAPL | Stock | 115.14 | 115.1425 | 115.0175 | 115.0212 | 26700.0 |
| 2020-08-14 08:50:00 | AAPL | Stock | 115.04 | 115.1125 | 115.04 | 115.0775 | 26632.0 |
| 2020-08-14 08:55:00 | AAPL | Stock | 115.0925 | 115.1715 | 115.09 | 115.12 | 17892.0 |
> showing 50 of 402,202 rows — these rows as CSV