PREVIEW / stock_30min / 2025-05-08
file: by_date/stock_30min/2025/2025-05-08.parquet size: 2.2 MB rows: 105,654 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-08 04:00:00 | AAPL | Stock | 197.98 | 198.52 | 197.85 | 198.33 | 21748.0 |
| 2025-05-08 04:30:00 | AAPL | Stock | 198.4 | 198.76 | 198.4 | 198.75 | 10671.0 |
| 2025-05-08 05:00:00 | AAPL | Stock | 198.73 | 198.95 | 198.64 | 198.9 | 11203.0 |
| 2025-05-08 05:30:00 | AAPL | Stock | 198.95 | 198.99 | 198.49 | 198.8 | 22718.0 |
| 2025-05-08 06:00:00 | AAPL | Stock | 198.82 | 198.99 | 198.74 | 198.94 | 18773.0 |
| 2025-05-08 06:30:00 | AAPL | Stock | 198.89 | 199.16 | 198.85 | 198.99 | 24778.0 |
| 2025-05-08 07:00:00 | AAPL | Stock | 198.97 | 199.0 | 198.04 | 198.04 | 68622.0 |
| 2025-05-08 07:30:00 | AAPL | Stock | 198.1 | 198.38 | 197.91 | 198.31 | 30002.0 |
| 2025-05-08 08:00:00 | AAPL | Stock | 198.81 | 199.0 | 197.71 | 198.2 | 174786.0 |
| 2025-05-08 08:30:00 | AAPL | Stock | 198.05 | 198.21 | 197.19 | 197.52 | 108413.0 |
| 2025-05-08 09:00:00 | AAPL | Stock | 197.598 | 197.7857 | 196.25 | 197.75 | 93013.0 |
| 2025-05-08 09:30:00 | AAPL | Stock | 197.73 | 198.13 | 196.08 | 196.15 | 3735545.0 |
| 2025-05-08 10:00:00 | AAPL | Stock | 196.17 | 196.31 | 194.6796 | 195.82 | 3370459.0 |
| 2025-05-08 10:30:00 | AAPL | Stock | 195.83 | 197.2497 | 195.515 | 196.62 | 2429061.0 |
| 2025-05-08 11:00:00 | AAPL | Stock | 196.58 | 197.83 | 196.41 | 197.54 | 2009381.0 |
| 2025-05-08 11:30:00 | AAPL | Stock | 197.53 | 199.75 | 197.3 | 199.34 | 3091542.0 |
| 2025-05-08 12:00:00 | AAPL | Stock | 199.34 | 200.05 | 199.23 | 199.24 | 2054089.0 |
| 2025-05-08 12:30:00 | AAPL | Stock | 199.2357 | 199.99 | 199.0101 | 199.72 | 1241368.0 |
| 2025-05-08 13:00:00 | AAPL | Stock | 199.72 | 199.85 | 199.05 | 199.14 | 1166306.0 |
| 2025-05-08 13:30:00 | AAPL | Stock | 199.15 | 199.212 | 198.3033 | 198.3213 | 1212685.0 |
| 2025-05-08 14:00:00 | AAPL | Stock | 198.32 | 198.665 | 198.08 | 198.64 | 1367371.0 |
| 2025-05-08 14:30:00 | AAPL | Stock | 198.64 | 199.2593 | 198.57 | 198.62 | 1286769.0 |
| 2025-05-08 15:00:00 | AAPL | Stock | 198.62 | 199.688 | 198.44 | 199.56 | 1599196.0 |
| 2025-05-08 15:30:00 | AAPL | Stock | 199.57 | 199.62 | 197.164 | 197.4 | 4116948.0 |
| 2025-05-08 16:00:00 | AAPL | Stock | 197.49 | 197.72 | 197.2 | 197.5795 | 8385824.0 |
| 2025-05-08 16:30:00 | AAPL | Stock | 197.5 | 197.73 | 197.29 | 197.29 | 30764.0 |
| 2025-05-08 17:00:00 | AAPL | Stock | 197.3 | 197.49 | 197.2 | 197.49 | 27876.0 |
| 2025-05-08 17:30:00 | AAPL | Stock | 197.59 | 197.6501 | 197.39 | 197.4994 | 9577.0 |
| 2025-05-08 18:00:00 | AAPL | Stock | 197.5 | 197.5 | 197.37 | 197.5 | 19117.0 |
| 2025-05-08 18:30:00 | AAPL | Stock | 197.41 | 197.5 | 197.38 | 197.4982 | 5343.0 |
| 2025-05-08 19:00:00 | AAPL | Stock | 197.5 | 197.5981 | 197.42 | 197.42 | 14594.0 |
| 2025-05-08 19:30:00 | AAPL | Stock | 197.4339 | 197.56 | 197.3545 | 197.51 | 12700.0 |
| 2025-05-08 04:00:00 | MSFT | Stock | 437.65 | 438.0 | 437.03 | 438.0 | 7379.0 |
| 2025-05-08 04:30:00 | MSFT | Stock | 437.77 | 438.15 | 437.5 | 437.5 | 6876.0 |
| 2025-05-08 05:00:00 | MSFT | Stock | 437.4 | 437.61 | 437.08 | 437.36 | 10637.0 |
| 2025-05-08 05:30:00 | MSFT | Stock | 437.3 | 437.3 | 436.81 | 436.81 | 8619.0 |
| 2025-05-08 06:00:00 | MSFT | Stock | 436.68 | 436.99 | 436.5 | 436.5 | 6771.0 |
| 2025-05-08 06:30:00 | MSFT | Stock | 436.97 | 437.5 | 436.97 | 437.5 | 600.0 |
| 2025-05-08 07:00:00 | MSFT | Stock | 437.51 | 438.29 | 437.28 | 437.45 | 5631.0 |
| 2025-05-08 07:30:00 | MSFT | Stock | 437.52 | 437.7 | 437.13 | 437.16 | 10337.0 |
| 2025-05-08 08:00:00 | MSFT | Stock | 437.45 | 438.2777 | 436.36 | 436.7048 | 22373.0 |
| 2025-05-08 08:30:00 | MSFT | Stock | 436.95 | 437.39 | 435.59 | 436.04 | 17507.0 |
| 2025-05-08 09:00:00 | MSFT | Stock | 436.2 | 438.29 | 436.0154 | 437.92 | 29906.0 |
| 2025-05-08 09:30:00 | MSFT | Stock | 437.94 | 441.1 | 436.69 | 438.01 | 1977709.0 |
| 2025-05-08 10:00:00 | MSFT | Stock | 437.9701 | 438.665 | 436.5 | 437.74 | 498988.0 |
| 2025-05-08 10:30:00 | MSFT | Stock | 437.77 | 438.21 | 435.66 | 437.0 | 475090.0 |
| 2025-05-08 11:00:00 | MSFT | Stock | 436.945 | 440.9689 | 436.16 | 439.89 | 715656.0 |
| 2025-05-08 11:30:00 | MSFT | Stock | 439.96 | 443.49 | 439.46 | 441.785 | 1070340.0 |
| 2025-05-08 12:00:00 | MSFT | Stock | 441.74 | 442.88 | 441.7 | 441.9922 | 641357.0 |
| 2025-05-08 12:30:00 | MSFT | Stock | 442.06 | 443.45 | 441.815 | 443.062 | 434993.0 |
> showing 50 of 105,654 rows — these rows as CSV