PREVIEW / stock_30min / 2024-12-19
file: by_date/stock_30min/2024/2024-12-19.parquet size: 2.3 MB rows: 109,762 symbols: 651
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-12-19 04:00:00 | AAPL | Stock | 247.89 | 247.89 | 247.09 | 247.65 | 25404.0 |
| 2024-12-19 04:30:00 | AAPL | Stock | 247.7 | 247.99 | 247.62 | 247.62 | 13648.0 |
| 2024-12-19 05:00:00 | AAPL | Stock | 247.62 | 247.98 | 247.4 | 247.93 | 16211.0 |
| 2024-12-19 05:30:00 | AAPL | Stock | 247.83 | 247.91 | 247.73 | 247.73 | 10205.0 |
| 2024-12-19 06:00:00 | AAPL | Stock | 247.84 | 247.94 | 247.72 | 247.78 | 5163.0 |
| 2024-12-19 06:30:00 | AAPL | Stock | 247.63 | 247.63 | 247.52 | 247.59 | 6660.0 |
| 2024-12-19 07:00:00 | AAPL | Stock | 247.59 | 248.33 | 247.59 | 248.17 | 28481.0 |
| 2024-12-19 07:30:00 | AAPL | Stock | 248.18 | 248.19 | 247.84 | 247.99 | 15618.0 |
| 2024-12-19 08:00:00 | AAPL | Stock | 247.8 | 248.6 | 246.47 | 248.35 | 88183.0 |
| 2024-12-19 08:30:00 | AAPL | Stock | 248.35 | 248.45 | 247.28 | 247.37 | 66450.0 |
| 2024-12-19 09:00:00 | AAPL | Stock | 247.35 | 248.03 | 247.0 | 247.48 | 137989.0 |
| 2024-12-19 09:30:00 | AAPL | Stock | 247.5 | 249.17 | 247.095 | 248.69 | 5113808.0 |
| 2024-12-19 10:00:00 | AAPL | Stock | 248.69 | 251.02 | 248.65 | 249.89 | 3996565.0 |
| 2024-12-19 10:30:00 | AAPL | Stock | 249.89 | 250.5899 | 249.37 | 250.46 | 2220308.0 |
| 2024-12-19 11:00:00 | AAPL | Stock | 250.46 | 251.3876 | 249.495 | 251.04 | 1711414.0 |
| 2024-12-19 11:30:00 | AAPL | Stock | 251.04 | 251.85 | 250.82 | 251.13 | 1792225.0 |
| 2024-12-19 12:00:00 | AAPL | Stock | 251.13 | 251.69 | 250.535 | 250.58 | 1404588.0 |
| 2024-12-19 12:30:00 | AAPL | Stock | 250.59 | 250.74 | 249.72 | 250.655 | 1438067.0 |
| 2024-12-19 13:00:00 | AAPL | Stock | 250.645 | 250.94 | 249.81 | 250.83 | 991965.0 |
| 2024-12-19 13:30:00 | AAPL | Stock | 250.81 | 251.35 | 250.56 | 251.32 | 800532.0 |
| 2024-12-19 14:00:00 | AAPL | Stock | 251.33 | 251.45 | 250.2902 | 250.52 | 861190.0 |
| 2024-12-19 14:30:00 | AAPL | Stock | 250.51 | 250.52 | 250.031 | 250.06 | 863742.0 |
| 2024-12-19 15:00:00 | AAPL | Stock | 250.06 | 250.48 | 249.53 | 250.325 | 1275940.0 |
| 2024-12-19 15:30:00 | AAPL | Stock | 250.325 | 252.0 | 249.4093 | 249.85 | 3243315.0 |
| 2024-12-19 16:00:00 | AAPL | Stock | 249.85 | 250.11 | 249.29 | 249.81 | 15036254.0 |
| 2024-12-19 16:30:00 | AAPL | Stock | 249.82 | 250.0981 | 249.81 | 250.0686 | 20548.0 |
| 2024-12-19 17:00:00 | AAPL | Stock | 249.79 | 250.02 | 249.79 | 249.9336 | 21064.0 |
| 2024-12-19 17:30:00 | AAPL | Stock | 249.91 | 249.95 | 249.81 | 249.82 | 5431.0 |
| 2024-12-19 18:00:00 | AAPL | Stock | 249.93 | 249.96 | 249.8 | 249.8 | 8181.0 |
| 2024-12-19 18:30:00 | AAPL | Stock | 249.71 | 249.71 | 249.29 | 249.3501 | 5063.0 |
| 2024-12-19 19:00:00 | AAPL | Stock | 249.45 | 249.6 | 248.68 | 249.1999 | 12484.0 |
| 2024-12-19 19:30:00 | AAPL | Stock | 249.0 | 249.39 | 248.66 | 248.79 | 19254.0 |
| 2024-12-19 04:00:00 | MSFT | Stock | 440.79 | 441.75 | 439.55 | 439.9 | 9554.0 |
| 2024-12-19 04:30:00 | MSFT | Stock | 439.82 | 440.37 | 439.8 | 440.01 | 3914.0 |
| 2024-12-19 05:00:00 | MSFT | Stock | 440.1 | 440.6 | 439.64 | 440.6 | 3762.0 |
| 2024-12-19 05:30:00 | MSFT | Stock | 440.25 | 440.27 | 439.89 | 440.2 | 2048.0 |
| 2024-12-19 06:00:00 | MSFT | Stock | 440.22 | 440.6 | 440.22 | 440.52 | 2162.0 |
| 2024-12-19 06:30:00 | MSFT | Stock | 440.38 | 441.0 | 439.53 | 440.29 | 6743.0 |
| 2024-12-19 07:00:00 | MSFT | Stock | 440.46 | 442.25 | 440.46 | 442.0 | 5931.0 |
| 2024-12-19 07:30:00 | MSFT | Stock | 441.86 | 442.38 | 441.47 | 442.38 | 1704.0 |
| 2024-12-19 08:00:00 | MSFT | Stock | 441.0 | 442.75 | 439.48 | 441.39 | 26036.0 |
| 2024-12-19 08:30:00 | MSFT | Stock | 441.1577 | 441.55 | 440.6 | 441.0 | 14471.0 |
| 2024-12-19 09:00:00 | MSFT | Stock | 440.82 | 442.43 | 440.34 | 441.8 | 17911.0 |
| 2024-12-19 09:30:00 | MSFT | Stock | 441.62 | 442.9693 | 438.34 | 439.54 | 1596736.0 |
| 2024-12-19 10:00:00 | MSFT | Stock | 439.36 | 442.3799 | 438.33 | 441.08 | 779637.0 |
| 2024-12-19 10:30:00 | MSFT | Stock | 440.85 | 442.235 | 440.01 | 441.76 | 593851.0 |
| 2024-12-19 11:00:00 | MSFT | Stock | 441.79 | 442.65 | 439.85 | 442.28 | 525800.0 |
| 2024-12-19 11:30:00 | MSFT | Stock | 442.11 | 443.1834 | 441.63 | 442.085 | 414898.0 |
| 2024-12-19 12:00:00 | MSFT | Stock | 442.075 | 442.13 | 439.83 | 439.882 | 374898.0 |
| 2024-12-19 12:30:00 | MSFT | Stock | 439.85 | 440.84 | 439.52 | 440.355 | 399675.0 |
> showing 50 of 109,762 rows — these rows as CSV