PREVIEW / stock_30min / 2024-07-19
file: by_date/stock_30min/2024/2024-07-19.parquet size: 1.9 MB rows: 94,713 symbols: 882
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-19 04:00:00 | AAPL | Stock | 224.13 | 224.2 | 222.0 | 222.7 | 32964.0 |
| 2024-07-19 04:30:00 | AAPL | Stock | 222.64 | 223.2 | 222.62 | 223.0 | 9892.0 |
| 2024-07-19 05:00:00 | AAPL | Stock | 222.93 | 223.67 | 222.91 | 223.59 | 10716.0 |
| 2024-07-19 05:30:00 | AAPL | Stock | 223.68 | 224.9 | 223.68 | 224.85 | 27024.0 |
| 2024-07-19 06:00:00 | AAPL | Stock | 224.79 | 225.5 | 224.79 | 225.4 | 14131.0 |
| 2024-07-19 06:30:00 | AAPL | Stock | 225.31 | 225.66 | 225.1 | 225.1 | 13534.0 |
| 2024-07-19 07:00:00 | AAPL | Stock | 225.0 | 226.24 | 225.0 | 225.95 | 31083.0 |
| 2024-07-19 07:30:00 | AAPL | Stock | 226.0 | 226.2 | 225.68 | 225.9 | 13059.0 |
| 2024-07-19 08:00:00 | AAPL | Stock | 225.15 | 226.25 | 223.26 | 225.7008 | 140016.0 |
| 2024-07-19 08:30:00 | AAPL | Stock | 225.71 | 226.38 | 225.7 | 226.28 | 45215.0 |
| 2024-07-19 09:00:00 | AAPL | Stock | 226.3 | 226.3923 | 224.58 | 224.97 | 206882.0 |
| 2024-07-19 09:30:00 | AAPL | Stock | 224.84 | 226.6 | 224.42 | 225.825 | 8276810.0 |
| 2024-07-19 10:00:00 | AAPL | Stock | 225.81 | 226.8 | 224.93 | 225.0142 | 2560342.0 |
| 2024-07-19 10:30:00 | AAPL | Stock | 225.03 | 225.86 | 224.62 | 224.8 | 2228749.0 |
| 2024-07-19 11:00:00 | AAPL | Stock | 224.81 | 225.26 | 223.8708 | 223.96 | 1773386.0 |
| 2024-07-19 11:30:00 | AAPL | Stock | 223.96 | 225.05 | 223.56 | 224.99 | 1627308.0 |
| 2024-07-19 12:00:00 | AAPL | Stock | 224.97 | 224.99 | 223.82 | 223.945 | 1178257.0 |
| 2024-07-19 12:30:00 | AAPL | Stock | 223.94 | 224.19 | 223.275 | 223.99 | 1332644.0 |
| 2024-07-19 13:00:00 | AAPL | Stock | 223.97 | 224.5799 | 223.47 | 224.46 | 1121156.0 |
| 2024-07-19 13:30:00 | AAPL | Stock | 224.46 | 224.782 | 223.86 | 224.61 | 1364012.0 |
| 2024-07-19 14:00:00 | AAPL | Stock | 224.6 | 224.945 | 224.28 | 224.45 | 1267502.0 |
| 2024-07-19 14:30:00 | AAPL | Stock | 224.46 | 224.52 | 223.89 | 224.44 | 1270604.0 |
| 2024-07-19 15:00:00 | AAPL | Stock | 224.45 | 225.12 | 224.41 | 225.01 | 1706376.0 |
| 2024-07-19 15:30:00 | AAPL | Stock | 225.0 | 225.0699 | 224.01 | 224.33 | 4312343.0 |
| 2024-07-19 16:00:00 | AAPL | Stock | 224.31 | 224.6 | 224.31 | 224.46 | 5949670.0 |
| 2024-07-19 16:30:00 | AAPL | Stock | 224.48 | 224.5 | 224.31 | 224.46 | 8562.0 |
| 2024-07-19 17:00:00 | AAPL | Stock | 224.46 | 224.47 | 224.31 | 224.38 | 438487.0 |
| 2024-07-19 17:30:00 | AAPL | Stock | 224.4 | 224.4 | 224.32 | 224.35 | 7316.0 |
| 2024-07-19 18:00:00 | AAPL | Stock | 224.35 | 224.35 | 224.31 | 224.31 | 5966.0 |
| 2024-07-19 18:30:00 | AAPL | Stock | 224.31 | 224.3281 | 224.3 | 224.3 | 125051.0 |
| 2024-07-19 19:00:00 | AAPL | Stock | 224.3007 | 224.34 | 224.3 | 224.34 | 3812.0 |
| 2024-07-19 19:30:00 | AAPL | Stock | 224.32 | 224.33 | 224.18 | 224.3271 | 3499.0 |
| 2024-07-19 04:00:00 | MSFT | Stock | 431.59 | 435.0 | 428.0 | 431.8 | 82649.0 |
| 2024-07-19 04:30:00 | MSFT | Stock | 431.6 | 432.93 | 429.34 | 429.34 | 45414.0 |
| 2024-07-19 05:00:00 | MSFT | Stock | 429.51 | 431.7 | 426.55 | 427.13 | 39470.0 |
| 2024-07-19 05:30:00 | MSFT | Stock | 427.26 | 432.17 | 425.2 | 430.03 | 124827.0 |
| 2024-07-19 06:00:00 | MSFT | Stock | 429.8 | 432.8 | 429.04 | 431.7 | 28775.0 |
| 2024-07-19 06:30:00 | MSFT | Stock | 431.25 | 434.71 | 431.18 | 433.6 | 73570.0 |
| 2024-07-19 07:00:00 | MSFT | Stock | 433.6 | 435.4 | 432.5 | 434.12 | 62319.0 |
| 2024-07-19 07:30:00 | MSFT | Stock | 434.06 | 434.79 | 433.52 | 433.95 | 24180.0 |
| 2024-07-19 08:00:00 | MSFT | Stock | 434.0 | 442.3 | 426.4714 | 433.4996 | 123176.0 |
| 2024-07-19 08:30:00 | MSFT | Stock | 433.5 | 435.4 | 433.4809 | 435.4 | 36839.0 |
| 2024-07-19 09:00:00 | MSFT | Stock | 435.4 | 435.6 | 431.8 | 433.4 | 112361.0 |
| 2024-07-19 09:30:00 | MSFT | Stock | 433.1 | 441.14 | 432.0 | 437.78 | 4103849.0 |
| 2024-07-19 10:00:00 | MSFT | Stock | 437.76 | 441.0 | 436.86 | 438.23 | 891545.0 |
| 2024-07-19 10:30:00 | MSFT | Stock | 438.19 | 439.5384 | 437.4001 | 439.225 | 591074.0 |
| 2024-07-19 11:00:00 | MSFT | Stock | 439.27 | 440.26 | 437.64 | 437.71 | 389516.0 |
| 2024-07-19 11:30:00 | MSFT | Stock | 437.68 | 438.74 | 436.45 | 438.455 | 508047.0 |
| 2024-07-19 12:00:00 | MSFT | Stock | 438.42 | 438.74 | 437.26 | 437.62 | 378665.0 |
| 2024-07-19 12:30:00 | MSFT | Stock | 437.5598 | 437.72 | 436.19 | 437.15 | 298235.0 |
> showing 50 of 94,713 rows — these rows as CSV