PREVIEW / stock_30min / 2024-01-12
file: by_date/stock_30min/2024/2024-01-12.parquet size: 2.0 MB rows: 97,792 symbols: 1,171
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-01-12 04:00:00 | AAPL | Stock | 185.27 | 185.77 | 185.27 | 185.66 | 4681.0 |
| 2024-01-12 04:30:00 | AAPL | Stock | 185.66 | 185.8 | 185.55 | 185.55 | 10621.0 |
| 2024-01-12 05:00:00 | AAPL | Stock | 185.51 | 185.61 | 185.5 | 185.52 | 3641.0 |
| 2024-01-12 05:30:00 | AAPL | Stock | 185.5 | 185.5 | 185.11 | 185.26 | 1556.0 |
| 2024-01-12 06:00:00 | AAPL | Stock | 185.25 | 185.26 | 184.95 | 185.17 | 11038.0 |
| 2024-01-12 06:30:00 | AAPL | Stock | 185.09 | 185.09 | 184.5 | 184.75 | 6724.0 |
| 2024-01-12 07:00:00 | AAPL | Stock | 184.75 | 185.07 | 184.65 | 185.07 | 12576.0 |
| 2024-01-12 07:30:00 | AAPL | Stock | 185.07 | 185.3 | 185.07 | 185.15 | 29399.0 |
| 2024-01-12 08:00:00 | AAPL | Stock | 184.82 | 185.55 | 184.75 | 185.1 | 69985.0 |
| 2024-01-12 08:30:00 | AAPL | Stock | 185.13 | 185.73 | 185.13 | 185.49 | 46615.0 |
| 2024-01-12 09:00:00 | AAPL | Stock | 185.45 | 186.2 | 185.4 | 186.11 | 91830.0 |
| 2024-01-12 09:30:00 | AAPL | Stock | 186.05 | 186.74 | 185.73 | 185.75 | 4111113.0 |
| 2024-01-12 10:00:00 | AAPL | Stock | 185.77 | 186.305 | 185.485 | 185.79 | 2454647.0 |
| 2024-01-12 10:30:00 | AAPL | Stock | 185.8 | 186.0 | 185.19 | 185.695 | 2065098.0 |
| 2024-01-12 11:00:00 | AAPL | Stock | 185.705 | 186.06 | 185.52 | 185.875 | 1864589.0 |
| 2024-01-12 11:30:00 | AAPL | Stock | 185.875 | 185.925 | 185.39 | 185.5724 | 1748758.0 |
| 2024-01-12 12:00:00 | AAPL | Stock | 185.57 | 185.85 | 185.44 | 185.62 | 1248231.0 |
| 2024-01-12 12:30:00 | AAPL | Stock | 185.615 | 185.79 | 185.43 | 185.6228 | 996416.0 |
| 2024-01-12 13:00:00 | AAPL | Stock | 185.63 | 185.84 | 185.5802 | 185.7938 | 929523.0 |
| 2024-01-12 13:30:00 | AAPL | Stock | 185.8 | 185.94 | 185.7688 | 185.89 | 1014995.0 |
| 2024-01-12 14:00:00 | AAPL | Stock | 185.895 | 186.0669 | 185.6 | 185.61 | 1300792.0 |
| 2024-01-12 14:30:00 | AAPL | Stock | 185.6033 | 185.61 | 185.26 | 185.315 | 1830224.0 |
| 2024-01-12 15:00:00 | AAPL | Stock | 185.31 | 185.55 | 185.22 | 185.515 | 1421771.0 |
| 2024-01-12 15:30:00 | AAPL | Stock | 185.52 | 185.98 | 185.4659 | 185.92 | 4059733.0 |
| 2024-01-12 16:00:00 | AAPL | Stock | 185.91 | 185.99 | 185.7369 | 185.92 | 7274393.0 |
| 2024-01-12 16:30:00 | AAPL | Stock | 185.86 | 185.92 | 185.75 | 185.85 | 25478.0 |
| 2024-01-12 17:00:00 | AAPL | Stock | 185.82 | 185.92 | 185.8 | 185.83 | 196686.0 |
| 2024-01-12 17:30:00 | AAPL | Stock | 185.78 | 185.81 | 185.64 | 185.8 | 10716.0 |
| 2024-01-12 18:00:00 | AAPL | Stock | 185.8 | 185.8 | 185.7245 | 185.7245 | 1579.0 |
| 2024-01-12 18:30:00 | AAPL | Stock | 185.73 | 185.74 | 185.66 | 185.66 | 4054.0 |
| 2024-01-12 19:00:00 | AAPL | Stock | 185.7 | 185.7 | 185.65 | 185.69 | 11794.0 |
| 2024-01-12 19:30:00 | AAPL | Stock | 185.69 | 185.69 | 185.59 | 185.63 | 10422.0 |
| 2024-01-12 04:00:00 | MSFT | Stock | 383.23 | 384.67 | 383.23 | 384.67 | 1012.0 |
| 2024-01-12 04:30:00 | MSFT | Stock | 383.9 | 384.09 | 383.53 | 383.63 | 1650.0 |
| 2024-01-12 05:00:00 | MSFT | Stock | 383.3 | 383.9 | 383.3 | 383.8 | 723.0 |
| 2024-01-12 05:30:00 | MSFT | Stock | 383.66 | 383.74 | 383.4 | 383.74 | 1376.0 |
| 2024-01-12 06:00:00 | MSFT | Stock | 383.94 | 383.94 | 383.3 | 383.3 | 1336.0 |
| 2024-01-12 06:30:00 | MSFT | Stock | 383.37 | 383.5 | 382.52 | 382.9 | 1437.0 |
| 2024-01-12 07:00:00 | MSFT | Stock | 383.2 | 383.65 | 383.2 | 383.49 | 6430.0 |
| 2024-01-12 07:30:00 | MSFT | Stock | 383.68 | 383.8 | 383.54 | 383.63 | 3872.0 |
| 2024-01-12 08:00:00 | MSFT | Stock | 383.1 | 384.22 | 383.01 | 383.72 | 21133.0 |
| 2024-01-12 08:30:00 | MSFT | Stock | 383.96 | 385.5 | 383.96 | 385.35 | 46113.0 |
| 2024-01-12 09:00:00 | MSFT | Stock | 385.33 | 385.49 | 384.63 | 385.42 | 130653.0 |
| 2024-01-12 09:30:00 | MSFT | Stock | 385.45 | 387.1847 | 384.98 | 385.3 | 1929120.0 |
| 2024-01-12 10:00:00 | MSFT | Stock | 385.305 | 386.34 | 384.65 | 385.83 | 1146487.0 |
| 2024-01-12 10:30:00 | MSFT | Stock | 385.85 | 387.01 | 385.77 | 387.0083 | 995760.0 |
| 2024-01-12 11:00:00 | MSFT | Stock | 387.0 | 388.48 | 386.9 | 387.86 | 1187596.0 |
| 2024-01-12 11:30:00 | MSFT | Stock | 387.87 | 388.0299 | 386.31 | 386.42 | 740509.0 |
| 2024-01-12 12:00:00 | MSFT | Stock | 386.45 | 387.21 | 386.1353 | 386.8 | 528332.0 |
| 2024-01-12 12:30:00 | MSFT | Stock | 386.795 | 387.48 | 386.4628 | 387.264 | 449442.0 |
> showing 50 of 97,792 rows — these rows as CSV