PREVIEW / stock_30min / 2024-12-18
file: by_date/stock_30min/2024/2024-12-18.parquet size: 2.3 MB rows: 110,616 symbols: 665
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-18 04:00:00 | AAPL | Stock | 253.6 | 253.61 | 253.03 | 253.03 | 7371.0 |
| 2024-12-18 04:30:00 | AAPL | Stock | 253.15 | 253.33 | 253.15 | 253.3 | 300.0 |
| 2024-12-18 05:00:00 | AAPL | Stock | 253.36 | 253.5 | 253.33 | 253.5 | 3057.0 |
| 2024-12-18 05:30:00 | AAPL | Stock | 253.49 | 253.49 | 253.36 | 253.42 | 1526.0 |
| 2024-12-18 06:00:00 | AAPL | Stock | 253.45 | 253.45 | 253.31 | 253.31 | 1534.0 |
| 2024-12-18 06:30:00 | AAPL | Stock | 253.31 | 253.31 | 253.15 | 253.16 | 2033.0 |
| 2024-12-18 07:00:00 | AAPL | Stock | 253.21 | 253.36 | 253.15 | 253.33 | 8021.0 |
| 2024-12-18 07:30:00 | AAPL | Stock | 253.3 | 253.5 | 253.11 | 253.35 | 7871.0 |
| 2024-12-18 08:00:00 | AAPL | Stock | 253.28 | 253.97 | 253.1001 | 253.57 | 36343.0 |
| 2024-12-18 08:30:00 | AAPL | Stock | 253.5401 | 253.5999 | 252.421 | 252.421 | 99177.0 |
| 2024-12-18 09:00:00 | AAPL | Stock | 252.4207 | 252.6 | 252.0 | 252.18 | 84647.0 |
| 2024-12-18 09:30:00 | AAPL | Stock | 252.16 | 253.4 | 251.33 | 252.02 | 3821156.0 |
| 2024-12-18 10:00:00 | AAPL | Stock | 252.035 | 253.3254 | 251.98 | 253.07 | 1801308.0 |
| 2024-12-18 10:30:00 | AAPL | Stock | 253.07 | 253.8 | 252.9 | 253.4701 | 1650123.0 |
| 2024-12-18 11:00:00 | AAPL | Stock | 253.52 | 253.54 | 252.84 | 253.32 | 1117500.0 |
| 2024-12-18 11:30:00 | AAPL | Stock | 253.3236 | 253.62 | 253.175 | 253.4309 | 730615.0 |
| 2024-12-18 12:00:00 | AAPL | Stock | 253.43 | 254.04 | 253.3506 | 253.635 | 1110647.0 |
| 2024-12-18 12:30:00 | AAPL | Stock | 253.63 | 253.98 | 253.465 | 253.8535 | 982795.0 |
| 2024-12-18 13:00:00 | AAPL | Stock | 253.85 | 254.01 | 253.61 | 253.7101 | 1005237.0 |
| 2024-12-18 13:30:00 | AAPL | Stock | 253.71 | 254.28 | 253.67 | 254.09 | 1087707.0 |
| 2024-12-18 14:00:00 | AAPL | Stock | 254.08 | 254.1 | 251.5 | 252.45 | 2501732.0 |
| 2024-12-18 14:30:00 | AAPL | Stock | 252.449 | 252.98 | 250.92 | 251.05 | 2213694.0 |
| 2024-12-18 15:00:00 | AAPL | Stock | 251.02 | 251.38 | 249.5 | 249.9 | 3551300.0 |
| 2024-12-18 15:30:00 | AAPL | Stock | 249.91 | 250.3992 | 247.74 | 247.86 | 6765474.0 |
| 2024-12-18 16:00:00 | AAPL | Stock | 247.83 | 248.05 | 246.0 | 247.6 | 14708625.0 |
| 2024-12-18 16:30:00 | AAPL | Stock | 247.76 | 248.49 | 246.95 | 246.95 | 162477.0 |
| 2024-12-18 17:00:00 | AAPL | Stock | 246.97 | 248.05 | 246.6814 | 247.31 | 60450.0 |
| 2024-12-18 17:30:00 | AAPL | Stock | 247.39 | 247.49 | 246.41 | 246.6095 | 40814.0 |
| 2024-12-18 18:00:00 | AAPL | Stock | 246.65 | 247.4014 | 246.5 | 247.34 | 33651.0 |
| 2024-12-18 18:30:00 | AAPL | Stock | 247.3 | 247.98 | 246.6 | 246.77 | 43126.0 |
| 2024-12-18 19:00:00 | AAPL | Stock | 246.89 | 247.13 | 246.6 | 247.13 | 12696.0 |
| 2024-12-18 19:30:00 | AAPL | Stock | 247.11 | 247.19 | 246.7836 | 247.19 | 30709.0 |
| 2024-12-18 04:00:00 | MSFT | Stock | 455.22 | 455.22 | 454.41 | 454.53 | 3480.0 |
| 2024-12-18 04:30:00 | MSFT | Stock | 454.53 | 454.78 | 454.53 | 454.78 | 1967.0 |
| 2024-12-18 05:00:00 | MSFT | Stock | 454.83 | 455.09 | 454.68 | 455.0 | 3338.0 |
| 2024-12-18 05:30:00 | MSFT | Stock | 454.89 | 454.99 | 454.72 | 454.8 | 2029.0 |
| 2024-12-18 06:00:00 | MSFT | Stock | 454.77 | 455.0 | 454.59 | 454.62 | 4533.0 |
| 2024-12-18 06:30:00 | MSFT | Stock | 454.69 | 454.7 | 454.6 | 454.65 | 862.0 |
| 2024-12-18 07:00:00 | MSFT | Stock | 454.65 | 454.7 | 454.5 | 454.5 | 2144.0 |
| 2024-12-18 07:30:00 | MSFT | Stock | 454.46 | 454.46 | 452.66 | 452.68 | 19330.0 |
| 2024-12-18 08:00:00 | MSFT | Stock | 454.6991 | 455.23 | 452.5 | 453.6 | 19945.0 |
| 2024-12-18 08:30:00 | MSFT | Stock | 453.7 | 453.7 | 451.98 | 451.98 | 16281.0 |
| 2024-12-18 09:00:00 | MSFT | Stock | 451.65 | 451.8 | 449.92 | 451.41 | 69273.0 |
| 2024-12-18 09:30:00 | MSFT | Stock | 451.3 | 452.32 | 446.1599 | 448.24 | 1967084.0 |
| 2024-12-18 10:00:00 | MSFT | Stock | 448.2975 | 450.49 | 447.77 | 450.37 | 621904.0 |
| 2024-12-18 10:30:00 | MSFT | Stock | 450.37 | 451.75 | 449.28 | 450.9732 | 533364.0 |
| 2024-12-18 11:00:00 | MSFT | Stock | 451.005 | 452.27 | 450.82 | 452.115 | 547335.0 |
| 2024-12-18 11:30:00 | MSFT | Stock | 452.17 | 452.62 | 451.78 | 452.14 | 335685.0 |
| 2024-12-18 12:00:00 | MSFT | Stock | 452.195 | 452.51 | 451.5 | 451.58 | 331282.0 |
| 2024-12-18 12:30:00 | MSFT | Stock | 451.55 | 452.65 | 451.2889 | 452.1 | 274352.0 |
> showing 50 of 110,616 rows — these rows as CSV