PREVIEW / stock_30min / 2025-05-06
file: by_date/stock_30min/2025/2025-05-06.parquet size: 2.1 MB rows: 103,567 symbols: 422
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-06 04:00:00 | AAPL | Stock | 198.65 | 198.65 | 197.48 | 197.64 | 21511.0 |
| 2025-05-06 04:30:00 | AAPL | Stock | 197.63 | 197.9 | 197.5 | 197.84 | 7962.0 |
| 2025-05-06 05:00:00 | AAPL | Stock | 197.8 | 197.8 | 197.33 | 197.49 | 10785.0 |
| 2025-05-06 05:30:00 | AAPL | Stock | 197.5 | 197.58 | 197.3 | 197.53 | 5582.0 |
| 2025-05-06 06:00:00 | AAPL | Stock | 197.57 | 197.76 | 197.55 | 197.6 | 13784.0 |
| 2025-05-06 06:30:00 | AAPL | Stock | 197.68 | 197.93 | 197.67 | 197.8 | 1652.0 |
| 2025-05-06 07:00:00 | AAPL | Stock | 197.99 | 198.21 | 197.71 | 197.83 | 29953.0 |
| 2025-05-06 07:30:00 | AAPL | Stock | 197.84 | 198.06 | 197.3 | 197.74 | 20974.0 |
| 2025-05-06 08:00:00 | AAPL | Stock | 197.59 | 198.93 | 197.3 | 197.64 | 67407.0 |
| 2025-05-06 08:30:00 | AAPL | Stock | 197.6507 | 197.9787 | 197.4 | 197.75 | 37637.0 |
| 2025-05-06 09:00:00 | AAPL | Stock | 197.7899 | 198.6 | 197.0506 | 198.24 | 180067.0 |
| 2025-05-06 09:30:00 | AAPL | Stock | 198.17 | 199.88 | 197.02 | 197.65 | 5547911.0 |
| 2025-05-06 10:00:00 | AAPL | Stock | 197.655 | 199.51 | 197.655 | 198.91 | 2867017.0 |
| 2025-05-06 10:30:00 | AAPL | Stock | 198.9 | 199.13 | 197.85 | 198.3 | 2148333.0 |
| 2025-05-06 11:00:00 | AAPL | Stock | 198.2715 | 199.08 | 197.95 | 199.035 | 1950561.0 |
| 2025-05-06 11:30:00 | AAPL | Stock | 199.035 | 199.45 | 198.66 | 198.805 | 1557447.0 |
| 2025-05-06 12:00:00 | AAPL | Stock | 198.83 | 200.65 | 198.705 | 198.98 | 2130893.0 |
| 2025-05-06 12:30:00 | AAPL | Stock | 198.975 | 199.96 | 198.96 | 199.505 | 1238689.0 |
| 2025-05-06 13:00:00 | AAPL | Stock | 199.52 | 200.03 | 199.0 | 199.425 | 1199602.0 |
| 2025-05-06 13:30:00 | AAPL | Stock | 199.44 | 199.8227 | 198.69 | 199.01 | 1176408.0 |
| 2025-05-06 14:00:00 | AAPL | Stock | 199.03 | 199.57 | 198.8 | 199.305 | 1020020.0 |
| 2025-05-06 14:30:00 | AAPL | Stock | 199.295 | 199.85 | 199.02 | 199.85 | 1302569.0 |
| 2025-05-06 15:00:00 | AAPL | Stock | 199.84 | 199.85 | 199.2204 | 199.7084 | 1242559.0 |
| 2025-05-06 15:30:00 | AAPL | Stock | 199.73 | 200.17 | 198.37 | 198.41 | 3431161.0 |
| 2025-05-06 16:00:00 | AAPL | Stock | 198.41 | 199.13 | 197.74 | 197.78 | 6778971.0 |
| 2025-05-06 16:30:00 | AAPL | Stock | 197.8 | 198.51 | 197.5 | 198.2 | 55330.0 |
| 2025-05-06 17:00:00 | AAPL | Stock | 198.0647 | 198.29 | 197.5595 | 198.1 | 39555.0 |
| 2025-05-06 17:30:00 | AAPL | Stock | 198.2 | 198.25 | 197.8 | 197.8 | 17481.0 |
| 2025-05-06 18:00:00 | AAPL | Stock | 197.96 | 201.47 | 197.96 | 201.14 | 326185.0 |
| 2025-05-06 18:30:00 | AAPL | Stock | 201.15 | 201.5 | 200.4137 | 201.37 | 121452.0 |
| 2025-05-06 19:00:00 | AAPL | Stock | 201.38 | 201.5 | 200.9 | 201.11 | 63059.0 |
| 2025-05-06 19:30:00 | AAPL | Stock | 201.3 | 201.3335 | 201.05 | 201.15 | 48851.0 |
| 2025-05-06 04:00:00 | MSFT | Stock | 432.79 | 433.62 | 431.16 | 431.16 | 10285.0 |
| 2025-05-06 04:30:00 | MSFT | Stock | 431.67 | 432.65 | 431.67 | 432.03 | 841.0 |
| 2025-05-06 05:00:00 | MSFT | Stock | 431.9 | 432.12 | 431.82 | 432.11 | 3643.0 |
| 2025-05-06 05:30:00 | MSFT | Stock | 432.2 | 433.0 | 431.91 | 433.0 | 7147.0 |
| 2025-05-06 06:00:00 | MSFT | Stock | 433.1 | 433.1 | 432.8 | 432.92 | 2205.0 |
| 2025-05-06 06:30:00 | MSFT | Stock | 433.65 | 433.65 | 433.18 | 433.18 | 300.0 |
| 2025-05-06 07:00:00 | MSFT | Stock | 433.94 | 434.5 | 433.03 | 433.08 | 4722.0 |
| 2025-05-06 07:30:00 | MSFT | Stock | 433.11 | 433.47 | 432.0 | 432.32 | 5481.0 |
| 2025-05-06 08:00:00 | MSFT | Stock | 432.0 | 435.0 | 432.0 | 432.77 | 20882.0 |
| 2025-05-06 08:30:00 | MSFT | Stock | 432.8799 | 433.7 | 432.65 | 433.6 | 8970.0 |
| 2025-05-06 09:00:00 | MSFT | Stock | 433.45 | 433.6 | 430.92 | 432.34 | 35515.0 |
| 2025-05-06 09:30:00 | MSFT | Stock | 432.08 | 435.13 | 431.17 | 433.5375 | 1469687.0 |
| 2025-05-06 10:00:00 | MSFT | Stock | 433.51 | 434.92 | 432.73 | 434.85 | 867359.0 |
| 2025-05-06 10:30:00 | MSFT | Stock | 434.89 | 436.19 | 434.6 | 435.665 | 554207.0 |
| 2025-05-06 11:00:00 | MSFT | Stock | 435.63 | 436.4494 | 435.36 | 436.34 | 363504.0 |
| 2025-05-06 11:30:00 | MSFT | Stock | 436.3125 | 436.75 | 435.51 | 435.88 | 316510.0 |
| 2025-05-06 12:00:00 | MSFT | Stock | 435.89 | 437.73 | 435.07 | 435.9652 | 413396.0 |
| 2025-05-06 12:30:00 | MSFT | Stock | 435.96 | 436.88 | 435.55 | 435.71 | 243278.0 |
> showing 50 of 103,567 rows — these rows as CSV