PREVIEW / stock_30min / 2024-09-24
file: by_date/stock_30min/2024/2024-09-24.parquet size: 2.1 MB rows: 100,758 symbols: 799
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-09-24 04:00:00 | AAPL | Stock | 226.97 | 228.12 | 226.97 | 227.92 | 23922.0 |
| 2024-09-24 04:30:00 | AAPL | Stock | 227.99 | 228.01 | 227.73 | 227.97 | 16366.0 |
| 2024-09-24 05:00:00 | AAPL | Stock | 227.99 | 228.0 | 227.76 | 227.96 | 4340.0 |
| 2024-09-24 05:30:00 | AAPL | Stock | 228.0 | 228.57 | 228.0 | 228.15 | 12785.0 |
| 2024-09-24 06:00:00 | AAPL | Stock | 228.12 | 228.38 | 228.06 | 228.22 | 7694.0 |
| 2024-09-24 06:30:00 | AAPL | Stock | 228.25 | 228.36 | 227.82 | 227.85 | 10492.0 |
| 2024-09-24 07:00:00 | AAPL | Stock | 227.8 | 227.9 | 227.0 | 227.52 | 38186.0 |
| 2024-09-24 07:30:00 | AAPL | Stock | 227.6 | 228.16 | 227.6 | 227.76 | 33783.0 |
| 2024-09-24 08:00:00 | AAPL | Stock | 227.5 | 228.4 | 225.904 | 228.166 | 120992.0 |
| 2024-09-24 08:30:00 | AAPL | Stock | 228.11 | 228.1553 | 227.95 | 228.1 | 23448.0 |
| 2024-09-24 09:00:00 | AAPL | Stock | 228.08 | 228.88 | 228.05 | 228.6 | 59063.0 |
| 2024-09-24 09:30:00 | AAPL | Stock | 228.59 | 229.35 | 227.17 | 227.41 | 3187708.0 |
| 2024-09-24 10:00:00 | AAPL | Stock | 227.43 | 227.43 | 226.05 | 226.07 | 2205354.0 |
| 2024-09-24 10:30:00 | AAPL | Stock | 226.07 | 227.3 | 225.73 | 227.185 | 1989965.0 |
| 2024-09-24 11:00:00 | AAPL | Stock | 227.1857 | 227.48 | 226.93 | 227.0121 | 1090486.0 |
| 2024-09-24 11:30:00 | AAPL | Stock | 227.02 | 227.615 | 226.7 | 227.45 | 955983.0 |
| 2024-09-24 12:00:00 | AAPL | Stock | 227.465 | 227.7394 | 227.44 | 227.55 | 763779.0 |
| 2024-09-24 12:30:00 | AAPL | Stock | 227.54 | 227.76 | 226.97 | 227.0 | 706037.0 |
| 2024-09-24 13:00:00 | AAPL | Stock | 227.0195 | 227.3 | 226.81 | 227.24 | 695571.0 |
| 2024-09-24 13:30:00 | AAPL | Stock | 227.2422 | 227.49 | 227.15 | 227.29 | 649945.0 |
| 2024-09-24 14:00:00 | AAPL | Stock | 227.3 | 227.39 | 226.81 | 226.8791 | 774077.0 |
| 2024-09-24 14:30:00 | AAPL | Stock | 226.87 | 227.0588 | 226.54 | 226.87 | 709333.0 |
| 2024-09-24 15:00:00 | AAPL | Stock | 226.87 | 227.09 | 226.84 | 227.026 | 697896.0 |
| 2024-09-24 15:30:00 | AAPL | Stock | 227.04 | 227.5 | 226.2 | 227.36 | 2925283.0 |
| 2024-09-24 16:00:00 | AAPL | Stock | 227.37 | 227.77 | 227.13 | 227.65 | 13213233.0 |
| 2024-09-24 16:30:00 | AAPL | Stock | 227.65 | 227.76 | 227.37 | 227.56 | 52191.0 |
| 2024-09-24 17:00:00 | AAPL | Stock | 227.52 | 227.75 | 227.42 | 227.75 | 5327.0 |
| 2024-09-24 17:30:00 | AAPL | Stock | 227.65 | 227.72 | 227.37 | 227.5701 | 450215.0 |
| 2024-09-24 18:00:00 | AAPL | Stock | 227.64 | 227.64 | 227.5202 | 227.56 | 8883.0 |
| 2024-09-24 18:30:00 | AAPL | Stock | 227.5286 | 227.54 | 227.43 | 227.54 | 6207.0 |
| 2024-09-24 19:00:00 | AAPL | Stock | 227.54 | 227.72 | 227.53 | 227.6497 | 15872.0 |
| 2024-09-24 19:30:00 | AAPL | Stock | 227.65 | 227.65 | 227.41 | 227.5128 | 22284.0 |
| 2024-09-24 04:00:00 | MSFT | Stock | 434.0 | 434.48 | 433.7 | 433.98 | 1736.0 |
| 2024-09-24 04:30:00 | MSFT | Stock | 433.64 | 433.89 | 433.64 | 433.88 | 308.0 |
| 2024-09-24 05:00:00 | MSFT | Stock | 433.6 | 433.6 | 433.4 | 433.4 | 688.0 |
| 2024-09-24 05:30:00 | MSFT | Stock | 433.45 | 433.8 | 433.39 | 433.8 | 716.0 |
| 2024-09-24 06:00:00 | MSFT | Stock | 433.5 | 433.5 | 433.49 | 433.49 | 200.0 |
| 2024-09-24 06:30:00 | MSFT | Stock | 433.49 | 433.6 | 433.25 | 433.25 | 2629.0 |
| 2024-09-24 07:00:00 | MSFT | Stock | 433.2 | 433.2 | 432.25 | 433.0 | 5583.0 |
| 2024-09-24 07:30:00 | MSFT | Stock | 433.46 | 433.5 | 433.2 | 433.2 | 2591.0 |
| 2024-09-24 08:00:00 | MSFT | Stock | 433.25 | 433.5829 | 432.43 | 433.1 | 9803.0 |
| 2024-09-24 08:30:00 | MSFT | Stock | 433.311 | 433.311 | 432.9 | 432.9486 | 4034.0 |
| 2024-09-24 09:00:00 | MSFT | Stock | 433.26 | 433.7574 | 433.08 | 433.08 | 11498.0 |
| 2024-09-24 09:30:00 | MSFT | Stock | 433.0 | 433.35 | 428.83 | 429.0509 | 1382402.0 |
| 2024-09-24 10:00:00 | MSFT | Stock | 429.02 | 429.2229 | 426.63 | 426.85 | 927727.0 |
| 2024-09-24 10:30:00 | MSFT | Stock | 426.86 | 428.43 | 426.1 | 428.37 | 810410.0 |
| 2024-09-24 11:00:00 | MSFT | Stock | 428.365 | 429.73 | 428.33 | 429.1272 | 558259.0 |
| 2024-09-24 11:30:00 | MSFT | Stock | 429.19 | 429.77 | 428.27 | 429.7 | 444676.0 |
| 2024-09-24 12:00:00 | MSFT | Stock | 429.7 | 430.5396 | 429.51 | 429.895 | 286312.0 |
| 2024-09-24 12:30:00 | MSFT | Stock | 429.84 | 430.37 | 428.88 | 428.92 | 232791.0 |
> showing 50 of 100,758 rows — these rows as CSV