PREVIEW / stock_30min / 2024-06-06
file: by_date/stock_30min/2024/2024-06-06.parquet size: 2.1 MB rows: 99,031 symbols: 965
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-06 04:00:00 | AAPL | Stock | 195.65 | 196.0 | 195.65 | 195.94 | 9027.0 |
| 2024-06-06 04:30:00 | AAPL | Stock | 195.9 | 196.04 | 195.84 | 195.91 | 19286.0 |
| 2024-06-06 05:00:00 | AAPL | Stock | 196.0 | 196.0 | 195.7 | 195.86 | 5511.0 |
| 2024-06-06 05:30:00 | AAPL | Stock | 195.8 | 195.82 | 195.76 | 195.82 | 7626.0 |
| 2024-06-06 06:00:00 | AAPL | Stock | 195.79 | 195.96 | 195.79 | 195.86 | 6028.0 |
| 2024-06-06 06:30:00 | AAPL | Stock | 195.91 | 195.93 | 195.91 | 195.92 | 4542.0 |
| 2024-06-06 07:00:00 | AAPL | Stock | 195.9 | 195.98 | 195.81 | 195.81 | 11975.0 |
| 2024-06-06 07:30:00 | AAPL | Stock | 195.81 | 195.81 | 195.63 | 195.67 | 10070.0 |
| 2024-06-06 08:00:00 | AAPL | Stock | 195.9 | 196.41 | 195.6 | 195.78 | 68168.0 |
| 2024-06-06 08:30:00 | AAPL | Stock | 195.8 | 195.98 | 195.7 | 195.869 | 36119.0 |
| 2024-06-06 09:00:00 | AAPL | Stock | 195.86 | 195.95 | 195.18 | 195.67 | 78869.0 |
| 2024-06-06 09:30:00 | AAPL | Stock | 195.67 | 196.37 | 195.21 | 196.1101 | 4506878.0 |
| 2024-06-06 10:00:00 | AAPL | Stock | 196.13 | 196.5 | 195.625 | 195.92 | 2962379.0 |
| 2024-06-06 10:30:00 | AAPL | Stock | 195.91 | 196.0 | 195.44 | 195.745 | 2073774.0 |
| 2024-06-06 11:00:00 | AAPL | Stock | 195.74 | 195.89 | 195.56 | 195.835 | 1473295.0 |
| 2024-06-06 11:30:00 | AAPL | Stock | 195.835 | 195.84 | 195.41 | 195.53 | 1346295.0 |
| 2024-06-06 12:00:00 | AAPL | Stock | 195.535 | 195.79 | 195.4324 | 195.67 | 1201624.0 |
| 2024-06-06 12:30:00 | AAPL | Stock | 195.675 | 195.97 | 195.6 | 195.97 | 1099343.0 |
| 2024-06-06 13:00:00 | AAPL | Stock | 195.96 | 196.07 | 195.46 | 195.648 | 1482758.0 |
| 2024-06-06 13:30:00 | AAPL | Stock | 195.645 | 195.735 | 195.44 | 195.475 | 1081298.0 |
| 2024-06-06 14:00:00 | AAPL | Stock | 195.475 | 195.57 | 194.95 | 195.5445 | 1833644.0 |
| 2024-06-06 14:30:00 | AAPL | Stock | 195.54 | 195.545 | 195.175 | 195.235 | 1270557.0 |
| 2024-06-06 15:00:00 | AAPL | Stock | 195.235 | 195.4183 | 195.02 | 195.393 | 1374397.0 |
| 2024-06-06 15:30:00 | AAPL | Stock | 195.395 | 195.5 | 194.17 | 194.48 | 5091702.0 |
| 2024-06-06 16:00:00 | AAPL | Stock | 194.43 | 194.5 | 193.94 | 194.46 | 5636262.0 |
| 2024-06-06 16:30:00 | AAPL | Stock | 194.46 | 194.48 | 194.4 | 194.45 | 71987.0 |
| 2024-06-06 17:00:00 | AAPL | Stock | 194.45 | 194.48 | 194.35 | 194.4 | 24828.0 |
| 2024-06-06 17:30:00 | AAPL | Stock | 194.48 | 194.48 | 194.36 | 194.4 | 13187.0 |
| 2024-06-06 18:00:00 | AAPL | Stock | 194.46 | 194.6345 | 194.41 | 194.52 | 7261.0 |
| 2024-06-06 18:30:00 | AAPL | Stock | 194.5 | 194.75 | 194.4 | 194.6408 | 10986.0 |
| 2024-06-06 19:00:00 | AAPL | Stock | 194.63 | 194.76 | 194.6 | 194.62 | 1618.0 |
| 2024-06-06 19:30:00 | AAPL | Stock | 194.64 | 194.76 | 194.51 | 194.59 | 9869.0 |
| 2024-06-06 04:00:00 | MSFT | Stock | 423.25 | 423.25 | 422.68 | 423.23 | 2328.0 |
| 2024-06-06 04:30:00 | MSFT | Stock | 423.21 | 423.25 | 423.1 | 423.1 | 1300.0 |
| 2024-06-06 05:00:00 | MSFT | Stock | 422.83 | 423.12 | 422.83 | 422.9 | 1180.0 |
| 2024-06-06 05:30:00 | MSFT | Stock | 422.9 | 422.9 | 422.8 | 422.8 | 273.0 |
| 2024-06-06 06:00:00 | MSFT | Stock | 422.77 | 423.5 | 422.77 | 423.13 | 3178.0 |
| 2024-06-06 06:30:00 | MSFT | Stock | 423.46 | 423.5 | 423.32 | 423.5 | 585.0 |
| 2024-06-06 07:00:00 | MSFT | Stock | 423.23 | 423.4 | 422.86 | 422.86 | 1637.0 |
| 2024-06-06 07:30:00 | MSFT | Stock | 422.73 | 423.0 | 422.68 | 423.0 | 2338.0 |
| 2024-06-06 08:00:00 | MSFT | Stock | 423.3 | 423.87 | 422.23 | 423.08 | 15485.0 |
| 2024-06-06 08:30:00 | MSFT | Stock | 423.1 | 423.42 | 422.22 | 423.16 | 11314.0 |
| 2024-06-06 09:00:00 | MSFT | Stock | 423.11 | 424.19 | 422.98 | 424.0 | 4677.0 |
| 2024-06-06 09:30:00 | MSFT | Stock | 424.02 | 425.31 | 422.59 | 423.32 | 1163955.0 |
| 2024-06-06 10:00:00 | MSFT | Stock | 423.37 | 424.11 | 422.79 | 423.44 | 613486.0 |
| 2024-06-06 10:30:00 | MSFT | Stock | 423.41 | 423.48 | 422.57 | 422.86 | 457917.0 |
| 2024-06-06 11:00:00 | MSFT | Stock | 422.83 | 423.16 | 421.3 | 421.4 | 429823.0 |
| 2024-06-06 11:30:00 | MSFT | Stock | 421.42 | 421.8557 | 420.58 | 421.6 | 522084.0 |
| 2024-06-06 12:00:00 | MSFT | Stock | 421.59 | 423.18 | 421.59 | 422.98 | 422250.0 |
| 2024-06-06 12:30:00 | MSFT | Stock | 423.0 | 423.45 | 422.4 | 423.42 | 285215.0 |
> showing 50 of 99,031 rows — these rows as CSV