PREVIEW / stock_30min / 2025-06-20
file: by_date/stock_30min/2025/2025-06-20.parquet size: 2.2 MB rows: 106,420 symbols: 399
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-06-20 04:00:00 | AAPL | Stock | 196.0 | 196.5 | 196.0 | 196.24 | 13652.0 |
| 2025-06-20 04:30:00 | AAPL | Stock | 196.23 | 196.25 | 195.7 | 195.73 | 7192.0 |
| 2025-06-20 05:00:00 | AAPL | Stock | 195.71 | 196.0 | 195.71 | 195.95 | 9547.0 |
| 2025-06-20 05:30:00 | AAPL | Stock | 195.96 | 196.11 | 195.92 | 196.1 | 13519.0 |
| 2025-06-20 06:00:00 | AAPL | Stock | 196.08 | 196.11 | 195.9 | 195.9 | 7885.0 |
| 2025-06-20 06:30:00 | AAPL | Stock | 195.94 | 196.04 | 195.94 | 195.95 | 1730.0 |
| 2025-06-20 07:00:00 | AAPL | Stock | 195.94 | 196.11 | 195.84 | 196.0 | 15609.0 |
| 2025-06-20 07:30:00 | AAPL | Stock | 196.0 | 196.7 | 195.99 | 196.6 | 21390.0 |
| 2025-06-20 08:00:00 | AAPL | Stock | 196.01 | 196.86 | 195.77 | 196.55 | 67106.0 |
| 2025-06-20 08:30:00 | AAPL | Stock | 196.5775 | 197.48 | 196.5775 | 197.39 | 75993.0 |
| 2025-06-20 09:00:00 | AAPL | Stock | 197.38 | 199.03 | 196.91 | 198.1 | 351316.0 |
| 2025-06-20 09:30:00 | AAPL | Stock | 198.12 | 200.95 | 197.52 | 199.845 | 15812776.0 |
| 2025-06-20 10:00:00 | AAPL | Stock | 199.84 | 199.94 | 198.5589 | 198.68 | 2494534.0 |
| 2025-06-20 10:30:00 | AAPL | Stock | 198.69 | 198.69 | 197.035 | 197.2798 | 2498054.0 |
| 2025-06-20 11:00:00 | AAPL | Stock | 197.26 | 198.0597 | 196.855 | 197.68 | 2427320.0 |
| 2025-06-20 11:30:00 | AAPL | Stock | 197.67 | 199.0 | 197.62 | 198.08 | 2251624.0 |
| 2025-06-20 12:00:00 | AAPL | Stock | 198.07 | 198.536 | 197.9 | 198.49 | 1137634.0 |
| 2025-06-20 12:30:00 | AAPL | Stock | 198.49 | 198.9391 | 198.29 | 198.81 | 1678876.0 |
| 2025-06-20 13:00:00 | AAPL | Stock | 198.81 | 199.41 | 198.27 | 198.32 | 1339695.0 |
| 2025-06-20 13:30:00 | AAPL | Stock | 198.32 | 199.18 | 198.07 | 199.14 | 1901852.0 |
| 2025-06-20 14:00:00 | AAPL | Stock | 199.145 | 200.19 | 199.1129 | 199.81 | 1931672.0 |
| 2025-06-20 14:30:00 | AAPL | Stock | 199.82 | 200.17 | 199.65 | 199.71 | 2214141.0 |
| 2025-06-20 15:00:00 | AAPL | Stock | 199.71 | 200.3367 | 199.6001 | 199.93 | 2904434.0 |
| 2025-06-20 15:30:00 | AAPL | Stock | 199.92 | 201.7 | 199.77 | 200.92 | 8499586.0 |
| 2025-06-20 16:00:00 | AAPL | Stock | 200.92 | 201.55 | 200.47 | 200.89 | 22896514.0 |
| 2025-06-20 16:30:00 | AAPL | Stock | 200.89 | 201.0 | 200.5513 | 200.6 | 68466.0 |
| 2025-06-20 17:00:00 | AAPL | Stock | 200.5619 | 201.1 | 200.5619 | 201.0285 | 103785.0 |
| 2025-06-20 17:30:00 | AAPL | Stock | 201.0218 | 201.51 | 200.98 | 201.4 | 109686.0 |
| 2025-06-20 18:00:00 | AAPL | Stock | 201.4 | 201.53 | 201.4 | 201.5 | 56252.0 |
| 2025-06-20 18:30:00 | AAPL | Stock | 201.53 | 201.7885 | 201.5 | 201.7 | 64527.0 |
| 2025-06-20 19:00:00 | AAPL | Stock | 201.71 | 201.71 | 201.12 | 201.21 | 30973.0 |
| 2025-06-20 19:30:00 | AAPL | Stock | 201.2109 | 201.42 | 201.1836 | 201.2901 | 41623.0 |
| 2025-06-20 04:00:00 | MSFT | Stock | 480.08 | 480.08 | 479.02 | 479.02 | 4360.0 |
| 2025-06-20 04:30:00 | MSFT | Stock | 479.02 | 479.02 | 478.61 | 478.61 | 313.0 |
| 2025-06-20 05:00:00 | MSFT | Stock | 478.03 | 478.74 | 478.0 | 478.5 | 1765.0 |
| 2025-06-20 05:30:00 | MSFT | Stock | 478.59 | 479.02 | 478.59 | 479.02 | 724.0 |
| 2025-06-20 06:00:00 | MSFT | Stock | 478.9 | 478.93 | 478.66 | 478.66 | 700.0 |
| 2025-06-20 06:30:00 | MSFT | Stock | 479.08 | 479.1 | 479.08 | 479.1 | 750.0 |
| 2025-06-20 07:00:00 | MSFT | Stock | 478.86 | 479.6 | 478.86 | 479.3 | 4245.0 |
| 2025-06-20 07:30:00 | MSFT | Stock | 479.46 | 480.34 | 479.46 | 479.75 | 3039.0 |
| 2025-06-20 08:00:00 | MSFT | Stock | 479.14 | 480.7 | 477.88 | 480.67 | 13252.0 |
| 2025-06-20 08:30:00 | MSFT | Stock | 480.6 | 481.14 | 480.46 | 480.95 | 18288.0 |
| 2025-06-20 09:00:00 | MSFT | Stock | 480.93 | 483.84 | 478.08 | 482.0 | 219378.0 |
| 2025-06-20 09:30:00 | MSFT | Stock | 482.23 | 483.46 | 480.23 | 480.67 | 5987762.0 |
| 2025-06-20 10:00:00 | MSFT | Stock | 480.66 | 481.438 | 479.14 | 479.6 | 603774.0 |
| 2025-06-20 10:30:00 | MSFT | Stock | 479.62 | 480.75 | 479.37 | 479.93 | 591292.0 |
| 2025-06-20 11:00:00 | MSFT | Stock | 479.83 | 480.48 | 478.9 | 479.93 | 374158.0 |
| 2025-06-20 11:30:00 | MSFT | Stock | 479.91 | 481.08 | 479.8 | 480.025 | 307184.0 |
| 2025-06-20 12:00:00 | MSFT | Stock | 480.025 | 480.5 | 479.38 | 479.76 | 407993.0 |
| 2025-06-20 12:30:00 | MSFT | Stock | 479.7 | 480.65 | 479.64 | 480.2 | 321740.0 |
> showing 50 of 106,420 rows — these rows as CSV