PREVIEW / stock_30min / 2025-01-17
file: by_date/stock_30min/2025/2025-01-17.parquet size: 2.2 MB rows: 106,398 symbols: 572
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-17 04:00:00 | AAPL | Stock | 229.02 | 229.73 | 229.01 | 229.58 | 19502.0 |
| 2025-01-17 04:30:00 | AAPL | Stock | 229.54 | 229.79 | 229.54 | 229.75 | 17516.0 |
| 2025-01-17 05:00:00 | AAPL | Stock | 229.81 | 229.81 | 229.28 | 229.39 | 8719.0 |
| 2025-01-17 05:30:00 | AAPL | Stock | 229.3 | 229.42 | 229.01 | 229.36 | 13883.0 |
| 2025-01-17 06:00:00 | AAPL | Stock | 229.36 | 229.96 | 229.06 | 229.9 | 36548.0 |
| 2025-01-17 06:30:00 | AAPL | Stock | 229.94 | 230.45 | 229.87 | 229.87 | 62090.0 |
| 2025-01-17 07:00:00 | AAPL | Stock | 229.87 | 229.99 | 229.4 | 229.9 | 62752.0 |
| 2025-01-17 07:30:00 | AAPL | Stock | 229.94 | 230.28 | 229.9 | 230.06 | 33461.0 |
| 2025-01-17 08:00:00 | AAPL | Stock | 230.0 | 230.56 | 228.76 | 230.53 | 218559.0 |
| 2025-01-17 08:30:00 | AAPL | Stock | 230.55 | 231.32 | 230.55 | 231.1707 | 244716.0 |
| 2025-01-17 09:00:00 | AAPL | Stock | 231.21 | 232.3 | 231.05 | 231.94 | 657767.0 |
| 2025-01-17 09:30:00 | AAPL | Stock | 232.115 | 232.29 | 229.72 | 230.79 | 16087429.0 |
| 2025-01-17 10:00:00 | AAPL | Stock | 230.77 | 231.28 | 230.0 | 230.385 | 2967327.0 |
| 2025-01-17 10:30:00 | AAPL | Stock | 230.4 | 231.65 | 230.35 | 231.33 | 2469745.0 |
| 2025-01-17 11:00:00 | AAPL | Stock | 231.3376 | 231.51 | 230.87 | 231.2813 | 2075127.0 |
| 2025-01-17 11:30:00 | AAPL | Stock | 231.29 | 231.32 | 229.55 | 229.6611 | 2168432.0 |
| 2025-01-17 12:00:00 | AAPL | Stock | 229.66 | 230.3443 | 229.49 | 230.2591 | 1799156.0 |
| 2025-01-17 12:30:00 | AAPL | Stock | 230.27 | 230.44 | 229.89 | 230.16 | 1372306.0 |
| 2025-01-17 13:00:00 | AAPL | Stock | 230.15 | 230.35 | 229.89 | 229.91 | 1198250.0 |
| 2025-01-17 13:30:00 | AAPL | Stock | 229.9102 | 229.95 | 229.12 | 229.28 | 1569259.0 |
| 2025-01-17 14:00:00 | AAPL | Stock | 229.285 | 229.32 | 228.48 | 229.18 | 1851646.0 |
| 2025-01-17 14:30:00 | AAPL | Stock | 229.18 | 229.6088 | 229.17 | 229.2057 | 1382457.0 |
| 2025-01-17 15:00:00 | AAPL | Stock | 229.2 | 229.77 | 229.08 | 229.4401 | 1891946.0 |
| 2025-01-17 15:30:00 | AAPL | Stock | 229.44 | 230.07 | 229.23 | 229.96 | 4122855.0 |
| 2025-01-17 16:00:00 | AAPL | Stock | 229.99 | 230.12 | 229.6037 | 229.88 | 7826806.0 |
| 2025-01-17 16:30:00 | AAPL | Stock | 229.89 | 229.98 | 229.81 | 229.9235 | 71493.0 |
| 2025-01-17 17:00:00 | AAPL | Stock | 229.93 | 230.0485 | 229.92 | 230.0 | 26489.0 |
| 2025-01-17 17:30:00 | AAPL | Stock | 229.94 | 229.9796 | 229.9 | 229.96 | 4454.0 |
| 2025-01-17 18:00:00 | AAPL | Stock | 229.9012 | 229.95 | 229.83 | 229.85 | 8165.0 |
| 2025-01-17 18:30:00 | AAPL | Stock | 229.85 | 229.85 | 229.71 | 229.8226 | 7183.0 |
| 2025-01-17 19:00:00 | AAPL | Stock | 229.8 | 229.98 | 229.3999 | 229.4 | 175841.0 |
| 2025-01-17 19:30:00 | AAPL | Stock | 229.4 | 230.0 | 229.2742 | 229.499 | 29771.0 |
| 2025-01-17 04:00:00 | MSFT | Stock | 425.15 | 426.28 | 425.15 | 426.28 | 6817.0 |
| 2025-01-17 04:30:00 | MSFT | Stock | 426.06 | 426.4 | 425.4 | 426.4 | 1729.0 |
| 2025-01-17 05:00:00 | MSFT | Stock | 426.6 | 426.6 | 425.56 | 425.73 | 2175.0 |
| 2025-01-17 05:30:00 | MSFT | Stock | 425.82 | 425.93 | 425.82 | 425.93 | 982.0 |
| 2025-01-17 06:00:00 | MSFT | Stock | 426.14 | 426.28 | 425.2 | 426.28 | 2054.0 |
| 2025-01-17 06:30:00 | MSFT | Stock | 426.42 | 426.42 | 425.92 | 425.92 | 300.0 |
| 2025-01-17 07:00:00 | MSFT | Stock | 425.51 | 425.95 | 425.51 | 425.8 | 1811.0 |
| 2025-01-17 07:30:00 | MSFT | Stock | 425.8 | 426.0 | 425.67 | 426.0 | 1640.0 |
| 2025-01-17 08:00:00 | MSFT | Stock | 425.3 | 427.75 | 425.1427 | 427.75 | 27456.0 |
| 2025-01-17 08:30:00 | MSFT | Stock | 427.7 | 428.989 | 427.085 | 428.62 | 16242.0 |
| 2025-01-17 09:00:00 | MSFT | Stock | 428.8 | 434.87 | 428.34 | 434.29 | 212685.0 |
| 2025-01-17 09:30:00 | MSFT | Stock | 434.085 | 434.48 | 428.17 | 428.875 | 6216597.0 |
| 2025-01-17 10:00:00 | MSFT | Stock | 428.875 | 430.3626 | 428.33 | 429.185 | 644736.0 |
| 2025-01-17 10:30:00 | MSFT | Stock | 429.22 | 429.6648 | 428.48 | 429.03 | 619492.0 |
| 2025-01-17 11:00:00 | MSFT | Stock | 429.03 | 429.99 | 428.54 | 429.895 | 506187.0 |
| 2025-01-17 11:30:00 | MSFT | Stock | 429.93 | 430.13 | 428.55 | 429.29 | 417211.0 |
| 2025-01-17 12:00:00 | MSFT | Stock | 429.29 | 430.77 | 428.9001 | 430.67 | 360998.0 |
| 2025-01-17 12:30:00 | MSFT | Stock | 430.68 | 432.0 | 430.42 | 431.6982 | 402979.0 |
> showing 50 of 106,398 rows — these rows as CSV