PREVIEW / stock_30min / 2024-12-02
file: by_date/stock_30min/2024/2024-12-02.parquet size: 2.2 MB rows: 107,829 symbols: 697
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 |
|---|---|---|---|---|---|---|---|
| 2024-12-02 04:00:00 | AAPL | Stock | 237.1 | 237.17 | 236.86 | 237.17 | 4799.0 |
| 2024-12-02 04:30:00 | AAPL | Stock | 237.16 | 237.19 | 237.12 | 237.17 | 3959.0 |
| 2024-12-02 05:00:00 | AAPL | Stock | 237.15 | 237.2 | 237.12 | 237.15 | 2945.0 |
| 2024-12-02 05:30:00 | AAPL | Stock | 237.13 | 237.23 | 237.13 | 237.17 | 2075.0 |
| 2024-12-02 06:00:00 | AAPL | Stock | 237.19 | 237.21 | 237.17 | 237.17 | 1729.0 |
| 2024-12-02 06:30:00 | AAPL | Stock | 237.2 | 237.29 | 237.15 | 237.18 | 6701.0 |
| 2024-12-02 07:00:00 | AAPL | Stock | 237.25 | 238.0 | 237.05 | 237.54 | 46087.0 |
| 2024-12-02 07:30:00 | AAPL | Stock | 237.54 | 237.58 | 237.21 | 237.42 | 22957.0 |
| 2024-12-02 08:00:00 | AAPL | Stock | 237.75 | 237.95 | 236.0 | 237.2856 | 57855.0 |
| 2024-12-02 08:30:00 | AAPL | Stock | 237.28 | 237.31 | 237.09 | 237.244 | 35943.0 |
| 2024-12-02 09:00:00 | AAPL | Stock | 237.28 | 237.38 | 236.78 | 237.3 | 115396.0 |
| 2024-12-02 09:30:00 | AAPL | Stock | 237.27 | 239.6 | 237.16 | 239.305 | 4668330.0 |
| 2024-12-02 10:00:00 | AAPL | Stock | 239.28 | 240.29 | 238.96 | 240.27 | 3507927.0 |
| 2024-12-02 10:30:00 | AAPL | Stock | 240.27 | 240.79 | 239.78 | 240.09 | 2307133.0 |
| 2024-12-02 11:00:00 | AAPL | Stock | 240.09 | 240.24 | 239.44 | 239.83 | 1603652.0 |
| 2024-12-02 11:30:00 | AAPL | Stock | 239.83 | 240.0 | 239.36 | 239.9558 | 1256135.0 |
| 2024-12-02 12:00:00 | AAPL | Stock | 239.95 | 240.2 | 239.76 | 239.84 | 976554.0 |
| 2024-12-02 12:30:00 | AAPL | Stock | 239.84 | 240.0 | 239.51 | 239.5101 | 833248.0 |
| 2024-12-02 13:00:00 | AAPL | Stock | 239.51 | 239.72 | 239.24 | 239.44 | 955988.0 |
| 2024-12-02 13:30:00 | AAPL | Stock | 239.425 | 239.51 | 239.03 | 239.1488 | 975726.0 |
| 2024-12-02 14:00:00 | AAPL | Stock | 239.1401 | 239.4198 | 239.03 | 239.33 | 716723.0 |
| 2024-12-02 14:30:00 | AAPL | Stock | 239.33 | 239.67 | 239.2501 | 239.64 | 906698.0 |
| 2024-12-02 15:00:00 | AAPL | Stock | 239.64 | 239.84 | 239.34 | 239.79 | 1006565.0 |
| 2024-12-02 15:30:00 | AAPL | Stock | 239.79 | 239.94 | 239.04 | 239.6 | 3027625.0 |
| 2024-12-02 16:00:00 | AAPL | Stock | 239.6 | 239.98 | 239.59 | 239.83 | 6939677.0 |
| 2024-12-02 16:30:00 | AAPL | Stock | 239.81 | 239.89 | 239.59 | 239.88 | 56271.0 |
| 2024-12-02 17:00:00 | AAPL | Stock | 239.84 | 239.94 | 239.7009 | 239.82 | 8878.0 |
| 2024-12-02 17:30:00 | AAPL | Stock | 239.83 | 239.83 | 239.7245 | 239.7245 | 2146.0 |
| 2024-12-02 18:00:00 | AAPL | Stock | 239.704 | 239.82 | 239.65 | 239.71 | 6297.0 |
| 2024-12-02 18:30:00 | AAPL | Stock | 239.7005 | 239.79 | 239.6301 | 239.75 | 3314.0 |
| 2024-12-02 19:00:00 | AAPL | Stock | 239.72 | 239.8 | 239.65 | 239.78 | 2199.0 |
| 2024-12-02 19:30:00 | AAPL | Stock | 239.71 | 239.79 | 239.66 | 239.68 | 1528.0 |
| 2024-12-02 04:00:00 | MSFT | Stock | 422.61 | 422.61 | 421.5 | 421.7 | 8649.0 |
| 2024-12-02 04:30:00 | MSFT | Stock | 421.11 | 421.4 | 421.09 | 421.4 | 2192.0 |
| 2024-12-02 05:00:00 | MSFT | Stock | 421.21 | 421.21 | 420.87 | 421.2 | 1678.0 |
| 2024-12-02 05:30:00 | MSFT | Stock | 421.38 | 421.59 | 421.38 | 421.59 | 1114.0 |
| 2024-12-02 06:00:00 | MSFT | Stock | 421.66 | 421.75 | 421.65 | 421.75 | 5096.0 |
| 2024-12-02 06:30:00 | MSFT | Stock | 421.75 | 421.75 | 421.65 | 421.75 | 827.0 |
| 2024-12-02 07:00:00 | MSFT | Stock | 421.72 | 422.7 | 421.72 | 422.45 | 3236.0 |
| 2024-12-02 07:30:00 | MSFT | Stock | 422.44 | 423.03 | 422.29 | 422.97 | 3502.0 |
| 2024-12-02 08:00:00 | MSFT | Stock | 422.4 | 422.93 | 421.73 | 422.49 | 17370.0 |
| 2024-12-02 08:30:00 | MSFT | Stock | 422.5 | 422.75 | 422.2 | 422.2 | 20679.0 |
| 2024-12-02 09:00:00 | MSFT | Stock | 422.34 | 423.34 | 421.5 | 421.77 | 34447.0 |
| 2024-12-02 09:30:00 | MSFT | Stock | 421.57 | 427.1 | 421.31 | 426.17 | 1290787.0 |
| 2024-12-02 10:00:00 | MSFT | Stock | 426.19 | 430.68 | 425.98 | 430.5655 | 1243012.0 |
| 2024-12-02 10:30:00 | MSFT | Stock | 430.6058 | 433.0 | 430.5978 | 431.195 | 959453.0 |
| 2024-12-02 11:00:00 | MSFT | Stock | 431.14 | 431.8774 | 430.12 | 430.296 | 507248.0 |
| 2024-12-02 11:30:00 | MSFT | Stock | 430.335 | 431.6069 | 429.76 | 431.2834 | 404335.0 |
| 2024-12-02 12:00:00 | MSFT | Stock | 431.32 | 431.77 | 430.58 | 430.925 | 375450.0 |
| 2024-12-02 12:30:00 | MSFT | Stock | 430.96 | 431.35 | 430.58 | 431.0 | 302481.0 |
> showing 50 of 107,829 rows — these rows as CSV