PREVIEW / stock_30min / 2025-01-23
file: by_date/stock_30min/2025/2025-01-23.parquet size: 2.2 MB rows: 106,859 symbols: 579
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 |
|---|---|---|---|---|---|---|---|
| 2025-01-23 04:00:00 | AAPL | Stock | 223.52 | 223.52 | 222.22 | 222.75 | 14611.0 |
| 2025-01-23 04:30:00 | AAPL | Stock | 222.77 | 222.82 | 222.6 | 222.82 | 6549.0 |
| 2025-01-23 05:00:00 | AAPL | Stock | 222.83 | 222.83 | 222.6 | 222.67 | 5172.0 |
| 2025-01-23 05:30:00 | AAPL | Stock | 222.73 | 222.73 | 222.51 | 222.62 | 4856.0 |
| 2025-01-23 06:00:00 | AAPL | Stock | 222.68 | 223.19 | 222.68 | 223.11 | 21456.0 |
| 2025-01-23 06:30:00 | AAPL | Stock | 223.11 | 223.3 | 222.89 | 223.2 | 14712.0 |
| 2025-01-23 07:00:00 | AAPL | Stock | 223.23 | 223.33 | 223.05 | 223.27 | 21368.0 |
| 2025-01-23 07:30:00 | AAPL | Stock | 223.25 | 224.25 | 223.25 | 224.14 | 47283.0 |
| 2025-01-23 08:00:00 | AAPL | Stock | 223.04 | 224.55 | 222.44 | 224.46 | 200306.0 |
| 2025-01-23 08:30:00 | AAPL | Stock | 224.4388 | 224.84 | 224.12 | 224.7495 | 106124.0 |
| 2025-01-23 09:00:00 | AAPL | Stock | 224.75 | 224.9 | 224.11 | 224.87 | 198432.0 |
| 2025-01-23 09:30:00 | AAPL | Stock | 224.73 | 226.26 | 224.26 | 225.18 | 6236905.0 |
| 2025-01-23 10:00:00 | AAPL | Stock | 225.19 | 227.03 | 224.8903 | 225.97 | 4679914.0 |
| 2025-01-23 10:30:00 | AAPL | Stock | 225.965 | 226.37 | 225.1 | 225.3242 | 2478484.0 |
| 2025-01-23 11:00:00 | AAPL | Stock | 225.3337 | 225.41 | 224.37 | 225.175 | 2552195.0 |
| 2025-01-23 11:30:00 | AAPL | Stock | 225.16 | 225.195 | 223.8 | 224.04 | 2193191.0 |
| 2025-01-23 12:00:00 | AAPL | Stock | 224.06 | 224.16 | 223.3857 | 223.57 | 1671270.0 |
| 2025-01-23 12:30:00 | AAPL | Stock | 223.565 | 223.72 | 223.19 | 223.695 | 1602279.0 |
| 2025-01-23 13:00:00 | AAPL | Stock | 223.69 | 223.78 | 223.4 | 223.55 | 1231167.0 |
| 2025-01-23 13:30:00 | AAPL | Stock | 223.56 | 223.64 | 223.01 | 223.0743 | 1322383.0 |
| 2025-01-23 14:00:00 | AAPL | Stock | 223.075 | 223.1599 | 222.43 | 222.8 | 2042635.0 |
| 2025-01-23 14:30:00 | AAPL | Stock | 222.81 | 222.97 | 222.575 | 222.75 | 1433690.0 |
| 2025-01-23 15:00:00 | AAPL | Stock | 222.74 | 223.17 | 222.6805 | 222.88 | 1640279.0 |
| 2025-01-23 15:30:00 | AAPL | Stock | 222.87 | 223.65 | 222.3 | 223.65 | 5453609.0 |
| 2025-01-23 16:00:00 | AAPL | Stock | 223.65 | 223.9 | 223.0 | 223.2 | 7965852.0 |
| 2025-01-23 16:30:00 | AAPL | Stock | 223.2 | 223.66 | 223.06 | 223.3584 | 42784.0 |
| 2025-01-23 17:00:00 | AAPL | Stock | 223.32 | 223.45 | 223.32 | 223.4 | 11440.0 |
| 2025-01-23 17:30:00 | AAPL | Stock | 223.4 | 223.48 | 223.38 | 223.45 | 9635.0 |
| 2025-01-23 18:00:00 | AAPL | Stock | 223.49 | 223.49 | 223.25 | 223.36 | 9278.0 |
| 2025-01-23 18:30:00 | AAPL | Stock | 223.3561 | 223.4413 | 223.2188 | 223.255 | 9474.0 |
| 2025-01-23 19:00:00 | AAPL | Stock | 223.2601 | 223.35 | 223.15 | 223.252 | 4241.0 |
| 2025-01-23 19:30:00 | AAPL | Stock | 223.2 | 223.25 | 223.1512 | 223.24 | 16053.0 |
| 2025-01-23 04:00:00 | MSFT | Stock | 443.25 | 443.76 | 441.22 | 442.46 | 8489.0 |
| 2025-01-23 04:30:00 | MSFT | Stock | 443.0 | 443.05 | 442.64 | 443.05 | 1850.0 |
| 2025-01-23 05:00:00 | MSFT | Stock | 442.64 | 443.56 | 442.55 | 443.38 | 4087.0 |
| 2025-01-23 05:30:00 | MSFT | Stock | 443.48 | 443.5 | 443.02 | 443.38 | 3695.0 |
| 2025-01-23 06:00:00 | MSFT | Stock | 443.02 | 443.1 | 442.78 | 442.8 | 2637.0 |
| 2025-01-23 06:30:00 | MSFT | Stock | 442.71 | 443.65 | 442.55 | 443.65 | 2948.0 |
| 2025-01-23 07:00:00 | MSFT | Stock | 443.9 | 444.29 | 443.1 | 444.1 | 8421.0 |
| 2025-01-23 07:30:00 | MSFT | Stock | 444.01 | 444.01 | 442.98 | 443.34 | 16293.0 |
| 2025-01-23 08:00:00 | MSFT | Stock | 443.0 | 444.0205 | 442.731 | 443.3 | 18039.0 |
| 2025-01-23 08:30:00 | MSFT | Stock | 443.4 | 443.5 | 442.85 | 443.29 | 5927.0 |
| 2025-01-23 09:00:00 | MSFT | Stock | 443.24 | 443.6197 | 441.75 | 442.11 | 32333.0 |
| 2025-01-23 09:30:00 | MSFT | Stock | 442.23 | 444.48 | 441.5 | 443.83 | 1232245.0 |
| 2025-01-23 10:00:00 | MSFT | Stock | 443.785 | 444.14 | 442.51 | 443.1701 | 502274.0 |
| 2025-01-23 10:30:00 | MSFT | Stock | 443.19 | 443.88 | 442.73 | 442.99 | 463406.0 |
| 2025-01-23 11:00:00 | MSFT | Stock | 442.97 | 443.59 | 441.92 | 443.554 | 559915.0 |
| 2025-01-23 11:30:00 | MSFT | Stock | 443.5995 | 444.15 | 443.29 | 443.605 | 369821.0 |
| 2025-01-23 12:00:00 | MSFT | Stock | 443.65 | 443.71 | 442.78 | 443.1 | 292426.0 |
| 2025-01-23 12:30:00 | MSFT | Stock | 443.055 | 443.09 | 442.4303 | 442.775 | 253859.0 |
> showing 50 of 106,859 rows — these rows as CSV