PREVIEW / stock_30min / 2024-08-16
file: by_date/stock_30min/2024/2024-08-16.parquet size: 2.0 MB rows: 97,181 symbols: 843
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-08-16 04:00:00 | AAPL | Stock | 225.61 | 225.61 | 225.34 | 225.34 | 6091.0 |
| 2024-08-16 04:30:00 | AAPL | Stock | 225.45 | 225.63 | 225.3 | 225.3 | 12765.0 |
| 2024-08-16 05:00:00 | AAPL | Stock | 225.38 | 225.44 | 225.31 | 225.44 | 3699.0 |
| 2024-08-16 05:30:00 | AAPL | Stock | 225.46 | 225.46 | 225.33 | 225.4 | 2214.0 |
| 2024-08-16 06:00:00 | AAPL | Stock | 225.37 | 225.42 | 225.23 | 225.42 | 3850.0 |
| 2024-08-16 06:30:00 | AAPL | Stock | 225.32 | 225.32 | 225.0 | 225.2 | 3737.0 |
| 2024-08-16 07:00:00 | AAPL | Stock | 225.27 | 225.39 | 224.93 | 224.95 | 14197.0 |
| 2024-08-16 07:30:00 | AAPL | Stock | 224.93 | 225.2 | 224.9 | 224.9 | 5705.0 |
| 2024-08-16 08:00:00 | AAPL | Stock | 224.9 | 225.64 | 224.3 | 224.38 | 82767.0 |
| 2024-08-16 08:30:00 | AAPL | Stock | 224.35 | 224.35 | 223.52 | 224.04 | 57012.0 |
| 2024-08-16 09:00:00 | AAPL | Stock | 223.9994 | 224.9 | 223.04 | 224.0 | 210250.0 |
| 2024-08-16 09:30:00 | AAPL | Stock | 224.1 | 224.69 | 223.6501 | 224.115 | 5127989.0 |
| 2024-08-16 10:00:00 | AAPL | Stock | 224.08 | 225.03 | 224.02 | 224.39 | 1765428.0 |
| 2024-08-16 10:30:00 | AAPL | Stock | 224.39 | 224.66 | 223.9661 | 224.16 | 1357827.0 |
| 2024-08-16 11:00:00 | AAPL | Stock | 224.15 | 225.02 | 223.995 | 224.91 | 1586470.0 |
| 2024-08-16 11:30:00 | AAPL | Stock | 224.91 | 226.04 | 224.91 | 225.915 | 2050545.0 |
| 2024-08-16 12:00:00 | AAPL | Stock | 225.91 | 226.45 | 225.78 | 226.34 | 1829783.0 |
| 2024-08-16 12:30:00 | AAPL | Stock | 226.35 | 226.8271 | 226.31 | 226.6073 | 1676613.0 |
| 2024-08-16 13:00:00 | AAPL | Stock | 226.61 | 226.66 | 226.36 | 226.55 | 1036574.0 |
| 2024-08-16 13:30:00 | AAPL | Stock | 226.55 | 226.67 | 225.96 | 226.14 | 835666.0 |
| 2024-08-16 14:00:00 | AAPL | Stock | 226.14 | 226.1503 | 225.63 | 225.99 | 779248.0 |
| 2024-08-16 14:30:00 | AAPL | Stock | 225.985 | 226.18 | 225.7636 | 226.13 | 810296.0 |
| 2024-08-16 15:00:00 | AAPL | Stock | 226.124 | 226.21 | 225.8 | 225.96 | 950121.0 |
| 2024-08-16 15:30:00 | AAPL | Stock | 225.9605 | 226.15 | 225.54 | 226.1 | 2514233.0 |
| 2024-08-16 16:00:00 | AAPL | Stock | 226.07 | 226.21 | 226.05 | 226.21 | 5818561.0 |
| 2024-08-16 16:30:00 | AAPL | Stock | 226.1806 | 226.2 | 226.05 | 226.15 | 24608.0 |
| 2024-08-16 17:00:00 | AAPL | Stock | 226.15 | 226.21 | 226.05 | 226.19 | 257094.0 |
| 2024-08-16 17:30:00 | AAPL | Stock | 226.21 | 226.25 | 226.19 | 226.22 | 5475.0 |
| 2024-08-16 18:00:00 | AAPL | Stock | 226.22 | 226.22 | 226.18 | 226.18 | 7267.0 |
| 2024-08-16 18:30:00 | AAPL | Stock | 226.1888 | 226.1888 | 225.9807 | 226.0 | 16438.0 |
| 2024-08-16 19:00:00 | AAPL | Stock | 226.02 | 226.02 | 225.88 | 225.88 | 10727.0 |
| 2024-08-16 19:30:00 | AAPL | Stock | 225.88 | 225.99 | 225.6 | 225.95 | 7134.0 |
| 2024-08-16 04:00:00 | MSFT | Stock | 422.02 | 423.08 | 422.02 | 422.49 | 3528.0 |
| 2024-08-16 04:30:00 | MSFT | Stock | 422.42 | 422.57 | 422.17 | 422.57 | 1664.0 |
| 2024-08-16 05:00:00 | MSFT | Stock | 422.65 | 422.8 | 422.58 | 422.8 | 1001.0 |
| 2024-08-16 05:30:00 | MSFT | Stock | 422.7 | 422.83 | 422.7 | 422.7 | 947.0 |
| 2024-08-16 06:00:00 | MSFT | Stock | 422.52 | 422.52 | 421.82 | 422.01 | 3332.0 |
| 2024-08-16 06:30:00 | MSFT | Stock | 421.78 | 421.78 | 421.74 | 421.74 | 971.0 |
| 2024-08-16 07:00:00 | MSFT | Stock | 421.74 | 421.74 | 421.15 | 421.25 | 5025.0 |
| 2024-08-16 07:30:00 | MSFT | Stock | 421.2 | 421.3 | 420.5 | 420.5 | 5777.0 |
| 2024-08-16 08:00:00 | MSFT | Stock | 421.5 | 422.2462 | 419.62 | 419.8 | 22079.0 |
| 2024-08-16 08:30:00 | MSFT | Stock | 419.9634 | 419.9634 | 419.01 | 419.846 | 17270.0 |
| 2024-08-16 09:00:00 | MSFT | Stock | 419.8 | 421.84 | 418.08 | 421.02 | 63617.0 |
| 2024-08-16 09:30:00 | MSFT | Stock | 421.09 | 421.34 | 417.3 | 417.8 | 2363391.0 |
| 2024-08-16 10:00:00 | MSFT | Stock | 417.79 | 418.98 | 417.68 | 417.85 | 691197.0 |
| 2024-08-16 10:30:00 | MSFT | Stock | 417.82 | 418.54 | 417.43 | 417.79 | 608786.0 |
| 2024-08-16 11:00:00 | MSFT | Stock | 417.79 | 418.36 | 417.31 | 417.95 | 445544.0 |
| 2024-08-16 11:30:00 | MSFT | Stock | 417.95 | 418.95 | 417.66 | 418.59 | 391452.0 |
| 2024-08-16 12:00:00 | MSFT | Stock | 418.5 | 419.45 | 418.2232 | 419.1401 | 327396.0 |
| 2024-08-16 12:30:00 | MSFT | Stock | 419.15 | 419.65 | 418.98 | 419.555 | 315811.0 |
> showing 50 of 97,181 rows — these rows as CSV