PREVIEW / stock_30min / 2024-06-14
file: by_date/stock_30min/2024/2024-06-14.parquet size: 2.0 MB rows: 97,836 symbols: 949
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-06-14 04:00:00 | AAPL | Stock | 214.4 | 214.6 | 213.81 | 214.46 | 45564.0 |
| 2024-06-14 04:30:00 | AAPL | Stock | 214.57 | 214.6 | 214.23 | 214.23 | 7161.0 |
| 2024-06-14 05:00:00 | AAPL | Stock | 214.23 | 214.26 | 213.89 | 214.0 | 10118.0 |
| 2024-06-14 05:30:00 | AAPL | Stock | 214.0 | 214.0 | 213.59 | 213.7 | 11392.0 |
| 2024-06-14 06:00:00 | AAPL | Stock | 213.65 | 213.68 | 212.8 | 213.07 | 28066.0 |
| 2024-06-14 06:30:00 | AAPL | Stock | 213.06 | 213.75 | 213.03 | 213.55 | 19805.0 |
| 2024-06-14 07:00:00 | AAPL | Stock | 213.4 | 213.63 | 212.75 | 213.36 | 30734.0 |
| 2024-06-14 07:30:00 | AAPL | Stock | 213.47 | 213.9 | 213.27 | 213.3 | 15429.0 |
| 2024-06-14 08:00:00 | AAPL | Stock | 212.8 | 214.78 | 212.75 | 213.65 | 148155.0 |
| 2024-06-14 08:30:00 | AAPL | Stock | 213.71 | 214.24 | 213.15 | 213.48 | 78673.0 |
| 2024-06-14 09:00:00 | AAPL | Stock | 213.49 | 214.0 | 212.65 | 213.82 | 134676.0 |
| 2024-06-14 09:30:00 | AAPL | Stock | 213.81 | 215.17 | 213.18 | 213.7499 | 6719129.0 |
| 2024-06-14 10:00:00 | AAPL | Stock | 213.74 | 214.64 | 212.62 | 213.39 | 5102704.0 |
| 2024-06-14 10:30:00 | AAPL | Stock | 213.39 | 213.9199 | 212.66 | 213.1115 | 3168065.0 |
| 2024-06-14 11:00:00 | AAPL | Stock | 213.12 | 213.85 | 212.85 | 213.595 | 3052078.0 |
| 2024-06-14 11:30:00 | AAPL | Stock | 213.595 | 213.82 | 212.45 | 212.55 | 3104522.0 |
| 2024-06-14 12:00:00 | AAPL | Stock | 212.54 | 212.55 | 211.67 | 211.75 | 3690028.0 |
| 2024-06-14 12:30:00 | AAPL | Stock | 211.75 | 212.19 | 211.3 | 212.18 | 3291904.0 |
| 2024-06-14 13:00:00 | AAPL | Stock | 212.19 | 212.279 | 211.35 | 211.78 | 2282496.0 |
| 2024-06-14 13:30:00 | AAPL | Stock | 211.785 | 212.45 | 211.76 | 212.37 | 2565966.0 |
| 2024-06-14 14:00:00 | AAPL | Stock | 212.37 | 212.39 | 211.69 | 212.225 | 1914196.0 |
| 2024-06-14 14:30:00 | AAPL | Stock | 212.2295 | 212.35 | 211.68 | 212.165 | 1887186.0 |
| 2024-06-14 15:00:00 | AAPL | Stock | 212.16 | 212.39 | 211.79 | 212.3701 | 2184177.0 |
| 2024-06-14 15:30:00 | AAPL | Stock | 212.375 | 212.59 | 211.42 | 212.52 | 6351180.0 |
| 2024-06-14 16:00:00 | AAPL | Stock | 212.54 | 212.63 | 212.38 | 212.45 | 6662562.0 |
| 2024-06-14 16:30:00 | AAPL | Stock | 212.47 | 212.5 | 212.45 | 212.49 | 87087.0 |
| 2024-06-14 17:00:00 | AAPL | Stock | 212.48 | 212.61 | 212.46 | 212.51 | 97241.0 |
| 2024-06-14 17:30:00 | AAPL | Stock | 212.57 | 212.65 | 212.52 | 212.6 | 9665.0 |
| 2024-06-14 18:00:00 | AAPL | Stock | 212.62 | 212.8564 | 212.6 | 212.7949 | 26736.0 |
| 2024-06-14 18:30:00 | AAPL | Stock | 212.75 | 212.8 | 212.49 | 212.69 | 14198.0 |
| 2024-06-14 19:00:00 | AAPL | Stock | 212.69 | 212.71 | 212.52 | 212.53 | 15001.0 |
| 2024-06-14 19:30:00 | AAPL | Stock | 212.51 | 212.57 | 212.37 | 212.44 | 19242.0 |
| 2024-06-14 04:00:00 | MSFT | Stock | 441.25 | 441.25 | 440.0 | 440.0 | 5812.0 |
| 2024-06-14 04:30:00 | MSFT | Stock | 439.5 | 440.2 | 439.33 | 439.5 | 1762.0 |
| 2024-06-14 05:00:00 | MSFT | Stock | 439.5 | 439.66 | 439.4 | 439.5 | 1358.0 |
| 2024-06-14 05:30:00 | MSFT | Stock | 439.0 | 439.0 | 437.97 | 438.3 | 4957.0 |
| 2024-06-14 06:00:00 | MSFT | Stock | 438.24 | 438.24 | 437.16 | 437.2 | 14118.0 |
| 2024-06-14 06:30:00 | MSFT | Stock | 437.8 | 438.0 | 437.79 | 437.79 | 1212.0 |
| 2024-06-14 07:00:00 | MSFT | Stock | 437.99 | 438.29 | 437.3 | 438.27 | 7055.0 |
| 2024-06-14 07:30:00 | MSFT | Stock | 438.43 | 438.85 | 438.02 | 438.02 | 5776.0 |
| 2024-06-14 08:00:00 | MSFT | Stock | 437.69 | 440.96 | 437.0901 | 438.98 | 22982.0 |
| 2024-06-14 08:30:00 | MSFT | Stock | 438.89 | 439.29 | 438.6 | 438.94 | 9693.0 |
| 2024-06-14 09:00:00 | MSFT | Stock | 438.9 | 439.65 | 437.79 | 438.12 | 19831.0 |
| 2024-06-14 09:30:00 | MSFT | Stock | 438.05 | 442.2 | 436.721 | 442.02 | 1407997.0 |
| 2024-06-14 10:00:00 | MSFT | Stock | 442.01 | 442.035 | 440.33 | 441.3299 | 530749.0 |
| 2024-06-14 10:30:00 | MSFT | Stock | 441.34 | 442.7838 | 440.68 | 442.78 | 596473.0 |
| 2024-06-14 11:00:00 | MSFT | Stock | 442.86 | 442.97 | 441.79 | 441.92 | 358552.0 |
| 2024-06-14 11:30:00 | MSFT | Stock | 441.93 | 442.54 | 441.01 | 442.52 | 356307.0 |
| 2024-06-14 12:00:00 | MSFT | Stock | 442.51 | 443.1376 | 442.31 | 442.62 | 345488.0 |
| 2024-06-14 12:30:00 | MSFT | Stock | 442.63 | 442.7499 | 442.05 | 442.3897 | 205802.0 |
> showing 50 of 97,836 rows — these rows as CSV