PREVIEW / stock_5min / 2020-08-28
file: by_date/stock_5min/2020/2020-08-28.parquet size: 6.3 MB rows: 397,094 symbols: 2,459
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-28 04:00:00 | AAPL | Stock | 125.2525 | 125.42 | 125.2525 | 125.42 | 2508.0 |
| 2020-08-28 04:05:00 | AAPL | Stock | 125.47 | 125.5375 | 125.455 | 125.5025 | 7200.0 |
| 2020-08-28 04:10:00 | AAPL | Stock | 125.5025 | 125.625 | 125.5025 | 125.625 | 12776.0 |
| 2020-08-28 04:15:00 | AAPL | Stock | 125.625 | 125.625 | 125.535 | 125.6 | 1776.0 |
| 2020-08-28 04:20:00 | AAPL | Stock | 125.575 | 125.575 | 125.575 | 125.575 | 1200.0 |
| 2020-08-28 04:25:00 | AAPL | Stock | 125.5375 | 125.575 | 125.5375 | 125.54 | 2584.0 |
| 2020-08-28 04:30:00 | AAPL | Stock | 125.575 | 125.625 | 125.45 | 125.45 | 3828.0 |
| 2020-08-28 04:40:00 | AAPL | Stock | 125.28 | 125.28 | 125.2625 | 125.2625 | 2272.0 |
| 2020-08-28 04:45:00 | AAPL | Stock | 125.2025 | 125.3175 | 125.2025 | 125.3175 | 1716.0 |
| 2020-08-28 04:50:00 | AAPL | Stock | 125.3225 | 125.4775 | 125.3225 | 125.4775 | 964.0 |
| 2020-08-28 04:55:00 | AAPL | Stock | 125.425 | 125.4625 | 125.425 | 125.4625 | 960.0 |
| 2020-08-28 05:20:00 | AAPL | Stock | 125.375 | 125.375 | 125.375 | 125.375 | 1084.0 |
| 2020-08-28 05:30:00 | AAPL | Stock | 125.4125 | 125.4125 | 125.4125 | 125.4125 | 400.0 |
| 2020-08-28 05:35:00 | AAPL | Stock | 125.29 | 125.29 | 125.29 | 125.29 | 400.0 |
| 2020-08-28 05:50:00 | AAPL | Stock | 125.295 | 125.295 | 125.265 | 125.265 | 1556.0 |
| 2020-08-28 05:55:00 | AAPL | Stock | 125.2775 | 125.325 | 125.2775 | 125.325 | 5668.0 |
| 2020-08-28 06:00:00 | AAPL | Stock | 125.3425 | 125.3425 | 125.3275 | 125.3275 | 3944.0 |
| 2020-08-28 06:05:00 | AAPL | Stock | 125.1275 | 125.1925 | 125.125 | 125.125 | 1892.0 |
| 2020-08-28 06:25:00 | AAPL | Stock | 125.1075 | 125.125 | 125.1075 | 125.125 | 3292.0 |
| 2020-08-28 06:30:00 | AAPL | Stock | 125.125 | 125.15 | 125.125 | 125.1425 | 2172.0 |
| 2020-08-28 06:55:00 | AAPL | Stock | 125.225 | 125.225 | 125.225 | 125.225 | 2160.0 |
| 2020-08-28 07:00:00 | AAPL | Stock | 125.225 | 125.625 | 125.175 | 125.625 | 64400.0 |
| 2020-08-28 07:05:00 | AAPL | Stock | 125.625 | 125.745 | 125.5625 | 125.745 | 79536.0 |
| 2020-08-28 07:10:00 | AAPL | Stock | 125.72 | 125.845 | 125.6625 | 125.775 | 78360.0 |
| 2020-08-28 07:15:00 | AAPL | Stock | 125.79 | 125.9225 | 125.75 | 125.9225 | 57824.0 |
| 2020-08-28 07:20:00 | AAPL | Stock | 125.9175 | 125.95 | 125.7925 | 125.8 | 36728.0 |
| 2020-08-28 07:25:00 | AAPL | Stock | 125.8075 | 125.885 | 125.7625 | 125.8575 | 26508.0 |
| 2020-08-28 07:30:00 | AAPL | Stock | 125.85 | 125.87 | 125.8225 | 125.84 | 27272.0 |
| 2020-08-28 07:35:00 | AAPL | Stock | 125.8675 | 125.8675 | 125.675 | 125.7 | 24424.0 |
| 2020-08-28 07:40:00 | AAPL | Stock | 125.6975 | 125.75 | 125.675 | 125.73 | 10964.0 |
| 2020-08-28 07:45:00 | AAPL | Stock | 125.715 | 125.75 | 125.7 | 125.725 | 15380.0 |
| 2020-08-28 07:50:00 | AAPL | Stock | 125.725 | 125.8375 | 125.725 | 125.775 | 26448.0 |
| 2020-08-28 07:55:00 | AAPL | Stock | 125.8075 | 125.9 | 125.8075 | 125.895 | 28428.0 |
| 2020-08-28 08:00:00 | AAPL | Stock | 125.895 | 125.986 | 125.25 | 125.6725 | 222320.0 |
| 2020-08-28 08:05:00 | AAPL | Stock | 125.75 | 125.8125 | 125.725 | 125.725 | 44624.0 |
| 2020-08-28 08:10:00 | AAPL | Stock | 125.75 | 125.75 | 125.7 | 125.73 | 28112.0 |
| 2020-08-28 08:15:00 | AAPL | Stock | 125.7325 | 125.775 | 125.6875 | 125.725 | 29288.0 |
| 2020-08-28 08:20:00 | AAPL | Stock | 125.725 | 125.775 | 125.01 | 125.7025 | 216884.0 |
| 2020-08-28 08:25:00 | AAPL | Stock | 125.7475 | 125.85 | 125.725 | 125.835 | 31648.0 |
| 2020-08-28 08:30:00 | AAPL | Stock | 125.825 | 125.87 | 125.75 | 125.7925 | 87996.0 |
| 2020-08-28 08:35:00 | AAPL | Stock | 125.8175 | 125.825 | 125.6625 | 125.7 | 51380.0 |
| 2020-08-28 08:40:00 | AAPL | Stock | 125.7075 | 125.775 | 125.6775 | 125.7675 | 41380.0 |
| 2020-08-28 08:45:00 | AAPL | Stock | 125.7575 | 125.7575 | 125.6875 | 125.7375 | 48236.0 |
| 2020-08-28 08:50:00 | AAPL | Stock | 125.712 | 125.8275 | 125.712 | 125.8275 | 26708.0 |
| 2020-08-28 08:55:00 | AAPL | Stock | 125.8 | 125.835 | 125.73 | 125.775 | 64904.0 |
| 2020-08-28 09:00:00 | AAPL | Stock | 125.805 | 125.9625 | 125.795 | 125.95 | 80256.0 |
| 2020-08-28 09:05:00 | AAPL | Stock | 125.97 | 126.22 | 125.97 | 126.22 | 114884.0 |
| 2020-08-28 09:10:00 | AAPL | Stock | 126.22 | 126.285 | 126.1275 | 126.2125 | 143716.0 |
| 2020-08-28 09:15:00 | AAPL | Stock | 126.225 | 126.225 | 126.1 | 126.1 | 70212.0 |
| 2020-08-28 09:20:00 | AAPL | Stock | 126.0975 | 126.1875 | 126.085 | 126.1025 | 124396.0 |
> showing 50 of 397,094 rows — these rows as CSV