PREVIEW / stock_30min / 2025-05-02
file: by_date/stock_30min/2025/2025-05-02.parquet size: 2.1 MB rows: 102,935 symbols: 422
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-02 04:00:00 | AAPL | Stock | 206.6 | 208.01 | 205.82 | 207.65 | 139661.0 |
| 2025-05-02 04:30:00 | AAPL | Stock | 207.62 | 207.74 | 207.0 | 207.14 | 48441.0 |
| 2025-05-02 05:00:00 | AAPL | Stock | 207.2 | 207.49 | 206.9 | 207.04 | 17882.0 |
| 2025-05-02 05:30:00 | AAPL | Stock | 207.28 | 207.6 | 207.2 | 207.2 | 13176.0 |
| 2025-05-02 06:00:00 | AAPL | Stock | 207.24 | 207.29 | 206.6 | 206.76 | 50182.0 |
| 2025-05-02 06:30:00 | AAPL | Stock | 206.9 | 206.96 | 206.41 | 206.41 | 46558.0 |
| 2025-05-02 07:00:00 | AAPL | Stock | 206.56 | 207.4 | 205.51 | 206.15 | 229656.0 |
| 2025-05-02 07:30:00 | AAPL | Stock | 206.15 | 206.44 | 205.75 | 206.0 | 96202.0 |
| 2025-05-02 08:00:00 | AAPL | Stock | 207.03 | 208.0324 | 205.5 | 206.25 | 535707.0 |
| 2025-05-02 08:30:00 | AAPL | Stock | 206.3 | 207.7498 | 206.0 | 207.45 | 535470.0 |
| 2025-05-02 09:00:00 | AAPL | Stock | 207.406 | 207.72 | 205.87 | 206.33 | 613561.0 |
| 2025-05-02 09:30:00 | AAPL | Stock | 206.09 | 206.43 | 202.16 | 203.79 | 14942889.0 |
| 2025-05-02 10:00:00 | AAPL | Stock | 203.77 | 206.82 | 203.25 | 206.72 | 7260878.0 |
| 2025-05-02 10:30:00 | AAPL | Stock | 206.72 | 206.99 | 204.77 | 205.175 | 4443228.0 |
| 2025-05-02 11:00:00 | AAPL | Stock | 205.19 | 205.73 | 204.6 | 204.9008 | 2926855.0 |
| 2025-05-02 11:30:00 | AAPL | Stock | 204.92 | 205.64 | 204.86 | 205.48 | 2438407.0 |
| 2025-05-02 12:00:00 | AAPL | Stock | 205.4874 | 206.58 | 204.9 | 205.0 | 4212446.0 |
| 2025-05-02 12:30:00 | AAPL | Stock | 205.0 | 205.89 | 204.86 | 204.9395 | 2680671.0 |
| 2025-05-02 13:00:00 | AAPL | Stock | 204.93 | 205.15 | 204.15 | 204.699 | 2651236.0 |
| 2025-05-02 13:30:00 | AAPL | Stock | 204.7 | 205.83 | 204.7 | 205.4 | 2454615.0 |
| 2025-05-02 14:00:00 | AAPL | Stock | 205.39 | 205.61 | 204.81 | 204.88 | 1984565.0 |
| 2025-05-02 14:30:00 | AAPL | Stock | 204.87 | 205.43 | 204.09 | 204.18 | 2867557.0 |
| 2025-05-02 15:00:00 | AAPL | Stock | 204.17 | 204.9815 | 203.66 | 204.76 | 3497518.0 |
| 2025-05-02 15:30:00 | AAPL | Stock | 204.78 | 205.5 | 203.89 | 205.3 | 7013511.0 |
| 2025-05-02 16:00:00 | AAPL | Stock | 205.35 | 205.6 | 205.1992 | 205.21 | 8368796.0 |
| 2025-05-02 16:30:00 | AAPL | Stock | 205.29 | 205.35 | 205.0038 | 205.06 | 115782.0 |
| 2025-05-02 17:00:00 | AAPL | Stock | 205.06 | 205.15 | 205.01 | 205.15 | 62786.0 |
| 2025-05-02 17:30:00 | AAPL | Stock | 205.16 | 205.29 | 205.16 | 205.2 | 20714.0 |
| 2025-05-02 18:00:00 | AAPL | Stock | 205.22 | 205.29 | 205.1598 | 205.2491 | 8478.0 |
| 2025-05-02 18:30:00 | AAPL | Stock | 205.1999 | 205.25 | 205.0779 | 205.09 | 11197.0 |
| 2025-05-02 19:00:00 | AAPL | Stock | 205.06 | 205.17 | 205.04 | 205.13 | 19878.0 |
| 2025-05-02 19:30:00 | AAPL | Stock | 205.13 | 205.15 | 205.04 | 205.04 | 27398.0 |
| 2025-05-02 04:00:00 | MSFT | Stock | 426.72 | 427.5 | 425.88 | 427.0 | 22987.0 |
| 2025-05-02 04:30:00 | MSFT | Stock | 427.18 | 427.35 | 425.92 | 425.99 | 3291.0 |
| 2025-05-02 05:00:00 | MSFT | Stock | 426.0 | 427.37 | 425.5 | 425.99 | 11325.0 |
| 2025-05-02 05:30:00 | MSFT | Stock | 425.9 | 426.58 | 425.9 | 426.25 | 3715.0 |
| 2025-05-02 06:00:00 | MSFT | Stock | 426.68 | 426.7 | 426.39 | 426.49 | 2866.0 |
| 2025-05-02 06:30:00 | MSFT | Stock | 427.0 | 427.2 | 426.04 | 426.17 | 7175.0 |
| 2025-05-02 07:00:00 | MSFT | Stock | 426.34 | 427.35 | 426.2 | 426.9 | 10615.0 |
| 2025-05-02 07:30:00 | MSFT | Stock | 426.81 | 426.81 | 424.62 | 425.21 | 17854.0 |
| 2025-05-02 08:00:00 | MSFT | Stock | 425.25 | 432.0 | 424.0 | 427.0 | 80321.0 |
| 2025-05-02 08:30:00 | MSFT | Stock | 427.0 | 430.0 | 427.0 | 430.0 | 66644.0 |
| 2025-05-02 09:00:00 | MSFT | Stock | 430.1323 | 432.85 | 428.82 | 431.72 | 107760.0 |
| 2025-05-02 09:30:00 | MSFT | Stock | 431.72 | 437.41 | 429.985 | 436.805 | 4487227.0 |
| 2025-05-02 10:00:00 | MSFT | Stock | 436.805 | 439.44 | 435.94 | 437.85 | 2199187.0 |
| 2025-05-02 10:30:00 | MSFT | Stock | 437.89 | 437.9 | 434.46 | 435.11 | 1259676.0 |
| 2025-05-02 11:00:00 | MSFT | Stock | 435.115 | 436.1 | 434.18 | 434.9 | 1103802.0 |
| 2025-05-02 11:30:00 | MSFT | Stock | 434.905 | 436.22 | 433.9382 | 436.05 | 709169.0 |
| 2025-05-02 12:00:00 | MSFT | Stock | 436.02 | 438.19 | 435.51 | 437.13 | 1045835.0 |
| 2025-05-02 12:30:00 | MSFT | Stock | 437.13 | 438.17 | 436.8143 | 437.68 | 616222.0 |
> showing 50 of 102,935 rows — these rows as CSV