PREVIEW / stock_30min / 2024-05-16
file: by_date/stock_30min/2024/2024-05-16.parquet size: 2.1 MB rows: 99,517 symbols: 972
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-16 04:00:00 | AAPL | Stock | 190.12 | 190.58 | 190.12 | 190.3 | 7189.0 |
| 2024-05-16 04:30:00 | AAPL | Stock | 190.31 | 190.33 | 190.28 | 190.28 | 4684.0 |
| 2024-05-16 05:00:00 | AAPL | Stock | 190.3 | 190.3 | 189.59 | 189.69 | 20264.0 |
| 2024-05-16 05:30:00 | AAPL | Stock | 189.57 | 189.67 | 189.5 | 189.67 | 5155.0 |
| 2024-05-16 06:00:00 | AAPL | Stock | 189.69 | 189.76 | 189.69 | 189.71 | 5833.0 |
| 2024-05-16 06:30:00 | AAPL | Stock | 189.68 | 189.95 | 189.68 | 189.95 | 33134.0 |
| 2024-05-16 07:00:00 | AAPL | Stock | 189.99 | 190.15 | 189.99 | 190.09 | 7811.0 |
| 2024-05-16 07:30:00 | AAPL | Stock | 190.11 | 190.15 | 190.05 | 190.09 | 4965.0 |
| 2024-05-16 08:00:00 | AAPL | Stock | 189.95 | 190.76 | 189.9264 | 190.08 | 65799.0 |
| 2024-05-16 08:30:00 | AAPL | Stock | 190.12 | 190.22 | 189.9 | 190.0 | 58242.0 |
| 2024-05-16 09:00:00 | AAPL | Stock | 190.02 | 190.65 | 189.97 | 190.57 | 112723.0 |
| 2024-05-16 09:30:00 | AAPL | Stock | 190.44 | 191.095 | 189.975 | 190.4999 | 6244024.0 |
| 2024-05-16 10:00:00 | AAPL | Stock | 190.5 | 190.78 | 190.03 | 190.5802 | 3307306.0 |
| 2024-05-16 10:30:00 | AAPL | Stock | 190.585 | 190.75 | 190.15 | 190.335 | 2468618.0 |
| 2024-05-16 11:00:00 | AAPL | Stock | 190.34 | 190.59 | 189.725 | 189.965 | 2720755.0 |
| 2024-05-16 11:30:00 | AAPL | Stock | 189.965 | 190.14 | 189.765 | 190.0186 | 2240831.0 |
| 2024-05-16 12:00:00 | AAPL | Stock | 190.01 | 190.38 | 189.82 | 190.3211 | 2142605.0 |
| 2024-05-16 12:30:00 | AAPL | Stock | 190.3295 | 190.4881 | 190.23 | 190.329 | 1373467.0 |
| 2024-05-16 13:00:00 | AAPL | Stock | 190.32 | 190.45 | 189.97 | 190.01 | 1515582.0 |
| 2024-05-16 13:30:00 | AAPL | Stock | 190.0005 | 190.26 | 189.89 | 190.19 | 1318063.0 |
| 2024-05-16 14:00:00 | AAPL | Stock | 190.185 | 190.1874 | 189.76 | 189.9274 | 1658400.0 |
| 2024-05-16 14:30:00 | AAPL | Stock | 189.92 | 190.1 | 189.84 | 189.94 | 1281099.0 |
| 2024-05-16 15:00:00 | AAPL | Stock | 189.94 | 190.02 | 189.84 | 189.885 | 1834525.0 |
| 2024-05-16 15:30:00 | AAPL | Stock | 189.89 | 190.22 | 189.6601 | 189.91 | 4597448.0 |
| 2024-05-16 16:00:00 | AAPL | Stock | 189.92 | 189.92 | 189.71 | 189.76 | 8180697.0 |
| 2024-05-16 16:30:00 | AAPL | Stock | 189.76 | 189.84 | 189.73 | 189.74 | 13771.0 |
| 2024-05-16 17:00:00 | AAPL | Stock | 189.74 | 189.84 | 189.72 | 189.82 | 7128.0 |
| 2024-05-16 17:30:00 | AAPL | Stock | 189.82 | 189.82 | 189.76 | 189.78 | 4402.0 |
| 2024-05-16 18:00:00 | AAPL | Stock | 189.78 | 190.0 | 189.73 | 189.897 | 20143.0 |
| 2024-05-16 18:30:00 | AAPL | Stock | 189.91 | 189.9378 | 189.87 | 189.9378 | 1138.0 |
| 2024-05-16 19:00:00 | AAPL | Stock | 189.9 | 189.94 | 189.86 | 189.87 | 4111.0 |
| 2024-05-16 19:30:00 | AAPL | Stock | 189.87 | 190.0 | 189.87 | 190.0 | 9506.0 |
| 2024-05-16 04:00:00 | MSFT | Stock | 423.83 | 423.83 | 423.5 | 423.8 | 990.0 |
| 2024-05-16 04:30:00 | MSFT | Stock | 423.89 | 424.0 | 423.89 | 424.0 | 1081.0 |
| 2024-05-16 05:00:00 | MSFT | Stock | 423.81 | 423.94 | 423.81 | 423.94 | 955.0 |
| 2024-05-16 05:30:00 | MSFT | Stock | 423.97 | 424.0 | 423.97 | 424.0 | 200.0 |
| 2024-05-16 06:00:00 | MSFT | Stock | 424.0 | 424.06 | 424.0 | 424.05 | 2692.0 |
| 2024-05-16 06:30:00 | MSFT | Stock | 423.98 | 424.0 | 423.92 | 424.0 | 1189.0 |
| 2024-05-16 07:00:00 | MSFT | Stock | 423.9 | 423.9 | 423.15 | 423.15 | 2346.0 |
| 2024-05-16 07:30:00 | MSFT | Stock | 423.39 | 423.39 | 423.25 | 423.34 | 592.0 |
| 2024-05-16 08:00:00 | MSFT | Stock | 423.9009 | 424.33 | 423.2 | 423.7 | 9995.0 |
| 2024-05-16 08:30:00 | MSFT | Stock | 423.42 | 423.42 | 422.64 | 422.98 | 7789.0 |
| 2024-05-16 09:00:00 | MSFT | Stock | 423.08 | 423.08 | 421.6201 | 422.0 | 16226.0 |
| 2024-05-16 09:30:00 | MSFT | Stock | 421.8 | 425.42 | 421.71 | 423.93 | 1294655.0 |
| 2024-05-16 10:00:00 | MSFT | Stock | 423.95 | 424.415 | 422.64 | 423.855 | 428224.0 |
| 2024-05-16 10:30:00 | MSFT | Stock | 423.95 | 424.76 | 423.81 | 424.435 | 392988.0 |
| 2024-05-16 11:00:00 | MSFT | Stock | 424.49 | 424.68 | 423.07 | 424.125 | 479427.0 |
| 2024-05-16 11:30:00 | MSFT | Stock | 424.14 | 424.81 | 422.75 | 422.97 | 523133.0 |
| 2024-05-16 12:00:00 | MSFT | Stock | 422.94 | 422.965 | 422.13 | 422.395 | 378454.0 |
| 2024-05-16 12:30:00 | MSFT | Stock | 422.43 | 422.73 | 422.02 | 422.59 | 314984.0 |
> showing 50 of 99,517 rows — these rows as CSV