PREVIEW / stock_30min / 2024-10-16
file: by_date/stock_30min/2024/2024-10-16.parquet size: 2.1 MB rows: 101,243 symbols: 777
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-10-16 04:00:00 | AAPL | Stock | 234.34 | 234.44 | 234.1 | 234.11 | 8075.0 |
| 2024-10-16 04:30:00 | AAPL | Stock | 234.23 | 234.23 | 234.08 | 234.15 | 1358.0 |
| 2024-10-16 05:00:00 | AAPL | Stock | 234.18 | 234.25 | 234.11 | 234.11 | 1673.0 |
| 2024-10-16 05:30:00 | AAPL | Stock | 234.03 | 234.03 | 233.0 | 233.54 | 6263.0 |
| 2024-10-16 06:00:00 | AAPL | Stock | 233.46 | 233.54 | 233.42 | 233.5 | 2528.0 |
| 2024-10-16 06:30:00 | AAPL | Stock | 233.48 | 233.74 | 233.48 | 233.55 | 2787.0 |
| 2024-10-16 07:00:00 | AAPL | Stock | 233.69 | 234.23 | 233.69 | 234.19 | 9625.0 |
| 2024-10-16 07:30:00 | AAPL | Stock | 234.2 | 234.22 | 233.85 | 233.95 | 11620.0 |
| 2024-10-16 08:00:00 | AAPL | Stock | 233.8 | 234.15 | 232.84 | 233.0 | 97742.0 |
| 2024-10-16 08:30:00 | AAPL | Stock | 232.9513 | 233.02 | 232.84 | 232.91 | 46418.0 |
| 2024-10-16 09:00:00 | AAPL | Stock | 232.91 | 233.23 | 231.4 | 231.7 | 242058.0 |
| 2024-10-16 09:30:00 | AAPL | Stock | 231.71 | 232.12 | 230.03 | 230.08 | 5248445.0 |
| 2024-10-16 10:00:00 | AAPL | Stock | 230.085 | 230.99 | 229.84 | 230.7297 | 2499680.0 |
| 2024-10-16 10:30:00 | AAPL | Stock | 230.71 | 230.77 | 230.05 | 230.3995 | 1560070.0 |
| 2024-10-16 11:00:00 | AAPL | Stock | 230.4 | 231.145 | 230.3401 | 230.585 | 1330009.0 |
| 2024-10-16 11:30:00 | AAPL | Stock | 230.58 | 230.96 | 230.1102 | 230.1988 | 1172332.0 |
| 2024-10-16 12:00:00 | AAPL | Stock | 230.1901 | 230.41 | 230.061 | 230.34 | 1085107.0 |
| 2024-10-16 12:30:00 | AAPL | Stock | 230.345 | 231.07 | 230.315 | 231.035 | 843615.0 |
| 2024-10-16 13:00:00 | AAPL | Stock | 231.05 | 231.29 | 230.723 | 230.9 | 814501.0 |
| 2024-10-16 13:30:00 | AAPL | Stock | 230.91 | 230.99 | 230.58 | 230.805 | 791436.0 |
| 2024-10-16 14:00:00 | AAPL | Stock | 230.8242 | 231.37 | 230.73 | 231.11 | 882127.0 |
| 2024-10-16 14:30:00 | AAPL | Stock | 231.11 | 231.44 | 230.98 | 231.2676 | 748057.0 |
| 2024-10-16 15:00:00 | AAPL | Stock | 231.27 | 231.62 | 231.2 | 231.615 | 936507.0 |
| 2024-10-16 15:30:00 | AAPL | Stock | 231.62 | 231.935 | 231.22 | 231.75 | 2154221.0 |
| 2024-10-16 16:00:00 | AAPL | Stock | 231.75 | 231.79 | 230.8862 | 231.61 | 5073391.0 |
| 2024-10-16 16:30:00 | AAPL | Stock | 231.68 | 231.78 | 231.3 | 231.48 | 45685.0 |
| 2024-10-16 17:00:00 | AAPL | Stock | 231.47 | 231.78 | 231.36 | 231.48 | 95131.0 |
| 2024-10-16 17:30:00 | AAPL | Stock | 231.56 | 231.612 | 231.56 | 231.6 | 2862.0 |
| 2024-10-16 18:00:00 | AAPL | Stock | 231.6 | 231.76 | 231.55 | 231.62 | 2441.0 |
| 2024-10-16 18:30:00 | AAPL | Stock | 231.68 | 231.72 | 231.6 | 231.65 | 4189.0 |
| 2024-10-16 19:00:00 | AAPL | Stock | 231.59 | 231.6 | 231.46 | 231.6 | 1260.0 |
| 2024-10-16 19:30:00 | AAPL | Stock | 231.48 | 231.57 | 231.3 | 231.3605 | 6571.0 |
| 2024-10-16 04:00:00 | MSFT | Stock | 419.77 | 419.77 | 419.0 | 419.02 | 1866.0 |
| 2024-10-16 04:30:00 | MSFT | Stock | 419.0 | 419.25 | 419.0 | 419.15 | 1214.0 |
| 2024-10-16 05:00:00 | MSFT | Stock | 419.38 | 419.44 | 419.38 | 419.44 | 730.0 |
| 2024-10-16 05:30:00 | MSFT | Stock | 419.53 | 419.53 | 419.53 | 419.53 | 100.0 |
| 2024-10-16 06:00:00 | MSFT | Stock | 419.55 | 419.69 | 416.85 | 418.0 | 9256.0 |
| 2024-10-16 06:30:00 | MSFT | Stock | 418.26 | 418.26 | 417.96 | 418.0 | 1106.0 |
| 2024-10-16 07:00:00 | MSFT | Stock | 418.0 | 418.46 | 417.8 | 418.19 | 6884.0 |
| 2024-10-16 07:30:00 | MSFT | Stock | 418.45 | 418.45 | 417.55 | 418.15 | 2889.0 |
| 2024-10-16 08:00:00 | MSFT | Stock | 418.47 | 420.0 | 417.55 | 417.6 | 17347.0 |
| 2024-10-16 08:30:00 | MSFT | Stock | 417.7 | 417.82 | 416.64 | 417.0 | 16380.0 |
| 2024-10-16 09:00:00 | MSFT | Stock | 417.24 | 417.3995 | 414.39 | 415.01 | 57416.0 |
| 2024-10-16 09:30:00 | MSFT | Stock | 415.17 | 415.84 | 410.6408 | 410.93 | 1722381.0 |
| 2024-10-16 10:00:00 | MSFT | Stock | 410.88 | 413.44 | 410.48 | 413.33 | 865361.0 |
| 2024-10-16 10:30:00 | MSFT | Stock | 413.3 | 414.26 | 412.34 | 413.705 | 592572.0 |
| 2024-10-16 11:00:00 | MSFT | Stock | 413.71 | 415.4 | 413.595 | 415.4 | 445139.0 |
| 2024-10-16 11:30:00 | MSFT | Stock | 415.38 | 415.82 | 414.03 | 414.11 | 349711.0 |
| 2024-10-16 12:00:00 | MSFT | Stock | 414.1 | 415.17 | 414.04 | 414.985 | 237860.0 |
| 2024-10-16 12:30:00 | MSFT | Stock | 414.99 | 415.73 | 414.83 | 415.6501 | 220616.0 |
> showing 50 of 101,243 rows — these rows as CSV