PREVIEW / stock_30min / 2025-01-10
file: by_date/stock_30min/2025/2025-01-10.parquet size: 2.3 MB rows: 111,112 symbols: 594
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-10 04:00:00 | AAPL | Stock | 243.44 | 244.0 | 241.7 | 242.69 | 10015.0 |
| 2025-01-10 04:30:00 | AAPL | Stock | 242.67 | 242.67 | 242.53 | 242.53 | 2440.0 |
| 2025-01-10 05:00:00 | AAPL | Stock | 242.55 | 242.55 | 242.4 | 242.46 | 1944.0 |
| 2025-01-10 05:30:00 | AAPL | Stock | 242.4 | 242.52 | 242.4 | 242.44 | 3092.0 |
| 2025-01-10 06:00:00 | AAPL | Stock | 242.42 | 242.7 | 242.4 | 242.7 | 7518.0 |
| 2025-01-10 06:30:00 | AAPL | Stock | 242.59 | 242.64 | 242.45 | 242.47 | 2681.0 |
| 2025-01-10 07:00:00 | AAPL | Stock | 242.44 | 242.44 | 242.03 | 242.05 | 18281.0 |
| 2025-01-10 07:30:00 | AAPL | Stock | 242.03 | 242.27 | 242.02 | 242.2 | 6674.0 |
| 2025-01-10 08:00:00 | AAPL | Stock | 242.41 | 242.7 | 242.03 | 242.65 | 33997.0 |
| 2025-01-10 08:30:00 | AAPL | Stock | 242.5 | 242.69 | 240.1 | 241.05 | 105580.0 |
| 2025-01-10 09:00:00 | AAPL | Stock | 240.85 | 241.54 | 239.27 | 240.0 | 297288.0 |
| 2025-01-10 09:30:00 | AAPL | Stock | 240.0 | 240.16 | 237.47 | 237.95 | 6244838.0 |
| 2025-01-10 10:00:00 | AAPL | Stock | 237.88 | 237.915 | 235.8 | 237.425 | 3737938.0 |
| 2025-01-10 10:30:00 | AAPL | Stock | 237.4242 | 237.4483 | 235.47 | 235.91 | 2648314.0 |
| 2025-01-10 11:00:00 | AAPL | Stock | 235.92 | 236.58 | 233.5 | 233.77 | 3872706.0 |
| 2025-01-10 11:30:00 | AAPL | Stock | 233.77 | 234.9684 | 233.0 | 234.89 | 3587598.0 |
| 2025-01-10 12:00:00 | AAPL | Stock | 234.9 | 235.9 | 234.82 | 235.56 | 1836523.0 |
| 2025-01-10 12:30:00 | AAPL | Stock | 235.54 | 235.9 | 235.06 | 235.715 | 1373803.0 |
| 2025-01-10 13:00:00 | AAPL | Stock | 235.715 | 237.3397 | 235.64 | 237.115 | 1699852.0 |
| 2025-01-10 13:30:00 | AAPL | Stock | 237.12 | 237.59 | 236.9 | 237.44 | 1287194.0 |
| 2025-01-10 14:00:00 | AAPL | Stock | 237.43 | 237.48 | 236.41 | 236.83 | 1054880.0 |
| 2025-01-10 14:30:00 | AAPL | Stock | 236.84 | 236.88 | 235.94 | 236.3599 | 1004809.0 |
| 2025-01-10 15:00:00 | AAPL | Stock | 236.35 | 236.36 | 235.75 | 235.995 | 1544362.0 |
| 2025-01-10 15:30:00 | AAPL | Stock | 235.995 | 237.29 | 235.77 | 236.93 | 3946938.0 |
| 2025-01-10 16:00:00 | AAPL | Stock | 236.85 | 237.45 | 236.85 | 237.185 | 11296363.0 |
| 2025-01-10 16:30:00 | AAPL | Stock | 237.19 | 237.26 | 236.85 | 237.2 | 110653.0 |
| 2025-01-10 17:00:00 | AAPL | Stock | 237.2 | 237.24 | 237.01 | 237.04 | 8495.0 |
| 2025-01-10 17:30:00 | AAPL | Stock | 237.0326 | 237.1399 | 237.0 | 237.05 | 5856.0 |
| 2025-01-10 18:00:00 | AAPL | Stock | 237.05 | 237.13 | 237.0 | 237.01 | 4166.0 |
| 2025-01-10 18:30:00 | AAPL | Stock | 237.09 | 237.1089 | 237.01 | 237.01 | 2404.0 |
| 2025-01-10 19:00:00 | AAPL | Stock | 236.96 | 237.0 | 236.95 | 236.95 | 5389.0 |
| 2025-01-10 19:30:00 | AAPL | Stock | 237.0 | 237.0399 | 236.95 | 237.02 | 9230.0 |
| 2025-01-10 04:00:00 | MSFT | Stock | 423.6 | 423.6 | 423.08 | 423.25 | 1400.0 |
| 2025-01-10 04:30:00 | MSFT | Stock | 423.25 | 423.52 | 423.23 | 423.5 | 4701.0 |
| 2025-01-10 05:00:00 | MSFT | Stock | 423.56 | 423.95 | 423.56 | 423.95 | 1000.0 |
| 2025-01-10 05:30:00 | MSFT | Stock | 423.88 | 424.06 | 423.74 | 424.0 | 1327.0 |
| 2025-01-10 06:00:00 | MSFT | Stock | 424.12 | 424.26 | 424.11 | 424.25 | 800.0 |
| 2025-01-10 06:30:00 | MSFT | Stock | 424.51 | 424.59 | 424.25 | 424.25 | 3000.0 |
| 2025-01-10 07:00:00 | MSFT | Stock | 424.36 | 424.6 | 423.9 | 424.0 | 6306.0 |
| 2025-01-10 07:30:00 | MSFT | Stock | 424.17 | 424.27 | 424.0 | 424.13 | 2813.0 |
| 2025-01-10 08:00:00 | MSFT | Stock | 423.62 | 425.0 | 423.24 | 424.2 | 14635.0 |
| 2025-01-10 08:30:00 | MSFT | Stock | 424.3 | 424.3 | 420.33 | 420.8805 | 21771.0 |
| 2025-01-10 09:00:00 | MSFT | Stock | 420.85 | 424.88 | 420.81 | 424.63 | 29196.0 |
| 2025-01-10 09:30:00 | MSFT | Stock | 424.63 | 424.71 | 418.63 | 419.69 | 1816850.0 |
| 2025-01-10 10:00:00 | MSFT | Stock | 419.73 | 419.73 | 415.02 | 417.865 | 1478819.0 |
| 2025-01-10 10:30:00 | MSFT | Stock | 417.865 | 419.8899 | 415.03 | 417.96 | 946679.0 |
| 2025-01-10 11:00:00 | MSFT | Stock | 418.03 | 418.25 | 416.1201 | 417.54 | 595651.0 |
| 2025-01-10 11:30:00 | MSFT | Stock | 417.54 | 418.32 | 416.38 | 416.53 | 480025.0 |
| 2025-01-10 12:00:00 | MSFT | Stock | 416.55 | 418.373 | 416.15 | 418.32 | 353022.0 |
| 2025-01-10 12:30:00 | MSFT | Stock | 418.32 | 420.39 | 418.14 | 419.84 | 475017.0 |
> showing 50 of 111,112 rows — these rows as CSV