PREVIEW / stock_30min / 2025-01-15
file: by_date/stock_30min/2025/2025-01-15.parquet size: 2.3 MB rows: 108,154 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-15 04:00:00 | AAPL | Stock | 233.79 | 233.99 | 233.71 | 233.71 | 1288.0 |
| 2025-01-15 04:30:00 | AAPL | Stock | 233.65 | 233.78 | 233.65 | 233.78 | 200.0 |
| 2025-01-15 05:00:00 | AAPL | Stock | 233.67 | 233.9 | 233.63 | 233.74 | 1932.0 |
| 2025-01-15 05:30:00 | AAPL | Stock | 233.77 | 233.91 | 233.75 | 233.91 | 2024.0 |
| 2025-01-15 06:00:00 | AAPL | Stock | 233.94 | 234.19 | 233.94 | 234.18 | 2844.0 |
| 2025-01-15 06:30:00 | AAPL | Stock | 234.19 | 234.6 | 234.19 | 234.51 | 4667.0 |
| 2025-01-15 07:00:00 | AAPL | Stock | 234.42 | 234.51 | 233.88 | 233.88 | 11238.0 |
| 2025-01-15 07:30:00 | AAPL | Stock | 233.87 | 233.9 | 233.75 | 233.75 | 9357.0 |
| 2025-01-15 08:00:00 | AAPL | Stock | 234.3172 | 234.5479 | 233.4 | 233.56 | 44234.0 |
| 2025-01-15 08:30:00 | AAPL | Stock | 233.63 | 236.38 | 233.48 | 235.2 | 170929.0 |
| 2025-01-15 09:00:00 | AAPL | Stock | 235.2499 | 235.25 | 234.11 | 234.73 | 119358.0 |
| 2025-01-15 09:30:00 | AAPL | Stock | 234.73 | 238.121 | 234.43 | 237.35 | 4110320.0 |
| 2025-01-15 10:00:00 | AAPL | Stock | 237.37 | 238.39 | 237.36 | 237.9201 | 2382054.0 |
| 2025-01-15 10:30:00 | AAPL | Stock | 237.96 | 238.34 | 237.45 | 237.975 | 1416521.0 |
| 2025-01-15 11:00:00 | AAPL | Stock | 237.965 | 238.54 | 237.31 | 237.4007 | 1394340.0 |
| 2025-01-15 11:30:00 | AAPL | Stock | 237.4 | 237.4 | 236.5024 | 236.775 | 1334362.0 |
| 2025-01-15 12:00:00 | AAPL | Stock | 236.78 | 237.59 | 236.67 | 237.1199 | 964636.0 |
| 2025-01-15 12:30:00 | AAPL | Stock | 237.115 | 237.74 | 237.115 | 237.19 | 964160.0 |
| 2025-01-15 13:00:00 | AAPL | Stock | 237.2 | 237.54 | 236.97 | 237.53 | 700917.0 |
| 2025-01-15 13:30:00 | AAPL | Stock | 237.53 | 237.7247 | 237.26 | 237.58 | 758575.0 |
| 2025-01-15 14:00:00 | AAPL | Stock | 237.58 | 237.765 | 237.43 | 237.565 | 644660.0 |
| 2025-01-15 14:30:00 | AAPL | Stock | 237.58 | 238.0342 | 237.58 | 237.81 | 913928.0 |
| 2025-01-15 15:00:00 | AAPL | Stock | 237.83 | 237.9134 | 237.52 | 237.6212 | 1212978.0 |
| 2025-01-15 15:30:00 | AAPL | Stock | 237.62 | 238.96 | 237.35 | 237.88 | 3672628.0 |
| 2025-01-15 16:00:00 | AAPL | Stock | 237.84 | 238.09 | 237.7 | 237.97 | 9498242.0 |
| 2025-01-15 16:30:00 | AAPL | Stock | 237.97 | 238.09 | 237.87 | 237.95 | 78731.0 |
| 2025-01-15 17:00:00 | AAPL | Stock | 238.0 | 238.3581 | 237.94 | 238.3 | 8468.0 |
| 2025-01-15 17:30:00 | AAPL | Stock | 238.29 | 238.3173 | 238.0575 | 238.2548 | 3094.0 |
| 2025-01-15 18:00:00 | AAPL | Stock | 238.06 | 238.36 | 238.0 | 238.36 | 5954.0 |
| 2025-01-15 18:30:00 | AAPL | Stock | 238.35 | 238.48 | 238.27 | 238.2735 | 7072.0 |
| 2025-01-15 19:00:00 | AAPL | Stock | 238.41 | 238.52 | 238.38 | 238.51 | 7047.0 |
| 2025-01-15 19:30:00 | AAPL | Stock | 238.55 | 238.71 | 238.3 | 238.5993 | 17189.0 |
| 2025-01-15 04:00:00 | MSFT | Stock | 416.16 | 416.16 | 415.69 | 415.69 | 400.0 |
| 2025-01-15 04:30:00 | MSFT | Stock | 415.71 | 416.74 | 415.71 | 416.28 | 900.0 |
| 2025-01-15 05:00:00 | MSFT | Stock | 416.3 | 416.3 | 416.3 | 416.3 | 100.0 |
| 2025-01-15 06:00:00 | MSFT | Stock | 416.13 | 416.13 | 415.77 | 415.83 | 912.0 |
| 2025-01-15 06:30:00 | MSFT | Stock | 416.2 | 416.91 | 416.2 | 416.91 | 1407.0 |
| 2025-01-15 07:00:00 | MSFT | Stock | 416.59 | 416.89 | 416.36 | 416.52 | 2751.0 |
| 2025-01-15 07:30:00 | MSFT | Stock | 416.47 | 416.71 | 416.47 | 416.7 | 3600.0 |
| 2025-01-15 08:00:00 | MSFT | Stock | 416.68 | 416.7 | 416.0 | 416.7 | 17984.0 |
| 2025-01-15 08:30:00 | MSFT | Stock | 416.8 | 422.0 | 416.8 | 421.15 | 78174.0 |
| 2025-01-15 09:00:00 | MSFT | Stock | 421.1 | 421.4 | 418.91 | 418.96 | 31569.0 |
| 2025-01-15 09:30:00 | MSFT | Stock | 419.13 | 425.3199 | 418.265 | 423.9999 | 1946663.0 |
| 2025-01-15 10:00:00 | MSFT | Stock | 423.875 | 425.51 | 423.68 | 425.275 | 679569.0 |
| 2025-01-15 10:30:00 | MSFT | Stock | 425.31 | 425.605 | 424.74 | 424.805 | 547562.0 |
| 2025-01-15 11:00:00 | MSFT | Stock | 424.81 | 427.42 | 424.81 | 426.285 | 743434.0 |
| 2025-01-15 11:30:00 | MSFT | Stock | 426.22 | 426.306 | 424.6501 | 424.9 | 444929.0 |
| 2025-01-15 12:00:00 | MSFT | Stock | 424.87 | 425.6825 | 424.37 | 425.22 | 301510.0 |
| 2025-01-15 12:30:00 | MSFT | Stock | 425.16 | 426.4499 | 424.66 | 424.7499 | 448470.0 |
| 2025-01-15 13:00:00 | MSFT | Stock | 424.69 | 425.7521 | 424.6 | 425.67 | 292362.0 |
> showing 50 of 108,154 rows — these rows as CSV