PREVIEW / stock_30min / 2024-07-16
file: by_date/stock_30min/2024/2024-07-16.parquet size: 2.1 MB rows: 101,364 symbols: 910
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-16 04:00:00 | AAPL | Stock | 236.0 | 236.0 | 234.43 | 235.4 | 12532.0 |
| 2024-07-16 04:30:00 | AAPL | Stock | 235.42 | 235.47 | 234.7 | 235.01 | 8227.0 |
| 2024-07-16 05:00:00 | AAPL | Stock | 235.05 | 235.05 | 234.7 | 234.9 | 4483.0 |
| 2024-07-16 05:30:00 | AAPL | Stock | 234.9 | 235.0 | 234.86 | 234.99 | 4037.0 |
| 2024-07-16 06:00:00 | AAPL | Stock | 235.0 | 235.29 | 235.0 | 235.26 | 3946.0 |
| 2024-07-16 06:30:00 | AAPL | Stock | 235.25 | 235.25 | 235.15 | 235.15 | 1388.0 |
| 2024-07-16 07:00:00 | AAPL | Stock | 235.15 | 235.3 | 234.99 | 234.99 | 15345.0 |
| 2024-07-16 07:30:00 | AAPL | Stock | 234.96 | 235.18 | 234.9 | 235.18 | 7437.0 |
| 2024-07-16 08:00:00 | AAPL | Stock | 235.08 | 236.65 | 234.5345 | 235.21 | 84625.0 |
| 2024-07-16 08:30:00 | AAPL | Stock | 235.19 | 235.22 | 234.61 | 234.82 | 54339.0 |
| 2024-07-16 09:00:00 | AAPL | Stock | 234.85 | 235.2163 | 234.75 | 235.0 | 67482.0 |
| 2024-07-16 09:30:00 | AAPL | Stock | 235.0 | 236.27 | 233.97 | 234.4 | 5644780.0 |
| 2024-07-16 10:00:00 | AAPL | Stock | 234.37 | 234.52 | 233.01 | 233.83 | 3228953.0 |
| 2024-07-16 10:30:00 | AAPL | Stock | 233.84 | 234.75 | 233.675 | 234.1 | 2514275.0 |
| 2024-07-16 11:00:00 | AAPL | Stock | 234.092 | 234.91 | 233.92 | 234.16 | 1684152.0 |
| 2024-07-16 11:30:00 | AAPL | Stock | 234.16 | 234.35 | 233.79 | 233.91 | 1098718.0 |
| 2024-07-16 12:00:00 | AAPL | Stock | 233.92 | 234.25 | 232.62 | 232.9479 | 1775364.0 |
| 2024-07-16 12:30:00 | AAPL | Stock | 232.93 | 233.63 | 232.33 | 233.59 | 1368923.0 |
| 2024-07-16 13:00:00 | AAPL | Stock | 233.56 | 233.7972 | 233.285 | 233.545 | 1121305.0 |
| 2024-07-16 13:30:00 | AAPL | Stock | 233.54 | 234.2 | 233.41 | 234.13 | 1287364.0 |
| 2024-07-16 14:00:00 | AAPL | Stock | 234.1136 | 234.55 | 233.71 | 234.39 | 1323119.0 |
| 2024-07-16 14:30:00 | AAPL | Stock | 234.3995 | 234.865 | 234.3 | 234.79 | 1188292.0 |
| 2024-07-16 15:00:00 | AAPL | Stock | 234.795 | 234.87 | 234.31 | 234.5599 | 1139607.0 |
| 2024-07-16 15:30:00 | AAPL | Stock | 234.56 | 234.98 | 234.285 | 234.81 | 2190178.0 |
| 2024-07-16 16:00:00 | AAPL | Stock | 234.8 | 234.9 | 234.5 | 234.52 | 4373801.0 |
| 2024-07-16 16:30:00 | AAPL | Stock | 234.52 | 234.82 | 234.43 | 234.55 | 24680.0 |
| 2024-07-16 17:00:00 | AAPL | Stock | 234.56 | 234.6 | 234.5057 | 234.5057 | 8597.0 |
| 2024-07-16 17:30:00 | AAPL | Stock | 234.59 | 234.64 | 234.44 | 234.64 | 7863.0 |
| 2024-07-16 18:00:00 | AAPL | Stock | 234.62 | 234.75 | 234.61 | 234.61 | 9085.0 |
| 2024-07-16 18:30:00 | AAPL | Stock | 234.6 | 234.69 | 234.561 | 234.65 | 7076.0 |
| 2024-07-16 19:00:00 | AAPL | Stock | 234.6512 | 234.72 | 234.2413 | 234.2413 | 12965.0 |
| 2024-07-16 19:30:00 | AAPL | Stock | 234.31 | 234.59 | 234.25 | 234.3195 | 14327.0 |
| 2024-07-16 04:00:00 | MSFT | Stock | 454.78 | 454.78 | 452.0 | 452.25 | 1542.0 |
| 2024-07-16 04:30:00 | MSFT | Stock | 452.39 | 452.4 | 452.22 | 452.4 | 1661.0 |
| 2024-07-16 05:00:00 | MSFT | Stock | 452.5 | 453.1 | 452.5 | 453.1 | 600.0 |
| 2024-07-16 05:30:00 | MSFT | Stock | 453.05 | 453.17 | 453.05 | 453.12 | 445.0 |
| 2024-07-16 06:00:00 | MSFT | Stock | 452.9 | 452.99 | 452.9 | 452.99 | 246.0 |
| 2024-07-16 06:30:00 | MSFT | Stock | 453.25 | 453.45 | 453.13 | 453.13 | 470.0 |
| 2024-07-16 07:00:00 | MSFT | Stock | 453.38 | 453.68 | 453.15 | 453.68 | 784.0 |
| 2024-07-16 07:30:00 | MSFT | Stock | 453.9 | 454.0 | 453.77 | 454.0 | 1035.0 |
| 2024-07-16 08:00:00 | MSFT | Stock | 453.25 | 454.8 | 453.25 | 454.11 | 10549.0 |
| 2024-07-16 08:30:00 | MSFT | Stock | 454.11 | 454.51 | 453.12 | 454.15 | 7560.0 |
| 2024-07-16 09:00:00 | MSFT | Stock | 454.0 | 454.95 | 453.28 | 454.1 | 10125.0 |
| 2024-07-16 09:30:00 | MSFT | Stock | 454.31 | 454.31 | 450.93 | 451.1635 | 1252355.0 |
| 2024-07-16 10:00:00 | MSFT | Stock | 451.17 | 451.66 | 447.696 | 448.38 | 1109001.0 |
| 2024-07-16 10:30:00 | MSFT | Stock | 448.39 | 449.62 | 447.25 | 448.3301 | 687282.0 |
| 2024-07-16 11:00:00 | MSFT | Stock | 448.33 | 450.029 | 447.77 | 448.85 | 551359.0 |
| 2024-07-16 11:30:00 | MSFT | Stock | 448.875 | 449.25 | 448.4838 | 448.53 | 477224.0 |
| 2024-07-16 12:00:00 | MSFT | Stock | 448.56 | 448.9814 | 447.11 | 447.74 | 458542.0 |
| 2024-07-16 12:30:00 | MSFT | Stock | 447.73 | 448.7999 | 447.23 | 448.7 | 356282.0 |
> showing 50 of 101,364 rows — these rows as CSV