PREVIEW / stock_30min / 2023-11-30
file: by_date/stock_30min/2023/2023-11-30.parquet size: 2.1 MB rows: 100,291 symbols: 1,289
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 |
|---|---|---|---|---|---|---|---|
| 2023-11-30 04:00:00 | AAPL | Stock | 189.44 | 189.6 | 189.4 | 189.43 | 936.0 |
| 2023-11-30 04:30:00 | AAPL | Stock | 189.42 | 189.5 | 189.31 | 189.5 | 1330.0 |
| 2023-11-30 05:00:00 | AAPL | Stock | 189.45 | 189.45 | 189.45 | 189.45 | 225.0 |
| 2023-11-30 05:30:00 | AAPL | Stock | 189.48 | 189.5 | 189.44 | 189.44 | 951.0 |
| 2023-11-30 06:00:00 | AAPL | Stock | 189.51 | 189.51 | 189.38 | 189.45 | 5722.0 |
| 2023-11-30 06:30:00 | AAPL | Stock | 189.47 | 189.52 | 189.4 | 189.4 | 319.0 |
| 2023-11-30 07:00:00 | AAPL | Stock | 189.56 | 189.96 | 189.56 | 189.94 | 14305.0 |
| 2023-11-30 07:30:00 | AAPL | Stock | 189.91 | 190.05 | 189.91 | 189.98 | 12042.0 |
| 2023-11-30 08:00:00 | AAPL | Stock | 189.61 | 190.16 | 189.51 | 190.16 | 54202.0 |
| 2023-11-30 08:30:00 | AAPL | Stock | 190.14 | 190.2 | 189.65 | 189.72 | 68344.0 |
| 2023-11-30 09:00:00 | AAPL | Stock | 189.7 | 189.91 | 189.61 | 189.88 | 55093.0 |
| 2023-11-30 09:30:00 | AAPL | Stock | 189.84 | 190.32 | 189.05 | 189.205 | 3692738.0 |
| 2023-11-30 10:00:00 | AAPL | Stock | 189.21 | 189.35 | 188.66 | 188.8259 | 2792297.0 |
| 2023-11-30 10:30:00 | AAPL | Stock | 188.83 | 188.99 | 188.34 | 188.76 | 2184187.0 |
| 2023-11-30 11:00:00 | AAPL | Stock | 188.75 | 188.919 | 188.39 | 188.48 | 1535790.0 |
| 2023-11-30 11:30:00 | AAPL | Stock | 188.48 | 188.535 | 188.19 | 188.24 | 1582709.0 |
| 2023-11-30 12:00:00 | AAPL | Stock | 188.25 | 188.61 | 188.19 | 188.35 | 1176294.0 |
| 2023-11-30 12:30:00 | AAPL | Stock | 188.35 | 188.7595 | 188.27 | 188.7023 | 1187520.0 |
| 2023-11-30 13:00:00 | AAPL | Stock | 188.7 | 188.7 | 188.27 | 188.33 | 1122965.0 |
| 2023-11-30 13:30:00 | AAPL | Stock | 188.335 | 188.7679 | 188.29 | 188.5099 | 1062373.0 |
| 2023-11-30 14:00:00 | AAPL | Stock | 188.51 | 188.83 | 188.5 | 188.79 | 1076429.0 |
| 2023-11-30 14:30:00 | AAPL | Stock | 188.788 | 189.21 | 188.64 | 189.175 | 1295008.0 |
| 2023-11-30 15:00:00 | AAPL | Stock | 189.175 | 189.195 | 188.69 | 188.78 | 1397423.0 |
| 2023-11-30 15:30:00 | AAPL | Stock | 188.765 | 190.2 | 188.76 | 189.95 | 6245898.0 |
| 2023-11-30 16:00:00 | AAPL | Stock | 189.94 | 190.26 | 189.79 | 189.87 | 12713730.0 |
| 2023-11-30 16:30:00 | AAPL | Stock | 189.87 | 189.95 | 189.83 | 189.87 | 45773.0 |
| 2023-11-30 17:00:00 | AAPL | Stock | 189.89 | 190.0 | 189.87 | 190.0 | 24702.0 |
| 2023-11-30 17:30:00 | AAPL | Stock | 190.0 | 190.08 | 189.89 | 190.01 | 38542.0 |
| 2023-11-30 18:00:00 | AAPL | Stock | 189.95 | 190.2 | 189.93 | 190.15 | 12850.0 |
| 2023-11-30 18:30:00 | AAPL | Stock | 190.1271 | 190.23 | 190.1 | 190.11 | 10401.0 |
| 2023-11-30 19:00:00 | AAPL | Stock | 190.1 | 190.16 | 190.06 | 190.1 | 13503.0 |
| 2023-11-30 19:30:00 | AAPL | Stock | 190.12 | 190.3 | 190.12 | 190.3 | 34428.0 |
| 2023-11-30 04:00:00 | MSFT | Stock | 379.26 | 379.89 | 379.26 | 379.89 | 1491.0 |
| 2023-11-30 04:30:00 | MSFT | Stock | 379.7 | 379.7 | 379.5 | 379.5 | 557.0 |
| 2023-11-30 05:30:00 | MSFT | Stock | 379.39 | 379.7 | 379.39 | 379.7 | 461.0 |
| 2023-11-30 06:00:00 | MSFT | Stock | 379.59 | 379.59 | 379.48 | 379.48 | 1040.0 |
| 2023-11-30 06:30:00 | MSFT | Stock | 379.72 | 379.74 | 379.72 | 379.73 | 300.0 |
| 2023-11-30 07:00:00 | MSFT | Stock | 379.57 | 380.8 | 379.57 | 380.4 | 11263.0 |
| 2023-11-30 07:30:00 | MSFT | Stock | 380.45 | 380.77 | 380.4 | 380.53 | 7172.0 |
| 2023-11-30 08:00:00 | MSFT | Stock | 379.6 | 380.99 | 379.59 | 380.9 | 26583.0 |
| 2023-11-30 08:30:00 | MSFT | Stock | 380.8 | 380.8 | 378.8 | 378.8 | 47557.0 |
| 2023-11-30 09:00:00 | MSFT | Stock | 378.75 | 378.9 | 378.25 | 378.38 | 23299.0 |
| 2023-11-30 09:30:00 | MSFT | Stock | 378.49 | 380.09 | 377.655 | 378.57 | 2008322.0 |
| 2023-11-30 10:00:00 | MSFT | Stock | 378.61 | 379.42 | 377.41 | 378.062 | 891294.0 |
| 2023-11-30 10:30:00 | MSFT | Stock | 378.09 | 378.8 | 376.6801 | 377.56 | 834022.0 |
| 2023-11-30 11:00:00 | MSFT | Stock | 377.54 | 377.78 | 376.74 | 376.93 | 695061.0 |
| 2023-11-30 11:30:00 | MSFT | Stock | 376.93 | 377.14 | 376.07 | 376.15 | 629237.0 |
| 2023-11-30 12:00:00 | MSFT | Stock | 376.18 | 376.97 | 376.01 | 376.4584 | 526945.0 |
| 2023-11-30 12:30:00 | MSFT | Stock | 376.48 | 377.1399 | 376.32 | 376.93 | 384784.0 |
| 2023-11-30 13:00:00 | MSFT | Stock | 376.93 | 377.0362 | 376.0537 | 376.0537 | 390531.0 |
> showing 50 of 100,291 rows — these rows as CSV