PREVIEW / stock_30min / 2024-05-30
file: by_date/stock_30min/2024/2024-05-30.parquet size: 2.0 MB rows: 98,093 symbols: 964
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-30 04:00:00 | AAPL | Stock | 190.01 | 190.36 | 189.89 | 190.35 | 10336.0 |
| 2024-05-30 04:30:00 | AAPL | Stock | 190.38 | 190.68 | 190.38 | 190.5 | 5574.0 |
| 2024-05-30 05:00:00 | AAPL | Stock | 190.5 | 190.53 | 190.5 | 190.53 | 2756.0 |
| 2024-05-30 05:30:00 | AAPL | Stock | 190.54 | 190.66 | 190.54 | 190.6 | 1463.0 |
| 2024-05-30 06:00:00 | AAPL | Stock | 190.66 | 190.67 | 190.49 | 190.5 | 1773.0 |
| 2024-05-30 06:30:00 | AAPL | Stock | 190.5 | 190.76 | 190.5 | 190.76 | 3656.0 |
| 2024-05-30 07:00:00 | AAPL | Stock | 190.7 | 190.7 | 190.37 | 190.37 | 6893.0 |
| 2024-05-30 07:30:00 | AAPL | Stock | 190.4 | 190.41 | 190.2 | 190.2 | 14298.0 |
| 2024-05-30 08:00:00 | AAPL | Stock | 190.51 | 190.68 | 189.86 | 190.5 | 68442.0 |
| 2024-05-30 08:30:00 | AAPL | Stock | 190.5 | 190.87 | 190.4 | 190.46 | 52904.0 |
| 2024-05-30 09:00:00 | AAPL | Stock | 190.5 | 190.78 | 190.37 | 190.78 | 60263.0 |
| 2024-05-30 09:30:00 | AAPL | Stock | 190.78 | 192.1 | 190.63 | 190.89 | 5746363.0 |
| 2024-05-30 10:00:00 | AAPL | Stock | 190.89 | 191.625 | 190.68 | 191.445 | 3358368.0 |
| 2024-05-30 10:30:00 | AAPL | Stock | 191.45 | 191.47 | 191.0 | 191.25 | 2461115.0 |
| 2024-05-30 11:00:00 | AAPL | Stock | 191.25 | 191.83 | 191.25 | 191.67 | 2048131.0 |
| 2024-05-30 11:30:00 | AAPL | Stock | 191.67 | 191.75 | 191.37 | 191.47 | 1173851.0 |
| 2024-05-30 12:00:00 | AAPL | Stock | 191.46 | 191.64 | 191.1 | 191.26 | 1188428.0 |
| 2024-05-30 12:30:00 | AAPL | Stock | 191.26 | 191.75 | 191.205 | 191.748 | 1135400.0 |
| 2024-05-30 13:00:00 | AAPL | Stock | 191.7483 | 192.14 | 191.71 | 192.0787 | 1940975.0 |
| 2024-05-30 13:30:00 | AAPL | Stock | 192.08 | 192.18 | 191.845 | 191.94 | 1283582.0 |
| 2024-05-30 14:00:00 | AAPL | Stock | 191.925 | 192.0 | 191.36 | 191.535 | 1436221.0 |
| 2024-05-30 14:30:00 | AAPL | Stock | 191.5367 | 191.8 | 191.41 | 191.74 | 1889053.0 |
| 2024-05-30 15:00:00 | AAPL | Stock | 191.74 | 191.79 | 191.515 | 191.565 | 1524806.0 |
| 2024-05-30 15:30:00 | AAPL | Stock | 191.58 | 191.84 | 190.85 | 191.29 | 5576236.0 |
| 2024-05-30 16:00:00 | AAPL | Stock | 191.32 | 191.42 | 190.8701 | 191.0112 | 10128862.0 |
| 2024-05-30 16:30:00 | AAPL | Stock | 191.14 | 191.49 | 191.08 | 191.29 | 126978.0 |
| 2024-05-30 17:00:00 | AAPL | Stock | 191.2903 | 191.6 | 191.29 | 191.45 | 34874.0 |
| 2024-05-30 17:30:00 | AAPL | Stock | 191.49 | 191.54 | 191.29 | 191.38 | 43150.0 |
| 2024-05-30 18:00:00 | AAPL | Stock | 191.39 | 191.7 | 191.29 | 191.36 | 24981.0 |
| 2024-05-30 18:30:00 | AAPL | Stock | 191.43 | 191.6 | 191.41 | 191.52 | 9759.0 |
| 2024-05-30 19:00:00 | AAPL | Stock | 191.54 | 191.59 | 191.49 | 191.52 | 10098.0 |
| 2024-05-30 19:30:00 | AAPL | Stock | 191.57 | 191.65 | 191.41 | 191.41 | 19996.0 |
| 2024-05-30 04:00:00 | MSFT | Stock | 425.5 | 425.64 | 425.01 | 425.43 | 1219.0 |
| 2024-05-30 04:30:00 | MSFT | Stock | 425.4 | 425.9 | 425.4 | 425.9 | 625.0 |
| 2024-05-30 05:30:00 | MSFT | Stock | 425.95 | 425.95 | 425.95 | 425.95 | 375.0 |
| 2024-05-30 06:00:00 | MSFT | Stock | 425.76 | 425.76 | 425.5 | 425.5 | 1285.0 |
| 2024-05-30 06:30:00 | MSFT | Stock | 425.68 | 425.75 | 425.37 | 425.75 | 1375.0 |
| 2024-05-30 07:00:00 | MSFT | Stock | 425.65 | 425.89 | 425.49 | 425.68 | 3072.0 |
| 2024-05-30 07:30:00 | MSFT | Stock | 425.56 | 425.7 | 425.01 | 425.11 | 5944.0 |
| 2024-05-30 08:00:00 | MSFT | Stock | 425.9 | 425.9 | 423.9 | 424.66 | 27050.0 |
| 2024-05-30 08:30:00 | MSFT | Stock | 424.72 | 425.0 | 424.05 | 424.1 | 21343.0 |
| 2024-05-30 09:00:00 | MSFT | Stock | 424.2212 | 425.0 | 423.5 | 424.03 | 36710.0 |
| 2024-05-30 09:30:00 | MSFT | Stock | 424.24 | 424.3 | 420.63 | 421.6 | 2195714.0 |
| 2024-05-30 10:00:00 | MSFT | Stock | 421.65 | 421.75 | 417.75 | 420.27 | 1970136.0 |
| 2024-05-30 10:30:00 | MSFT | Stock | 420.27 | 420.33 | 417.6 | 418.06 | 1434530.0 |
| 2024-05-30 11:00:00 | MSFT | Stock | 418.045 | 419.6 | 417.93 | 419.15 | 1362490.0 |
| 2024-05-30 11:30:00 | MSFT | Stock | 419.15 | 420.27 | 419.0 | 419.05 | 887510.0 |
| 2024-05-30 12:00:00 | MSFT | Stock | 419.075 | 419.6 | 419.02 | 419.135 | 523110.0 |
| 2024-05-30 12:30:00 | MSFT | Stock | 419.145 | 419.92 | 419.06 | 419.67 | 446376.0 |
| 2024-05-30 13:00:00 | MSFT | Stock | 419.675 | 420.26 | 419.35 | 419.545 | 440846.0 |
> showing 50 of 98,093 rows — these rows as CSV