PREVIEW / stock_30min / 2024-07-23
file: by_date/stock_30min/2024/2024-07-23.parquet size: 2.0 MB rows: 98,727 symbols: 909
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-07-23 04:00:00 | AAPL | Stock | 224.24 | 224.24 | 223.13 | 223.35 | 8617.0 |
| 2024-07-23 04:30:00 | AAPL | Stock | 223.35 | 223.45 | 223.1 | 223.38 | 6586.0 |
| 2024-07-23 05:00:00 | AAPL | Stock | 223.3 | 223.8 | 223.3 | 223.8 | 8150.0 |
| 2024-07-23 05:30:00 | AAPL | Stock | 223.83 | 223.83 | 223.81 | 223.81 | 200.0 |
| 2024-07-23 06:00:00 | AAPL | Stock | 223.7 | 223.79 | 223.45 | 223.7 | 7022.0 |
| 2024-07-23 06:30:00 | AAPL | Stock | 223.74 | 223.74 | 223.48 | 223.54 | 1929.0 |
| 2024-07-23 07:00:00 | AAPL | Stock | 223.82 | 224.42 | 223.82 | 224.42 | 7974.0 |
| 2024-07-23 07:30:00 | AAPL | Stock | 224.39 | 224.67 | 224.01 | 224.28 | 8331.0 |
| 2024-07-23 08:00:00 | AAPL | Stock | 224.07 | 224.5 | 223.38 | 224.1 | 57596.0 |
| 2024-07-23 08:30:00 | AAPL | Stock | 224.19 | 224.3 | 223.709 | 223.8 | 13872.0 |
| 2024-07-23 09:00:00 | AAPL | Stock | 223.78 | 224.69 | 223.7 | 224.44 | 55259.0 |
| 2024-07-23 09:30:00 | AAPL | Stock | 224.365 | 224.65 | 222.68 | 224.15 | 3712930.0 |
| 2024-07-23 10:00:00 | AAPL | Stock | 224.175 | 225.14 | 223.98 | 224.625 | 1969194.0 |
| 2024-07-23 10:30:00 | AAPL | Stock | 224.64 | 224.95 | 224.1006 | 224.65 | 1389312.0 |
| 2024-07-23 11:00:00 | AAPL | Stock | 224.67 | 226.73 | 224.55 | 226.6089 | 2912580.0 |
| 2024-07-23 11:30:00 | AAPL | Stock | 226.615 | 226.94 | 226.29 | 226.61 | 1897642.0 |
| 2024-07-23 12:00:00 | AAPL | Stock | 226.63 | 226.6499 | 225.2 | 225.6399 | 1219942.0 |
| 2024-07-23 12:30:00 | AAPL | Stock | 225.63 | 225.6999 | 225.08 | 225.254 | 970571.0 |
| 2024-07-23 13:00:00 | AAPL | Stock | 225.26 | 225.38 | 224.61 | 224.71 | 1302803.0 |
| 2024-07-23 13:30:00 | AAPL | Stock | 224.71 | 225.03 | 224.55 | 225.008 | 960796.0 |
| 2024-07-23 14:00:00 | AAPL | Stock | 225.0 | 225.04 | 224.38 | 224.54 | 1200680.0 |
| 2024-07-23 14:30:00 | AAPL | Stock | 224.56 | 224.786 | 224.328 | 224.78 | 867365.0 |
| 2024-07-23 15:00:00 | AAPL | Stock | 224.78 | 225.1 | 224.57 | 225.0747 | 1339106.0 |
| 2024-07-23 15:30:00 | AAPL | Stock | 225.06 | 225.28 | 224.32 | 224.98 | 3096316.0 |
| 2024-07-23 16:00:00 | AAPL | Stock | 224.97 | 225.04 | 224.51 | 224.99 | 4680188.0 |
| 2024-07-23 16:30:00 | AAPL | Stock | 224.99 | 225.2392 | 224.8 | 224.93 | 88341.0 |
| 2024-07-23 17:00:00 | AAPL | Stock | 224.98 | 225.01 | 224.7 | 224.7 | 169053.0 |
| 2024-07-23 17:30:00 | AAPL | Stock | 224.78 | 225.01 | 224.51 | 224.5626 | 25956.0 |
| 2024-07-23 18:00:00 | AAPL | Stock | 224.56 | 224.82 | 224.1927 | 224.2 | 27307.0 |
| 2024-07-23 18:30:00 | AAPL | Stock | 224.26 | 224.95 | 224.26 | 224.76 | 25407.0 |
| 2024-07-23 19:00:00 | AAPL | Stock | 224.6 | 224.83 | 224.51 | 224.51 | 12560.0 |
| 2024-07-23 19:30:00 | AAPL | Stock | 224.55 | 224.69 | 224.2781 | 224.2781 | 25070.0 |
| 2024-07-23 04:00:00 | MSFT | Stock | 442.8 | 442.8 | 440.88 | 441.53 | 2694.0 |
| 2024-07-23 04:30:00 | MSFT | Stock | 441.52 | 441.96 | 441.52 | 441.96 | 852.0 |
| 2024-07-23 05:00:00 | MSFT | Stock | 442.78 | 442.79 | 442.78 | 442.79 | 864.0 |
| 2024-07-23 05:30:00 | MSFT | Stock | 443.89 | 443.89 | 443.68 | 443.68 | 336.0 |
| 2024-07-23 06:00:00 | MSFT | Stock | 444.02 | 444.05 | 444.0 | 444.05 | 407.0 |
| 2024-07-23 06:30:00 | MSFT | Stock | 444.51 | 444.51 | 444.22 | 444.22 | 1892.0 |
| 2024-07-23 07:00:00 | MSFT | Stock | 444.07 | 444.44 | 444.03 | 444.15 | 3729.0 |
| 2024-07-23 07:30:00 | MSFT | Stock | 444.2 | 444.2 | 444.0 | 444.0 | 4222.0 |
| 2024-07-23 08:00:00 | MSFT | Stock | 444.29 | 444.48 | 441.41 | 443.32 | 11904.0 |
| 2024-07-23 08:30:00 | MSFT | Stock | 443.4 | 444.0 | 442.97 | 444.0 | 5622.0 |
| 2024-07-23 09:00:00 | MSFT | Stock | 444.18 | 444.5 | 443.58 | 443.81 | 10963.0 |
| 2024-07-23 09:30:00 | MSFT | Stock | 443.895 | 447.8 | 443.23 | 445.95 | 1164260.0 |
| 2024-07-23 10:00:00 | MSFT | Stock | 446.0 | 446.92 | 444.69 | 446.13 | 470421.0 |
| 2024-07-23 10:30:00 | MSFT | Stock | 446.145 | 446.3 | 444.18 | 445.76 | 394199.0 |
| 2024-07-23 11:00:00 | MSFT | Stock | 445.74 | 448.39 | 445.74 | 447.92 | 477803.0 |
| 2024-07-23 11:30:00 | MSFT | Stock | 447.914 | 448.01 | 446.645 | 446.87 | 278894.0 |
| 2024-07-23 12:00:00 | MSFT | Stock | 446.8 | 446.8 | 444.3301 | 445.065 | 340049.0 |
| 2024-07-23 12:30:00 | MSFT | Stock | 445.02 | 445.4 | 443.8 | 444.46 | 278222.0 |
> showing 50 of 98,727 rows — these rows as CSV