PREVIEW / stock_30min / 2024-06-12
file: by_date/stock_30min/2024/2024-06-12.parquet size: 2.1 MB rows: 100,218 symbols: 965
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-12 04:00:00 | AAPL | Stock | 206.54 | 206.69 | 206.1 | 206.32 | 26363.0 |
| 2024-06-12 04:30:00 | AAPL | Stock | 206.39 | 206.46 | 206.3 | 206.33 | 13400.0 |
| 2024-06-12 05:00:00 | AAPL | Stock | 206.33 | 206.33 | 205.7 | 205.75 | 40135.0 |
| 2024-06-12 05:30:00 | AAPL | Stock | 205.68 | 206.12 | 205.59 | 206.0 | 17399.0 |
| 2024-06-12 06:00:00 | AAPL | Stock | 206.0 | 206.37 | 205.81 | 206.3 | 18136.0 |
| 2024-06-12 06:30:00 | AAPL | Stock | 206.26 | 206.49 | 206.01 | 206.2 | 21952.0 |
| 2024-06-12 07:00:00 | AAPL | Stock | 206.16 | 206.27 | 205.98 | 206.14 | 80782.0 |
| 2024-06-12 07:30:00 | AAPL | Stock | 206.15 | 206.44 | 206.14 | 206.2 | 56770.0 |
| 2024-06-12 08:00:00 | AAPL | Stock | 206.19 | 206.69 | 205.5 | 205.9 | 360543.0 |
| 2024-06-12 08:30:00 | AAPL | Stock | 206.0 | 207.61 | 205.63 | 206.4 | 911831.0 |
| 2024-06-12 09:00:00 | AAPL | Stock | 206.4 | 207.78 | 205.85 | 207.43 | 480998.0 |
| 2024-06-12 09:30:00 | AAPL | Stock | 207.37 | 215.0 | 206.9 | 214.255 | 29512052.0 |
| 2024-06-12 10:00:00 | AAPL | Stock | 214.26 | 215.99 | 214.21 | 215.235 | 15138443.0 |
| 2024-06-12 10:30:00 | AAPL | Stock | 215.22 | 216.62 | 214.68 | 216.6031 | 11339250.0 |
| 2024-06-12 11:00:00 | AAPL | Stock | 216.61 | 218.12 | 216.5 | 217.5801 | 12187860.0 |
| 2024-06-12 11:30:00 | AAPL | Stock | 217.58 | 217.61 | 216.18 | 216.5075 | 7647840.0 |
| 2024-06-12 12:00:00 | AAPL | Stock | 216.51 | 217.49 | 215.27 | 215.35 | 7018882.0 |
| 2024-06-12 12:30:00 | AAPL | Stock | 215.3306 | 216.33 | 214.861 | 215.8257 | 5817329.0 |
| 2024-06-12 13:00:00 | AAPL | Stock | 215.8399 | 217.36 | 215.51 | 216.93 | 5130736.0 |
| 2024-06-12 13:30:00 | AAPL | Stock | 216.9275 | 217.655 | 216.46 | 217.49 | 4890410.0 |
| 2024-06-12 14:00:00 | AAPL | Stock | 217.49 | 219.33 | 216.55 | 218.9602 | 10775659.0 |
| 2024-06-12 14:30:00 | AAPL | Stock | 218.9501 | 220.15 | 218.4 | 219.78 | 10957550.0 |
| 2024-06-12 15:00:00 | AAPL | Stock | 219.78 | 220.2 | 217.37 | 217.73 | 9192997.0 |
| 2024-06-12 15:30:00 | AAPL | Stock | 217.74 | 217.76 | 212.83 | 213.08 | 23502284.0 |
| 2024-06-12 16:00:00 | AAPL | Stock | 213.08 | 213.71 | 212.5 | 213.1421 | 9187689.0 |
| 2024-06-12 16:30:00 | AAPL | Stock | 213.38 | 213.95 | 213.11 | 213.92 | 220691.0 |
| 2024-06-12 17:00:00 | AAPL | Stock | 213.96 | 214.43 | 213.07 | 213.62 | 433413.0 |
| 2024-06-12 17:30:00 | AAPL | Stock | 213.64 | 213.84 | 213.07 | 213.7 | 66017.0 |
| 2024-06-12 18:00:00 | AAPL | Stock | 213.74 | 213.7514 | 212.8101 | 213.07 | 136166.0 |
| 2024-06-12 18:30:00 | AAPL | Stock | 212.9313 | 213.21 | 212.83 | 213.2 | 101589.0 |
| 2024-06-12 19:00:00 | AAPL | Stock | 213.2138 | 213.3899 | 213.0505 | 213.31 | 120992.0 |
| 2024-06-12 19:30:00 | AAPL | Stock | 213.3 | 214.35 | 213.3 | 214.2 | 226863.0 |
| 2024-06-12 04:00:00 | MSFT | Stock | 433.31 | 435.0 | 433.31 | 434.91 | 5941.0 |
| 2024-06-12 04:30:00 | MSFT | Stock | 434.77 | 435.81 | 434.77 | 435.81 | 2588.0 |
| 2024-06-12 05:00:00 | MSFT | Stock | 435.55 | 435.63 | 435.43 | 435.45 | 4054.0 |
| 2024-06-12 05:30:00 | MSFT | Stock | 435.1 | 435.43 | 435.04 | 435.05 | 3219.0 |
| 2024-06-12 06:00:00 | MSFT | Stock | 435.07 | 435.07 | 435.0 | 435.07 | 649.0 |
| 2024-06-12 07:00:00 | MSFT | Stock | 434.08 | 435.0 | 434.01 | 434.71 | 3600.0 |
| 2024-06-12 07:30:00 | MSFT | Stock | 434.71 | 434.76 | 434.5 | 434.5 | 1278.0 |
| 2024-06-12 08:00:00 | MSFT | Stock | 435.0 | 435.0 | 432.8 | 435.0 | 24221.0 |
| 2024-06-12 08:30:00 | MSFT | Stock | 434.95 | 439.0 | 434.95 | 436.74 | 107127.0 |
| 2024-06-12 09:00:00 | MSFT | Stock | 436.7399 | 436.76 | 434.82 | 435.28 | 77387.0 |
| 2024-06-12 09:30:00 | MSFT | Stock | 435.2 | 438.55 | 433.25 | 438.01 | 1967293.0 |
| 2024-06-12 10:00:00 | MSFT | Stock | 438.07 | 438.4 | 436.17 | 437.835 | 744067.0 |
| 2024-06-12 10:30:00 | MSFT | Stock | 437.85 | 438.35 | 437.5 | 438.0062 | 597643.0 |
| 2024-06-12 11:00:00 | MSFT | Stock | 438.01 | 438.6 | 437.03 | 438.23 | 637811.0 |
| 2024-06-12 11:30:00 | MSFT | Stock | 438.24 | 439.53 | 438.03 | 438.8001 | 706294.0 |
| 2024-06-12 12:00:00 | MSFT | Stock | 438.79 | 438.91 | 438.22 | 438.38 | 420989.0 |
| 2024-06-12 12:30:00 | MSFT | Stock | 438.41 | 439.3 | 438.06 | 439.28 | 334762.0 |
| 2024-06-12 13:00:00 | MSFT | Stock | 439.295 | 440.42 | 439.26 | 439.8062 | 564373.0 |
> showing 50 of 100,218 rows — these rows as CSV