PREVIEW / stock_30min / 2024-05-28
file: by_date/stock_30min/2024/2024-05-28.parquet size: 2.1 MB rows: 101,327 symbols: 968
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-05-28 04:00:00 | AAPL | Stock | 190.8 | 192.7 | 190.59 | 192.7 | 79032.0 |
| 2024-05-28 04:30:00 | AAPL | Stock | 192.74 | 194.29 | 192.74 | 194.29 | 109218.0 |
| 2024-05-28 05:00:00 | AAPL | Stock | 194.2 | 194.26 | 194.0 | 194.16 | 13169.0 |
| 2024-05-28 05:30:00 | AAPL | Stock | 194.12 | 194.81 | 194.12 | 194.5 | 61188.0 |
| 2024-05-28 06:00:00 | AAPL | Stock | 194.6 | 194.62 | 193.85 | 194.0 | 38591.0 |
| 2024-05-28 06:30:00 | AAPL | Stock | 193.9 | 194.31 | 193.66 | 193.7 | 28432.0 |
| 2024-05-28 07:00:00 | AAPL | Stock | 193.69 | 193.96 | 193.5 | 193.6 | 71602.0 |
| 2024-05-28 07:30:00 | AAPL | Stock | 193.6 | 193.65 | 193.45 | 193.5 | 70693.0 |
| 2024-05-28 08:00:00 | AAPL | Stock | 193.56 | 194.5202 | 190.69 | 193.3 | 208104.0 |
| 2024-05-28 08:30:00 | AAPL | Stock | 193.22 | 193.25 | 192.62 | 192.98 | 117537.0 |
| 2024-05-28 09:00:00 | AAPL | Stock | 192.96 | 193.0 | 191.03 | 191.59 | 387598.0 |
| 2024-05-28 09:30:00 | AAPL | Stock | 191.51 | 193.0 | 190.33 | 191.05 | 7792536.0 |
| 2024-05-28 10:00:00 | AAPL | Stock | 191.05 | 192.1 | 191.0 | 191.64 | 3539662.0 |
| 2024-05-28 10:30:00 | AAPL | Stock | 191.625 | 191.77 | 191.1301 | 191.645 | 2171565.0 |
| 2024-05-28 11:00:00 | AAPL | Stock | 191.66 | 191.76 | 191.31 | 191.62 | 1668651.0 |
| 2024-05-28 11:30:00 | AAPL | Stock | 191.61 | 191.95 | 191.39 | 191.475 | 1720097.0 |
| 2024-05-28 12:00:00 | AAPL | Stock | 191.47 | 191.76 | 191.06 | 191.26 | 1784343.0 |
| 2024-05-28 12:30:00 | AAPL | Stock | 191.2502 | 191.46 | 191.06 | 191.3057 | 1293602.0 |
| 2024-05-28 13:00:00 | AAPL | Stock | 191.305 | 191.35 | 190.86 | 190.875 | 1283560.0 |
| 2024-05-28 13:30:00 | AAPL | Stock | 190.875 | 190.97 | 190.19 | 190.3222 | 1681431.0 |
| 2024-05-28 14:00:00 | AAPL | Stock | 190.33 | 190.49 | 189.65 | 189.7298 | 2160622.0 |
| 2024-05-28 14:30:00 | AAPL | Stock | 189.725 | 189.76 | 189.1 | 189.72 | 2276904.0 |
| 2024-05-28 15:00:00 | AAPL | Stock | 189.72 | 189.87 | 189.48 | 189.5328 | 1918628.0 |
| 2024-05-28 15:30:00 | AAPL | Stock | 189.538 | 190.11 | 189.33 | 190.1 | 4150741.0 |
| 2024-05-28 16:00:00 | AAPL | Stock | 190.13 | 190.24 | 189.91 | 189.9499 | 7566029.0 |
| 2024-05-28 16:30:00 | AAPL | Stock | 189.95 | 190.05 | 189.9498 | 190.03 | 33988.0 |
| 2024-05-28 17:00:00 | AAPL | Stock | 190.0399 | 190.12 | 189.99 | 190.04 | 14680.0 |
| 2024-05-28 17:30:00 | AAPL | Stock | 190.0306 | 190.13 | 190.02 | 190.02 | 15299.0 |
| 2024-05-28 18:00:00 | AAPL | Stock | 190.03 | 190.13 | 189.97 | 189.97 | 20707.0 |
| 2024-05-28 18:30:00 | AAPL | Stock | 189.99 | 190.05 | 189.9704 | 190.02 | 4162.0 |
| 2024-05-28 19:00:00 | AAPL | Stock | 190.0 | 190.23 | 189.99 | 190.21 | 28835.0 |
| 2024-05-28 19:30:00 | AAPL | Stock | 190.22 | 190.23 | 190.03 | 190.15 | 17938.0 |
| 2024-05-28 04:00:00 | MSFT | Stock | 430.84 | 430.84 | 430.31 | 430.36 | 5169.0 |
| 2024-05-28 04:30:00 | MSFT | Stock | 430.37 | 430.67 | 430.37 | 430.6 | 594.0 |
| 2024-05-28 05:00:00 | MSFT | Stock | 430.81 | 430.81 | 430.37 | 430.73 | 1499.0 |
| 2024-05-28 05:30:00 | MSFT | Stock | 430.44 | 430.5 | 430.44 | 430.5 | 465.0 |
| 2024-05-28 06:00:00 | MSFT | Stock | 430.3 | 430.3 | 428.61 | 428.61 | 958.0 |
| 2024-05-28 06:30:00 | MSFT | Stock | 428.79 | 429.55 | 428.08 | 428.08 | 7334.0 |
| 2024-05-28 07:00:00 | MSFT | Stock | 428.67 | 429.0 | 428.5 | 428.86 | 8730.0 |
| 2024-05-28 07:30:00 | MSFT | Stock | 428.75 | 430.0 | 428.5 | 430.0 | 5637.0 |
| 2024-05-28 08:00:00 | MSFT | Stock | 428.79 | 431.54 | 428.45 | 429.75 | 26706.0 |
| 2024-05-28 08:30:00 | MSFT | Stock | 429.15 | 429.77 | 428.8 | 429.7458 | 15881.0 |
| 2024-05-28 09:00:00 | MSFT | Stock | 429.7738 | 430.43 | 429.05 | 429.99 | 20807.0 |
| 2024-05-28 09:30:00 | MSFT | Stock | 429.82 | 430.82 | 426.6 | 428.005 | 1846831.0 |
| 2024-05-28 10:00:00 | MSFT | Stock | 427.96 | 429.91 | 427.6201 | 428.45 | 763970.0 |
| 2024-05-28 10:30:00 | MSFT | Stock | 428.42 | 428.8 | 427.7601 | 428.59 | 563748.0 |
| 2024-05-28 11:00:00 | MSFT | Stock | 428.6205 | 429.32 | 428.26 | 428.44 | 345599.0 |
| 2024-05-28 11:30:00 | MSFT | Stock | 428.46 | 428.87 | 427.98 | 428.425 | 348255.0 |
| 2024-05-28 12:00:00 | MSFT | Stock | 428.48 | 428.95 | 428.34 | 428.91 | 288960.0 |
| 2024-05-28 12:30:00 | MSFT | Stock | 428.89 | 429.15 | 428.7 | 428.79 | 242603.0 |
> showing 50 of 101,327 rows — these rows as CSV