PREVIEW / stock_30min / 2021-12-30
file: by_date/stock_30min/2021/2021-12-30.parquet size: 2.2 MB rows: 109,023 symbols: 2,631
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-12-30 04:00:00 | AAPL | Stock | 179.4 | 179.7 | 179.36 | 179.62 | 6140.0 |
| 2021-12-30 04:30:00 | AAPL | Stock | 179.64 | 179.88 | 179.64 | 179.77 | 4555.0 |
| 2021-12-30 05:00:00 | AAPL | Stock | 179.77 | 179.8 | 179.68 | 179.76 | 2085.0 |
| 2021-12-30 05:30:00 | AAPL | Stock | 179.72 | 179.75 | 179.7 | 179.75 | 2323.0 |
| 2021-12-30 06:00:00 | AAPL | Stock | 179.75 | 179.75 | 179.64 | 179.68 | 4451.0 |
| 2021-12-30 06:30:00 | AAPL | Stock | 179.66 | 180.0 | 179.66 | 179.9 | 7531.0 |
| 2021-12-30 07:00:00 | AAPL | Stock | 179.89 | 179.96 | 179.62 | 179.84 | 48321.0 |
| 2021-12-30 07:30:00 | AAPL | Stock | 179.82 | 179.98 | 179.68 | 179.68 | 27233.0 |
| 2021-12-30 08:00:00 | AAPL | Stock | 179.6899 | 179.94 | 179.5 | 179.65 | 277284.0 |
| 2021-12-30 08:30:00 | AAPL | Stock | 179.65 | 179.74 | 179.5 | 179.6 | 83354.0 |
| 2021-12-30 09:00:00 | AAPL | Stock | 179.61 | 179.75 | 179.46 | 179.46 | 177087.0 |
| 2021-12-30 09:30:00 | AAPL | Stock | 179.55 | 179.928 | 178.89 | 179.5285 | 6776978.0 |
| 2021-12-30 10:00:00 | AAPL | Stock | 179.53 | 180.57 | 179.49 | 180.3175 | 6623556.0 |
| 2021-12-30 10:30:00 | AAPL | Stock | 180.31 | 180.4 | 179.8 | 180.005 | 4453391.0 |
| 2021-12-30 11:00:00 | AAPL | Stock | 180.01 | 180.1599 | 179.75 | 180.0158 | 3105018.0 |
| 2021-12-30 11:30:00 | AAPL | Stock | 180.0189 | 180.02 | 179.59 | 179.805 | 2866363.0 |
| 2021-12-30 12:00:00 | AAPL | Stock | 179.8 | 179.96 | 179.53 | 179.7159 | 2202497.0 |
| 2021-12-30 12:30:00 | AAPL | Stock | 179.72 | 179.89 | 179.65 | 179.8358 | 1463318.0 |
| 2021-12-30 13:00:00 | AAPL | Stock | 179.83 | 179.8599 | 179.2801 | 179.3515 | 2172624.0 |
| 2021-12-30 13:30:00 | AAPL | Stock | 179.3521 | 179.42 | 179.16 | 179.285 | 2693663.0 |
| 2021-12-30 14:00:00 | AAPL | Stock | 179.28 | 179.2862 | 178.66 | 178.975 | 3078189.0 |
| 2021-12-30 14:30:00 | AAPL | Stock | 178.97 | 179.3481 | 178.95 | 179.24 | 2460938.0 |
| 2021-12-30 15:00:00 | AAPL | Stock | 179.2458 | 179.305 | 178.82 | 178.96 | 2426194.0 |
| 2021-12-30 15:30:00 | AAPL | Stock | 178.9601 | 179.04 | 178.09 | 178.25 | 7168076.0 |
| 2021-12-30 16:00:00 | AAPL | Stock | 178.25 | 178.38 | 178.14 | 178.2 | 3359930.0 |
| 2021-12-30 16:30:00 | AAPL | Stock | 178.2 | 178.25 | 178.1 | 178.12 | 25608.0 |
| 2021-12-30 17:00:00 | AAPL | Stock | 178.12 | 178.12 | 177.91 | 178.01 | 40308.0 |
| 2021-12-30 17:30:00 | AAPL | Stock | 178.04 | 178.09 | 177.95 | 177.98 | 9656.0 |
| 2021-12-30 18:00:00 | AAPL | Stock | 178.0 | 178.19 | 177.98 | 178.14 | 20390.0 |
| 2021-12-30 18:30:00 | AAPL | Stock | 178.15 | 178.22 | 178.09 | 178.22 | 19542.0 |
| 2021-12-30 19:00:00 | AAPL | Stock | 178.22 | 178.25 | 177.12 | 177.5 | 38232.0 |
| 2021-12-30 19:30:00 | AAPL | Stock | 177.29 | 177.72 | 177.25 | 177.65 | 31096.0 |
| 2021-12-30 04:00:00 | MSFT | Stock | 342.02 | 342.23 | 341.94 | 342.0 | 2172.0 |
| 2021-12-30 04:30:00 | MSFT | Stock | 342.0 | 342.0 | 342.0 | 342.0 | 720.0 |
| 2021-12-30 05:00:00 | MSFT | Stock | 342.02 | 342.02 | 342.02 | 342.02 | 167.0 |
| 2021-12-30 05:30:00 | MSFT | Stock | 342.0 | 342.0 | 342.0 | 342.0 | 267.0 |
| 2021-12-30 06:00:00 | MSFT | Stock | 342.0 | 342.0 | 341.9 | 341.99 | 1577.0 |
| 2021-12-30 06:30:00 | MSFT | Stock | 342.0 | 342.3 | 341.93 | 342.26 | 5170.0 |
| 2021-12-30 07:00:00 | MSFT | Stock | 342.13 | 342.67 | 342.13 | 342.6 | 6525.0 |
| 2021-12-30 07:30:00 | MSFT | Stock | 342.56 | 342.92 | 342.56 | 342.87 | 3531.0 |
| 2021-12-30 08:00:00 | MSFT | Stock | 342.4999 | 342.8 | 341.81 | 342.77 | 8378.0 |
| 2021-12-30 08:30:00 | MSFT | Stock | 342.5415 | 342.77 | 342.4 | 342.7 | 6640.0 |
| 2021-12-30 09:00:00 | MSFT | Stock | 342.55 | 342.7 | 341.63 | 341.7 | 222270.0 |
| 2021-12-30 09:30:00 | MSFT | Stock | 341.97 | 342.37 | 340.83 | 341.1818 | 1255920.0 |
| 2021-12-30 10:00:00 | MSFT | Stock | 341.21 | 343.13 | 341.041 | 342.91 | 1181088.0 |
| 2021-12-30 10:30:00 | MSFT | Stock | 342.89 | 342.89 | 341.28 | 341.479 | 709422.0 |
| 2021-12-30 11:00:00 | MSFT | Stock | 341.47 | 342.39 | 341.16 | 342.2 | 679236.0 |
| 2021-12-30 11:30:00 | MSFT | Stock | 342.19 | 342.21 | 341.28 | 341.5 | 495395.0 |
| 2021-12-30 12:00:00 | MSFT | Stock | 341.49 | 341.8 | 341.14 | 341.56 | 493236.0 |
| 2021-12-30 12:30:00 | MSFT | Stock | 341.57 | 341.76 | 341.31 | 341.43 | 323030.0 |
> showing 50 of 109,023 rows — these rows as CSV