PREVIEW / stock_30min / 2025-05-01
file: by_date/stock_30min/2025/2025-05-01.parquet size: 2.1 MB rows: 102,824 symbols: 418
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-01 04:00:00 | AAPL | Stock | 209.58 | 209.86 | 209.05 | 209.4 | 19351.0 |
| 2025-05-01 04:30:00 | AAPL | Stock | 209.55 | 209.75 | 209.22 | 209.72 | 21839.0 |
| 2025-05-01 05:00:00 | AAPL | Stock | 209.72 | 210.27 | 209.66 | 210.27 | 17562.0 |
| 2025-05-01 05:30:00 | AAPL | Stock | 210.28 | 210.3 | 209.76 | 210.3 | 19153.0 |
| 2025-05-01 06:00:00 | AAPL | Stock | 210.21 | 210.35 | 209.71 | 209.84 | 16397.0 |
| 2025-05-01 06:30:00 | AAPL | Stock | 209.71 | 209.99 | 209.67 | 209.99 | 12168.0 |
| 2025-05-01 07:00:00 | AAPL | Stock | 210.04 | 210.29 | 209.01 | 209.27 | 95325.0 |
| 2025-05-01 07:30:00 | AAPL | Stock | 209.27 | 209.53 | 209.16 | 209.31 | 36479.0 |
| 2025-05-01 08:00:00 | AAPL | Stock | 209.31 | 210.29 | 209.03 | 209.58 | 235606.0 |
| 2025-05-01 08:30:00 | AAPL | Stock | 209.53 | 212.5 | 209.0 | 209.13 | 189910.0 |
| 2025-05-01 09:00:00 | AAPL | Stock | 209.11 | 209.63 | 208.8 | 208.9 | 283055.0 |
| 2025-05-01 09:30:00 | AAPL | Stock | 209.08 | 212.5 | 208.9 | 210.68 | 5085877.0 |
| 2025-05-01 10:00:00 | AAPL | Stock | 210.8 | 211.84 | 209.71 | 211.74 | 2595567.0 |
| 2025-05-01 10:30:00 | AAPL | Stock | 211.75 | 213.09 | 211.315 | 212.89 | 2200824.0 |
| 2025-05-01 11:00:00 | AAPL | Stock | 212.89 | 214.27 | 212.69 | 212.8966 | 2012827.0 |
| 2025-05-01 11:30:00 | AAPL | Stock | 212.895 | 213.12 | 211.415 | 211.5844 | 1551103.0 |
| 2025-05-01 12:00:00 | AAPL | Stock | 211.6 | 212.84 | 211.53 | 212.78 | 1369681.0 |
| 2025-05-01 12:30:00 | AAPL | Stock | 212.78 | 212.85 | 211.85 | 212.135 | 934045.0 |
| 2025-05-01 13:00:00 | AAPL | Stock | 212.12 | 212.8776 | 212.07 | 212.51 | 870085.0 |
| 2025-05-01 13:30:00 | AAPL | Stock | 212.51 | 212.79 | 212.06 | 212.595 | 986743.0 |
| 2025-05-01 14:00:00 | AAPL | Stock | 212.59 | 213.0 | 212.52 | 212.78 | 1013950.0 |
| 2025-05-01 14:30:00 | AAPL | Stock | 212.79 | 213.2 | 212.52 | 212.545 | 1140377.0 |
| 2025-05-01 15:00:00 | AAPL | Stock | 212.55 | 212.96 | 212.3 | 212.94 | 1566969.0 |
| 2025-05-01 15:30:00 | AAPL | Stock | 212.94 | 214.56 | 212.47 | 212.83 | 5483868.0 |
| 2025-05-01 16:00:00 | AAPL | Stock | 212.8 | 213.77 | 211.56 | 212.45 | 7724699.0 |
| 2025-05-01 16:30:00 | AAPL | Stock | 212.48 | 214.0 | 207.0 | 207.7001 | 2033318.0 |
| 2025-05-01 17:00:00 | AAPL | Stock | 207.7992 | 211.0 | 206.13 | 207.49 | 1383016.0 |
| 2025-05-01 17:30:00 | AAPL | Stock | 207.4 | 208.2 | 204.5807 | 205.21 | 676508.0 |
| 2025-05-01 18:00:00 | AAPL | Stock | 205.25 | 205.25 | 204.0 | 204.5 | 301607.0 |
| 2025-05-01 18:30:00 | AAPL | Stock | 204.45 | 204.64 | 203.84 | 204.55 | 183277.0 |
| 2025-05-01 19:00:00 | AAPL | Stock | 204.5 | 205.4138 | 204.4 | 205.38 | 169059.0 |
| 2025-05-01 19:30:00 | AAPL | Stock | 205.3615 | 205.416 | 204.51 | 205.25 | 201467.0 |
| 2025-05-01 04:00:00 | MSFT | Stock | 423.3 | 427.27 | 421.0 | 427.2 | 90934.0 |
| 2025-05-01 04:30:00 | MSFT | Stock | 427.02 | 428.68 | 426.87 | 427.62 | 35670.0 |
| 2025-05-01 05:00:00 | MSFT | Stock | 427.83 | 428.21 | 426.75 | 426.95 | 24535.0 |
| 2025-05-01 05:30:00 | MSFT | Stock | 426.9 | 429.22 | 426.7 | 428.6 | 28435.0 |
| 2025-05-01 06:00:00 | MSFT | Stock | 428.69 | 431.06 | 428.69 | 430.02 | 54182.0 |
| 2025-05-01 06:30:00 | MSFT | Stock | 430.02 | 432.1 | 429.55 | 431.24 | 69482.0 |
| 2025-05-01 07:00:00 | MSFT | Stock | 431.0 | 432.18 | 430.09 | 430.5 | 119820.0 |
| 2025-05-01 07:30:00 | MSFT | Stock | 430.5 | 432.5 | 429.77 | 431.3 | 117905.0 |
| 2025-05-01 08:00:00 | MSFT | Stock | 431.2 | 432.2801 | 422.5 | 429.5 | 247613.0 |
| 2025-05-01 08:30:00 | MSFT | Stock | 429.4 | 431.7 | 428.44 | 431.0 | 256446.0 |
| 2025-05-01 09:00:00 | MSFT | Stock | 431.0 | 432.0 | 427.1 | 431.5 | 592188.0 |
| 2025-05-01 09:30:00 | MSFT | Stock | 431.44 | 436.99 | 430.11 | 430.5932 | 11704115.0 |
| 2025-05-01 10:00:00 | MSFT | Stock | 430.66 | 431.99 | 428.54 | 431.135 | 3957603.0 |
| 2025-05-01 10:30:00 | MSFT | Stock | 431.07 | 432.64 | 430.01 | 432.07 | 2589531.0 |
| 2025-05-01 11:00:00 | MSFT | Stock | 432.08 | 433.58 | 431.195 | 432.25 | 2223465.0 |
| 2025-05-01 11:30:00 | MSFT | Stock | 432.2 | 432.29 | 428.165 | 429.1 | 1395106.0 |
| 2025-05-01 12:00:00 | MSFT | Stock | 429.12 | 430.775 | 427.8275 | 429.3 | 1402806.0 |
| 2025-05-01 12:30:00 | MSFT | Stock | 429.27 | 430.34 | 427.67 | 427.8101 | 1065667.0 |
> showing 50 of 102,824 rows — these rows as CSV