PREVIEW / stock_5min / 2020-05-21
file: by_date/stock_5min/2020/2020-05-21.parquet size: 6.3 MB rows: 399,490 symbols: 2,364
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-05-21 04:00:00 | AAPL | Stock | 79.5325 | 79.5325 | 79.5 | 79.5 | 8212.0 |
| 2020-05-21 04:05:00 | AAPL | Stock | 79.5 | 79.5 | 79.38 | 79.38 | 6924.0 |
| 2020-05-21 04:15:00 | AAPL | Stock | 79.2925 | 79.2925 | 79.2925 | 79.2925 | 760.0 |
| 2020-05-21 04:25:00 | AAPL | Stock | 79.2525 | 79.3225 | 79.25 | 79.3225 | 2984.0 |
| 2020-05-21 04:30:00 | AAPL | Stock | 79.3 | 79.3 | 79.19 | 79.19 | 2064.0 |
| 2020-05-21 04:40:00 | AAPL | Stock | 79.3475 | 79.3475 | 79.3475 | 79.3475 | 400.0 |
| 2020-05-21 05:00:00 | AAPL | Stock | 79.4775 | 79.4925 | 79.4775 | 79.4925 | 1544.0 |
| 2020-05-21 05:20:00 | AAPL | Stock | 79.47 | 79.47 | 79.47 | 79.47 | 740.0 |
| 2020-05-21 05:25:00 | AAPL | Stock | 79.4825 | 79.4825 | 79.4825 | 79.4825 | 400.0 |
| 2020-05-21 05:45:00 | AAPL | Stock | 79.3775 | 79.3775 | 79.3775 | 79.3775 | 804.0 |
| 2020-05-21 06:00:00 | AAPL | Stock | 79.3075 | 79.3075 | 79.29 | 79.29 | 3600.0 |
| 2020-05-21 06:05:00 | AAPL | Stock | 79.3175 | 79.3175 | 79.29 | 79.29 | 2028.0 |
| 2020-05-21 06:10:00 | AAPL | Stock | 79.29 | 79.3675 | 79.29 | 79.3675 | 2000.0 |
| 2020-05-21 06:15:00 | AAPL | Stock | 79.3825 | 79.3825 | 79.325 | 79.325 | 3484.0 |
| 2020-05-21 06:25:00 | AAPL | Stock | 79.36 | 79.3675 | 79.36 | 79.3675 | 880.0 |
| 2020-05-21 06:40:00 | AAPL | Stock | 79.4225 | 79.4425 | 79.4225 | 79.4425 | 1656.0 |
| 2020-05-21 07:00:00 | AAPL | Stock | 79.45 | 79.57 | 79.415 | 79.48 | 27064.0 |
| 2020-05-21 07:05:00 | AAPL | Stock | 79.5225 | 79.6 | 79.505 | 79.595 | 12096.0 |
| 2020-05-21 07:10:00 | AAPL | Stock | 79.6225 | 79.65 | 79.585 | 79.63 | 15268.0 |
| 2020-05-21 07:15:00 | AAPL | Stock | 79.595 | 79.6225 | 79.5625 | 79.5625 | 9248.0 |
| 2020-05-21 07:20:00 | AAPL | Stock | 79.5725 | 79.605 | 79.5725 | 79.605 | 11148.0 |
| 2020-05-21 07:25:00 | AAPL | Stock | 79.6375 | 79.7125 | 79.6375 | 79.675 | 13840.0 |
| 2020-05-21 07:30:00 | AAPL | Stock | 79.6825 | 79.6825 | 79.625 | 79.625 | 13408.0 |
| 2020-05-21 07:35:00 | AAPL | Stock | 79.65 | 79.7075 | 79.6475 | 79.6675 | 9196.0 |
| 2020-05-21 07:40:00 | AAPL | Stock | 79.695 | 79.7175 | 79.65 | 79.7125 | 11448.0 |
| 2020-05-21 07:45:00 | AAPL | Stock | 79.715 | 79.7175 | 79.645 | 79.6525 | 5760.0 |
| 2020-05-21 07:50:00 | AAPL | Stock | 79.655 | 79.655 | 79.615 | 79.625 | 12516.0 |
| 2020-05-21 07:55:00 | AAPL | Stock | 79.6375 | 79.6375 | 79.5875 | 79.605 | 7508.0 |
| 2020-05-21 08:00:00 | AAPL | Stock | 79.7125 | 79.7125 | 79.375 | 79.3775 | 82528.0 |
| 2020-05-21 08:05:00 | AAPL | Stock | 79.45 | 79.51 | 79.4 | 79.51 | 14404.0 |
| 2020-05-21 08:10:00 | AAPL | Stock | 79.5875 | 79.6125 | 79.5875 | 79.6 | 7652.0 |
| 2020-05-21 08:15:00 | AAPL | Stock | 79.6 | 79.625 | 79.545 | 79.61 | 12368.0 |
| 2020-05-21 08:20:00 | AAPL | Stock | 79.5725 | 79.5825 | 79.56 | 79.575 | 3600.0 |
| 2020-05-21 08:25:00 | AAPL | Stock | 79.5475 | 79.5625 | 79.525 | 79.525 | 9344.0 |
| 2020-05-21 08:30:00 | AAPL | Stock | 79.5125 | 79.6225 | 79.5 | 79.575 | 29316.0 |
| 2020-05-21 08:35:00 | AAPL | Stock | 79.5375 | 79.79 | 79.5375 | 79.79 | 55508.0 |
| 2020-05-21 08:40:00 | AAPL | Stock | 79.75 | 79.805 | 79.7025 | 79.805 | 45520.0 |
| 2020-05-21 08:45:00 | AAPL | Stock | 79.845 | 79.8725 | 79.75 | 79.7625 | 44144.0 |
| 2020-05-21 08:50:00 | AAPL | Stock | 79.775 | 79.792 | 79.6375 | 79.665 | 21344.0 |
| 2020-05-21 08:55:00 | AAPL | Stock | 79.6512 | 79.674 | 79.6062 | 79.6675 | 18780.0 |
| 2020-05-21 09:00:00 | AAPL | Stock | 79.6625 | 79.6825 | 79.55 | 79.6825 | 20820.0 |
| 2020-05-21 09:05:00 | AAPL | Stock | 79.55 | 79.6575 | 79.5 | 79.625 | 36648.0 |
| 2020-05-21 09:10:00 | AAPL | Stock | 79.6025 | 79.625 | 79.5825 | 79.615 | 27456.0 |
| 2020-05-21 09:15:00 | AAPL | Stock | 79.625 | 79.6655 | 79.6025 | 79.65 | 16428.0 |
| 2020-05-21 09:20:00 | AAPL | Stock | 79.66 | 79.75 | 79.66 | 79.7448 | 41440.0 |
| 2020-05-21 09:25:00 | AAPL | Stock | 79.72 | 79.76 | 79.6625 | 79.6675 | 55436.0 |
| 2020-05-21 09:30:00 | AAPL | Stock | 79.665 | 79.8325 | 79.635 | 79.75 | 3086384.0 |
| 2020-05-21 09:35:00 | AAPL | Stock | 79.76 | 80.1825 | 79.7075 | 80.1178 | 3905132.0 |
| 2020-05-21 09:40:00 | AAPL | Stock | 80.1175 | 80.2225 | 80.0225 | 80.171 | 2222872.0 |
| 2020-05-21 09:45:00 | AAPL | Stock | 80.175 | 80.1885 | 80.055 | 80.1258 | 1342548.0 |
> showing 50 of 399,490 rows — these rows as CSV