PREVIEW / stock_30min / 2025-05-07
file: by_date/stock_30min/2025/2025-05-07.parquet size: 2.1 MB rows: 102,029 symbols: 419
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-05-07 04:00:00 | AAPL | Stock | 201.45 | 201.45 | 200.2 | 200.52 | 23957.0 |
| 2025-05-07 04:30:00 | AAPL | Stock | 200.6 | 200.71 | 200.5 | 200.5 | 7639.0 |
| 2025-05-07 05:00:00 | AAPL | Stock | 200.77 | 200.8 | 200.16 | 200.16 | 14897.0 |
| 2025-05-07 05:30:00 | AAPL | Stock | 200.19 | 200.5 | 200.16 | 200.39 | 9324.0 |
| 2025-05-07 06:00:00 | AAPL | Stock | 200.2 | 200.47 | 200.12 | 200.26 | 11146.0 |
| 2025-05-07 06:30:00 | AAPL | Stock | 200.35 | 200.68 | 200.35 | 200.5 | 7144.0 |
| 2025-05-07 07:00:00 | AAPL | Stock | 200.59 | 201.05 | 200.42 | 200.68 | 25642.0 |
| 2025-05-07 07:30:00 | AAPL | Stock | 200.76 | 200.83 | 200.4 | 200.6 | 15718.0 |
| 2025-05-07 08:00:00 | AAPL | Stock | 200.41 | 201.0199 | 199.88 | 199.88 | 145137.0 |
| 2025-05-07 08:30:00 | AAPL | Stock | 200.0 | 200.3199 | 199.8 | 200.0499 | 44552.0 |
| 2025-05-07 09:00:00 | AAPL | Stock | 200.0 | 200.23 | 199.01 | 199.11 | 136972.0 |
| 2025-05-07 09:30:00 | AAPL | Stock | 199.17 | 199.365 | 197.35 | 197.805 | 4213457.0 |
| 2025-05-07 10:00:00 | AAPL | Stock | 197.805 | 199.44 | 197.75 | 199.22 | 1925387.0 |
| 2025-05-07 10:30:00 | AAPL | Stock | 199.227 | 199.4 | 197.44 | 197.47 | 1934844.0 |
| 2025-05-07 11:00:00 | AAPL | Stock | 197.48 | 197.51 | 193.81 | 194.3507 | 6877213.0 |
| 2025-05-07 11:30:00 | AAPL | Stock | 194.36 | 195.12 | 193.25 | 195.105 | 3785227.0 |
| 2025-05-07 12:00:00 | AAPL | Stock | 195.1 | 195.37 | 194.51 | 194.87 | 2523460.0 |
| 2025-05-07 12:30:00 | AAPL | Stock | 194.85 | 195.78 | 194.575 | 195.621 | 1509242.0 |
| 2025-05-07 13:00:00 | AAPL | Stock | 195.615 | 195.76 | 195.05 | 195.3 | 1132829.0 |
| 2025-05-07 13:30:00 | AAPL | Stock | 195.32 | 195.36 | 194.23 | 194.66 | 1712687.0 |
| 2025-05-07 14:00:00 | AAPL | Stock | 194.615 | 195.13 | 193.3 | 194.01 | 2164476.0 |
| 2025-05-07 14:30:00 | AAPL | Stock | 193.995 | 195.71 | 193.8314 | 195.44 | 1901657.0 |
| 2025-05-07 15:00:00 | AAPL | Stock | 195.44 | 195.46 | 194.12 | 194.32 | 1679345.0 |
| 2025-05-07 15:30:00 | AAPL | Stock | 194.34 | 197.4699 | 194.29 | 196.22 | 4705736.0 |
| 2025-05-07 16:00:00 | AAPL | Stock | 196.25 | 196.41 | 195.75 | 195.85 | 14159619.0 |
| 2025-05-07 16:30:00 | AAPL | Stock | 195.94 | 196.62 | 195.86 | 196.52 | 48794.0 |
| 2025-05-07 17:00:00 | AAPL | Stock | 196.58 | 196.5898 | 196.25 | 196.45 | 38657.0 |
| 2025-05-07 17:30:00 | AAPL | Stock | 196.45 | 196.5 | 196.2 | 196.2499 | 32012.0 |
| 2025-05-07 18:00:00 | AAPL | Stock | 196.2 | 196.39 | 196.06 | 196.35 | 16882.0 |
| 2025-05-07 18:30:00 | AAPL | Stock | 196.33 | 196.3799 | 196.11 | 196.1232 | 14826.0 |
| 2025-05-07 19:00:00 | AAPL | Stock | 196.1206 | 196.48 | 196.1206 | 196.45 | 14171.0 |
| 2025-05-07 19:30:00 | AAPL | Stock | 196.4498 | 196.4971 | 196.3303 | 196.45 | 23555.0 |
| 2025-05-07 04:00:00 | MSFT | Stock | 435.79 | 435.98 | 433.97 | 433.99 | 2229.0 |
| 2025-05-07 04:30:00 | MSFT | Stock | 434.68 | 434.69 | 434.2 | 434.38 | 3875.0 |
| 2025-05-07 05:00:00 | MSFT | Stock | 434.72 | 434.8 | 434.1 | 434.23 | 2557.0 |
| 2025-05-07 05:30:00 | MSFT | Stock | 434.19 | 434.47 | 433.94 | 434.47 | 2507.0 |
| 2025-05-07 06:00:00 | MSFT | Stock | 434.25 | 434.39 | 434.0 | 434.29 | 3913.0 |
| 2025-05-07 06:30:00 | MSFT | Stock | 434.08 | 434.94 | 434.04 | 434.42 | 2471.0 |
| 2025-05-07 07:00:00 | MSFT | Stock | 434.6 | 435.71 | 434.6 | 435.25 | 3777.0 |
| 2025-05-07 07:30:00 | MSFT | Stock | 435.02 | 435.27 | 434.5 | 434.89 | 1397.0 |
| 2025-05-07 08:00:00 | MSFT | Stock | 435.46 | 435.74 | 433.22 | 433.22 | 17691.0 |
| 2025-05-07 08:30:00 | MSFT | Stock | 433.41 | 434.0 | 433.41 | 433.6 | 6234.0 |
| 2025-05-07 09:00:00 | MSFT | Stock | 433.5 | 434.05 | 432.3405 | 434.04 | 14351.0 |
| 2025-05-07 09:30:00 | MSFT | Stock | 434.08 | 435.07 | 432.33 | 434.6 | 1561854.0 |
| 2025-05-07 10:00:00 | MSFT | Stock | 434.68 | 435.71 | 434.04 | 435.32 | 577788.0 |
| 2025-05-07 10:30:00 | MSFT | Stock | 435.37 | 435.52 | 431.1103 | 432.005 | 744899.0 |
| 2025-05-07 11:00:00 | MSFT | Stock | 432.015 | 434.54 | 431.27 | 433.2505 | 929529.0 |
| 2025-05-07 11:30:00 | MSFT | Stock | 433.255 | 434.52 | 432.77 | 433.735 | 372328.0 |
| 2025-05-07 12:00:00 | MSFT | Stock | 433.68 | 434.72 | 433.31 | 434.305 | 359828.0 |
| 2025-05-07 12:30:00 | MSFT | Stock | 434.34 | 436.08 | 434.28 | 435.86 | 283851.0 |
> showing 50 of 102,029 rows — these rows as CSV