PREVIEW / stock_30min / 2024-10-10
file: by_date/stock_30min/2024/2024-10-10.parquet size: 2.0 MB rows: 96,742 symbols: 765
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-10-10 04:00:00 | AAPL | Stock | 229.4 | 229.4 | 228.94 | 228.95 | 4053.0 |
| 2024-10-10 04:30:00 | AAPL | Stock | 228.94 | 229.03 | 228.76 | 228.83 | 1090.0 |
| 2024-10-10 05:00:00 | AAPL | Stock | 228.84 | 228.93 | 228.84 | 228.86 | 6174.0 |
| 2024-10-10 05:30:00 | AAPL | Stock | 228.93 | 228.93 | 228.36 | 228.66 | 9793.0 |
| 2024-10-10 06:00:00 | AAPL | Stock | 228.68 | 228.68 | 228.53 | 228.55 | 6337.0 |
| 2024-10-10 06:30:00 | AAPL | Stock | 228.65 | 228.75 | 228.48 | 228.49 | 5596.0 |
| 2024-10-10 07:00:00 | AAPL | Stock | 228.57 | 228.7 | 228.47 | 228.65 | 10604.0 |
| 2024-10-10 07:30:00 | AAPL | Stock | 228.7 | 229.0 | 228.7 | 229.0 | 10033.0 |
| 2024-10-10 08:00:00 | AAPL | Stock | 228.6 | 229.1 | 228.49 | 228.95 | 42354.0 |
| 2024-10-10 08:30:00 | AAPL | Stock | 229.01 | 229.1 | 227.75 | 227.8 | 260009.0 |
| 2024-10-10 09:00:00 | AAPL | Stock | 227.82 | 228.0998 | 227.52 | 227.79 | 92924.0 |
| 2024-10-10 09:30:00 | AAPL | Stock | 227.8 | 228.8298 | 227.17 | 228.44 | 3100673.0 |
| 2024-10-10 10:00:00 | AAPL | Stock | 228.44 | 228.57 | 227.6607 | 228.2555 | 1286492.0 |
| 2024-10-10 10:30:00 | AAPL | Stock | 228.2364 | 228.3399 | 227.63 | 227.83 | 1288494.0 |
| 2024-10-10 11:00:00 | AAPL | Stock | 227.85 | 228.396 | 227.69 | 228.29 | 776517.0 |
| 2024-10-10 11:30:00 | AAPL | Stock | 228.29 | 228.66 | 228.14 | 228.655 | 627452.0 |
| 2024-10-10 12:00:00 | AAPL | Stock | 228.66 | 229.24 | 228.62 | 228.71 | 970638.0 |
| 2024-10-10 12:30:00 | AAPL | Stock | 228.725 | 228.7391 | 228.1203 | 228.44 | 698318.0 |
| 2024-10-10 13:00:00 | AAPL | Stock | 228.44 | 228.68 | 228.19 | 228.5 | 569752.0 |
| 2024-10-10 13:30:00 | AAPL | Stock | 228.48 | 228.8 | 228.03 | 228.62 | 737059.0 |
| 2024-10-10 14:00:00 | AAPL | Stock | 228.6499 | 228.6499 | 228.27 | 228.32 | 449886.0 |
| 2024-10-10 14:30:00 | AAPL | Stock | 228.32 | 228.49 | 228.07 | 228.485 | 560561.0 |
| 2024-10-10 15:00:00 | AAPL | Stock | 228.48 | 228.95 | 228.26 | 228.8501 | 789226.0 |
| 2024-10-10 15:30:00 | AAPL | Stock | 228.85 | 229.5 | 228.3 | 229.03 | 2276035.0 |
| 2024-10-10 16:00:00 | AAPL | Stock | 229.04 | 229.24 | 229.02 | 229.21 | 5979162.0 |
| 2024-10-10 16:30:00 | AAPL | Stock | 229.2015 | 229.2015 | 229.04 | 229.1915 | 13056.0 |
| 2024-10-10 17:00:00 | AAPL | Stock | 229.208 | 229.23 | 229.1114 | 229.1799 | 3759.0 |
| 2024-10-10 17:30:00 | AAPL | Stock | 229.1154 | 229.1855 | 229.1025 | 229.12 | 1835.0 |
| 2024-10-10 18:00:00 | AAPL | Stock | 229.15 | 229.25 | 229.11 | 229.124 | 4472.0 |
| 2024-10-10 18:30:00 | AAPL | Stock | 229.18 | 229.2284 | 229.0904 | 229.2284 | 18723.0 |
| 2024-10-10 19:00:00 | AAPL | Stock | 229.2464 | 229.44 | 229.2211 | 229.31 | 7867.0 |
| 2024-10-10 19:30:00 | AAPL | Stock | 229.32 | 229.4383 | 229.2517 | 229.36 | 18215.0 |
| 2024-10-10 04:00:00 | MSFT | Stock | 417.11 | 417.8 | 416.85 | 417.65 | 4671.0 |
| 2024-10-10 04:30:00 | MSFT | Stock | 417.68 | 418.0 | 416.66 | 416.66 | 4476.0 |
| 2024-10-10 05:00:00 | MSFT | Stock | 416.95 | 417.1 | 416.95 | 417.1 | 1198.0 |
| 2024-10-10 05:30:00 | MSFT | Stock | 417.28 | 417.55 | 417.28 | 417.43 | 560.0 |
| 2024-10-10 06:00:00 | MSFT | Stock | 417.67 | 418.79 | 417.67 | 418.38 | 3592.0 |
| 2024-10-10 06:30:00 | MSFT | Stock | 418.21 | 418.79 | 417.99 | 418.15 | 4090.0 |
| 2024-10-10 07:00:00 | MSFT | Stock | 418.01 | 418.01 | 416.95 | 417.46 | 5282.0 |
| 2024-10-10 07:30:00 | MSFT | Stock | 417.35 | 417.46 | 417.29 | 417.29 | 2210.0 |
| 2024-10-10 08:00:00 | MSFT | Stock | 418.0016 | 418.0016 | 416.5338 | 417.3 | 14510.0 |
| 2024-10-10 08:30:00 | MSFT | Stock | 417.46 | 417.46 | 415.2062 | 415.495 | 32714.0 |
| 2024-10-10 09:00:00 | MSFT | Stock | 415.4 | 416.48 | 415.0 | 415.44 | 29548.0 |
| 2024-10-10 09:30:00 | MSFT | Stock | 415.225 | 416.25 | 413.15 | 414.9 | 1309331.0 |
| 2024-10-10 10:00:00 | MSFT | Stock | 414.96 | 415.755 | 414.3 | 415.13 | 484642.0 |
| 2024-10-10 10:30:00 | MSFT | Stock | 415.125 | 415.47 | 413.88 | 414.37 | 537516.0 |
| 2024-10-10 11:00:00 | MSFT | Stock | 414.375 | 416.08 | 414.1 | 416.01 | 393510.0 |
| 2024-10-10 11:30:00 | MSFT | Stock | 415.9696 | 416.95 | 415.41 | 416.9199 | 408306.0 |
| 2024-10-10 12:00:00 | MSFT | Stock | 416.85 | 417.35 | 416.32 | 416.6558 | 411819.0 |
| 2024-10-10 12:30:00 | MSFT | Stock | 416.625 | 416.86 | 415.65 | 415.87 | 273616.0 |
> showing 50 of 96,742 rows — these rows as CSV