PREVIEW / stock_30min / 2024-04-02
file: by_date/stock_30min/2024/2024-04-02.parquet size: 2.1 MB rows: 101,322 symbols: 1,053
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-04-02 04:00:00 | AAPL | Stock | 169.71 | 170.06 | 169.71 | 170.06 | 2581.0 |
| 2024-04-02 04:30:00 | AAPL | Stock | 170.05 | 170.08 | 169.81 | 169.9 | 6518.0 |
| 2024-04-02 05:00:00 | AAPL | Stock | 170.0 | 170.04 | 170.0 | 170.0 | 932.0 |
| 2024-04-02 05:30:00 | AAPL | Stock | 169.98 | 169.98 | 169.85 | 169.89 | 5051.0 |
| 2024-04-02 06:00:00 | AAPL | Stock | 169.8 | 169.88 | 169.78 | 169.79 | 3001.0 |
| 2024-04-02 06:30:00 | AAPL | Stock | 169.85 | 169.85 | 169.6 | 169.65 | 3692.0 |
| 2024-04-02 07:00:00 | AAPL | Stock | 169.63 | 169.64 | 169.42 | 169.51 | 15854.0 |
| 2024-04-02 07:30:00 | AAPL | Stock | 169.51 | 169.51 | 169.35 | 169.41 | 29141.0 |
| 2024-04-02 08:00:00 | AAPL | Stock | 169.6 | 169.93 | 169.21 | 169.33 | 62131.0 |
| 2024-04-02 08:30:00 | AAPL | Stock | 169.34 | 169.36 | 169.0 | 169.06 | 100878.0 |
| 2024-04-02 09:00:00 | AAPL | Stock | 169.05 | 169.15 | 168.76 | 169.07 | 230334.0 |
| 2024-04-02 09:30:00 | AAPL | Stock | 169.08 | 169.33 | 168.2302 | 169.08 | 6007444.0 |
| 2024-04-02 10:00:00 | AAPL | Stock | 169.09 | 169.34 | 168.81 | 169.04 | 2608109.0 |
| 2024-04-02 10:30:00 | AAPL | Stock | 169.035 | 169.195 | 168.53 | 168.675 | 2125164.0 |
| 2024-04-02 11:00:00 | AAPL | Stock | 168.675 | 169.04 | 168.66 | 168.8322 | 1690292.0 |
| 2024-04-02 11:30:00 | AAPL | Stock | 168.835 | 169.15 | 168.615 | 168.65 | 1656688.0 |
| 2024-04-02 12:00:00 | AAPL | Stock | 168.65 | 168.715 | 168.37 | 168.6745 | 1741118.0 |
| 2024-04-02 12:30:00 | AAPL | Stock | 168.68 | 168.87 | 168.64 | 168.8 | 1108466.0 |
| 2024-04-02 13:00:00 | AAPL | Stock | 168.8 | 169.09 | 168.8 | 168.995 | 1570329.0 |
| 2024-04-02 13:30:00 | AAPL | Stock | 169.0 | 169.105 | 168.96 | 169.0101 | 1467082.0 |
| 2024-04-02 14:00:00 | AAPL | Stock | 169.02 | 169.06 | 168.86 | 168.92 | 1330602.0 |
| 2024-04-02 14:30:00 | AAPL | Stock | 168.92 | 168.95 | 168.75 | 168.825 | 1173867.0 |
| 2024-04-02 15:00:00 | AAPL | Stock | 168.825 | 169.07 | 168.73 | 168.98 | 1904200.0 |
| 2024-04-02 15:30:00 | AAPL | Stock | 168.99 | 169.2201 | 168.77 | 168.94 | 5385553.0 |
| 2024-04-02 16:00:00 | AAPL | Stock | 168.94 | 169.03 | 168.71 | 168.85 | 9537301.0 |
| 2024-04-02 16:30:00 | AAPL | Stock | 168.85 | 169.02 | 168.81 | 168.9318 | 84681.0 |
| 2024-04-02 17:00:00 | AAPL | Stock | 168.97 | 168.99 | 168.84 | 168.95 | 12594.0 |
| 2024-04-02 17:30:00 | AAPL | Stock | 168.94 | 168.99 | 168.94 | 168.95 | 10820.0 |
| 2024-04-02 18:00:00 | AAPL | Stock | 168.96 | 168.99 | 168.9 | 168.98 | 5511.0 |
| 2024-04-02 18:30:00 | AAPL | Stock | 168.9801 | 169.2519 | 168.9801 | 169.25 | 17992.0 |
| 2024-04-02 19:00:00 | AAPL | Stock | 169.25 | 169.4 | 169.25 | 169.3499 | 13184.0 |
| 2024-04-02 19:30:00 | AAPL | Stock | 169.32 | 169.48 | 169.2 | 169.4 | 18964.0 |
| 2024-04-02 04:00:00 | MSFT | Stock | 424.49 | 424.49 | 424.01 | 424.3 | 3052.0 |
| 2024-04-02 04:30:00 | MSFT | Stock | 423.96 | 423.96 | 423.88 | 423.88 | 471.0 |
| 2024-04-02 05:00:00 | MSFT | Stock | 423.99 | 424.43 | 423.95 | 424.43 | 1166.0 |
| 2024-04-02 05:30:00 | MSFT | Stock | 424.46 | 424.95 | 424.46 | 424.49 | 1732.0 |
| 2024-04-02 06:00:00 | MSFT | Stock | 424.12 | 424.19 | 424.06 | 424.06 | 1427.0 |
| 2024-04-02 06:30:00 | MSFT | Stock | 423.5 | 424.01 | 423.32 | 424.01 | 1133.0 |
| 2024-04-02 07:00:00 | MSFT | Stock | 424.11 | 424.11 | 423.15 | 423.26 | 4359.0 |
| 2024-04-02 07:30:00 | MSFT | Stock | 423.52 | 423.55 | 423.11 | 423.11 | 3627.0 |
| 2024-04-02 08:00:00 | MSFT | Stock | 423.95 | 425.98 | 422.77 | 422.92 | 12412.0 |
| 2024-04-02 08:30:00 | MSFT | Stock | 423.12 | 423.12 | 420.0 | 420.74 | 30032.0 |
| 2024-04-02 09:00:00 | MSFT | Stock | 420.68 | 421.6 | 419.36 | 420.17 | 69614.0 |
| 2024-04-02 09:30:00 | MSFT | Stock | 420.17 | 421.64 | 419.11 | 419.4325 | 1520445.0 |
| 2024-04-02 10:00:00 | MSFT | Stock | 419.54 | 419.6 | 417.84 | 419.065 | 888677.0 |
| 2024-04-02 10:30:00 | MSFT | Stock | 419.02 | 420.19 | 418.995 | 419.99 | 560576.0 |
| 2024-04-02 11:00:00 | MSFT | Stock | 420.0 | 421.27 | 419.55 | 420.91 | 599934.0 |
| 2024-04-02 11:30:00 | MSFT | Stock | 420.93 | 421.63 | 420.81 | 420.94 | 480024.0 |
| 2024-04-02 12:00:00 | MSFT | Stock | 420.87 | 421.19 | 420.28 | 420.87 | 310567.0 |
| 2024-04-02 12:30:00 | MSFT | Stock | 420.89 | 421.44 | 420.56 | 421.44 | 263565.0 |
> showing 50 of 101,322 rows — these rows as CSV