PREVIEW / stock_30min / 2025-08-27
file: by_date/stock_30min/2025/2025-08-27.parquet size: 2.2 MB rows: 104,492 symbols: 325
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-08-27 04:00:00 | AAPL | Stock | 229.67 | 229.73 | 229.52 | 229.52 | 4522.0 |
| 2025-08-27 04:30:00 | AAPL | Stock | 229.41 | 229.55 | 229.33 | 229.4 | 3299.0 |
| 2025-08-27 05:00:00 | AAPL | Stock | 229.58 | 229.6 | 229.4 | 229.4 | 2317.0 |
| 2025-08-27 05:30:00 | AAPL | Stock | 229.44 | 229.44 | 229.2 | 229.34 | 2284.0 |
| 2025-08-27 06:00:00 | AAPL | Stock | 229.22 | 229.26 | 229.18 | 229.2 | 3131.0 |
| 2025-08-27 06:30:00 | AAPL | Stock | 229.32 | 229.35 | 229.14 | 229.35 | 2378.0 |
| 2025-08-27 07:00:00 | AAPL | Stock | 229.38 | 229.45 | 229.35 | 229.41 | 2777.0 |
| 2025-08-27 07:30:00 | AAPL | Stock | 229.49 | 229.52 | 229.32 | 229.35 | 4976.0 |
| 2025-08-27 08:00:00 | AAPL | Stock | 229.41 | 230.12 | 229.18 | 229.25 | 41085.0 |
| 2025-08-27 08:30:00 | AAPL | Stock | 229.2173 | 229.29 | 228.49 | 229.2015 | 41741.0 |
| 2025-08-27 09:00:00 | AAPL | Stock | 229.3 | 229.5 | 228.45 | 228.69 | 66389.0 |
| 2025-08-27 09:30:00 | AAPL | Stock | 228.69 | 230.25 | 228.26 | 229.795 | 3728150.0 |
| 2025-08-27 10:00:00 | AAPL | Stock | 229.755 | 230.093 | 229.29 | 230.015 | 2078265.0 |
| 2025-08-27 10:30:00 | AAPL | Stock | 230.02 | 230.71 | 229.82 | 230.18 | 2122718.0 |
| 2025-08-27 11:00:00 | AAPL | Stock | 230.18 | 230.34 | 229.48 | 229.5741 | 1191245.0 |
| 2025-08-27 11:30:00 | AAPL | Stock | 229.57 | 230.06 | 229.3 | 229.915 | 1151728.0 |
| 2025-08-27 12:00:00 | AAPL | Stock | 229.92 | 230.088 | 229.68 | 229.89 | 695474.0 |
| 2025-08-27 12:30:00 | AAPL | Stock | 229.89 | 229.9882 | 229.6 | 229.78 | 692230.0 |
| 2025-08-27 13:00:00 | AAPL | Stock | 229.77 | 230.09 | 229.67 | 229.84 | 683922.0 |
| 2025-08-27 13:30:00 | AAPL | Stock | 229.85 | 230.075 | 229.8 | 229.99 | 627416.0 |
| 2025-08-27 14:00:00 | AAPL | Stock | 229.98 | 230.68 | 229.89 | 230.625 | 1099640.0 |
| 2025-08-27 14:30:00 | AAPL | Stock | 230.62 | 230.635 | 230.08 | 230.15 | 775685.0 |
| 2025-08-27 15:00:00 | AAPL | Stock | 230.155 | 230.16 | 229.72 | 230.1325 | 890562.0 |
| 2025-08-27 15:30:00 | AAPL | Stock | 230.125 | 230.9 | 230.12 | 230.5 | 2544441.0 |
| 2025-08-27 16:00:00 | AAPL | Stock | 230.45 | 230.99 | 230.0 | 230.6 | 4105854.0 |
| 2025-08-27 16:30:00 | AAPL | Stock | 230.63 | 231.36 | 230.35 | 231.28 | 89367.0 |
| 2025-08-27 17:00:00 | AAPL | Stock | 231.3 | 231.36 | 231.01 | 231.2 | 20386.0 |
| 2025-08-27 17:30:00 | AAPL | Stock | 231.0581 | 231.15 | 231.03 | 231.11 | 10259.0 |
| 2025-08-27 18:00:00 | AAPL | Stock | 231.1399 | 231.1399 | 230.51 | 230.66 | 23507.0 |
| 2025-08-27 18:30:00 | AAPL | Stock | 230.83 | 230.9988 | 230.75 | 230.85 | 10120.0 |
| 2025-08-27 19:00:00 | AAPL | Stock | 230.8992 | 230.9 | 230.8 | 230.84 | 7142.0 |
| 2025-08-27 19:30:00 | AAPL | Stock | 230.761 | 230.829 | 230.51 | 230.5493 | 17251.0 |
| 2025-08-27 04:00:00 | MSFT | Stock | 502.26 | 502.51 | 502.26 | 502.3 | 805.0 |
| 2025-08-27 04:30:00 | MSFT | Stock | 502.49 | 502.49 | 502.1 | 502.12 | 300.0 |
| 2025-08-27 05:00:00 | MSFT | Stock | 502.6 | 503.06 | 502.6 | 503.06 | 2400.0 |
| 2025-08-27 06:00:00 | MSFT | Stock | 502.85 | 502.85 | 502.85 | 502.85 | 100.0 |
| 2025-08-27 06:30:00 | MSFT | Stock | 503.1 | 503.1 | 503.1 | 503.1 | 199.0 |
| 2025-08-27 07:00:00 | MSFT | Stock | 502.73 | 503.25 | 502.7 | 503.25 | 2703.0 |
| 2025-08-27 07:30:00 | MSFT | Stock | 503.2 | 504.0 | 503.2 | 504.0 | 2663.0 |
| 2025-08-27 08:00:00 | MSFT | Stock | 502.9 | 504.3 | 502.1 | 503.9696 | 24916.0 |
| 2025-08-27 08:30:00 | MSFT | Stock | 503.7 | 504.05 | 503.1001 | 504.0 | 13003.0 |
| 2025-08-27 09:00:00 | MSFT | Stock | 504.0999 | 504.15 | 501.22 | 501.51 | 28622.0 |
| 2025-08-27 09:30:00 | MSFT | Stock | 502.0 | 503.57 | 499.9 | 500.265 | 1134076.0 |
| 2025-08-27 10:00:00 | MSFT | Stock | 500.265 | 504.14 | 500.17 | 504.14 | 747813.0 |
| 2025-08-27 10:30:00 | MSFT | Stock | 504.115 | 505.12 | 503.7862 | 503.93 | 768902.0 |
| 2025-08-27 11:00:00 | MSFT | Stock | 503.96 | 504.5649 | 503.475 | 504.5 | 482430.0 |
| 2025-08-27 11:30:00 | MSFT | Stock | 504.52 | 504.85 | 503.715 | 504.61 | 412577.0 |
| 2025-08-27 12:00:00 | MSFT | Stock | 504.64 | 504.705 | 503.455 | 504.06 | 281339.0 |
| 2025-08-27 12:30:00 | MSFT | Stock | 504.06 | 505.58 | 503.995 | 505.03 | 356176.0 |
| 2025-08-27 13:00:00 | MSFT | Stock | 505.06 | 505.645 | 504.895 | 505.39 | 284238.0 |
> showing 50 of 104,492 rows — these rows as CSV