PREVIEW / stock_30min / 2024-06-26
file: by_date/stock_30min/2024/2024-06-26.parquet size: 2.0 MB rows: 97,439 symbols: 914
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-26 04:00:00 | AAPL | Stock | 209.35 | 209.99 | 209.35 | 209.74 | 18678.0 |
| 2024-06-26 04:30:00 | AAPL | Stock | 209.79 | 210.09 | 209.76 | 209.9 | 6829.0 |
| 2024-06-26 05:00:00 | AAPL | Stock | 209.73 | 209.86 | 209.73 | 209.78 | 960.0 |
| 2024-06-26 05:30:00 | AAPL | Stock | 209.71 | 209.74 | 209.7 | 209.7 | 1159.0 |
| 2024-06-26 06:00:00 | AAPL | Stock | 209.7 | 209.7 | 209.5 | 209.55 | 1504.0 |
| 2024-06-26 06:30:00 | AAPL | Stock | 209.6 | 211.64 | 209.52 | 211.0 | 95286.0 |
| 2024-06-26 07:00:00 | AAPL | Stock | 211.0 | 211.2 | 210.53 | 210.8 | 46810.0 |
| 2024-06-26 07:30:00 | AAPL | Stock | 210.77 | 211.155 | 210.7 | 211.15 | 43429.0 |
| 2024-06-26 08:00:00 | AAPL | Stock | 210.9 | 211.15 | 209.11 | 210.72 | 157286.0 |
| 2024-06-26 08:30:00 | AAPL | Stock | 210.67 | 210.93 | 210.22 | 210.38 | 110339.0 |
| 2024-06-26 09:00:00 | AAPL | Stock | 210.3969 | 211.61 | 210.3 | 211.5 | 167890.0 |
| 2024-06-26 09:30:00 | AAPL | Stock | 211.5 | 212.4 | 210.64 | 211.53 | 6934269.0 |
| 2024-06-26 10:00:00 | AAPL | Stock | 211.49 | 213.0 | 211.37 | 212.36 | 4635589.0 |
| 2024-06-26 10:30:00 | AAPL | Stock | 212.37 | 213.43 | 212.34 | 213.195 | 3855638.0 |
| 2024-06-26 11:00:00 | AAPL | Stock | 213.195 | 213.75 | 213.03 | 213.21 | 3042235.0 |
| 2024-06-26 11:30:00 | AAPL | Stock | 213.21 | 214.44 | 213.03 | 214.27 | 3086541.0 |
| 2024-06-26 12:00:00 | AAPL | Stock | 214.26 | 214.78 | 213.98 | 214.3451 | 2532401.0 |
| 2024-06-26 12:30:00 | AAPL | Stock | 214.345 | 214.37 | 213.265 | 213.83 | 2097370.0 |
| 2024-06-26 13:00:00 | AAPL | Stock | 213.83 | 213.87 | 213.23 | 213.56 | 1230422.0 |
| 2024-06-26 13:30:00 | AAPL | Stock | 213.5517 | 214.06 | 213.49 | 214.0122 | 1784187.0 |
| 2024-06-26 14:00:00 | AAPL | Stock | 214.01 | 214.86 | 213.945 | 214.35 | 2932375.0 |
| 2024-06-26 14:30:00 | AAPL | Stock | 214.345 | 214.57 | 214.02 | 214.15 | 1873816.0 |
| 2024-06-26 15:00:00 | AAPL | Stock | 214.15 | 214.16 | 212.83 | 213.27 | 2678370.0 |
| 2024-06-26 15:30:00 | AAPL | Stock | 213.29 | 213.5 | 212.72 | 213.1 | 4545593.0 |
| 2024-06-26 16:00:00 | AAPL | Stock | 213.25 | 213.3 | 212.89 | 213.14 | 9229191.0 |
| 2024-06-26 16:30:00 | AAPL | Stock | 213.15 | 213.25 | 213.01 | 213.22 | 150045.0 |
| 2024-06-26 17:00:00 | AAPL | Stock | 213.23 | 213.25 | 212.93 | 212.9997 | 1508544.0 |
| 2024-06-26 17:30:00 | AAPL | Stock | 213.0 | 213.12 | 212.93 | 212.95 | 12131.0 |
| 2024-06-26 18:00:00 | AAPL | Stock | 212.96 | 213.08 | 212.96 | 212.96 | 10775.0 |
| 2024-06-26 18:30:00 | AAPL | Stock | 212.95 | 212.97 | 212.5 | 212.65 | 18755.0 |
| 2024-06-26 19:00:00 | AAPL | Stock | 212.61 | 213.0 | 212.6 | 212.72 | 43161.0 |
| 2024-06-26 19:30:00 | AAPL | Stock | 212.8 | 212.95 | 212.7205 | 212.8 | 17090.0 |
| 2024-06-26 04:00:00 | MSFT | Stock | 452.45 | 452.45 | 451.79 | 451.82 | 659.0 |
| 2024-06-26 04:30:00 | MSFT | Stock | 451.99 | 452.0 | 451.99 | 452.0 | 208.0 |
| 2024-06-26 05:00:00 | MSFT | Stock | 451.27 | 451.31 | 451.1 | 451.3 | 604.0 |
| 2024-06-26 06:00:00 | MSFT | Stock | 450.65 | 450.65 | 450.65 | 450.65 | 100.0 |
| 2024-06-26 06:30:00 | MSFT | Stock | 450.75 | 451.0 | 450.64 | 450.85 | 1740.0 |
| 2024-06-26 07:00:00 | MSFT | Stock | 450.85 | 450.85 | 450.0 | 450.0 | 1604.0 |
| 2024-06-26 07:30:00 | MSFT | Stock | 449.7 | 449.71 | 449.38 | 449.71 | 3334.0 |
| 2024-06-26 08:00:00 | MSFT | Stock | 450.71 | 452.36 | 449.39 | 449.85 | 17425.0 |
| 2024-06-26 08:30:00 | MSFT | Stock | 449.8996 | 450.0 | 449.71 | 449.71 | 10438.0 |
| 2024-06-26 09:00:00 | MSFT | Stock | 449.6 | 450.459 | 447.8 | 448.59 | 30665.0 |
| 2024-06-26 09:30:00 | MSFT | Stock | 448.75 | 450.804 | 448.19 | 450.43 | 1140075.0 |
| 2024-06-26 10:00:00 | MSFT | Stock | 450.5 | 451.6899 | 450.08 | 450.9401 | 599230.0 |
| 2024-06-26 10:30:00 | MSFT | Stock | 451.01 | 453.5885 | 450.995 | 453.105 | 623819.0 |
| 2024-06-26 11:00:00 | MSFT | Stock | 453.09 | 453.41 | 451.65 | 453.1 | 486629.0 |
| 2024-06-26 11:30:00 | MSFT | Stock | 453.1 | 453.6 | 452.33 | 453.38 | 346289.0 |
| 2024-06-26 12:00:00 | MSFT | Stock | 453.3776 | 453.3821 | 452.2 | 452.73 | 383132.0 |
| 2024-06-26 12:30:00 | MSFT | Stock | 452.725 | 453.11 | 452.3 | 452.63 | 215246.0 |
| 2024-06-26 13:00:00 | MSFT | Stock | 452.575 | 452.78 | 451.3499 | 451.8301 | 297132.0 |
> showing 50 of 97,439 rows — these rows as CSV