PREVIEW / stock_30min / 2025-05-05
file: by_date/stock_30min/2025/2025-05-05.parquet size: 2.1 MB rows: 103,281 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-05 04:00:00 | AAPL | Stock | 205.0 | 205.0 | 203.67 | 203.67 | 21429.0 |
| 2025-05-05 04:30:00 | AAPL | Stock | 203.61 | 203.67 | 203.33 | 203.5 | 15506.0 |
| 2025-05-05 05:00:00 | AAPL | Stock | 203.51 | 203.8 | 203.5 | 203.79 | 9510.0 |
| 2025-05-05 05:30:00 | AAPL | Stock | 203.8 | 203.8 | 203.61 | 203.73 | 10726.0 |
| 2025-05-05 06:00:00 | AAPL | Stock | 203.71 | 203.76 | 203.5 | 203.5 | 12848.0 |
| 2025-05-05 06:30:00 | AAPL | Stock | 203.36 | 203.39 | 203.0 | 203.25 | 24251.0 |
| 2025-05-05 07:00:00 | AAPL | Stock | 203.25 | 203.44 | 203.01 | 203.05 | 30221.0 |
| 2025-05-05 07:30:00 | AAPL | Stock | 203.01 | 203.19 | 202.79 | 203.19 | 37080.0 |
| 2025-05-05 08:00:00 | AAPL | Stock | 203.25 | 204.3419 | 202.77 | 203.0064 | 128156.0 |
| 2025-05-05 08:30:00 | AAPL | Stock | 203.0126 | 203.29 | 202.95 | 203.28 | 60277.0 |
| 2025-05-05 09:00:00 | AAPL | Stock | 203.26 | 203.45 | 202.49 | 203.1 | 151601.0 |
| 2025-05-05 09:30:00 | AAPL | Stock | 203.1 | 204.1 | 199.5 | 199.725 | 7068287.0 |
| 2025-05-05 10:00:00 | AAPL | Stock | 199.76 | 200.34 | 198.62 | 198.78 | 4563222.0 |
| 2025-05-05 10:30:00 | AAPL | Stock | 198.787 | 199.17 | 198.21 | 198.9335 | 3524797.0 |
| 2025-05-05 11:00:00 | AAPL | Stock | 198.91 | 199.65 | 198.5 | 199.1996 | 2867045.0 |
| 2025-05-05 11:30:00 | AAPL | Stock | 199.1976 | 199.42 | 198.66 | 199.275 | 2223617.0 |
| 2025-05-05 12:00:00 | AAPL | Stock | 199.275 | 200.04 | 199.1 | 199.974 | 2318429.0 |
| 2025-05-05 12:30:00 | AAPL | Stock | 199.96 | 200.02 | 199.44 | 199.8911 | 1618649.0 |
| 2025-05-05 13:00:00 | AAPL | Stock | 199.88 | 200.64 | 199.6701 | 200.41 | 2259549.0 |
| 2025-05-05 13:30:00 | AAPL | Stock | 200.41 | 200.63 | 200.27 | 200.37 | 1278100.0 |
| 2025-05-05 14:00:00 | AAPL | Stock | 200.37 | 201.09 | 200.16 | 200.96 | 1598272.0 |
| 2025-05-05 14:30:00 | AAPL | Stock | 200.95 | 201.16 | 200.43 | 200.53 | 1696865.0 |
| 2025-05-05 15:00:00 | AAPL | Stock | 200.52 | 200.52 | 199.4 | 199.4 | 2293547.0 |
| 2025-05-05 15:30:00 | AAPL | Stock | 199.4 | 199.6 | 198.512 | 198.77 | 5044528.0 |
| 2025-05-05 16:00:00 | AAPL | Stock | 198.76 | 198.99 | 198.56 | 198.74 | 7949178.0 |
| 2025-05-05 16:30:00 | AAPL | Stock | 198.89 | 198.97 | 198.56 | 198.97 | 74052.0 |
| 2025-05-05 17:00:00 | AAPL | Stock | 198.98 | 199.05 | 198.72 | 198.7897 | 63007.0 |
| 2025-05-05 17:30:00 | AAPL | Stock | 198.75 | 198.79 | 198.56 | 198.66 | 19954.0 |
| 2025-05-05 18:00:00 | AAPL | Stock | 198.69 | 198.86 | 198.61 | 198.8 | 14460.0 |
| 2025-05-05 18:30:00 | AAPL | Stock | 198.8 | 198.8 | 198.5732 | 198.61 | 19173.0 |
| 2025-05-05 19:00:00 | AAPL | Stock | 198.56 | 198.77 | 198.56 | 198.68 | 12099.0 |
| 2025-05-05 19:30:00 | AAPL | Stock | 198.73 | 198.89 | 198.56 | 198.6 | 35108.0 |
| 2025-05-05 04:00:00 | MSFT | Stock | 432.88 | 432.88 | 431.5 | 431.58 | 6084.0 |
| 2025-05-05 04:30:00 | MSFT | Stock | 431.58 | 431.58 | 430.02 | 430.69 | 4260.0 |
| 2025-05-05 05:00:00 | MSFT | Stock | 430.88 | 431.0 | 430.6 | 430.95 | 3447.0 |
| 2025-05-05 05:30:00 | MSFT | Stock | 431.0 | 431.28 | 430.84 | 431.17 | 2821.0 |
| 2025-05-05 06:00:00 | MSFT | Stock | 431.56 | 431.77 | 431.53 | 431.53 | 2444.0 |
| 2025-05-05 06:30:00 | MSFT | Stock | 431.34 | 431.9 | 431.2 | 431.85 | 3477.0 |
| 2025-05-05 07:00:00 | MSFT | Stock | 431.75 | 432.8 | 431.4 | 432.8 | 7111.0 |
| 2025-05-05 07:30:00 | MSFT | Stock | 432.6 | 432.8 | 431.75 | 431.99 | 13230.0 |
| 2025-05-05 08:00:00 | MSFT | Stock | 431.86 | 433.0 | 431.3662 | 431.85 | 29419.0 |
| 2025-05-05 08:30:00 | MSFT | Stock | 432.0 | 432.0 | 429.92 | 431.0 | 49754.0 |
| 2025-05-05 09:00:00 | MSFT | Stock | 430.8 | 433.0 | 430.75 | 433.0 | 22655.0 |
| 2025-05-05 09:30:00 | MSFT | Stock | 432.87 | 436.5799 | 432.11 | 436.19 | 1471141.0 |
| 2025-05-05 10:00:00 | MSFT | Stock | 436.19 | 437.17 | 434.7064 | 435.09 | 701864.0 |
| 2025-05-05 10:30:00 | MSFT | Stock | 435.1942 | 437.44 | 434.47 | 437.425 | 588841.0 |
| 2025-05-05 11:00:00 | MSFT | Stock | 437.3925 | 438.06 | 436.09 | 436.5 | 565913.0 |
| 2025-05-05 11:30:00 | MSFT | Stock | 436.59 | 437.65 | 436.385 | 437.475 | 351614.0 |
| 2025-05-05 12:00:00 | MSFT | Stock | 437.4995 | 439.38 | 437.21 | 439.315 | 535657.0 |
| 2025-05-05 12:30:00 | MSFT | Stock | 439.31 | 439.5 | 438.7101 | 439.025 | 482282.0 |
> showing 50 of 103,281 rows — these rows as CSV