PREVIEW / stock_30min / 2024-11-18
file: by_date/stock_30min/2024/2024-11-18.parquet size: 2.2 MB rows: 105,377 symbols: 725
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 |
|---|---|---|---|---|---|---|---|
| 2024-11-18 04:00:00 | AAPL | Stock | 226.0 | 226.0 | 224.84 | 224.86 | 3282.0 |
| 2024-11-18 04:30:00 | AAPL | Stock | 225.05 | 225.21 | 224.86 | 225.21 | 1853.0 |
| 2024-11-18 05:00:00 | AAPL | Stock | 225.26 | 225.33 | 225.0 | 225.18 | 4050.0 |
| 2024-11-18 05:30:00 | AAPL | Stock | 225.17 | 225.38 | 225.16 | 225.38 | 2740.0 |
| 2024-11-18 06:00:00 | AAPL | Stock | 225.35 | 225.35 | 225.21 | 225.21 | 523.0 |
| 2024-11-18 06:30:00 | AAPL | Stock | 225.26 | 225.55 | 225.25 | 225.55 | 1255.0 |
| 2024-11-18 07:00:00 | AAPL | Stock | 225.62 | 226.0 | 225.52 | 225.58 | 18305.0 |
| 2024-11-18 07:30:00 | AAPL | Stock | 225.73 | 225.89 | 225.66 | 225.7 | 5026.0 |
| 2024-11-18 08:00:00 | AAPL | Stock | 225.9 | 226.31 | 224.438 | 225.05 | 54613.0 |
| 2024-11-18 08:30:00 | AAPL | Stock | 225.07 | 225.8799 | 225.05 | 225.69 | 19045.0 |
| 2024-11-18 09:00:00 | AAPL | Stock | 225.629 | 225.9844 | 225.01 | 225.15 | 71124.0 |
| 2024-11-18 09:30:00 | AAPL | Stock | 225.22 | 227.2 | 225.17 | 226.82 | 3791997.0 |
| 2024-11-18 10:00:00 | AAPL | Stock | 226.85 | 228.22 | 226.73 | 228.1 | 2188953.0 |
| 2024-11-18 10:30:00 | AAPL | Stock | 228.1 | 228.921 | 228.1 | 228.43 | 1722416.0 |
| 2024-11-18 11:00:00 | AAPL | Stock | 228.41 | 229.21 | 228.36 | 229.065 | 1414084.0 |
| 2024-11-18 11:30:00 | AAPL | Stock | 229.0651 | 229.16 | 228.37 | 228.54 | 953121.0 |
| 2024-11-18 12:00:00 | AAPL | Stock | 228.53 | 228.88 | 228.36 | 228.75 | 664371.0 |
| 2024-11-18 12:30:00 | AAPL | Stock | 228.75 | 229.6188 | 228.635 | 229.602 | 1059666.0 |
| 2024-11-18 13:00:00 | AAPL | Stock | 229.605 | 229.74 | 228.95 | 228.965 | 963396.0 |
| 2024-11-18 13:30:00 | AAPL | Stock | 228.96 | 229.5 | 228.67 | 229.446 | 809166.0 |
| 2024-11-18 14:00:00 | AAPL | Stock | 229.44 | 229.44 | 228.6961 | 228.815 | 698409.0 |
| 2024-11-18 14:30:00 | AAPL | Stock | 228.82 | 229.0803 | 228.72 | 228.855 | 635999.0 |
| 2024-11-18 15:00:00 | AAPL | Stock | 228.85 | 228.92 | 228.0337 | 228.06 | 1067905.0 |
| 2024-11-18 15:30:00 | AAPL | Stock | 228.05 | 228.25 | 227.3 | 227.99 | 2624042.0 |
| 2024-11-18 16:00:00 | AAPL | Stock | 228.02 | 228.22 | 227.9 | 228.18 | 12069936.0 |
| 2024-11-18 16:30:00 | AAPL | Stock | 228.17 | 228.6 | 228.02 | 228.4 | 64872.0 |
| 2024-11-18 17:00:00 | AAPL | Stock | 228.37 | 228.85 | 228.2024 | 228.32 | 37693.0 |
| 2024-11-18 17:30:00 | AAPL | Stock | 228.35 | 228.4 | 228.02 | 228.2412 | 14152.0 |
| 2024-11-18 18:00:00 | AAPL | Stock | 228.2 | 228.2 | 227.42 | 227.7704 | 16412.0 |
| 2024-11-18 18:30:00 | AAPL | Stock | 227.92 | 227.99 | 227.81 | 227.85 | 4325.0 |
| 2024-11-18 19:00:00 | AAPL | Stock | 227.85 | 228.31 | 227.8101 | 228.2 | 5258.0 |
| 2024-11-18 19:30:00 | AAPL | Stock | 228.1 | 228.1 | 227.6862 | 228.06 | 3989.0 |
| 2024-11-18 04:00:00 | MSFT | Stock | 416.7 | 416.7 | 415.01 | 415.3 | 2396.0 |
| 2024-11-18 04:30:00 | MSFT | Stock | 415.28 | 415.6 | 415.28 | 415.42 | 1363.0 |
| 2024-11-18 05:00:00 | MSFT | Stock | 415.56 | 416.04 | 415.55 | 416.04 | 1299.0 |
| 2024-11-18 05:30:00 | MSFT | Stock | 416.0 | 416.41 | 416.0 | 416.41 | 1123.0 |
| 2024-11-18 06:00:00 | MSFT | Stock | 416.39 | 416.4 | 415.71 | 415.71 | 2000.0 |
| 2024-11-18 06:30:00 | MSFT | Stock | 415.75 | 416.3 | 415.75 | 416.29 | 334.0 |
| 2024-11-18 07:00:00 | MSFT | Stock | 416.06 | 416.6 | 415.86 | 416.0 | 7053.0 |
| 2024-11-18 07:30:00 | MSFT | Stock | 416.0 | 416.0 | 415.66 | 415.66 | 2364.0 |
| 2024-11-18 08:00:00 | MSFT | Stock | 416.19 | 417.31 | 414.07 | 414.26 | 19834.0 |
| 2024-11-18 08:30:00 | MSFT | Stock | 414.27 | 416.33 | 414.26 | 415.9051 | 23692.0 |
| 2024-11-18 09:00:00 | MSFT | Stock | 415.66 | 416.0 | 414.02 | 414.05 | 29372.0 |
| 2024-11-18 09:30:00 | MSFT | Stock | 414.87 | 416.3773 | 412.1 | 415.4 | 1654007.0 |
| 2024-11-18 10:00:00 | MSFT | Stock | 415.47 | 417.4699 | 415.02 | 417.435 | 738415.0 |
| 2024-11-18 10:30:00 | MSFT | Stock | 417.4 | 418.4037 | 417.2 | 417.56 | 581176.0 |
| 2024-11-18 11:00:00 | MSFT | Stock | 417.58 | 417.795 | 416.39 | 416.39 | 337415.0 |
| 2024-11-18 11:30:00 | MSFT | Stock | 416.38 | 417.0 | 415.68 | 416.0532 | 308677.0 |
| 2024-11-18 12:00:00 | MSFT | Stock | 416.085 | 416.15 | 414.91 | 415.0471 | 254695.0 |
| 2024-11-18 12:30:00 | MSFT | Stock | 415.075 | 415.68 | 414.7 | 415.68 | 379390.0 |
> showing 50 of 105,377 rows — these rows as CSV