PREVIEW / stock_30min / 2025-06-06
file: by_date/stock_30min/2025/2025-06-06.parquet size: 2.2 MB rows: 102,899 symbols: 402
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-06 04:00:00 | AAPL | Stock | 201.5 | 201.72 | 201.5 | 201.65 | 4797.0 |
| 2025-06-06 04:30:00 | AAPL | Stock | 201.82 | 201.88 | 201.75 | 201.83 | 3803.0 |
| 2025-06-06 05:00:00 | AAPL | Stock | 201.88 | 201.9 | 201.7 | 201.9 | 3857.0 |
| 2025-06-06 05:30:00 | AAPL | Stock | 201.9 | 201.98 | 201.84 | 201.98 | 2208.0 |
| 2025-06-06 06:00:00 | AAPL | Stock | 201.9 | 201.98 | 201.74 | 201.92 | 11997.0 |
| 2025-06-06 06:30:00 | AAPL | Stock | 201.92 | 201.92 | 201.5 | 201.61 | 4657.0 |
| 2025-06-06 07:00:00 | AAPL | Stock | 201.56 | 201.62 | 201.38 | 201.5 | 8129.0 |
| 2025-06-06 07:30:00 | AAPL | Stock | 201.51 | 201.65 | 201.48 | 201.51 | 4476.0 |
| 2025-06-06 08:00:00 | AAPL | Stock | 201.68 | 201.91 | 201.2 | 201.5 | 51548.0 |
| 2025-06-06 08:30:00 | AAPL | Stock | 201.52 | 202.57 | 201.52 | 202.43 | 107601.0 |
| 2025-06-06 09:00:00 | AAPL | Stock | 202.4306 | 203.0 | 202.08 | 202.99 | 102142.0 |
| 2025-06-06 09:30:00 | AAPL | Stock | 203.0 | 205.7 | 202.9831 | 204.54 | 5929468.0 |
| 2025-06-06 10:00:00 | AAPL | Stock | 204.57 | 204.7446 | 203.33 | 203.66 | 2107545.0 |
| 2025-06-06 10:30:00 | AAPL | Stock | 203.65 | 203.92 | 203.12 | 203.15 | 1770508.0 |
| 2025-06-06 11:00:00 | AAPL | Stock | 203.14 | 204.06 | 202.86 | 203.04 | 1918501.0 |
| 2025-06-06 11:30:00 | AAPL | Stock | 203.04 | 203.6 | 202.87 | 203.045 | 1128842.0 |
| 2025-06-06 12:00:00 | AAPL | Stock | 203.05 | 203.1808 | 202.61 | 202.625 | 1192686.0 |
| 2025-06-06 12:30:00 | AAPL | Stock | 202.63 | 202.7757 | 202.05 | 202.695 | 1459347.0 |
| 2025-06-06 13:00:00 | AAPL | Stock | 202.69 | 203.78 | 202.61 | 203.59 | 1343851.0 |
| 2025-06-06 13:30:00 | AAPL | Stock | 203.6 | 204.15 | 203.59 | 204.055 | 1198131.0 |
| 2025-06-06 14:00:00 | AAPL | Stock | 204.06 | 205.21 | 204.0401 | 204.985 | 2009337.0 |
| 2025-06-06 14:30:00 | AAPL | Stock | 204.99 | 205.47 | 204.99 | 205.265 | 1452601.0 |
| 2025-06-06 15:00:00 | AAPL | Stock | 205.25 | 205.3 | 204.68 | 204.7 | 1542943.0 |
| 2025-06-06 15:30:00 | AAPL | Stock | 204.695 | 205.22 | 203.895 | 203.93 | 4369714.0 |
| 2025-06-06 16:00:00 | AAPL | Stock | 203.97 | 204.2 | 203.64 | 204.08 | 6388633.0 |
| 2025-06-06 16:30:00 | AAPL | Stock | 204.0485 | 204.1489 | 203.9 | 204.03 | 42381.0 |
| 2025-06-06 17:00:00 | AAPL | Stock | 204.0201 | 204.2 | 204.01 | 204.06 | 22845.0 |
| 2025-06-06 17:30:00 | AAPL | Stock | 204.06 | 204.12 | 203.9 | 204.0 | 26881.0 |
| 2025-06-06 18:00:00 | AAPL | Stock | 204.05 | 204.33 | 204.03 | 204.33 | 17188.0 |
| 2025-06-06 18:30:00 | AAPL | Stock | 204.45 | 204.5 | 204.25 | 204.48 | 9715.0 |
| 2025-06-06 19:00:00 | AAPL | Stock | 204.5 | 204.67 | 204.48 | 204.52 | 14844.0 |
| 2025-06-06 19:30:00 | AAPL | Stock | 204.5193 | 204.63 | 204.36 | 204.47 | 17952.0 |
| 2025-06-06 04:00:00 | MSFT | Stock | 469.05 | 469.26 | 469.0 | 469.25 | 2586.0 |
| 2025-06-06 04:30:00 | MSFT | Stock | 469.32 | 469.9 | 469.32 | 469.9 | 1844.0 |
| 2025-06-06 05:00:00 | MSFT | Stock | 469.34 | 469.45 | 469.34 | 469.45 | 238.0 |
| 2025-06-06 06:00:00 | MSFT | Stock | 469.37 | 469.65 | 469.35 | 469.35 | 1075.0 |
| 2025-06-06 06:30:00 | MSFT | Stock | 469.58 | 469.58 | 469.14 | 469.14 | 1754.0 |
| 2025-06-06 07:00:00 | MSFT | Stock | 469.11 | 469.25 | 469.0 | 469.0 | 1439.0 |
| 2025-06-06 07:30:00 | MSFT | Stock | 469.4 | 469.4 | 469.4 | 469.4 | 200.0 |
| 2025-06-06 08:00:00 | MSFT | Stock | 469.22 | 469.85 | 467.68 | 469.5 | 11940.0 |
| 2025-06-06 08:30:00 | MSFT | Stock | 469.0 | 470.8 | 469.0 | 470.8 | 29192.0 |
| 2025-06-06 09:00:00 | MSFT | Stock | 470.7 | 471.4 | 468.53 | 470.0 | 35158.0 |
| 2025-06-06 09:30:00 | MSFT | Stock | 470.01 | 472.7099 | 469.13 | 472.16 | 1898320.0 |
| 2025-06-06 10:00:00 | MSFT | Stock | 472.19 | 473.335 | 471.45 | 471.77 | 731135.0 |
| 2025-06-06 10:30:00 | MSFT | Stock | 471.73 | 472.34 | 471.06 | 471.0824 | 570434.0 |
| 2025-06-06 11:00:00 | MSFT | Stock | 471.07 | 471.95 | 469.58 | 470.67 | 413356.0 |
| 2025-06-06 11:30:00 | MSFT | Stock | 470.67 | 471.225 | 470.37 | 470.77 | 260173.0 |
| 2025-06-06 12:00:00 | MSFT | Stock | 470.77 | 471.01 | 470.1 | 470.17 | 207690.0 |
| 2025-06-06 12:30:00 | MSFT | Stock | 470.17 | 470.27 | 468.78 | 469.5 | 300506.0 |
| 2025-06-06 13:00:00 | MSFT | Stock | 469.47 | 470.72 | 469.32 | 470.56 | 276833.0 |
> showing 50 of 102,899 rows — these rows as CSV