PREVIEW / stock_30min / 2025-01-13
file: by_date/stock_30min/2025/2025-01-13.parquet size: 2.3 MB rows: 110,978 symbols: 591
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-13 04:00:00 | AAPL | Stock | 235.0 | 235.0 | 233.77 | 234.0 | 27772.0 |
| 2025-01-13 04:30:00 | AAPL | Stock | 233.9 | 234.2 | 233.82 | 234.2 | 15952.0 |
| 2025-01-13 05:00:00 | AAPL | Stock | 234.23 | 234.25 | 233.76 | 234.04 | 14985.0 |
| 2025-01-13 05:30:00 | AAPL | Stock | 234.2 | 234.94 | 233.98 | 234.1 | 25758.0 |
| 2025-01-13 06:00:00 | AAPL | Stock | 234.21 | 234.76 | 234.0 | 234.55 | 10375.0 |
| 2025-01-13 06:30:00 | AAPL | Stock | 234.45 | 234.57 | 234.32 | 234.35 | 4072.0 |
| 2025-01-13 07:00:00 | AAPL | Stock | 234.25 | 234.49 | 233.33 | 233.79 | 51606.0 |
| 2025-01-13 07:30:00 | AAPL | Stock | 233.79 | 234.97 | 233.79 | 234.55 | 31985.0 |
| 2025-01-13 08:00:00 | AAPL | Stock | 234.22 | 235.98 | 233.3302 | 234.3 | 79262.0 |
| 2025-01-13 08:30:00 | AAPL | Stock | 234.404 | 234.61 | 234.1748 | 234.19 | 49352.0 |
| 2025-01-13 09:00:00 | AAPL | Stock | 234.33 | 234.33 | 232.67 | 233.65 | 146626.0 |
| 2025-01-13 09:30:00 | AAPL | Stock | 233.65 | 233.65 | 230.2 | 230.32 | 7049974.0 |
| 2025-01-13 10:00:00 | AAPL | Stock | 230.325 | 231.32 | 229.72 | 230.38 | 2977568.0 |
| 2025-01-13 10:30:00 | AAPL | Stock | 230.38 | 231.8 | 230.22 | 231.115 | 2645000.0 |
| 2025-01-13 11:00:00 | AAPL | Stock | 231.14 | 231.62 | 230.37 | 230.725 | 1560086.0 |
| 2025-01-13 11:30:00 | AAPL | Stock | 230.725 | 231.72 | 230.46 | 230.6495 | 1409422.0 |
| 2025-01-13 12:00:00 | AAPL | Stock | 230.67 | 232.53 | 230.4 | 232.32 | 1526690.0 |
| 2025-01-13 12:30:00 | AAPL | Stock | 232.29 | 233.235 | 231.98 | 233.1501 | 1209365.0 |
| 2025-01-13 13:00:00 | AAPL | Stock | 233.15 | 233.435 | 232.84 | 233.38 | 1027366.0 |
| 2025-01-13 13:30:00 | AAPL | Stock | 233.38 | 233.9 | 233.25 | 233.88 | 1137867.0 |
| 2025-01-13 14:00:00 | AAPL | Stock | 233.86 | 233.97 | 233.27 | 233.56 | 903456.0 |
| 2025-01-13 14:30:00 | AAPL | Stock | 233.55 | 234.2 | 233.37 | 233.93 | 1004446.0 |
| 2025-01-13 15:00:00 | AAPL | Stock | 233.93 | 233.99 | 233.43 | 233.6844 | 1219412.0 |
| 2025-01-13 15:30:00 | AAPL | Stock | 233.69 | 234.67 | 233.655 | 234.4 | 3645628.0 |
| 2025-01-13 16:00:00 | AAPL | Stock | 234.4 | 235.0 | 234.23 | 234.5 | 7711243.0 |
| 2025-01-13 16:30:00 | AAPL | Stock | 234.53 | 234.63 | 234.4 | 234.56 | 49915.0 |
| 2025-01-13 17:00:00 | AAPL | Stock | 234.56 | 234.6999 | 234.54 | 234.5605 | 9908.0 |
| 2025-01-13 17:30:00 | AAPL | Stock | 234.69 | 234.89 | 234.65 | 234.8583 | 8178.0 |
| 2025-01-13 18:00:00 | AAPL | Stock | 234.86 | 235.07 | 234.86 | 235.07 | 15877.0 |
| 2025-01-13 18:30:00 | AAPL | Stock | 235.14 | 235.47 | 235.14 | 235.43 | 15031.0 |
| 2025-01-13 19:00:00 | AAPL | Stock | 235.33 | 235.56 | 235.27 | 235.4 | 12763.0 |
| 2025-01-13 19:30:00 | AAPL | Stock | 235.4 | 235.49 | 235.22 | 235.45 | 4458.0 |
| 2025-01-13 04:00:00 | MSFT | Stock | 417.0 | 417.0 | 414.44 | 414.44 | 10653.0 |
| 2025-01-13 04:30:00 | MSFT | Stock | 414.22 | 414.54 | 413.6 | 414.54 | 3070.0 |
| 2025-01-13 05:00:00 | MSFT | Stock | 414.43 | 415.89 | 414.43 | 415.78 | 3304.0 |
| 2025-01-13 05:30:00 | MSFT | Stock | 415.9 | 415.9 | 415.24 | 415.42 | 4125.0 |
| 2025-01-13 06:00:00 | MSFT | Stock | 415.3 | 415.69 | 415.25 | 415.62 | 3587.0 |
| 2025-01-13 06:30:00 | MSFT | Stock | 415.46 | 415.46 | 415.27 | 415.33 | 1941.0 |
| 2025-01-13 07:00:00 | MSFT | Stock | 415.99 | 416.86 | 415.6 | 416.51 | 11362.0 |
| 2025-01-13 07:30:00 | MSFT | Stock | 416.37 | 417.39 | 416.25 | 417.36 | 2560.0 |
| 2025-01-13 08:00:00 | MSFT | Stock | 415.75 | 417.54 | 414.0535 | 416.38 | 28629.0 |
| 2025-01-13 08:30:00 | MSFT | Stock | 416.435 | 416.9 | 416.2047 | 416.29 | 6961.0 |
| 2025-01-13 09:00:00 | MSFT | Stock | 416.39 | 416.91 | 414.74 | 415.1 | 32905.0 |
| 2025-01-13 09:30:00 | MSFT | Stock | 415.23 | 418.5 | 414.0307 | 415.0195 | 1398535.0 |
| 2025-01-13 10:00:00 | MSFT | Stock | 415.025 | 416.2 | 413.83 | 414.335 | 640902.0 |
| 2025-01-13 10:30:00 | MSFT | Stock | 414.335 | 416.12 | 414.22 | 414.66 | 493593.0 |
| 2025-01-13 11:00:00 | MSFT | Stock | 414.65 | 415.0072 | 413.301 | 413.5 | 553372.0 |
| 2025-01-13 11:30:00 | MSFT | Stock | 413.44 | 414.5 | 412.29 | 412.7687 | 519808.0 |
| 2025-01-13 12:00:00 | MSFT | Stock | 412.8 | 414.6293 | 412.5658 | 414.225 | 438867.0 |
| 2025-01-13 12:30:00 | MSFT | Stock | 414.225 | 415.63 | 413.86 | 415.5 | 365922.0 |
> showing 50 of 110,978 rows — these rows as CSV