PREVIEW / stock_30min / 2024-07-29
file: by_date/stock_30min/2024/2024-07-29.parquet size: 2.0 MB rows: 98,651 symbols: 890
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-07-29 04:00:00 | AAPL | Stock | 218.69 | 218.69 | 218.11 | 218.22 | 9856.0 |
| 2024-07-29 04:30:00 | AAPL | Stock | 218.29 | 218.35 | 218.12 | 218.29 | 3293.0 |
| 2024-07-29 05:00:00 | AAPL | Stock | 218.3 | 218.8 | 218.3 | 218.74 | 4411.0 |
| 2024-07-29 05:30:00 | AAPL | Stock | 218.79 | 218.79 | 218.75 | 218.75 | 314.0 |
| 2024-07-29 06:00:00 | AAPL | Stock | 218.51 | 218.58 | 217.9 | 217.9 | 17267.0 |
| 2024-07-29 06:30:00 | AAPL | Stock | 217.85 | 217.85 | 216.87 | 217.7 | 12609.0 |
| 2024-07-29 07:00:00 | AAPL | Stock | 217.8 | 218.0 | 217.5 | 218.0 | 21124.0 |
| 2024-07-29 07:30:00 | AAPL | Stock | 218.0 | 218.23 | 217.96 | 218.0 | 15889.0 |
| 2024-07-29 08:00:00 | AAPL | Stock | 217.5 | 219.32 | 217.12 | 217.46 | 122701.0 |
| 2024-07-29 08:30:00 | AAPL | Stock | 217.46 | 217.6697 | 217.0 | 217.0 | 69041.0 |
| 2024-07-29 09:00:00 | AAPL | Stock | 217.02 | 217.08 | 216.52 | 216.93 | 85563.0 |
| 2024-07-29 09:30:00 | AAPL | Stock | 216.96 | 219.3 | 215.75 | 218.94 | 4952305.0 |
| 2024-07-29 10:00:00 | AAPL | Stock | 218.95 | 219.09 | 217.5 | 217.73 | 2312218.0 |
| 2024-07-29 10:30:00 | AAPL | Stock | 217.75 | 218.7 | 217.445 | 217.815 | 1959906.0 |
| 2024-07-29 11:00:00 | AAPL | Stock | 217.83 | 217.88 | 216.51 | 217.14 | 1835850.0 |
| 2024-07-29 11:30:00 | AAPL | Stock | 217.11 | 218.08 | 216.6 | 218.03 | 1262730.0 |
| 2024-07-29 12:00:00 | AAPL | Stock | 218.04 | 218.96 | 218.04 | 218.55 | 1273531.0 |
| 2024-07-29 12:30:00 | AAPL | Stock | 218.55 | 218.8899 | 218.375 | 218.78 | 780407.0 |
| 2024-07-29 13:00:00 | AAPL | Stock | 218.79 | 219.28 | 218.66 | 218.7 | 1399111.0 |
| 2024-07-29 13:30:00 | AAPL | Stock | 218.7 | 219.0869 | 218.3209 | 218.36 | 988124.0 |
| 2024-07-29 14:00:00 | AAPL | Stock | 218.37 | 218.75 | 218.05 | 218.35 | 1239510.0 |
| 2024-07-29 14:30:00 | AAPL | Stock | 218.34 | 218.63 | 217.97 | 218.57 | 1155484.0 |
| 2024-07-29 15:00:00 | AAPL | Stock | 218.56 | 218.75 | 218.35 | 218.59 | 1278114.0 |
| 2024-07-29 15:30:00 | AAPL | Stock | 218.59 | 219.12 | 218.0 | 218.22 | 3197892.0 |
| 2024-07-29 16:00:00 | AAPL | Stock | 218.24 | 218.43 | 217.83 | 218.39 | 4123878.0 |
| 2024-07-29 16:30:00 | AAPL | Stock | 218.24 | 218.3729 | 218.24 | 218.31 | 33993.0 |
| 2024-07-29 17:00:00 | AAPL | Stock | 218.38 | 218.39 | 218.24 | 218.34 | 9650.0 |
| 2024-07-29 17:30:00 | AAPL | Stock | 218.11 | 218.34 | 218.11 | 218.18 | 6163.0 |
| 2024-07-29 18:00:00 | AAPL | Stock | 218.26 | 218.44 | 218.26 | 218.34 | 5232.0 |
| 2024-07-29 18:30:00 | AAPL | Stock | 218.35 | 218.35 | 218.12 | 218.15 | 8497.0 |
| 2024-07-29 19:00:00 | AAPL | Stock | 218.2997 | 218.2997 | 217.63 | 217.75 | 6379.0 |
| 2024-07-29 19:30:00 | AAPL | Stock | 217.7 | 217.83 | 217.0364 | 217.19 | 16013.0 |
| 2024-07-29 04:00:00 | MSFT | Stock | 428.54 | 428.54 | 427.35 | 427.35 | 3863.0 |
| 2024-07-29 04:30:00 | MSFT | Stock | 427.7 | 427.93 | 427.3 | 427.3 | 507.0 |
| 2024-07-29 05:00:00 | MSFT | Stock | 427.3 | 427.3 | 427.19 | 427.2 | 300.0 |
| 2024-07-29 05:30:00 | MSFT | Stock | 427.95 | 428.6 | 427.95 | 428.6 | 300.0 |
| 2024-07-29 06:00:00 | MSFT | Stock | 428.38 | 428.75 | 428.36 | 428.7 | 1520.0 |
| 2024-07-29 06:30:00 | MSFT | Stock | 428.75 | 428.8 | 428.31 | 428.56 | 2309.0 |
| 2024-07-29 07:00:00 | MSFT | Stock | 428.73 | 428.88 | 428.25 | 428.88 | 8496.0 |
| 2024-07-29 07:30:00 | MSFT | Stock | 429.0 | 429.65 | 429.0 | 429.6 | 5021.0 |
| 2024-07-29 08:00:00 | MSFT | Stock | 428.7 | 430.0 | 425.27 | 429.85 | 41236.0 |
| 2024-07-29 08:30:00 | MSFT | Stock | 429.9 | 431.0 | 429.9 | 430.0 | 26166.0 |
| 2024-07-29 09:00:00 | MSFT | Stock | 429.9 | 432.2 | 429.55 | 431.58 | 27149.0 |
| 2024-07-29 09:30:00 | MSFT | Stock | 431.58 | 432.15 | 425.32 | 428.4 | 1758421.0 |
| 2024-07-29 10:00:00 | MSFT | Stock | 428.425 | 428.78 | 425.66 | 427.27 | 716975.0 |
| 2024-07-29 10:30:00 | MSFT | Stock | 427.23 | 428.15 | 426.06 | 426.28 | 455338.0 |
| 2024-07-29 11:00:00 | MSFT | Stock | 426.325 | 427.21 | 424.92 | 425.84 | 500603.0 |
| 2024-07-29 11:30:00 | MSFT | Stock | 425.83 | 427.62 | 424.7042 | 427.19 | 383362.0 |
| 2024-07-29 12:00:00 | MSFT | Stock | 427.23 | 429.21 | 427.23 | 428.015 | 459928.0 |
| 2024-07-29 12:30:00 | MSFT | Stock | 428.0206 | 429.38 | 428.0 | 428.58 | 357237.0 |
> showing 50 of 98,651 rows — these rows as CSV