PREVIEW / stock_30min / 2024-10-02
file: by_date/stock_30min/2024/2024-10-02.parquet size: 2.1 MB rows: 99,901 symbols: 749
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-10-02 04:00:00 | AAPL | Stock | 225.6 | 226.0 | 225.52 | 225.66 | 4757.0 |
| 2024-10-02 04:30:00 | AAPL | Stock | 225.81 | 225.9 | 225.75 | 225.75 | 2619.0 |
| 2024-10-02 05:00:00 | AAPL | Stock | 225.65 | 225.65 | 225.07 | 225.1 | 7194.0 |
| 2024-10-02 05:30:00 | AAPL | Stock | 225.21 | 225.35 | 224.75 | 224.8 | 4852.0 |
| 2024-10-02 06:00:00 | AAPL | Stock | 224.64 | 225.0 | 224.5 | 224.94 | 7842.0 |
| 2024-10-02 06:30:00 | AAPL | Stock | 224.93 | 225.0 | 224.75 | 224.84 | 26830.0 |
| 2024-10-02 07:00:00 | AAPL | Stock | 224.82 | 225.0 | 224.52 | 224.89 | 18435.0 |
| 2024-10-02 07:30:00 | AAPL | Stock | 224.92 | 225.0 | 224.75 | 224.75 | 12646.0 |
| 2024-10-02 08:00:00 | AAPL | Stock | 224.66 | 225.98 | 224.5 | 224.6 | 62035.0 |
| 2024-10-02 08:30:00 | AAPL | Stock | 224.65 | 225.61 | 224.55 | 225.2 | 38126.0 |
| 2024-10-02 09:00:00 | AAPL | Stock | 225.2 | 225.8987 | 224.74 | 225.89 | 72583.0 |
| 2024-10-02 09:30:00 | AAPL | Stock | 225.89 | 226.12 | 223.21 | 223.38 | 4614653.0 |
| 2024-10-02 10:00:00 | AAPL | Stock | 223.375 | 225.42 | 223.02 | 225.42 | 2339682.0 |
| 2024-10-02 10:30:00 | AAPL | Stock | 225.4 | 226.39 | 225.27 | 226.08 | 2198653.0 |
| 2024-10-02 11:00:00 | AAPL | Stock | 226.085 | 226.6 | 225.91 | 226.22 | 1492285.0 |
| 2024-10-02 11:30:00 | AAPL | Stock | 226.22 | 227.05 | 226.165 | 226.84 | 1865206.0 |
| 2024-10-02 12:00:00 | AAPL | Stock | 226.85 | 227.0 | 226.65 | 226.952 | 966751.0 |
| 2024-10-02 12:30:00 | AAPL | Stock | 226.96 | 227.03 | 226.62 | 226.635 | 870107.0 |
| 2024-10-02 13:00:00 | AAPL | Stock | 226.63 | 227.0394 | 226.58 | 226.96 | 814271.0 |
| 2024-10-02 13:30:00 | AAPL | Stock | 226.94 | 227.14 | 226.34 | 227.116 | 980381.0 |
| 2024-10-02 14:00:00 | AAPL | Stock | 227.11 | 227.18 | 226.46 | 226.82 | 896334.0 |
| 2024-10-02 14:30:00 | AAPL | Stock | 226.82 | 226.97 | 226.65 | 226.9 | 648032.0 |
| 2024-10-02 15:00:00 | AAPL | Stock | 226.9 | 227.33 | 226.86 | 227.25 | 905724.0 |
| 2024-10-02 15:30:00 | AAPL | Stock | 227.24 | 227.37 | 226.68 | 226.81 | 2131730.0 |
| 2024-10-02 16:00:00 | AAPL | Stock | 226.79 | 227.17 | 226.66 | 226.9 | 4219881.0 |
| 2024-10-02 16:30:00 | AAPL | Stock | 226.99 | 227.38 | 226.91 | 227.2 | 15462.0 |
| 2024-10-02 17:00:00 | AAPL | Stock | 227.299 | 227.3 | 226.78 | 227.115 | 20625.0 |
| 2024-10-02 17:30:00 | AAPL | Stock | 227.11 | 227.13 | 226.78 | 227.0982 | 96962.0 |
| 2024-10-02 18:00:00 | AAPL | Stock | 227.06 | 227.1485 | 227.02 | 227.13 | 8598.0 |
| 2024-10-02 18:30:00 | AAPL | Stock | 227.15 | 227.15 | 227.0 | 227.0287 | 7050.0 |
| 2024-10-02 19:00:00 | AAPL | Stock | 227.0 | 227.0699 | 226.97 | 226.9999 | 6506.0 |
| 2024-10-02 19:30:00 | AAPL | Stock | 227.0 | 227.07 | 226.78 | 226.9715 | 12084.0 |
| 2024-10-02 04:00:00 | MSFT | Stock | 420.0 | 420.5 | 420.0 | 420.33 | 3089.0 |
| 2024-10-02 04:30:00 | MSFT | Stock | 420.33 | 420.33 | 420.33 | 420.33 | 100.0 |
| 2024-10-02 05:00:00 | MSFT | Stock | 420.03 | 420.03 | 419.5 | 419.5 | 1007.0 |
| 2024-10-02 05:30:00 | MSFT | Stock | 419.54 | 419.54 | 419.54 | 419.54 | 140.0 |
| 2024-10-02 06:00:00 | MSFT | Stock | 419.28 | 420.0 | 419.27 | 420.0 | 2188.0 |
| 2024-10-02 06:30:00 | MSFT | Stock | 420.0 | 420.0 | 419.59 | 419.59 | 3364.0 |
| 2024-10-02 07:00:00 | MSFT | Stock | 419.83 | 420.01 | 419.46 | 420.0 | 6472.0 |
| 2024-10-02 07:30:00 | MSFT | Stock | 420.01 | 420.14 | 419.14 | 419.14 | 3588.0 |
| 2024-10-02 08:00:00 | MSFT | Stock | 419.9843 | 420.38 | 419.1 | 419.35 | 11312.0 |
| 2024-10-02 08:30:00 | MSFT | Stock | 419.25 | 420.79 | 419.25 | 420.5332 | 14460.0 |
| 2024-10-02 09:00:00 | MSFT | Stock | 420.3 | 422.87 | 420.2 | 422.87 | 18051.0 |
| 2024-10-02 09:30:00 | MSFT | Stock | 422.58 | 422.88 | 416.71 | 418.5192 | 1685620.0 |
| 2024-10-02 10:00:00 | MSFT | Stock | 418.5 | 419.21 | 417.65 | 419.08 | 643632.0 |
| 2024-10-02 10:30:00 | MSFT | Stock | 419.13 | 419.22 | 417.57 | 418.04 | 758397.0 |
| 2024-10-02 11:00:00 | MSFT | Stock | 418.07 | 419.335 | 417.68 | 418.89 | 539740.0 |
| 2024-10-02 11:30:00 | MSFT | Stock | 418.89 | 419.1098 | 417.96 | 418.495 | 334850.0 |
| 2024-10-02 12:00:00 | MSFT | Stock | 418.51 | 419.4 | 418.41 | 419.23 | 336136.0 |
| 2024-10-02 12:30:00 | MSFT | Stock | 419.14 | 419.14 | 417.05 | 417.07 | 377397.0 |
> showing 50 of 99,901 rows — these rows as CSV