PREVIEW / stock_30min / 2024-10-01
file: by_date/stock_30min/2024/2024-10-01.parquet size: 2.1 MB rows: 100,767 symbols: 774
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-10-01 04:00:00 | AAPL | Stock | 233.33 | 233.37 | 233.08 | 233.19 | 3927.0 |
| 2024-10-01 04:30:00 | AAPL | Stock | 233.25 | 233.28 | 233.09 | 233.09 | 3780.0 |
| 2024-10-01 05:00:00 | AAPL | Stock | 233.23 | 233.35 | 233.23 | 233.35 | 1710.0 |
| 2024-10-01 05:30:00 | AAPL | Stock | 233.35 | 233.42 | 233.27 | 233.42 | 2184.0 |
| 2024-10-01 06:00:00 | AAPL | Stock | 233.39 | 233.45 | 233.39 | 233.41 | 2756.0 |
| 2024-10-01 06:30:00 | AAPL | Stock | 233.38 | 233.56 | 233.0 | 233.0 | 23794.0 |
| 2024-10-01 07:00:00 | AAPL | Stock | 233.0 | 233.1 | 229.7 | 230.33 | 358484.0 |
| 2024-10-01 07:30:00 | AAPL | Stock | 230.38 | 230.48 | 229.44 | 230.32 | 148024.0 |
| 2024-10-01 08:00:00 | AAPL | Stock | 230.3 | 233.47 | 229.45 | 229.98 | 269634.0 |
| 2024-10-01 08:30:00 | AAPL | Stock | 229.99 | 230.4399 | 229.4 | 230.0 | 175270.0 |
| 2024-10-01 09:00:00 | AAPL | Stock | 230.0 | 230.39 | 228.88 | 229.5 | 415950.0 |
| 2024-10-01 09:30:00 | AAPL | Stock | 229.52 | 229.66 | 225.61 | 226.125 | 9239620.0 |
| 2024-10-01 10:00:00 | AAPL | Stock | 226.13 | 226.3 | 224.66 | 224.98 | 4156192.0 |
| 2024-10-01 10:30:00 | AAPL | Stock | 224.98 | 225.47 | 224.53 | 225.32 | 2390122.0 |
| 2024-10-01 11:00:00 | AAPL | Stock | 225.29 | 225.5 | 224.52 | 225.475 | 2193918.0 |
| 2024-10-01 11:30:00 | AAPL | Stock | 225.47 | 225.94 | 225.03 | 225.22 | 1754756.0 |
| 2024-10-01 12:00:00 | AAPL | Stock | 225.21 | 225.83 | 225.075 | 225.313 | 1405241.0 |
| 2024-10-01 12:30:00 | AAPL | Stock | 225.3 | 225.395 | 224.2678 | 224.75 | 1725417.0 |
| 2024-10-01 13:00:00 | AAPL | Stock | 224.77 | 224.78 | 223.74 | 223.93 | 1696183.0 |
| 2024-10-01 13:30:00 | AAPL | Stock | 223.93 | 225.17 | 223.84 | 225.13 | 1697233.0 |
| 2024-10-01 14:00:00 | AAPL | Stock | 225.12 | 225.65 | 225.0626 | 225.46 | 1432299.0 |
| 2024-10-01 14:30:00 | AAPL | Stock | 225.44 | 225.75 | 225.246 | 225.604 | 1406163.0 |
| 2024-10-01 15:00:00 | AAPL | Stock | 225.61 | 226.1884 | 225.51 | 226.1501 | 1894154.0 |
| 2024-10-01 15:30:00 | AAPL | Stock | 226.15 | 226.34 | 225.8757 | 226.26 | 3962209.0 |
| 2024-10-01 16:00:00 | AAPL | Stock | 226.23 | 226.289 | 225.79 | 225.83 | 9685803.0 |
| 2024-10-01 16:30:00 | AAPL | Stock | 225.84 | 226.21 | 225.6015 | 225.67 | 119232.0 |
| 2024-10-01 17:00:00 | AAPL | Stock | 225.67 | 226.21 | 225.5 | 225.5624 | 170560.0 |
| 2024-10-01 17:30:00 | AAPL | Stock | 225.5718 | 225.68 | 225.5 | 225.5665 | 11180.0 |
| 2024-10-01 18:00:00 | AAPL | Stock | 225.57 | 225.8 | 225.3 | 225.54 | 24822.0 |
| 2024-10-01 18:30:00 | AAPL | Stock | 225.54 | 225.68 | 225.4683 | 225.62 | 16427.0 |
| 2024-10-01 19:00:00 | AAPL | Stock | 225.68 | 225.74 | 225.42 | 225.42 | 21778.0 |
| 2024-10-01 19:30:00 | AAPL | Stock | 225.4003 | 225.8435 | 225.4 | 225.72 | 14884.0 |
| 2024-10-01 04:00:00 | MSFT | Stock | 429.51 | 429.51 | 429.0 | 429.1 | 1576.0 |
| 2024-10-01 04:30:00 | MSFT | Stock | 429.2 | 429.31 | 429.0 | 429.0 | 1742.0 |
| 2024-10-01 05:00:00 | MSFT | Stock | 428.97 | 429.0 | 428.55 | 428.89 | 2175.0 |
| 2024-10-01 05:30:00 | MSFT | Stock | 428.89 | 429.0 | 428.89 | 429.0 | 266.0 |
| 2024-10-01 06:00:00 | MSFT | Stock | 428.92 | 429.0 | 428.91 | 429.0 | 1829.0 |
| 2024-10-01 06:30:00 | MSFT | Stock | 429.29 | 429.35 | 429.2 | 429.25 | 406.0 |
| 2024-10-01 07:00:00 | MSFT | Stock | 429.51 | 430.0 | 429.41 | 429.66 | 3337.0 |
| 2024-10-01 07:30:00 | MSFT | Stock | 429.5 | 429.75 | 429.05 | 429.69 | 6426.0 |
| 2024-10-01 08:00:00 | MSFT | Stock | 429.6 | 430.0 | 428.94 | 429.42 | 13924.0 |
| 2024-10-01 08:30:00 | MSFT | Stock | 429.15 | 430.3 | 428.8914 | 429.24 | 13068.0 |
| 2024-10-01 09:00:00 | MSFT | Stock | 429.4126 | 429.5837 | 428.08 | 428.45 | 11969.0 |
| 2024-10-01 09:30:00 | MSFT | Stock | 428.45 | 428.48 | 421.18 | 422.365 | 1682257.0 |
| 2024-10-01 10:00:00 | MSFT | Stock | 422.385 | 422.9299 | 420.3504 | 421.2 | 893660.0 |
| 2024-10-01 10:30:00 | MSFT | Stock | 421.13 | 421.9 | 420.4701 | 421.42 | 449430.0 |
| 2024-10-01 11:00:00 | MSFT | Stock | 421.45 | 421.54 | 418.81 | 420.0308 | 804739.0 |
| 2024-10-01 11:30:00 | MSFT | Stock | 420.04 | 422.2199 | 419.75 | 421.42 | 520707.0 |
| 2024-10-01 12:00:00 | MSFT | Stock | 421.435 | 422.36 | 421.15 | 421.82 | 376547.0 |
| 2024-10-01 12:30:00 | MSFT | Stock | 421.84 | 422.0 | 419.59 | 421.3 | 395054.0 |
> showing 50 of 100,767 rows — these rows as CSV