PREVIEW / stock_30min / 2025-02-24
file: by_date/stock_30min/2025/2025-02-24.parquet size: 2.2 MB rows: 107,963 symbols: 512
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-02-24 04:00:00 | AAPL | Stock | 245.39 | 245.43 | 245.06 | 245.24 | 13685.0 |
| 2025-02-24 04:30:00 | AAPL | Stock | 245.29 | 245.34 | 245.2 | 245.21 | 5538.0 |
| 2025-02-24 05:00:00 | AAPL | Stock | 245.2 | 245.22 | 245.12 | 245.2 | 7749.0 |
| 2025-02-24 05:30:00 | AAPL | Stock | 245.21 | 245.28 | 245.2 | 245.21 | 2745.0 |
| 2025-02-24 06:00:00 | AAPL | Stock | 245.22 | 245.23 | 241.55 | 242.35 | 188171.0 |
| 2025-02-24 06:30:00 | AAPL | Stock | 242.35 | 243.86 | 242.35 | 243.8 | 83862.0 |
| 2025-02-24 07:00:00 | AAPL | Stock | 243.86 | 244.38 | 243.46 | 244.17 | 62909.0 |
| 2025-02-24 07:30:00 | AAPL | Stock | 244.18 | 244.3 | 243.75 | 243.85 | 68486.0 |
| 2025-02-24 08:00:00 | AAPL | Stock | 243.6 | 246.0 | 243.4008 | 244.11 | 85758.0 |
| 2025-02-24 08:30:00 | AAPL | Stock | 244.11 | 244.7899 | 243.52 | 244.37 | 88974.0 |
| 2025-02-24 09:00:00 | AAPL | Stock | 244.33 | 245.4 | 243.11 | 245.01 | 283577.0 |
| 2025-02-24 09:30:00 | AAPL | Stock | 245.0 | 248.14 | 244.42 | 248.065 | 5604915.0 |
| 2025-02-24 10:00:00 | AAPL | Stock | 248.08 | 248.86 | 247.22 | 247.85 | 3773098.0 |
| 2025-02-24 10:30:00 | AAPL | Stock | 247.85 | 247.9541 | 246.01 | 247.225 | 3247491.0 |
| 2025-02-24 11:00:00 | AAPL | Stock | 247.22 | 247.6 | 246.27 | 247.1102 | 1719258.0 |
| 2025-02-24 11:30:00 | AAPL | Stock | 247.12 | 248.32 | 247.12 | 248.0 | 1733218.0 |
| 2025-02-24 12:00:00 | AAPL | Stock | 248.0 | 248.28 | 247.45 | 247.795 | 997231.0 |
| 2025-02-24 12:30:00 | AAPL | Stock | 247.82 | 247.96 | 247.27 | 247.27 | 913003.0 |
| 2025-02-24 13:00:00 | AAPL | Stock | 247.27 | 248.14 | 247.22 | 248.04 | 1038232.0 |
| 2025-02-24 13:30:00 | AAPL | Stock | 248.05 | 248.22 | 247.67 | 247.98 | 1020114.0 |
| 2025-02-24 14:00:00 | AAPL | Stock | 247.98 | 248.8 | 247.93 | 248.66 | 1593392.0 |
| 2025-02-24 14:30:00 | AAPL | Stock | 248.66 | 248.75 | 247.43 | 247.98 | 1205223.0 |
| 2025-02-24 15:00:00 | AAPL | Stock | 247.965 | 248.23 | 247.595 | 247.6 | 1240352.0 |
| 2025-02-24 15:30:00 | AAPL | Stock | 247.6 | 247.79 | 246.82 | 247.23 | 3712730.0 |
| 2025-02-24 16:00:00 | AAPL | Stock | 247.22 | 248.01 | 247.1 | 247.86 | 7899972.0 |
| 2025-02-24 16:30:00 | AAPL | Stock | 247.87 | 248.2 | 247.1 | 247.9 | 98015.0 |
| 2025-02-24 17:00:00 | AAPL | Stock | 247.93 | 248.0 | 247.1 | 247.91 | 24546.0 |
| 2025-02-24 17:30:00 | AAPL | Stock | 247.91 | 248.0 | 247.54 | 247.78 | 25784.0 |
| 2025-02-24 18:00:00 | AAPL | Stock | 247.77 | 248.0 | 247.71 | 247.97 | 24020.0 |
| 2025-02-24 18:30:00 | AAPL | Stock | 247.99 | 248.0496 | 247.4 | 247.55 | 37675.0 |
| 2025-02-24 19:00:00 | AAPL | Stock | 247.6 | 248.43 | 247.55 | 248.2 | 24257.0 |
| 2025-02-24 19:30:00 | AAPL | Stock | 248.2881 | 248.2997 | 248.05 | 248.09 | 9415.0 |
| 2025-02-24 04:00:00 | MSFT | Stock | 409.78 | 411.0 | 409.78 | 410.18 | 4572.0 |
| 2025-02-24 04:30:00 | MSFT | Stock | 410.14 | 410.83 | 409.81 | 409.81 | 6658.0 |
| 2025-02-24 05:00:00 | MSFT | Stock | 410.3 | 410.36 | 410.1 | 410.3 | 2532.0 |
| 2025-02-24 05:30:00 | MSFT | Stock | 410.1 | 410.35 | 410.1 | 410.23 | 1864.0 |
| 2025-02-24 06:00:00 | MSFT | Stock | 410.0 | 410.4 | 409.84 | 410.26 | 4270.0 |
| 2025-02-24 06:30:00 | MSFT | Stock | 410.4 | 410.4 | 410.4 | 410.4 | 1474.0 |
| 2025-02-24 07:00:00 | MSFT | Stock | 410.2 | 410.37 | 408.5 | 408.5 | 16640.0 |
| 2025-02-24 07:30:00 | MSFT | Stock | 408.88 | 409.0 | 408.29 | 408.8 | 15109.0 |
| 2025-02-24 08:00:00 | MSFT | Stock | 409.76 | 410.2371 | 408.21 | 408.52 | 45773.0 |
| 2025-02-24 08:30:00 | MSFT | Stock | 408.64 | 409.9 | 408.4025 | 409.83 | 39627.0 |
| 2025-02-24 09:00:00 | MSFT | Stock | 409.86 | 410.0005 | 408.33 | 408.9896 | 44686.0 |
| 2025-02-24 09:30:00 | MSFT | Stock | 408.51 | 409.37 | 400.17 | 401.41 | 3281823.0 |
| 2025-02-24 10:00:00 | MSFT | Stock | 401.47 | 401.6 | 399.32 | 399.79 | 1921914.0 |
| 2025-02-24 10:30:00 | MSFT | Stock | 399.815 | 403.26 | 399.66 | 403.23 | 1252912.0 |
| 2025-02-24 11:00:00 | MSFT | Stock | 403.29 | 404.39 | 402.67 | 403.26 | 860119.0 |
| 2025-02-24 11:30:00 | MSFT | Stock | 403.27 | 403.9 | 402.5 | 403.155 | 622071.0 |
| 2025-02-24 12:00:00 | MSFT | Stock | 403.15 | 404.545 | 403.07 | 403.95 | 378775.0 |
| 2025-02-24 12:30:00 | MSFT | Stock | 403.96 | 404.66 | 403.73 | 403.9 | 351849.0 |
> showing 50 of 107,963 rows — these rows as CSV