PREVIEW / stock_30min / 2024-06-10
file: by_date/stock_30min/2024/2024-06-10.parquet size: 2.0 MB rows: 98,828 symbols: 980
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-10 04:00:00 | AAPL | Stock | 197.0 | 197.77 | 197.0 | 197.72 | 23337.0 |
| 2024-06-10 04:30:00 | AAPL | Stock | 197.7 | 197.8 | 197.39 | 197.39 | 14219.0 |
| 2024-06-10 05:00:00 | AAPL | Stock | 197.41 | 197.55 | 197.29 | 197.4 | 8542.0 |
| 2024-06-10 05:30:00 | AAPL | Stock | 197.35 | 197.42 | 197.34 | 197.37 | 12609.0 |
| 2024-06-10 06:00:00 | AAPL | Stock | 197.37 | 197.37 | 197.14 | 197.31 | 12355.0 |
| 2024-06-10 06:30:00 | AAPL | Stock | 197.35 | 197.5 | 197.21 | 197.42 | 16380.0 |
| 2024-06-10 07:00:00 | AAPL | Stock | 197.42 | 197.65 | 197.25 | 197.53 | 21748.0 |
| 2024-06-10 07:30:00 | AAPL | Stock | 197.52 | 197.79 | 197.5 | 197.59 | 28819.0 |
| 2024-06-10 08:00:00 | AAPL | Stock | 197.32 | 198.32 | 197.21 | 197.7621 | 208584.0 |
| 2024-06-10 08:30:00 | AAPL | Stock | 197.8 | 197.97 | 197.5 | 197.55 | 112624.0 |
| 2024-06-10 09:00:00 | AAPL | Stock | 197.565 | 197.6469 | 196.52 | 196.89 | 353846.0 |
| 2024-06-10 09:30:00 | AAPL | Stock | 196.88 | 197.3 | 195.12 | 195.409 | 7610408.0 |
| 2024-06-10 10:00:00 | AAPL | Stock | 195.42 | 195.64 | 194.83 | 195.62 | 4101333.0 |
| 2024-06-10 10:30:00 | AAPL | Stock | 195.6217 | 195.74 | 195.37 | 195.385 | 2374529.0 |
| 2024-06-10 11:00:00 | AAPL | Stock | 195.38 | 195.7 | 195.25 | 195.5542 | 1976235.0 |
| 2024-06-10 11:30:00 | AAPL | Stock | 195.55 | 195.64 | 195.07 | 195.23 | 2043057.0 |
| 2024-06-10 12:00:00 | AAPL | Stock | 195.235 | 196.21 | 195.08 | 195.8884 | 3696284.0 |
| 2024-06-10 12:30:00 | AAPL | Stock | 195.89 | 196.15 | 195.44 | 195.62 | 2260451.0 |
| 2024-06-10 13:00:00 | AAPL | Stock | 195.61 | 196.385 | 195.11 | 195.425 | 4070899.0 |
| 2024-06-10 13:30:00 | AAPL | Stock | 195.44 | 195.61 | 193.4 | 194.95 | 7867395.0 |
| 2024-06-10 14:00:00 | AAPL | Stock | 194.95 | 196.45 | 192.15 | 193.16 | 12683243.0 |
| 2024-06-10 14:30:00 | AAPL | Stock | 193.15 | 194.3 | 192.33 | 193.16 | 9101187.0 |
| 2024-06-10 15:00:00 | AAPL | Stock | 193.16 | 194.17 | 192.6006 | 192.965 | 5534435.0 |
| 2024-06-10 15:30:00 | AAPL | Stock | 192.96 | 193.2 | 192.29 | 193.13 | 8437730.0 |
| 2024-06-10 16:00:00 | AAPL | Stock | 193.12 | 193.21 | 192.9001 | 193.0601 | 6061159.0 |
| 2024-06-10 16:30:00 | AAPL | Stock | 193.11 | 193.12 | 192.2206 | 192.85 | 242126.0 |
| 2024-06-10 17:00:00 | AAPL | Stock | 192.8916 | 193.12 | 192.22 | 192.4 | 164165.0 |
| 2024-06-10 17:30:00 | AAPL | Stock | 192.39 | 193.12 | 192.3 | 192.33 | 81294.0 |
| 2024-06-10 18:00:00 | AAPL | Stock | 192.3 | 193.05 | 192.26 | 192.87 | 53705.0 |
| 2024-06-10 18:30:00 | AAPL | Stock | 192.8688 | 192.8688 | 192.5 | 192.54 | 44436.0 |
| 2024-06-10 19:00:00 | AAPL | Stock | 192.55 | 192.55 | 192.32 | 192.37 | 25750.0 |
| 2024-06-10 19:30:00 | AAPL | Stock | 192.37 | 192.79 | 192.22 | 192.33 | 90085.0 |
| 2024-06-10 04:00:00 | MSFT | Stock | 423.8 | 423.9 | 423.65 | 423.85 | 1709.0 |
| 2024-06-10 04:30:00 | MSFT | Stock | 423.93 | 423.93 | 423.67 | 423.67 | 725.0 |
| 2024-06-10 05:00:00 | MSFT | Stock | 423.45 | 423.45 | 423.41 | 423.41 | 300.0 |
| 2024-06-10 05:30:00 | MSFT | Stock | 423.81 | 423.81 | 423.8 | 423.8 | 276.0 |
| 2024-06-10 06:30:00 | MSFT | Stock | 424.19 | 424.21 | 424.19 | 424.21 | 218.0 |
| 2024-06-10 07:00:00 | MSFT | Stock | 423.91 | 424.4 | 423.91 | 424.4 | 930.0 |
| 2024-06-10 07:30:00 | MSFT | Stock | 424.3 | 424.45 | 424.3 | 424.45 | 466.0 |
| 2024-06-10 08:00:00 | MSFT | Stock | 424.0 | 424.72 | 423.0 | 424.49 | 7231.0 |
| 2024-06-10 08:30:00 | MSFT | Stock | 424.45 | 424.79 | 424.25 | 424.51 | 10791.0 |
| 2024-06-10 09:00:00 | MSFT | Stock | 424.5 | 425.23 | 423.85 | 424.22 | 11798.0 |
| 2024-06-10 09:30:00 | MSFT | Stock | 424.66 | 427.8397 | 423.89 | 426.895 | 1168471.0 |
| 2024-06-10 10:00:00 | MSFT | Stock | 426.94 | 427.35 | 425.62 | 427.3 | 579761.0 |
| 2024-06-10 10:30:00 | MSFT | Stock | 427.285 | 427.36 | 426.15 | 426.63 | 280702.0 |
| 2024-06-10 11:00:00 | MSFT | Stock | 426.58 | 427.055 | 426.24 | 426.9001 | 246185.0 |
| 2024-06-10 11:30:00 | MSFT | Stock | 426.96 | 427.67 | 426.69 | 426.88 | 316031.0 |
| 2024-06-10 12:00:00 | MSFT | Stock | 426.875 | 427.38 | 426.31 | 426.48 | 272050.0 |
| 2024-06-10 12:30:00 | MSFT | Stock | 426.43 | 426.49 | 425.79 | 425.9 | 257691.0 |
| 2024-06-10 13:00:00 | MSFT | Stock | 425.88 | 426.36 | 425.5 | 425.7228 | 265845.0 |
> showing 50 of 98,828 rows — these rows as CSV