PREVIEW / stock_30min / 2025-05-27
file: by_date/stock_30min/2025/2025-05-27.parquet size: 2.2 MB rows: 106,590 symbols: 411
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 |
|---|---|---|---|---|---|---|---|
| 2025-05-27 04:00:00 | AAPL | Stock | 198.02 | 199.67 | 197.92 | 199.22 | 38523.0 |
| 2025-05-27 04:30:00 | AAPL | Stock | 199.2 | 199.24 | 198.91 | 199.09 | 16882.0 |
| 2025-05-27 05:00:00 | AAPL | Stock | 199.05 | 199.38 | 199.05 | 199.16 | 5130.0 |
| 2025-05-27 05:30:00 | AAPL | Stock | 199.09 | 199.24 | 199.06 | 199.06 | 7797.0 |
| 2025-05-27 06:00:00 | AAPL | Stock | 199.04 | 199.06 | 198.6 | 199.06 | 16127.0 |
| 2025-05-27 06:30:00 | AAPL | Stock | 199.15 | 199.2 | 198.71 | 198.71 | 12393.0 |
| 2025-05-27 07:00:00 | AAPL | Stock | 198.67 | 198.74 | 198.02 | 198.42 | 49050.0 |
| 2025-05-27 07:30:00 | AAPL | Stock | 198.42 | 198.67 | 198.4 | 198.54 | 17691.0 |
| 2025-05-27 08:00:00 | AAPL | Stock | 198.14 | 199.2 | 197.3 | 198.85 | 190713.0 |
| 2025-05-27 08:30:00 | AAPL | Stock | 198.81 | 198.9163 | 198.46 | 198.47 | 53825.0 |
| 2025-05-27 09:00:00 | AAPL | Stock | 198.5394 | 198.8 | 198.0 | 198.5 | 134861.0 |
| 2025-05-27 09:30:00 | AAPL | Stock | 198.29 | 199.17 | 197.43 | 198.0676 | 5616112.0 |
| 2025-05-27 10:00:00 | AAPL | Stock | 198.08 | 198.76 | 197.93 | 198.35 | 3405991.0 |
| 2025-05-27 10:30:00 | AAPL | Stock | 198.36 | 198.8799 | 198.01 | 198.155 | 2540716.0 |
| 2025-05-27 11:00:00 | AAPL | Stock | 198.17 | 199.37 | 198.105 | 199.365 | 2674252.0 |
| 2025-05-27 11:30:00 | AAPL | Stock | 199.36 | 200.093 | 199.0 | 200.07 | 2508943.0 |
| 2025-05-27 12:00:00 | AAPL | Stock | 200.07 | 200.58 | 199.9614 | 199.995 | 2447409.0 |
| 2025-05-27 12:30:00 | AAPL | Stock | 199.99 | 200.65 | 199.89 | 200.04 | 1851271.0 |
| 2025-05-27 13:00:00 | AAPL | Stock | 200.045 | 200.12 | 199.67 | 199.9599 | 1682661.0 |
| 2025-05-27 13:30:00 | AAPL | Stock | 199.955 | 200.55 | 199.81 | 200.5407 | 1551532.0 |
| 2025-05-27 14:00:00 | AAPL | Stock | 200.54 | 200.74 | 200.3537 | 200.38 | 1455103.0 |
| 2025-05-27 14:30:00 | AAPL | Stock | 200.38 | 200.55 | 200.22 | 200.4638 | 1621265.0 |
| 2025-05-27 15:00:00 | AAPL | Stock | 200.45 | 200.55 | 200.19 | 200.2944 | 1709001.0 |
| 2025-05-27 15:30:00 | AAPL | Stock | 200.3 | 200.47 | 199.93 | 200.19 | 4580134.0 |
| 2025-05-27 16:00:00 | AAPL | Stock | 200.18 | 200.46 | 200.1 | 200.21 | 7724480.0 |
| 2025-05-27 16:30:00 | AAPL | Stock | 200.3463 | 200.3463 | 200.21 | 200.2654 | 45857.0 |
| 2025-05-27 17:00:00 | AAPL | Stock | 200.2395 | 200.459 | 200.2395 | 200.4488 | 9472.0 |
| 2025-05-27 17:30:00 | AAPL | Stock | 200.4182 | 200.45 | 200.33 | 200.45 | 9071.0 |
| 2025-05-27 18:00:00 | AAPL | Stock | 200.43 | 200.47 | 200.32 | 200.41 | 7394.0 |
| 2025-05-27 18:30:00 | AAPL | Stock | 200.36 | 200.42 | 200.33 | 200.3589 | 8709.0 |
| 2025-05-27 19:00:00 | AAPL | Stock | 200.36 | 200.4399 | 200.32 | 200.3212 | 11436.0 |
| 2025-05-27 19:30:00 | AAPL | Stock | 200.38 | 200.45 | 200.3425 | 200.4 | 17936.0 |
| 2025-05-27 04:00:00 | MSFT | Stock | 453.3 | 457.16 | 452.5 | 455.48 | 9440.0 |
| 2025-05-27 04:30:00 | MSFT | Stock | 455.44 | 456.01 | 455.43 | 455.77 | 1574.0 |
| 2025-05-27 05:00:00 | MSFT | Stock | 455.93 | 456.31 | 455.31 | 455.31 | 710.0 |
| 2025-05-27 05:30:00 | MSFT | Stock | 455.49 | 455.6 | 454.67 | 454.85 | 3930.0 |
| 2025-05-27 06:00:00 | MSFT | Stock | 454.8 | 455.0 | 454.6 | 455.0 | 2927.0 |
| 2025-05-27 06:30:00 | MSFT | Stock | 455.0 | 455.0 | 454.0 | 454.71 | 5538.0 |
| 2025-05-27 07:00:00 | MSFT | Stock | 454.21 | 456.1 | 454.0 | 455.43 | 15878.0 |
| 2025-05-27 07:30:00 | MSFT | Stock | 455.95 | 456.37 | 455.95 | 456.13 | 2419.0 |
| 2025-05-27 08:00:00 | MSFT | Stock | 456.0 | 457.0 | 449.055 | 455.51 | 18925.0 |
| 2025-05-27 08:30:00 | MSFT | Stock | 455.75 | 455.89 | 455.3206 | 455.3206 | 5272.0 |
| 2025-05-27 09:00:00 | MSFT | Stock | 455.38 | 456.8 | 455.0 | 456.54 | 47303.0 |
| 2025-05-27 09:30:00 | MSFT | Stock | 456.48 | 460.2 | 456.115 | 457.36 | 1974337.0 |
| 2025-05-27 10:00:00 | MSFT | Stock | 457.44 | 459.1 | 457.44 | 457.97 | 842696.0 |
| 2025-05-27 10:30:00 | MSFT | Stock | 457.99 | 458.54 | 456.9801 | 457.12 | 551065.0 |
| 2025-05-27 11:00:00 | MSFT | Stock | 457.115 | 458.13 | 457.02 | 457.875 | 450616.0 |
| 2025-05-27 11:30:00 | MSFT | Stock | 457.84 | 458.52 | 457.215 | 458.36 | 540606.0 |
| 2025-05-27 12:00:00 | MSFT | Stock | 458.34 | 458.88 | 458.2 | 458.28 | 495594.0 |
| 2025-05-27 12:30:00 | MSFT | Stock | 458.27 | 459.39 | 458.2246 | 458.76 | 448689.0 |
> showing 50 of 106,590 rows — these rows as CSV