PREVIEW / stock_30min / 2024-12-31
file: by_date/stock_30min/2024/2024-12-31.parquet size: 2.2 MB rows: 108,351 symbols: 610
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-12-31 04:00:00 | AAPL | Stock | 252.14 | 252.93 | 251.85 | 252.93 | 2559.0 |
| 2024-12-31 04:30:00 | AAPL | Stock | 252.97 | 253.26 | 252.84 | 253.25 | 7131.0 |
| 2024-12-31 05:00:00 | AAPL | Stock | 253.2 | 253.2 | 252.92 | 252.92 | 900.0 |
| 2024-12-31 05:30:00 | AAPL | Stock | 252.81 | 253.4 | 252.81 | 253.08 | 2764.0 |
| 2024-12-31 06:00:00 | AAPL | Stock | 253.1 | 253.15 | 252.81 | 252.93 | 2351.0 |
| 2024-12-31 06:30:00 | AAPL | Stock | 252.91 | 253.21 | 252.88 | 253.2 | 3891.0 |
| 2024-12-31 07:00:00 | AAPL | Stock | 253.09 | 253.48 | 252.98 | 253.4 | 18568.0 |
| 2024-12-31 07:30:00 | AAPL | Stock | 253.32 | 253.34 | 252.72 | 252.8 | 14073.0 |
| 2024-12-31 08:00:00 | AAPL | Stock | 253.15 | 253.47 | 252.17 | 252.55 | 52963.0 |
| 2024-12-31 08:30:00 | AAPL | Stock | 252.3157 | 252.72 | 252.31 | 252.31 | 11629.0 |
| 2024-12-31 09:00:00 | AAPL | Stock | 252.3 | 252.4688 | 252.06 | 252.4688 | 24459.0 |
| 2024-12-31 09:30:00 | AAPL | Stock | 252.44 | 253.28 | 251.5501 | 252.269 | 2669312.0 |
| 2024-12-31 10:00:00 | AAPL | Stock | 252.25 | 252.4 | 251.31 | 251.6877 | 1206734.0 |
| 2024-12-31 10:30:00 | AAPL | Stock | 251.71 | 252.1399 | 251.4 | 251.8185 | 928728.0 |
| 2024-12-31 11:00:00 | AAPL | Stock | 251.83 | 251.846 | 251.02 | 251.18 | 936892.0 |
| 2024-12-31 11:30:00 | AAPL | Stock | 251.18 | 251.55 | 251.04 | 251.315 | 637855.0 |
| 2024-12-31 12:00:00 | AAPL | Stock | 251.32 | 251.53 | 250.65 | 250.7163 | 893324.0 |
| 2024-12-31 12:30:00 | AAPL | Stock | 250.7 | 250.76 | 250.06 | 250.67 | 1349238.0 |
| 2024-12-31 13:00:00 | AAPL | Stock | 250.66 | 250.74 | 249.43 | 249.68 | 1362737.0 |
| 2024-12-31 13:30:00 | AAPL | Stock | 249.69 | 250.205 | 249.53 | 249.88 | 820266.0 |
| 2024-12-31 14:00:00 | AAPL | Stock | 249.8899 | 250.268 | 249.67 | 249.77 | 916156.0 |
| 2024-12-31 14:30:00 | AAPL | Stock | 249.765 | 250.43 | 249.69 | 250.42 | 966979.0 |
| 2024-12-31 15:00:00 | AAPL | Stock | 250.41 | 250.88 | 249.79 | 250.7701 | 1708210.0 |
| 2024-12-31 15:30:00 | AAPL | Stock | 250.77 | 251.08 | 249.5 | 250.38 | 4592835.0 |
| 2024-12-31 16:00:00 | AAPL | Stock | 250.46 | 250.67 | 250.2 | 250.501 | 7562294.0 |
| 2024-12-31 16:30:00 | AAPL | Stock | 250.51 | 250.59 | 250.42 | 250.43 | 18571.0 |
| 2024-12-31 17:00:00 | AAPL | Stock | 250.43 | 250.5 | 250.42 | 250.5 | 5764.0 |
| 2024-12-31 17:30:00 | AAPL | Stock | 250.48 | 250.48 | 250.41 | 250.433 | 1928.0 |
| 2024-12-31 18:00:00 | AAPL | Stock | 250.4406 | 250.47 | 250.43 | 250.44 | 1071.0 |
| 2024-12-31 18:30:00 | AAPL | Stock | 250.49 | 250.49 | 250.4209 | 250.4219 | 720.0 |
| 2024-12-31 19:00:00 | AAPL | Stock | 250.4216 | 250.45 | 250.42 | 250.4215 | 4641.0 |
| 2024-12-31 19:30:00 | AAPL | Stock | 250.4101 | 250.45 | 250.41 | 250.41 | 1889.0 |
| 2024-12-31 04:00:00 | MSFT | Stock | 424.87 | 427.5 | 424.87 | 427.11 | 4796.0 |
| 2024-12-31 04:30:00 | MSFT | Stock | 427.21 | 427.48 | 426.82 | 426.82 | 1959.0 |
| 2024-12-31 05:00:00 | MSFT | Stock | 426.7 | 426.7 | 426.7 | 426.7 | 100.0 |
| 2024-12-31 05:30:00 | MSFT | Stock | 427.38 | 427.5 | 427.38 | 427.5 | 200.0 |
| 2024-12-31 06:00:00 | MSFT | Stock | 427.4 | 427.4 | 427.0 | 427.0 | 543.0 |
| 2024-12-31 06:30:00 | MSFT | Stock | 427.42 | 427.42 | 427.42 | 427.42 | 285.0 |
| 2024-12-31 07:00:00 | MSFT | Stock | 427.34 | 427.49 | 426.95 | 426.95 | 2836.0 |
| 2024-12-31 07:30:00 | MSFT | Stock | 427.01 | 427.01 | 426.01 | 426.24 | 2675.0 |
| 2024-12-31 08:00:00 | MSFT | Stock | 427.48 | 427.48 | 424.1 | 426.16 | 19390.0 |
| 2024-12-31 08:30:00 | MSFT | Stock | 426.4797 | 426.4797 | 426.0 | 426.0 | 3153.0 |
| 2024-12-31 09:00:00 | MSFT | Stock | 426.0 | 426.75 | 425.21 | 425.54 | 7857.0 |
| 2024-12-31 09:30:00 | MSFT | Stock | 426.26 | 426.73 | 424.205 | 425.62 | 688191.0 |
| 2024-12-31 10:00:00 | MSFT | Stock | 425.66 | 426.37 | 424.5775 | 425.2 | 385284.0 |
| 2024-12-31 10:30:00 | MSFT | Stock | 425.12 | 425.605 | 424.0001 | 424.76 | 265299.0 |
| 2024-12-31 11:00:00 | MSFT | Stock | 424.825 | 424.8688 | 422.85 | 423.4813 | 264522.0 |
| 2024-12-31 11:30:00 | MSFT | Stock | 423.32 | 423.95 | 422.78 | 423.19 | 233246.0 |
| 2024-12-31 12:00:00 | MSFT | Stock | 423.19 | 423.44 | 422.26 | 422.33 | 224794.0 |
| 2024-12-31 12:30:00 | MSFT | Stock | 422.315 | 423.6834 | 421.864 | 423.6834 | 364661.0 |
> showing 50 of 108,351 rows — these rows as CSV