PREVIEW / stock_30min / 2025-01-31
file: by_date/stock_30min/2025/2025-01-31.parquet size: 2.2 MB rows: 106,360 symbols: 556
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-01-31 04:00:00 | AAPL | Stock | 244.75 | 245.89 | 244.28 | 245.79 | 89931.0 |
| 2025-01-31 04:30:00 | AAPL | Stock | 245.76 | 245.86 | 245.59 | 245.61 | 9591.0 |
| 2025-01-31 05:00:00 | AAPL | Stock | 245.59 | 245.97 | 245.58 | 245.74 | 15057.0 |
| 2025-01-31 05:30:00 | AAPL | Stock | 245.81 | 245.83 | 245.1 | 245.31 | 19794.0 |
| 2025-01-31 06:00:00 | AAPL | Stock | 245.17 | 246.44 | 245.17 | 245.89 | 71988.0 |
| 2025-01-31 06:30:00 | AAPL | Stock | 245.82 | 246.0 | 245.6 | 245.91 | 33921.0 |
| 2025-01-31 07:00:00 | AAPL | Stock | 245.92 | 247.41 | 245.92 | 247.16 | 185088.0 |
| 2025-01-31 07:30:00 | AAPL | Stock | 247.16 | 247.49 | 246.78 | 247.16 | 139613.0 |
| 2025-01-31 08:00:00 | AAPL | Stock | 246.28 | 248.2299 | 244.01 | 247.88 | 625195.0 |
| 2025-01-31 08:30:00 | AAPL | Stock | 248.0 | 248.07 | 246.61 | 246.79 | 318751.0 |
| 2025-01-31 09:00:00 | AAPL | Stock | 246.79 | 247.87 | 246.7 | 247.16 | 526023.0 |
| 2025-01-31 09:30:00 | AAPL | Stock | 247.09 | 247.19 | 241.35 | 241.605 | 12724133.0 |
| 2025-01-31 10:00:00 | AAPL | Stock | 241.58 | 243.245 | 240.55 | 240.9436 | 5299982.0 |
| 2025-01-31 10:30:00 | AAPL | Stock | 240.905 | 241.43 | 240.01 | 240.925 | 4292590.0 |
| 2025-01-31 11:00:00 | AAPL | Stock | 240.93 | 241.11 | 238.59 | 238.949 | 3983662.0 |
| 2025-01-31 11:30:00 | AAPL | Stock | 238.96 | 240.05 | 238.76 | 238.93 | 2686741.0 |
| 2025-01-31 12:00:00 | AAPL | Stock | 238.945 | 239.82 | 238.74 | 239.7416 | 2284764.0 |
| 2025-01-31 12:30:00 | AAPL | Stock | 239.74 | 239.81 | 238.3 | 238.31 | 1986364.0 |
| 2025-01-31 13:00:00 | AAPL | Stock | 238.32 | 238.5399 | 236.22 | 236.425 | 3796996.0 |
| 2025-01-31 13:30:00 | AAPL | Stock | 236.43 | 236.86 | 235.11 | 235.26 | 2841173.0 |
| 2025-01-31 14:00:00 | AAPL | Stock | 235.28 | 235.93 | 234.47 | 235.135 | 3015332.0 |
| 2025-01-31 14:30:00 | AAPL | Stock | 235.155 | 235.2799 | 233.44 | 234.11 | 3162937.0 |
| 2025-01-31 15:00:00 | AAPL | Stock | 234.115 | 234.37 | 233.55 | 234.29 | 2736679.0 |
| 2025-01-31 15:30:00 | AAPL | Stock | 234.31 | 236.5 | 233.74 | 235.84 | 6453069.0 |
| 2025-01-31 16:00:00 | AAPL | Stock | 235.89 | 236.1 | 235.03 | 235.2683 | 12149275.0 |
| 2025-01-31 16:30:00 | AAPL | Stock | 235.24 | 236.0 | 234.95 | 235.25 | 389061.0 |
| 2025-01-31 17:00:00 | AAPL | Stock | 235.27 | 236.0 | 235.03 | 235.25 | 320871.0 |
| 2025-01-31 17:30:00 | AAPL | Stock | 235.06 | 235.33 | 235.06 | 235.2 | 22569.0 |
| 2025-01-31 18:00:00 | AAPL | Stock | 235.2015 | 235.2095 | 235.01 | 235.07 | 27230.0 |
| 2025-01-31 18:30:00 | AAPL | Stock | 235.05 | 235.08 | 234.8 | 234.9202 | 17539.0 |
| 2025-01-31 19:00:00 | AAPL | Stock | 234.92 | 235.0695 | 234.724 | 234.724 | 15026.0 |
| 2025-01-31 19:30:00 | AAPL | Stock | 234.78 | 234.78 | 233.92 | 233.92 | 39459.0 |
| 2025-01-31 04:00:00 | MSFT | Stock | 419.48 | 419.9 | 418.93 | 419.48 | 15039.0 |
| 2025-01-31 04:30:00 | MSFT | Stock | 419.48 | 420.0 | 419.48 | 419.9 | 19132.0 |
| 2025-01-31 05:00:00 | MSFT | Stock | 419.8 | 419.93 | 419.29 | 419.58 | 8289.0 |
| 2025-01-31 05:30:00 | MSFT | Stock | 419.52 | 420.14 | 419.42 | 420.14 | 21387.0 |
| 2025-01-31 06:00:00 | MSFT | Stock | 420.14 | 420.25 | 420.0 | 420.0 | 4430.0 |
| 2025-01-31 06:30:00 | MSFT | Stock | 419.92 | 420.0 | 419.62 | 419.9 | 9666.0 |
| 2025-01-31 07:00:00 | MSFT | Stock | 419.98 | 419.98 | 418.56 | 419.0 | 27380.0 |
| 2025-01-31 07:30:00 | MSFT | Stock | 419.1 | 419.58 | 419.0 | 419.2 | 14160.0 |
| 2025-01-31 08:00:00 | MSFT | Stock | 419.35 | 420.04 | 418.01 | 419.3855 | 182185.0 |
| 2025-01-31 08:30:00 | MSFT | Stock | 419.35 | 419.49 | 418.52 | 418.65 | 49714.0 |
| 2025-01-31 09:00:00 | MSFT | Stock | 418.52 | 419.5 | 417.85 | 418.69 | 104171.0 |
| 2025-01-31 09:30:00 | MSFT | Stock | 418.66 | 419.78 | 416.55 | 418.96 | 3232576.0 |
| 2025-01-31 10:00:00 | MSFT | Stock | 419.015 | 420.69 | 417.34 | 417.3874 | 1974662.0 |
| 2025-01-31 10:30:00 | MSFT | Stock | 417.387 | 418.13 | 416.27 | 417.229 | 1606300.0 |
| 2025-01-31 11:00:00 | MSFT | Stock | 417.18 | 417.68 | 415.93 | 416.145 | 1365873.0 |
| 2025-01-31 11:30:00 | MSFT | Stock | 416.12 | 416.76 | 415.23 | 416.6892 | 957023.0 |
| 2025-01-31 12:00:00 | MSFT | Stock | 416.73 | 418.6 | 416.6481 | 418.53 | 974765.0 |
| 2025-01-31 12:30:00 | MSFT | Stock | 418.55 | 418.9088 | 418.1801 | 418.3282 | 644867.0 |
> showing 50 of 106,360 rows — these rows as CSV