PREVIEW / stock_30min / 2025-01-14
file: by_date/stock_30min/2025/2025-01-14.parquet size: 2.2 MB rows: 106,161 symbols: 580
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-14 04:00:00 | AAPL | Stock | 235.69 | 236.42 | 235.39 | 235.41 | 8600.0 |
| 2025-01-14 04:30:00 | AAPL | Stock | 235.46 | 235.78 | 235.4 | 235.6 | 6843.0 |
| 2025-01-14 05:00:00 | AAPL | Stock | 235.58 | 235.61 | 235.3 | 235.35 | 6265.0 |
| 2025-01-14 05:30:00 | AAPL | Stock | 235.45 | 235.79 | 235.45 | 235.64 | 4538.0 |
| 2025-01-14 06:00:00 | AAPL | Stock | 235.59 | 235.64 | 235.05 | 235.23 | 7286.0 |
| 2025-01-14 06:30:00 | AAPL | Stock | 235.3 | 235.3 | 234.98 | 234.98 | 2606.0 |
| 2025-01-14 07:00:00 | AAPL | Stock | 235.07 | 235.15 | 234.55 | 235.14 | 19396.0 |
| 2025-01-14 07:30:00 | AAPL | Stock | 235.13 | 235.15 | 234.67 | 234.76 | 7060.0 |
| 2025-01-14 08:00:00 | AAPL | Stock | 234.71 | 235.9 | 234.001 | 234.17 | 76186.0 |
| 2025-01-14 08:30:00 | AAPL | Stock | 234.5 | 236.0 | 234.5 | 234.81 | 94463.0 |
| 2025-01-14 09:00:00 | AAPL | Stock | 234.94 | 235.1738 | 234.19 | 234.76 | 62085.0 |
| 2025-01-14 09:30:00 | AAPL | Stock | 234.75 | 236.03 | 234.26 | 234.925 | 3302837.0 |
| 2025-01-14 10:00:00 | AAPL | Stock | 234.937 | 236.12 | 234.76 | 235.61 | 1750755.0 |
| 2025-01-14 10:30:00 | AAPL | Stock | 235.6 | 235.98 | 234.65 | 234.77 | 1591287.0 |
| 2025-01-14 11:00:00 | AAPL | Stock | 234.78 | 234.8822 | 234.13 | 234.21 | 1250628.0 |
| 2025-01-14 11:30:00 | AAPL | Stock | 234.19 | 234.49 | 233.12 | 233.1742 | 1193335.0 |
| 2025-01-14 12:00:00 | AAPL | Stock | 233.165 | 233.57 | 232.845 | 233.325 | 1039902.0 |
| 2025-01-14 12:30:00 | AAPL | Stock | 233.32 | 233.45 | 232.65 | 233.03 | 781182.0 |
| 2025-01-14 13:00:00 | AAPL | Stock | 233.02 | 234.12 | 232.97 | 234.0202 | 833366.0 |
| 2025-01-14 13:30:00 | AAPL | Stock | 234.04 | 234.7731 | 233.72 | 234.695 | 900575.0 |
| 2025-01-14 14:00:00 | AAPL | Stock | 234.71 | 234.92 | 234.235 | 234.2587 | 943317.0 |
| 2025-01-14 14:30:00 | AAPL | Stock | 234.25 | 234.65 | 233.05 | 233.15 | 1415437.0 |
| 2025-01-14 15:00:00 | AAPL | Stock | 233.135 | 233.31 | 232.472 | 233.295 | 1264886.0 |
| 2025-01-14 15:30:00 | AAPL | Stock | 233.28 | 233.44 | 232.54 | 233.28 | 3557048.0 |
| 2025-01-14 16:00:00 | AAPL | Stock | 233.33 | 234.0 | 233.1 | 233.99 | 6497964.0 |
| 2025-01-14 16:30:00 | AAPL | Stock | 233.99 | 234.1777 | 233.28 | 233.85 | 49256.0 |
| 2025-01-14 17:00:00 | AAPL | Stock | 233.98 | 234.05 | 233.28 | 233.28 | 10395.0 |
| 2025-01-14 17:30:00 | AAPL | Stock | 233.76 | 233.76 | 233.34 | 233.4368 | 20098.0 |
| 2025-01-14 18:00:00 | AAPL | Stock | 233.7 | 233.8 | 233.42 | 233.4225 | 5845.0 |
| 2025-01-14 18:30:00 | AAPL | Stock | 233.5 | 233.5 | 233.24 | 233.35 | 7729.0 |
| 2025-01-14 19:00:00 | AAPL | Stock | 233.4 | 233.68 | 233.4 | 233.55 | 15520.0 |
| 2025-01-14 19:30:00 | AAPL | Stock | 233.53 | 233.82 | 233.5 | 233.78 | 6285.0 |
| 2025-01-14 04:00:00 | MSFT | Stock | 419.79 | 420.6 | 419.34 | 419.63 | 13791.0 |
| 2025-01-14 04:30:00 | MSFT | Stock | 419.3 | 419.8 | 419.25 | 419.8 | 700.0 |
| 2025-01-14 05:30:00 | MSFT | Stock | 419.53 | 419.53 | 419.49 | 419.49 | 300.0 |
| 2025-01-14 06:00:00 | MSFT | Stock | 419.53 | 419.65 | 419.0 | 419.19 | 1936.0 |
| 2025-01-14 06:30:00 | MSFT | Stock | 419.13 | 419.19 | 418.6 | 418.65 | 800.0 |
| 2025-01-14 07:00:00 | MSFT | Stock | 418.4 | 418.5 | 417.59 | 418.44 | 3432.0 |
| 2025-01-14 07:30:00 | MSFT | Stock | 418.44 | 418.52 | 418.06 | 418.06 | 2444.0 |
| 2025-01-14 08:00:00 | MSFT | Stock | 418.45 | 419.91 | 417.0 | 417.0 | 23430.0 |
| 2025-01-14 08:30:00 | MSFT | Stock | 417.42 | 420.8 | 417.42 | 418.17 | 26433.0 |
| 2025-01-14 09:00:00 | MSFT | Stock | 418.3 | 418.84 | 417.23 | 417.82 | 20832.0 |
| 2025-01-14 09:30:00 | MSFT | Stock | 417.82 | 419.74 | 416.61 | 416.985 | 1104238.0 |
| 2025-01-14 10:00:00 | MSFT | Stock | 417.015 | 418.41 | 416.72 | 416.9101 | 831112.0 |
| 2025-01-14 10:30:00 | MSFT | Stock | 416.99 | 417.95 | 415.9 | 416.075 | 579298.0 |
| 2025-01-14 11:00:00 | MSFT | Stock | 416.135 | 416.58 | 415.2535 | 415.74 | 352517.0 |
| 2025-01-14 11:30:00 | MSFT | Stock | 415.78 | 416.2599 | 414.3 | 414.395 | 407287.0 |
| 2025-01-14 12:00:00 | MSFT | Stock | 414.395 | 415.6 | 414.1609 | 415.04 | 279264.0 |
| 2025-01-14 12:30:00 | MSFT | Stock | 414.975 | 415.33 | 413.91 | 415.0 | 277698.0 |
| 2025-01-14 13:00:00 | MSFT | Stock | 415.0 | 416.5 | 414.91 | 416.2 | 268350.0 |
> showing 50 of 106,161 rows — these rows as CSV