PREVIEW / stock_30min / 2023-09-25
file: by_date/stock_30min/2023/2023-09-25.parquet size: 2.0 MB rows: 96,500 symbols: 1,403
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-09-25 04:00:00 | AAPL | Stock | 175.58 | 175.58 | 174.94 | 174.94 | 16179.0 |
| 2023-09-25 04:30:00 | AAPL | Stock | 174.81 | 174.81 | 173.99 | 174.47 | 27867.0 |
| 2023-09-25 05:00:00 | AAPL | Stock | 174.52 | 174.8 | 174.45 | 174.45 | 12312.0 |
| 2023-09-25 05:30:00 | AAPL | Stock | 174.42 | 174.78 | 174.34 | 174.76 | 7212.0 |
| 2023-09-25 06:00:00 | AAPL | Stock | 174.8 | 174.93 | 174.66 | 174.81 | 12293.0 |
| 2023-09-25 06:30:00 | AAPL | Stock | 174.89 | 174.91 | 174.67 | 174.89 | 11908.0 |
| 2023-09-25 07:00:00 | AAPL | Stock | 174.93 | 175.17 | 174.89 | 174.95 | 35695.0 |
| 2023-09-25 07:30:00 | AAPL | Stock | 174.95 | 174.95 | 174.31 | 174.46 | 14195.0 |
| 2023-09-25 08:00:00 | AAPL | Stock | 174.5 | 175.57 | 174.2 | 174.4 | 78595.0 |
| 2023-09-25 08:30:00 | AAPL | Stock | 174.45 | 175.1 | 174.45 | 174.67 | 36048.0 |
| 2023-09-25 09:00:00 | AAPL | Stock | 174.62 | 174.7064 | 174.07 | 174.11 | 137056.0 |
| 2023-09-25 09:30:00 | AAPL | Stock | 174.2 | 175.505 | 174.15 | 175.34 | 5266093.0 |
| 2023-09-25 10:00:00 | AAPL | Stock | 175.35 | 175.55 | 174.21 | 174.47 | 3077832.0 |
| 2023-09-25 10:30:00 | AAPL | Stock | 174.46 | 175.2193 | 174.37 | 174.88 | 2461429.0 |
| 2023-09-25 11:00:00 | AAPL | Stock | 174.89 | 176.54 | 174.87 | 176.27 | 3325950.0 |
| 2023-09-25 11:30:00 | AAPL | Stock | 176.288 | 176.49 | 175.88 | 176.03 | 2492042.0 |
| 2023-09-25 12:00:00 | AAPL | Stock | 176.04 | 176.97 | 175.88 | 176.88 | 2402959.0 |
| 2023-09-25 12:30:00 | AAPL | Stock | 176.885 | 176.91 | 176.13 | 176.29 | 1928396.0 |
| 2023-09-25 13:00:00 | AAPL | Stock | 176.28 | 176.8 | 176.04 | 176.13 | 1955553.0 |
| 2023-09-25 13:30:00 | AAPL | Stock | 176.15 | 176.34 | 175.88 | 176.26 | 1570783.0 |
| 2023-09-25 14:00:00 | AAPL | Stock | 176.27 | 176.3676 | 175.68 | 175.775 | 1570034.0 |
| 2023-09-25 14:30:00 | AAPL | Stock | 175.7701 | 176.129 | 175.48 | 175.55 | 1907368.0 |
| 2023-09-25 15:00:00 | AAPL | Stock | 175.555 | 175.68 | 174.97 | 175.6105 | 2917107.0 |
| 2023-09-25 15:30:00 | AAPL | Stock | 175.61 | 176.15 | 175.37 | 176.09 | 3997461.0 |
| 2023-09-25 16:00:00 | AAPL | Stock | 176.08 | 176.5 | 176.08 | 176.21 | 4054211.0 |
| 2023-09-25 16:30:00 | AAPL | Stock | 176.24 | 176.38 | 176.08 | 176.29 | 47317.0 |
| 2023-09-25 17:00:00 | AAPL | Stock | 176.32 | 176.32 | 176.08 | 176.08 | 34828.0 |
| 2023-09-25 17:30:00 | AAPL | Stock | 176.12 | 176.2 | 176.11 | 176.16 | 4468.0 |
| 2023-09-25 18:00:00 | AAPL | Stock | 176.15 | 176.1945 | 176.11 | 176.19 | 9996.0 |
| 2023-09-25 18:30:00 | AAPL | Stock | 176.18 | 176.2 | 176.14 | 176.1415 | 3799.0 |
| 2023-09-25 19:00:00 | AAPL | Stock | 176.14 | 176.17 | 175.97 | 176.06 | 15774.0 |
| 2023-09-25 19:30:00 | AAPL | Stock | 176.09 | 176.14 | 176.05 | 176.13 | 16058.0 |
| 2023-09-25 04:00:00 | MSFT | Stock | 317.68 | 317.68 | 317.01 | 317.01 | 1420.0 |
| 2023-09-25 04:30:00 | MSFT | Stock | 316.01 | 316.01 | 314.71 | 315.34 | 2896.0 |
| 2023-09-25 05:30:00 | MSFT | Stock | 315.27 | 315.4 | 315.27 | 315.4 | 203.0 |
| 2023-09-25 06:00:00 | MSFT | Stock | 315.9 | 318.27 | 315.9 | 317.92 | 13029.0 |
| 2023-09-25 06:30:00 | MSFT | Stock | 317.23 | 317.53 | 317.0 | 317.5 | 2072.0 |
| 2023-09-25 07:00:00 | MSFT | Stock | 317.47 | 317.6 | 317.12 | 317.12 | 5140.0 |
| 2023-09-25 07:30:00 | MSFT | Stock | 317.12 | 317.12 | 316.17 | 316.25 | 3614.0 |
| 2023-09-25 08:00:00 | MSFT | Stock | 317.1 | 318.14 | 315.9999 | 316.35 | 11803.0 |
| 2023-09-25 08:30:00 | MSFT | Stock | 316.13 | 317.32 | 316.13 | 316.6 | 7585.0 |
| 2023-09-25 09:00:00 | MSFT | Stock | 316.55 | 317.45 | 315.72 | 317.14 | 20710.0 |
| 2023-09-25 09:30:00 | MSFT | Stock | 316.93 | 317.67 | 315.65 | 316.39 | 1948102.0 |
| 2023-09-25 10:00:00 | MSFT | Stock | 316.43 | 317.62 | 316.019 | 316.08 | 970530.0 |
| 2023-09-25 10:30:00 | MSFT | Stock | 316.05 | 316.82 | 315.06 | 315.1 | 745497.0 |
| 2023-09-25 11:00:00 | MSFT | Stock | 315.08 | 317.22 | 315.08 | 316.5 | 669331.0 |
| 2023-09-25 11:30:00 | MSFT | Stock | 316.52 | 317.19 | 316.27 | 316.485 | 428398.0 |
| 2023-09-25 12:00:00 | MSFT | Stock | 316.51 | 316.86 | 315.86 | 316.59 | 417290.0 |
| 2023-09-25 12:30:00 | MSFT | Stock | 316.61 | 316.69 | 315.3313 | 315.6801 | 429971.0 |
| 2023-09-25 13:00:00 | MSFT | Stock | 315.68 | 316.4513 | 315.34 | 315.68 | 489778.0 |
> showing 50 of 96,500 rows — these rows as CSV