PREVIEW / stock_30min / 2025-04-16
file: by_date/stock_30min/2025/2025-04-16.parquet size: 2.1 MB rows: 101,428 symbols: 428
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-04-16 04:00:00 | AAPL | Stock | 198.8 | 200.1 | 197.03 | 199.31 | 40144.0 |
| 2025-04-16 04:30:00 | AAPL | Stock | 199.6 | 202.46 | 199.5 | 200.3 | 50226.0 |
| 2025-04-16 05:00:00 | AAPL | Stock | 200.5 | 200.86 | 200.39 | 200.72 | 10905.0 |
| 2025-04-16 05:30:00 | AAPL | Stock | 200.49 | 200.6 | 199.81 | 199.81 | 7086.0 |
| 2025-04-16 06:00:00 | AAPL | Stock | 199.94 | 200.6 | 199.94 | 200.36 | 8585.0 |
| 2025-04-16 06:30:00 | AAPL | Stock | 200.31 | 200.5 | 199.97 | 200.31 | 8405.0 |
| 2025-04-16 07:00:00 | AAPL | Stock | 200.39 | 200.65 | 199.86 | 200.49 | 32899.0 |
| 2025-04-16 07:30:00 | AAPL | Stock | 200.52 | 200.64 | 200.11 | 200.14 | 17796.0 |
| 2025-04-16 08:00:00 | AAPL | Stock | 200.34 | 200.62 | 197.58 | 200.14 | 130610.0 |
| 2025-04-16 08:30:00 | AAPL | Stock | 200.2 | 200.2188 | 199.4 | 199.4 | 65177.0 |
| 2025-04-16 09:00:00 | AAPL | Stock | 199.33 | 199.4957 | 197.89 | 198.2905 | 183331.0 |
| 2025-04-16 09:30:00 | AAPL | Stock | 198.36 | 200.7 | 196.27 | 196.56 | 6645643.0 |
| 2025-04-16 10:00:00 | AAPL | Stock | 196.55 | 197.44 | 196.0 | 197.07 | 3495797.0 |
| 2025-04-16 10:30:00 | AAPL | Stock | 197.06 | 198.45 | 196.81 | 197.58 | 2733581.0 |
| 2025-04-16 11:00:00 | AAPL | Stock | 197.58 | 199.0 | 197.1 | 198.3501 | 2133512.0 |
| 2025-04-16 11:30:00 | AAPL | Stock | 198.375 | 198.4 | 196.71 | 196.75 | 1596565.0 |
| 2025-04-16 12:00:00 | AAPL | Stock | 196.755 | 197.0 | 196.3905 | 196.91 | 1508465.0 |
| 2025-04-16 12:30:00 | AAPL | Stock | 196.91 | 197.36 | 196.65 | 197.2127 | 1145878.0 |
| 2025-04-16 13:00:00 | AAPL | Stock | 197.225 | 197.92 | 197.04 | 197.76 | 1312385.0 |
| 2025-04-16 13:30:00 | AAPL | Stock | 197.76 | 197.81 | 193.92 | 193.985 | 3678965.0 |
| 2025-04-16 14:00:00 | AAPL | Stock | 193.985 | 195.4 | 193.93 | 194.555 | 2293227.0 |
| 2025-04-16 14:30:00 | AAPL | Stock | 194.54 | 194.6437 | 193.3 | 193.34 | 1813184.0 |
| 2025-04-16 15:00:00 | AAPL | Stock | 193.33 | 193.5797 | 192.37 | 192.57 | 2460548.0 |
| 2025-04-16 15:30:00 | AAPL | Stock | 192.58 | 194.8635 | 192.57 | 194.3 | 5189379.0 |
| 2025-04-16 16:00:00 | AAPL | Stock | 194.3 | 195.0 | 194.18 | 194.8 | 8905495.0 |
| 2025-04-16 16:30:00 | AAPL | Stock | 194.8487 | 195.13 | 194.02 | 194.56 | 275460.0 |
| 2025-04-16 17:00:00 | AAPL | Stock | 194.45 | 195.14 | 194.45 | 195.05 | 33872.0 |
| 2025-04-16 17:30:00 | AAPL | Stock | 194.9 | 195.11 | 194.27 | 194.99 | 19692.0 |
| 2025-04-16 18:00:00 | AAPL | Stock | 194.87 | 195.15 | 194.6 | 194.89 | 8732.0 |
| 2025-04-16 18:30:00 | AAPL | Stock | 194.8 | 195.0 | 194.7678 | 194.8033 | 5850.0 |
| 2025-04-16 19:00:00 | AAPL | Stock | 194.97 | 195.12 | 194.51 | 195.0064 | 10233.0 |
| 2025-04-16 19:30:00 | AAPL | Stock | 195.09 | 195.19 | 194.55 | 194.94 | 17821.0 |
| 2025-04-16 04:00:00 | MSFT | Stock | 381.04 | 381.65 | 380.23 | 381.65 | 791.0 |
| 2025-04-16 04:30:00 | MSFT | Stock | 383.24 | 385.0 | 383.0 | 383.33 | 2919.0 |
| 2025-04-16 05:00:00 | MSFT | Stock | 383.74 | 383.74 | 383.72 | 383.72 | 200.0 |
| 2025-04-16 05:30:00 | MSFT | Stock | 383.98 | 384.16 | 382.98 | 383.62 | 4754.0 |
| 2025-04-16 06:00:00 | MSFT | Stock | 383.29 | 383.62 | 383.29 | 383.43 | 600.0 |
| 2025-04-16 06:30:00 | MSFT | Stock | 383.24 | 383.24 | 382.57 | 382.61 | 1641.0 |
| 2025-04-16 07:00:00 | MSFT | Stock | 382.12 | 382.51 | 381.79 | 382.2 | 2030.0 |
| 2025-04-16 07:30:00 | MSFT | Stock | 382.99 | 383.0 | 382.69 | 382.7 | 626.0 |
| 2025-04-16 08:00:00 | MSFT | Stock | 383.0 | 384.17 | 379.44 | 383.11 | 9026.0 |
| 2025-04-16 08:30:00 | MSFT | Stock | 383.0135 | 383.0135 | 381.11 | 381.15 | 14580.0 |
| 2025-04-16 09:00:00 | MSFT | Stock | 381.0 | 382.0 | 379.58 | 380.34 | 18694.0 |
| 2025-04-16 09:30:00 | MSFT | Stock | 380.66 | 381.61 | 376.05 | 376.16 | 1676928.0 |
| 2025-04-16 10:00:00 | MSFT | Stock | 376.2 | 378.93 | 375.9 | 378.635 | 571247.0 |
| 2025-04-16 10:30:00 | MSFT | Stock | 378.63 | 379.31 | 377.75 | 378.39 | 527299.0 |
| 2025-04-16 11:00:00 | MSFT | Stock | 378.435 | 380.11 | 377.8357 | 379.63 | 565758.0 |
| 2025-04-16 11:30:00 | MSFT | Stock | 379.69 | 379.69 | 376.61 | 376.74 | 467214.0 |
| 2025-04-16 12:00:00 | MSFT | Stock | 376.74 | 377.79 | 376.43 | 377.355 | 428982.0 |
| 2025-04-16 12:30:00 | MSFT | Stock | 377.3 | 377.76 | 376.84 | 377.295 | 279278.0 |
> showing 50 of 101,428 rows — these rows as CSV