PREVIEW / stock_5min / 2020-07-23
file: by_date/stock_5min/2020/2020-07-23.parquet size: 6.6 MB rows: 410,120 symbols: 2,447
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-07-23 04:00:00 | AAPL | Stock | 97.7375 | 97.75 | 97.7375 | 97.75 | 2296.0 |
| 2020-07-23 04:05:00 | AAPL | Stock | 97.725 | 97.75 | 97.725 | 97.75 | 6808.0 |
| 2020-07-23 04:10:00 | AAPL | Stock | 97.75 | 97.755 | 97.75 | 97.755 | 1616.0 |
| 2020-07-23 04:25:00 | AAPL | Stock | 97.895 | 97.895 | 97.895 | 97.895 | 400.0 |
| 2020-07-23 04:45:00 | AAPL | Stock | 97.875 | 97.875 | 97.75 | 97.775 | 5408.0 |
| 2020-07-23 04:55:00 | AAPL | Stock | 97.7025 | 97.7025 | 97.7025 | 97.7025 | 400.0 |
| 2020-07-23 05:05:00 | AAPL | Stock | 97.7025 | 97.7025 | 97.7025 | 97.7025 | 400.0 |
| 2020-07-23 05:10:00 | AAPL | Stock | 97.75 | 97.75 | 97.75 | 97.75 | 400.0 |
| 2020-07-23 05:20:00 | AAPL | Stock | 97.6875 | 97.6875 | 97.6425 | 97.6425 | 5600.0 |
| 2020-07-23 05:25:00 | AAPL | Stock | 97.675 | 97.675 | 97.675 | 97.675 | 1200.0 |
| 2020-07-23 05:30:00 | AAPL | Stock | 97.675 | 97.675 | 97.675 | 97.675 | 400.0 |
| 2020-07-23 05:35:00 | AAPL | Stock | 97.6725 | 97.6725 | 97.6725 | 97.6725 | 2384.0 |
| 2020-07-23 05:40:00 | AAPL | Stock | 97.6725 | 97.6725 | 97.64 | 97.64 | 1676.0 |
| 2020-07-23 05:55:00 | AAPL | Stock | 97.685 | 97.685 | 97.685 | 97.685 | 1132.0 |
| 2020-07-23 06:00:00 | AAPL | Stock | 97.64 | 97.675 | 97.64 | 97.675 | 2200.0 |
| 2020-07-23 06:05:00 | AAPL | Stock | 97.73 | 97.7925 | 97.73 | 97.7925 | 3512.0 |
| 2020-07-23 06:10:00 | AAPL | Stock | 97.7925 | 97.7925 | 97.7925 | 97.7925 | 1392.0 |
| 2020-07-23 06:15:00 | AAPL | Stock | 97.865 | 97.9 | 97.865 | 97.865 | 7200.0 |
| 2020-07-23 06:20:00 | AAPL | Stock | 97.8 | 97.8 | 97.8 | 97.8 | 508.0 |
| 2020-07-23 06:25:00 | AAPL | Stock | 97.7675 | 97.7675 | 97.7675 | 97.7675 | 1976.0 |
| 2020-07-23 06:30:00 | AAPL | Stock | 97.7775 | 97.7775 | 97.7775 | 97.7775 | 400.0 |
| 2020-07-23 06:45:00 | AAPL | Stock | 97.725 | 97.7425 | 97.725 | 97.7425 | 1164.0 |
| 2020-07-23 06:55:00 | AAPL | Stock | 97.73 | 97.73 | 97.73 | 97.73 | 400.0 |
| 2020-07-23 07:00:00 | AAPL | Stock | 97.75 | 97.895 | 97.7125 | 97.895 | 31020.0 |
| 2020-07-23 07:05:00 | AAPL | Stock | 97.8875 | 97.8875 | 97.805 | 97.83 | 39400.0 |
| 2020-07-23 07:10:00 | AAPL | Stock | 97.7975 | 97.8075 | 97.605 | 97.605 | 33924.0 |
| 2020-07-23 07:15:00 | AAPL | Stock | 97.595 | 97.605 | 97.5625 | 97.5625 | 12652.0 |
| 2020-07-23 07:20:00 | AAPL | Stock | 97.575 | 97.6525 | 97.5 | 97.5375 | 18328.0 |
| 2020-07-23 07:25:00 | AAPL | Stock | 97.5 | 97.515 | 97.35 | 97.365 | 49992.0 |
| 2020-07-23 07:30:00 | AAPL | Stock | 97.375 | 97.435 | 97.335 | 97.435 | 14648.0 |
| 2020-07-23 07:35:00 | AAPL | Stock | 97.46 | 97.4825 | 97.4 | 97.4 | 10640.0 |
| 2020-07-23 07:40:00 | AAPL | Stock | 97.4425 | 97.4425 | 97.36 | 97.375 | 7488.0 |
| 2020-07-23 07:45:00 | AAPL | Stock | 97.445 | 97.445 | 97.445 | 97.445 | 840.0 |
| 2020-07-23 07:50:00 | AAPL | Stock | 97.4375 | 97.4375 | 97.345 | 97.375 | 25836.0 |
| 2020-07-23 07:55:00 | AAPL | Stock | 97.45 | 97.4975 | 97.42 | 97.4975 | 3600.0 |
| 2020-07-23 08:00:00 | AAPL | Stock | 97.3775 | 97.8952 | 97.3325 | 97.4375 | 85788.0 |
| 2020-07-23 08:05:00 | AAPL | Stock | 97.47 | 97.47 | 97.4125 | 97.4125 | 3024.0 |
| 2020-07-23 08:10:00 | AAPL | Stock | 97.375 | 97.375 | 97.3025 | 97.3525 | 20980.0 |
| 2020-07-23 08:15:00 | AAPL | Stock | 97.375 | 97.375 | 97.25 | 97.3 | 23096.0 |
| 2020-07-23 08:20:00 | AAPL | Stock | 97.3125 | 97.35 | 97.2545 | 97.35 | 5488.0 |
| 2020-07-23 08:25:00 | AAPL | Stock | 97.3562 | 97.4695 | 97.34 | 97.4695 | 18360.0 |
| 2020-07-23 08:30:00 | AAPL | Stock | 97.4375 | 97.469 | 97.27 | 97.2898 | 22040.0 |
| 2020-07-23 08:35:00 | AAPL | Stock | 97.3375 | 97.3375 | 97.275 | 97.3175 | 19080.0 |
| 2020-07-23 08:40:00 | AAPL | Stock | 97.3602 | 97.375 | 97.3175 | 97.3175 | 31824.0 |
| 2020-07-23 08:45:00 | AAPL | Stock | 97.3235 | 97.355 | 97.255 | 97.2575 | 37124.0 |
| 2020-07-23 08:50:00 | AAPL | Stock | 97.27 | 97.27 | 97.055 | 97.1875 | 52656.0 |
| 2020-07-23 08:55:00 | AAPL | Stock | 97.175 | 97.1775 | 97.075 | 97.0875 | 18320.0 |
| 2020-07-23 09:00:00 | AAPL | Stock | 97.075 | 97.135 | 97.075 | 97.1275 | 20776.0 |
| 2020-07-23 09:05:00 | AAPL | Stock | 97.125 | 97.2125 | 97.125 | 97.1875 | 12716.0 |
| 2020-07-23 09:10:00 | AAPL | Stock | 97.21 | 97.2125 | 97.1825 | 97.1825 | 8192.0 |
> showing 50 of 410,120 rows — these rows as CSV