PREVIEW / stock_30min / 2024-06-24
file: by_date/stock_30min/2024/2024-06-24.parquet size: 2.0 MB rows: 98,949 symbols: 926
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-24 04:00:00 | AAPL | Stock | 207.4 | 208.0 | 207.4 | 208.0 | 26384.0 |
| 2024-06-24 04:30:00 | AAPL | Stock | 208.12 | 208.2 | 207.7 | 207.78 | 9391.0 |
| 2024-06-24 05:00:00 | AAPL | Stock | 207.73 | 207.75 | 207.33 | 207.47 | 11336.0 |
| 2024-06-24 05:30:00 | AAPL | Stock | 207.42 | 207.44 | 206.91 | 207.06 | 21434.0 |
| 2024-06-24 06:00:00 | AAPL | Stock | 207.1 | 207.49 | 207.1 | 207.48 | 19965.0 |
| 2024-06-24 06:30:00 | AAPL | Stock | 207.48 | 207.97 | 207.37 | 207.8 | 19340.0 |
| 2024-06-24 07:00:00 | AAPL | Stock | 207.84 | 208.14 | 207.4 | 207.61 | 85628.0 |
| 2024-06-24 07:30:00 | AAPL | Stock | 207.6 | 207.91 | 207.49 | 207.75 | 59782.0 |
| 2024-06-24 08:00:00 | AAPL | Stock | 207.7504 | 208.1 | 207.31 | 207.8 | 133647.0 |
| 2024-06-24 08:30:00 | AAPL | Stock | 207.85 | 208.01 | 207.59 | 207.976 | 105186.0 |
| 2024-06-24 09:00:00 | AAPL | Stock | 207.96 | 207.9893 | 207.57 | 207.676 | 162068.0 |
| 2024-06-24 09:30:00 | AAPL | Stock | 207.67 | 208.77 | 206.59 | 208.7 | 7582808.0 |
| 2024-06-24 10:00:00 | AAPL | Stock | 208.7 | 209.56 | 208.5 | 209.005 | 4091527.0 |
| 2024-06-24 10:30:00 | AAPL | Stock | 209.01 | 210.79 | 208.92 | 210.57 | 4738977.0 |
| 2024-06-24 11:00:00 | AAPL | Stock | 210.562 | 212.7 | 210.562 | 212.3655 | 6758039.0 |
| 2024-06-24 11:30:00 | AAPL | Stock | 212.37 | 212.6165 | 211.58 | 211.8499 | 3763593.0 |
| 2024-06-24 12:00:00 | AAPL | Stock | 211.83 | 211.85 | 210.63 | 210.91 | 3293942.0 |
| 2024-06-24 12:30:00 | AAPL | Stock | 210.91 | 211.0 | 209.54 | 209.7699 | 2791792.0 |
| 2024-06-24 13:00:00 | AAPL | Stock | 209.765 | 210.18 | 209.392 | 210.005 | 2498940.0 |
| 2024-06-24 13:30:00 | AAPL | Stock | 210.0 | 210.09 | 209.1801 | 209.26 | 2118439.0 |
| 2024-06-24 14:00:00 | AAPL | Stock | 209.25 | 209.4 | 208.88 | 209.38 | 2164071.0 |
| 2024-06-24 14:30:00 | AAPL | Stock | 209.38 | 209.51 | 208.52 | 208.85 | 2625488.0 |
| 2024-06-24 15:00:00 | AAPL | Stock | 208.845 | 209.1 | 208.61 | 208.859 | 1907747.0 |
| 2024-06-24 15:30:00 | AAPL | Stock | 208.85 | 208.91 | 207.8446 | 208.15 | 7055411.0 |
| 2024-06-24 16:00:00 | AAPL | Stock | 208.15 | 208.85 | 208.14 | 208.64 | 11346081.0 |
| 2024-06-24 16:30:00 | AAPL | Stock | 208.65 | 208.94 | 208.14 | 208.84 | 78321.0 |
| 2024-06-24 17:00:00 | AAPL | Stock | 208.9 | 209.0 | 208.72 | 208.72 | 33482.0 |
| 2024-06-24 17:30:00 | AAPL | Stock | 208.74 | 208.81 | 208.55 | 208.75 | 17836.0 |
| 2024-06-24 18:00:00 | AAPL | Stock | 208.75 | 209.0 | 208.7 | 208.98 | 27081.0 |
| 2024-06-24 18:30:00 | AAPL | Stock | 209.0 | 209.04 | 208.14 | 208.9571 | 17120.0 |
| 2024-06-24 19:00:00 | AAPL | Stock | 208.95 | 208.99 | 208.81 | 208.99 | 17822.0 |
| 2024-06-24 19:30:00 | AAPL | Stock | 209.01 | 209.1599 | 208.9511 | 209.12 | 28528.0 |
| 2024-06-24 04:00:00 | MSFT | Stock | 449.82 | 449.96 | 449.5 | 449.95 | 1749.0 |
| 2024-06-24 04:30:00 | MSFT | Stock | 449.95 | 449.99 | 449.9 | 449.9 | 468.0 |
| 2024-06-24 05:00:00 | MSFT | Stock | 449.98 | 450.1 | 449.98 | 450.1 | 843.0 |
| 2024-06-24 05:30:00 | MSFT | Stock | 450.01 | 450.5 | 449.97 | 450.5 | 1513.0 |
| 2024-06-24 06:00:00 | MSFT | Stock | 450.78 | 450.78 | 450.67 | 450.78 | 394.0 |
| 2024-06-24 06:30:00 | MSFT | Stock | 450.47 | 450.5 | 450.3 | 450.3 | 1167.0 |
| 2024-06-24 07:00:00 | MSFT | Stock | 450.35 | 450.41 | 449.55 | 449.55 | 8087.0 |
| 2024-06-24 07:30:00 | MSFT | Stock | 449.87 | 450.25 | 449.7 | 449.7 | 1916.0 |
| 2024-06-24 08:00:00 | MSFT | Stock | 450.14 | 450.904 | 449.6 | 449.78 | 12919.0 |
| 2024-06-24 08:30:00 | MSFT | Stock | 449.88 | 449.9866 | 449.0767 | 449.55 | 13822.0 |
| 2024-06-24 09:00:00 | MSFT | Stock | 449.5 | 450.13 | 449.0 | 450.13 | 20626.0 |
| 2024-06-24 09:30:00 | MSFT | Stock | 450.05 | 450.13 | 446.41 | 449.63 | 1346149.0 |
| 2024-06-24 10:00:00 | MSFT | Stock | 449.595 | 452.75 | 449.55 | 449.95 | 1141155.0 |
| 2024-06-24 10:30:00 | MSFT | Stock | 449.95 | 450.74 | 448.17 | 450.18 | 648953.0 |
| 2024-06-24 11:00:00 | MSFT | Stock | 450.19 | 450.45 | 449.32 | 449.99 | 422626.0 |
| 2024-06-24 11:30:00 | MSFT | Stock | 450.065 | 450.49 | 449.55 | 450.23 | 271923.0 |
| 2024-06-24 12:00:00 | MSFT | Stock | 450.2 | 450.27 | 449.08 | 449.52 | 309246.0 |
| 2024-06-24 12:30:00 | MSFT | Stock | 449.45 | 449.87 | 448.9001 | 449.38 | 233147.0 |
> showing 50 of 98,949 rows — these rows as CSV