PREVIEW / stock_5min / 2021-10-26
file: by_date/stock_5min/2021/2021-10-26.parquet size: 7.7 MB rows: 470,095 symbols: 2,730
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 |
|---|---|---|---|---|---|---|---|
| 2021-10-26 04:00:00 | AAPL | Stock | 148.87 | 149.21 | 148.65 | 149.21 | 8421.0 |
| 2021-10-26 04:05:00 | AAPL | Stock | 149.21 | 149.23 | 149.13 | 149.23 | 3795.0 |
| 2021-10-26 04:10:00 | AAPL | Stock | 149.22 | 149.22 | 149.12 | 149.15 | 1822.0 |
| 2021-10-26 04:15:00 | AAPL | Stock | 149.22 | 149.46 | 149.22 | 149.45 | 12318.0 |
| 2021-10-26 04:20:00 | AAPL | Stock | 149.45 | 149.48 | 149.4 | 149.4 | 2831.0 |
| 2021-10-26 04:25:00 | AAPL | Stock | 149.4 | 149.44 | 149.31 | 149.31 | 2356.0 |
| 2021-10-26 04:30:00 | AAPL | Stock | 149.22 | 149.22 | 149.22 | 149.22 | 148.0 |
| 2021-10-26 04:35:00 | AAPL | Stock | 149.22 | 149.34 | 149.22 | 149.34 | 1564.0 |
| 2021-10-26 04:40:00 | AAPL | Stock | 149.35 | 149.36 | 149.35 | 149.36 | 341.0 |
| 2021-10-26 04:45:00 | AAPL | Stock | 149.37 | 149.37 | 149.32 | 149.32 | 832.0 |
| 2021-10-26 04:50:00 | AAPL | Stock | 149.28 | 149.28 | 149.19 | 149.21 | 3885.0 |
| 2021-10-26 04:55:00 | AAPL | Stock | 149.2 | 149.2 | 149.15 | 149.15 | 672.0 |
| 2021-10-26 05:00:00 | AAPL | Stock | 149.13 | 149.15 | 148.82 | 148.9 | 13625.0 |
| 2021-10-26 05:05:00 | AAPL | Stock | 149.1 | 149.1 | 149.1 | 149.1 | 498.0 |
| 2021-10-26 05:10:00 | AAPL | Stock | 149.1 | 149.1 | 149.09 | 149.09 | 617.0 |
| 2021-10-26 05:15:00 | AAPL | Stock | 149.07 | 149.07 | 149.07 | 149.07 | 130.0 |
| 2021-10-26 05:20:00 | AAPL | Stock | 149.07 | 149.07 | 149.07 | 149.07 | 100.0 |
| 2021-10-26 05:25:00 | AAPL | Stock | 149.08 | 149.08 | 149.08 | 149.08 | 100.0 |
| 2021-10-26 05:30:00 | AAPL | Stock | 149.08 | 149.08 | 149.08 | 149.08 | 622.0 |
| 2021-10-26 05:35:00 | AAPL | Stock | 149.08 | 149.1 | 149.08 | 149.1 | 1154.0 |
| 2021-10-26 05:40:00 | AAPL | Stock | 149.1 | 149.1 | 149.08 | 149.1 | 1789.0 |
| 2021-10-26 05:45:00 | AAPL | Stock | 149.1 | 149.1 | 149.1 | 149.1 | 200.0 |
| 2021-10-26 05:50:00 | AAPL | Stock | 149.1 | 149.1 | 149.09 | 149.09 | 1434.0 |
| 2021-10-26 05:55:00 | AAPL | Stock | 149.1 | 149.14 | 149.08 | 149.08 | 5178.0 |
| 2021-10-26 06:10:00 | AAPL | Stock | 149.12 | 149.12 | 149.09 | 149.09 | 1038.0 |
| 2021-10-26 06:15:00 | AAPL | Stock | 149.1 | 149.1 | 149.09 | 149.09 | 817.0 |
| 2021-10-26 06:20:00 | AAPL | Stock | 149.09 | 149.09 | 148.98 | 148.98 | 7166.0 |
| 2021-10-26 06:25:00 | AAPL | Stock | 148.97 | 148.97 | 148.85 | 148.85 | 2164.0 |
| 2021-10-26 06:30:00 | AAPL | Stock | 148.9 | 148.9 | 148.87 | 148.9 | 832.0 |
| 2021-10-26 06:35:00 | AAPL | Stock | 148.9 | 148.9 | 148.9 | 148.9 | 1098.0 |
| 2021-10-26 06:40:00 | AAPL | Stock | 148.89 | 148.9 | 148.81 | 148.82 | 3359.0 |
| 2021-10-26 06:45:00 | AAPL | Stock | 148.82 | 148.82 | 148.81 | 148.81 | 1127.0 |
| 2021-10-26 06:50:00 | AAPL | Stock | 148.9 | 148.9 | 148.83 | 148.83 | 3965.0 |
| 2021-10-26 07:00:00 | AAPL | Stock | 148.85 | 148.9 | 148.84 | 148.85 | 12040.0 |
| 2021-10-26 07:05:00 | AAPL | Stock | 148.87 | 148.9 | 148.87 | 148.9 | 1756.0 |
| 2021-10-26 07:10:00 | AAPL | Stock | 148.9 | 148.92 | 148.89 | 148.92 | 5864.0 |
| 2021-10-26 07:15:00 | AAPL | Stock | 148.93 | 149.06 | 148.93 | 149.06 | 10575.0 |
| 2021-10-26 07:20:00 | AAPL | Stock | 149.05 | 149.08 | 149.04 | 149.05 | 1799.0 |
| 2021-10-26 07:25:00 | AAPL | Stock | 149.04 | 149.08 | 149.02 | 149.07 | 6096.0 |
| 2021-10-26 07:30:00 | AAPL | Stock | 149.05 | 149.11 | 149.05 | 149.09 | 5944.0 |
| 2021-10-26 07:35:00 | AAPL | Stock | 149.09 | 149.09 | 149.05 | 149.07 | 1050.0 |
| 2021-10-26 07:40:00 | AAPL | Stock | 149.05 | 149.05 | 149.0 | 149.04 | 11732.0 |
| 2021-10-26 07:45:00 | AAPL | Stock | 149.06 | 149.08 | 149.02 | 149.02 | 5733.0 |
| 2021-10-26 07:50:00 | AAPL | Stock | 149.05 | 149.06 | 148.96 | 149.02 | 11814.0 |
| 2021-10-26 07:55:00 | AAPL | Stock | 149.02 | 149.11 | 149.02 | 149.08 | 3255.0 |
| 2021-10-26 08:00:00 | AAPL | Stock | 148.889 | 149.11 | 148.269 | 149.02 | 77256.0 |
| 2021-10-26 08:05:00 | AAPL | Stock | 149.02 | 149.025 | 148.97 | 149.01 | 9881.0 |
| 2021-10-26 08:10:00 | AAPL | Stock | 149.03 | 149.13 | 149.03 | 149.13 | 5273.0 |
| 2021-10-26 08:15:00 | AAPL | Stock | 149.13 | 149.15 | 149.11 | 149.15 | 5186.0 |
| 2021-10-26 08:20:00 | AAPL | Stock | 149.15 | 149.15 | 149.02 | 149.09 | 21907.0 |
> showing 50 of 470,095 rows — these rows as CSV