PREVIEW / stock_30min / 2024-06-05
file: by_date/stock_30min/2024/2024-06-05.parquet size: 2.1 MB rows: 99,228 symbols: 981
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-06-05 04:00:00 | AAPL | Stock | 194.99 | 195.2 | 194.7 | 194.79 | 8513.0 |
| 2024-06-05 04:30:00 | AAPL | Stock | 194.82 | 194.9 | 194.81 | 194.81 | 1229.0 |
| 2024-06-05 05:00:00 | AAPL | Stock | 194.85 | 194.95 | 194.71 | 194.8 | 5841.0 |
| 2024-06-05 05:30:00 | AAPL | Stock | 194.68 | 194.79 | 194.58 | 194.79 | 9302.0 |
| 2024-06-05 06:00:00 | AAPL | Stock | 194.67 | 194.9 | 194.64 | 194.9 | 2581.0 |
| 2024-06-05 06:30:00 | AAPL | Stock | 194.9 | 194.95 | 194.61 | 194.61 | 10683.0 |
| 2024-06-05 07:00:00 | AAPL | Stock | 194.82 | 194.93 | 194.71 | 194.84 | 22079.0 |
| 2024-06-05 07:30:00 | AAPL | Stock | 194.81 | 194.88 | 194.7 | 194.83 | 8199.0 |
| 2024-06-05 08:00:00 | AAPL | Stock | 194.79 | 195.04 | 194.6678 | 195.0 | 60031.0 |
| 2024-06-05 08:30:00 | AAPL | Stock | 195.0 | 195.13 | 194.8 | 195.12 | 31200.0 |
| 2024-06-05 09:00:00 | AAPL | Stock | 195.11 | 195.53 | 195.11 | 195.53 | 110038.0 |
| 2024-06-05 09:30:00 | AAPL | Stock | 195.44 | 196.42 | 194.87 | 195.78 | 6075570.0 |
| 2024-06-05 10:00:00 | AAPL | Stock | 195.75 | 195.83 | 195.01 | 195.375 | 3089018.0 |
| 2024-06-05 10:30:00 | AAPL | Stock | 195.38 | 195.77 | 195.2101 | 195.27 | 1904349.0 |
| 2024-06-05 11:00:00 | AAPL | Stock | 195.27 | 196.17 | 195.195 | 196.14 | 2429389.0 |
| 2024-06-05 11:30:00 | AAPL | Stock | 196.14 | 196.9 | 195.95 | 196.02 | 3222073.0 |
| 2024-06-05 12:00:00 | AAPL | Stock | 196.01 | 196.3 | 195.82 | 195.925 | 1788047.0 |
| 2024-06-05 12:30:00 | AAPL | Stock | 195.92 | 196.26 | 195.85 | 196.035 | 1289117.0 |
| 2024-06-05 13:00:00 | AAPL | Stock | 196.04 | 196.13 | 195.59 | 195.8852 | 1897108.0 |
| 2024-06-05 13:30:00 | AAPL | Stock | 195.88 | 196.7 | 195.88 | 196.67 | 2249373.0 |
| 2024-06-05 14:00:00 | AAPL | Stock | 196.665 | 196.69 | 195.94 | 196.205 | 1768105.0 |
| 2024-06-05 14:30:00 | AAPL | Stock | 196.2 | 196.44 | 195.83 | 195.83 | 1641117.0 |
| 2024-06-05 15:00:00 | AAPL | Stock | 195.83 | 196.195 | 195.72 | 196.1399 | 2158705.0 |
| 2024-06-05 15:30:00 | AAPL | Stock | 196.13 | 196.45 | 195.62 | 195.9 | 5211180.0 |
| 2024-06-05 16:00:00 | AAPL | Stock | 195.88 | 195.88 | 195.36 | 195.5 | 7028776.0 |
| 2024-06-05 16:30:00 | AAPL | Stock | 195.48 | 195.87 | 195.37 | 195.45 | 111819.0 |
| 2024-06-05 17:00:00 | AAPL | Stock | 195.5 | 195.87 | 195.44 | 195.5 | 775518.0 |
| 2024-06-05 17:30:00 | AAPL | Stock | 195.5505 | 195.5667 | 195.36 | 195.4365 | 17454.0 |
| 2024-06-05 18:00:00 | AAPL | Stock | 195.42 | 195.45 | 195.35 | 195.44 | 17983.0 |
| 2024-06-05 18:30:00 | AAPL | Stock | 195.44 | 195.5999 | 195.34 | 195.59 | 19096.0 |
| 2024-06-05 19:00:00 | AAPL | Stock | 195.59 | 195.59 | 195.45 | 195.45 | 7880.0 |
| 2024-06-05 19:30:00 | AAPL | Stock | 195.48 | 195.64 | 195.45 | 195.53 | 22034.0 |
| 2024-06-05 04:00:00 | MSFT | Stock | 416.85 | 417.15 | 416.82 | 416.9 | 1000.0 |
| 2024-06-05 04:30:00 | MSFT | Stock | 417.23 | 417.7 | 417.23 | 417.7 | 1380.0 |
| 2024-06-05 05:00:00 | MSFT | Stock | 417.71 | 418.1 | 417.65 | 417.69 | 943.0 |
| 2024-06-05 05:30:00 | MSFT | Stock | 417.64 | 417.74 | 417.64 | 417.74 | 470.0 |
| 2024-06-05 06:00:00 | MSFT | Stock | 417.81 | 417.95 | 417.81 | 417.92 | 2647.0 |
| 2024-06-05 06:30:00 | MSFT | Stock | 417.95 | 417.95 | 417.22 | 417.22 | 3840.0 |
| 2024-06-05 07:00:00 | MSFT | Stock | 417.17 | 417.7 | 417.0 | 417.2 | 1414.0 |
| 2024-06-05 07:30:00 | MSFT | Stock | 417.27 | 417.58 | 417.27 | 417.45 | 2898.0 |
| 2024-06-05 08:00:00 | MSFT | Stock | 417.25 | 417.87 | 416.95 | 417.1 | 10840.0 |
| 2024-06-05 08:30:00 | MSFT | Stock | 417.25 | 417.77 | 417.0 | 417.4897 | 17012.0 |
| 2024-06-05 09:00:00 | MSFT | Stock | 417.42 | 418.04 | 417.18 | 418.04 | 15721.0 |
| 2024-06-05 09:30:00 | MSFT | Stock | 417.87 | 418.7 | 416.3 | 418.3 | 1329812.0 |
| 2024-06-05 10:00:00 | MSFT | Stock | 418.31 | 418.52 | 416.73 | 418.1 | 753713.0 |
| 2024-06-05 10:30:00 | MSFT | Stock | 418.17 | 419.908 | 418.17 | 419.62 | 594357.0 |
| 2024-06-05 11:00:00 | MSFT | Stock | 419.66 | 420.83 | 419.63 | 420.55 | 527922.0 |
| 2024-06-05 11:30:00 | MSFT | Stock | 420.59 | 421.11 | 420.1142 | 420.66 | 440425.0 |
| 2024-06-05 12:00:00 | MSFT | Stock | 420.6 | 421.7398 | 420.23 | 421.67 | 432197.0 |
| 2024-06-05 12:30:00 | MSFT | Stock | 421.66 | 422.75 | 421.58 | 422.38 | 482658.0 |
> showing 50 of 99,228 rows — these rows as CSV