PREVIEW / stock_30min / 2024-11-25
file: by_date/stock_30min/2024/2024-11-25.parquet size: 2.3 MB rows: 109,727 symbols: 705
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-11-25 04:00:00 | AAPL | Stock | 229.88 | 230.44 | 229.88 | 229.99 | 5205.0 |
| 2024-11-25 04:30:00 | AAPL | Stock | 230.0 | 230.18 | 229.9 | 230.12 | 10456.0 |
| 2024-11-25 05:00:00 | AAPL | Stock | 230.25 | 230.46 | 230.15 | 230.38 | 2724.0 |
| 2024-11-25 05:30:00 | AAPL | Stock | 230.42 | 230.75 | 230.42 | 230.7 | 7415.0 |
| 2024-11-25 06:00:00 | AAPL | Stock | 230.6 | 230.68 | 230.5 | 230.59 | 3428.0 |
| 2024-11-25 06:30:00 | AAPL | Stock | 230.55 | 230.59 | 230.43 | 230.5 | 2238.0 |
| 2024-11-25 07:00:00 | AAPL | Stock | 230.5 | 230.98 | 230.12 | 230.9 | 26141.0 |
| 2024-11-25 07:30:00 | AAPL | Stock | 230.79 | 231.37 | 230.75 | 231.33 | 24469.0 |
| 2024-11-25 08:00:00 | AAPL | Stock | 230.46 | 231.36 | 229.296 | 231.104 | 71880.0 |
| 2024-11-25 08:30:00 | AAPL | Stock | 231.1 | 231.6845 | 231.0 | 231.51 | 36033.0 |
| 2024-11-25 09:00:00 | AAPL | Stock | 231.55 | 231.59 | 231.03 | 231.37 | 76733.0 |
| 2024-11-25 09:30:00 | AAPL | Stock | 231.45 | 233.245 | 231.42 | 232.6 | 4913579.0 |
| 2024-11-25 10:00:00 | AAPL | Stock | 232.56 | 232.58 | 231.6199 | 232.03 | 1759565.0 |
| 2024-11-25 10:30:00 | AAPL | Stock | 231.99 | 232.801 | 231.71 | 231.895 | 1640281.0 |
| 2024-11-25 11:00:00 | AAPL | Stock | 231.89 | 232.32 | 231.7003 | 231.71 | 1275527.0 |
| 2024-11-25 11:30:00 | AAPL | Stock | 231.705 | 231.86 | 230.89 | 230.9 | 1275793.0 |
| 2024-11-25 12:00:00 | AAPL | Stock | 230.89 | 231.03 | 229.96 | 230.2068 | 1579129.0 |
| 2024-11-25 12:30:00 | AAPL | Stock | 230.2 | 230.48 | 229.74 | 230.11 | 1013989.0 |
| 2024-11-25 13:00:00 | AAPL | Stock | 230.105 | 230.59 | 230.07 | 230.42 | 785094.0 |
| 2024-11-25 13:30:00 | AAPL | Stock | 230.425 | 230.61 | 230.19 | 230.285 | 687913.0 |
| 2024-11-25 14:00:00 | AAPL | Stock | 230.28 | 230.74 | 230.24 | 230.685 | 795976.0 |
| 2024-11-25 14:30:00 | AAPL | Stock | 230.665 | 230.85 | 230.3 | 230.68 | 798877.0 |
| 2024-11-25 15:00:00 | AAPL | Stock | 230.68 | 230.7181 | 230.095 | 230.52 | 1026129.0 |
| 2024-11-25 15:30:00 | AAPL | Stock | 230.51 | 233.17 | 229.845 | 232.88 | 9451027.0 |
| 2024-11-25 16:00:00 | AAPL | Stock | 232.88 | 232.89 | 232.26 | 232.43 | 40051676.0 |
| 2024-11-25 16:30:00 | AAPL | Stock | 232.43 | 232.87 | 232.1 | 232.2 | 123438.0 |
| 2024-11-25 17:00:00 | AAPL | Stock | 232.2 | 232.4386 | 232.12 | 232.12 | 37796.0 |
| 2024-11-25 17:30:00 | AAPL | Stock | 232.11 | 232.25 | 232.0251 | 232.25 | 11503.0 |
| 2024-11-25 18:00:00 | AAPL | Stock | 232.21 | 232.63 | 232.21 | 232.63 | 16678.0 |
| 2024-11-25 18:30:00 | AAPL | Stock | 232.61 | 232.67 | 230.61 | 231.3 | 54683.0 |
| 2024-11-25 19:00:00 | AAPL | Stock | 231.3 | 231.5 | 231.01 | 231.32 | 31233.0 |
| 2024-11-25 19:30:00 | AAPL | Stock | 231.39 | 231.7417 | 231.06 | 231.06 | 40919.0 |
| 2024-11-25 04:00:00 | MSFT | Stock | 418.51 | 418.51 | 417.79 | 417.79 | 1824.0 |
| 2024-11-25 04:30:00 | MSFT | Stock | 417.86 | 418.18 | 417.69 | 417.69 | 1320.0 |
| 2024-11-25 05:00:00 | MSFT | Stock | 417.8 | 418.15 | 417.8 | 418.12 | 1000.0 |
| 2024-11-25 05:30:00 | MSFT | Stock | 418.1 | 418.1 | 417.67 | 417.97 | 1705.0 |
| 2024-11-25 06:00:00 | MSFT | Stock | 417.77 | 417.92 | 417.72 | 417.92 | 1244.0 |
| 2024-11-25 06:30:00 | MSFT | Stock | 418.0 | 418.08 | 417.5 | 417.65 | 1458.0 |
| 2024-11-25 07:00:00 | MSFT | Stock | 417.73 | 419.0 | 417.73 | 418.22 | 12097.0 |
| 2024-11-25 07:30:00 | MSFT | Stock | 418.2 | 418.85 | 418.2 | 418.72 | 7714.0 |
| 2024-11-25 08:00:00 | MSFT | Stock | 417.84 | 419.02 | 415.958 | 418.0 | 28097.0 |
| 2024-11-25 08:30:00 | MSFT | Stock | 418.05 | 418.91 | 418.05 | 418.65 | 16286.0 |
| 2024-11-25 09:00:00 | MSFT | Stock | 418.61 | 419.0 | 417.6 | 418.01 | 34533.0 |
| 2024-11-25 09:30:00 | MSFT | Stock | 418.25 | 421.08 | 416.21 | 416.52 | 2062101.0 |
| 2024-11-25 10:00:00 | MSFT | Stock | 416.42 | 416.46 | 414.89 | 415.69 | 781138.0 |
| 2024-11-25 10:30:00 | MSFT | Stock | 415.64 | 416.75 | 414.95 | 415.695 | 494257.0 |
| 2024-11-25 11:00:00 | MSFT | Stock | 415.785 | 416.715 | 415.33 | 416.48 | 421378.0 |
| 2024-11-25 11:30:00 | MSFT | Stock | 416.49 | 417.31 | 415.56 | 415.84 | 440555.0 |
| 2024-11-25 12:00:00 | MSFT | Stock | 415.81 | 416.0 | 415.17 | 415.37 | 247183.0 |
| 2024-11-25 12:30:00 | MSFT | Stock | 415.39 | 416.1799 | 414.85 | 416.0 | 303294.0 |
> showing 50 of 109,727 rows — these rows as CSV