PREVIEW / stock_30min / 2025-06-02
file: by_date/stock_30min/2025/2025-06-02.parquet size: 2.2 MB rows: 105,006 symbols: 403
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-06-02 04:00:00 | AAPL | Stock | 198.52 | 199.9 | 198.52 | 199.5 | 17290.0 |
| 2025-06-02 04:30:00 | AAPL | Stock | 199.46 | 199.63 | 199.26 | 199.31 | 2990.0 |
| 2025-06-02 05:00:00 | AAPL | Stock | 199.36 | 199.46 | 199.2 | 199.38 | 4534.0 |
| 2025-06-02 05:30:00 | AAPL | Stock | 199.34 | 199.4 | 199.21 | 199.29 | 4661.0 |
| 2025-06-02 06:00:00 | AAPL | Stock | 199.31 | 199.6 | 199.31 | 199.53 | 4270.0 |
| 2025-06-02 06:30:00 | AAPL | Stock | 199.47 | 199.57 | 199.38 | 199.53 | 4093.0 |
| 2025-06-02 07:00:00 | AAPL | Stock | 199.51 | 199.98 | 199.45 | 199.79 | 26256.0 |
| 2025-06-02 07:30:00 | AAPL | Stock | 199.78 | 199.91 | 199.55 | 199.71 | 13966.0 |
| 2025-06-02 08:00:00 | AAPL | Stock | 199.59 | 201.352 | 198.79 | 199.67 | 51954.0 |
| 2025-06-02 08:30:00 | AAPL | Stock | 199.7 | 199.97 | 199.52 | 199.61 | 22666.0 |
| 2025-06-02 09:00:00 | AAPL | Stock | 199.66 | 200.4478 | 199.19 | 200.28 | 61914.0 |
| 2025-06-02 09:30:00 | AAPL | Stock | 200.28 | 202.13 | 200.15 | 201.11 | 4254286.0 |
| 2025-06-02 10:00:00 | AAPL | Stock | 201.06 | 201.13 | 200.12 | 200.53 | 1834825.0 |
| 2025-06-02 10:30:00 | AAPL | Stock | 200.52 | 201.4872 | 200.35 | 201.435 | 1670619.0 |
| 2025-06-02 11:00:00 | AAPL | Stock | 201.43 | 201.99 | 200.627 | 200.71 | 1762324.0 |
| 2025-06-02 11:30:00 | AAPL | Stock | 200.72 | 201.1 | 200.3 | 201.005 | 1299241.0 |
| 2025-06-02 12:00:00 | AAPL | Stock | 201.01 | 201.1187 | 200.715 | 201.03 | 909482.0 |
| 2025-06-02 12:30:00 | AAPL | Stock | 201.03 | 201.168 | 200.57 | 200.8935 | 768051.0 |
| 2025-06-02 13:00:00 | AAPL | Stock | 200.9 | 201.12 | 200.86 | 200.8601 | 777324.0 |
| 2025-06-02 13:30:00 | AAPL | Stock | 200.86 | 201.0036 | 200.5801 | 200.9 | 820755.0 |
| 2025-06-02 14:00:00 | AAPL | Stock | 200.9 | 201.53 | 200.63 | 201.454 | 1146333.0 |
| 2025-06-02 14:30:00 | AAPL | Stock | 201.45 | 201.53 | 201.175 | 201.265 | 796464.0 |
| 2025-06-02 15:00:00 | AAPL | Stock | 201.27 | 201.78 | 201.14 | 201.66 | 1194824.0 |
| 2025-06-02 15:30:00 | AAPL | Stock | 201.65 | 201.82 | 201.3 | 201.79 | 2528808.0 |
| 2025-06-02 16:00:00 | AAPL | Stock | 201.8 | 202.48 | 201.53 | 202.09 | 4706613.0 |
| 2025-06-02 16:30:00 | AAPL | Stock | 202.1 | 202.1 | 201.86 | 201.941 | 16439.0 |
| 2025-06-02 17:00:00 | AAPL | Stock | 201.94 | 202.1 | 201.9 | 201.94 | 9608.0 |
| 2025-06-02 17:30:00 | AAPL | Stock | 201.93 | 201.99 | 201.88 | 201.9412 | 5839.0 |
| 2025-06-02 18:00:00 | AAPL | Stock | 201.9 | 201.93 | 201.53 | 201.53 | 7323.0 |
| 2025-06-02 18:30:00 | AAPL | Stock | 201.3066 | 201.7 | 201.3066 | 201.65 | 10131.0 |
| 2025-06-02 19:00:00 | AAPL | Stock | 201.66 | 201.93 | 201.21 | 201.85 | 20769.0 |
| 2025-06-02 19:30:00 | AAPL | Stock | 201.85 | 201.9337 | 201.25 | 201.68 | 21835.0 |
| 2025-06-02 04:00:00 | MSFT | Stock | 454.0 | 457.51 | 454.0 | 457.32 | 7941.0 |
| 2025-06-02 04:30:00 | MSFT | Stock | 457.88 | 457.88 | 457.59 | 457.59 | 200.0 |
| 2025-06-02 05:00:00 | MSFT | Stock | 457.44 | 457.44 | 457.32 | 457.32 | 209.0 |
| 2025-06-02 05:30:00 | MSFT | Stock | 457.25 | 457.25 | 457.2 | 457.2 | 672.0 |
| 2025-06-02 06:00:00 | MSFT | Stock | 457.6 | 458.03 | 457.6 | 457.82 | 1032.0 |
| 2025-06-02 06:30:00 | MSFT | Stock | 457.7 | 458.12 | 457.7 | 458.12 | 832.0 |
| 2025-06-02 07:00:00 | MSFT | Stock | 458.7 | 459.13 | 458.7 | 458.78 | 995.0 |
| 2025-06-02 07:30:00 | MSFT | Stock | 459.0 | 459.25 | 458.93 | 458.98 | 1747.0 |
| 2025-06-02 08:00:00 | MSFT | Stock | 458.225 | 459.5 | 457.0 | 458.51 | 13814.0 |
| 2025-06-02 08:30:00 | MSFT | Stock | 458.5 | 459.55 | 458.29 | 458.55 | 2428.0 |
| 2025-06-02 09:00:00 | MSFT | Stock | 458.56 | 458.63 | 456.41 | 457.11 | 13442.0 |
| 2025-06-02 09:30:00 | MSFT | Stock | 457.14 | 461.14 | 456.89 | 460.89 | 1141333.0 |
| 2025-06-02 10:00:00 | MSFT | Stock | 460.9 | 461.0 | 458.37 | 460.635 | 642391.0 |
| 2025-06-02 10:30:00 | MSFT | Stock | 460.63 | 461.19 | 459.94 | 460.96 | 431113.0 |
| 2025-06-02 11:00:00 | MSFT | Stock | 460.91 | 461.4499 | 460.0 | 460.57 | 465987.0 |
| 2025-06-02 11:30:00 | MSFT | Stock | 460.55 | 461.48 | 460.035 | 461.36 | 217007.0 |
| 2025-06-02 12:00:00 | MSFT | Stock | 461.32 | 461.55 | 460.63 | 460.85 | 200798.0 |
| 2025-06-02 12:30:00 | MSFT | Stock | 460.86 | 461.45 | 460.58 | 461.4 | 185380.0 |
> showing 50 of 105,006 rows — these rows as CSV