PREVIEW / stock_30min / 2024-12-12
file: by_date/stock_30min/2024/2024-12-12.parquet size: 2.2 MB rows: 104,958 symbols: 675
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-12 04:00:00 | AAPL | Stock | 247.5 | 247.65 | 246.52 | 247.06 | 11712.0 |
| 2024-12-12 04:30:00 | AAPL | Stock | 247.16 | 247.19 | 246.99 | 247.0 | 5646.0 |
| 2024-12-12 05:00:00 | AAPL | Stock | 247.01 | 247.42 | 246.93 | 247.42 | 1231.0 |
| 2024-12-12 05:30:00 | AAPL | Stock | 247.4 | 248.16 | 247.3 | 247.78 | 32440.0 |
| 2024-12-12 06:00:00 | AAPL | Stock | 247.64 | 247.64 | 247.25 | 247.26 | 13025.0 |
| 2024-12-12 06:30:00 | AAPL | Stock | 247.34 | 247.34 | 247.07 | 247.19 | 2323.0 |
| 2024-12-12 07:00:00 | AAPL | Stock | 247.2 | 247.2 | 247.0 | 247.0 | 16169.0 |
| 2024-12-12 07:30:00 | AAPL | Stock | 247.1 | 247.1 | 246.57 | 246.64 | 17553.0 |
| 2024-12-12 08:00:00 | AAPL | Stock | 247.05 | 247.62 | 246.5 | 246.67 | 53569.0 |
| 2024-12-12 08:30:00 | AAPL | Stock | 246.57 | 246.95 | 246.35 | 246.65 | 75634.0 |
| 2024-12-12 09:00:00 | AAPL | Stock | 246.7 | 247.4 | 246.52 | 246.982 | 89505.0 |
| 2024-12-12 09:30:00 | AAPL | Stock | 246.89 | 247.58 | 245.68 | 246.56 | 2978743.0 |
| 2024-12-12 10:00:00 | AAPL | Stock | 246.58 | 248.12 | 245.99 | 247.99 | 1964259.0 |
| 2024-12-12 10:30:00 | AAPL | Stock | 247.99 | 248.57 | 247.8721 | 248.04 | 1639073.0 |
| 2024-12-12 11:00:00 | AAPL | Stock | 248.05 | 248.5996 | 247.66 | 248.48 | 989737.0 |
| 2024-12-12 11:30:00 | AAPL | Stock | 248.48 | 248.5499 | 248.0887 | 248.1903 | 618308.0 |
| 2024-12-12 12:00:00 | AAPL | Stock | 248.19 | 248.43 | 247.99 | 248.0928 | 841660.0 |
| 2024-12-12 12:30:00 | AAPL | Stock | 248.09 | 248.55 | 247.63 | 248.55 | 743850.0 |
| 2024-12-12 13:00:00 | AAPL | Stock | 248.54 | 248.74 | 248.34 | 248.52 | 761147.0 |
| 2024-12-12 13:30:00 | AAPL | Stock | 248.52 | 248.65 | 248.421 | 248.5236 | 609330.0 |
| 2024-12-12 14:00:00 | AAPL | Stock | 248.5209 | 248.74 | 248.0 | 248.02 | 792781.0 |
| 2024-12-12 14:30:00 | AAPL | Stock | 248.015 | 248.21 | 247.8 | 247.93 | 572623.0 |
| 2024-12-12 15:00:00 | AAPL | Stock | 247.92 | 247.945 | 247.45 | 247.75 | 803568.0 |
| 2024-12-12 15:30:00 | AAPL | Stock | 247.75 | 248.2 | 247.74 | 247.94 | 2005963.0 |
| 2024-12-12 16:00:00 | AAPL | Stock | 247.96 | 248.47 | 247.61 | 247.82 | 5546508.0 |
| 2024-12-12 16:30:00 | AAPL | Stock | 248.0 | 248.12 | 247.69 | 248.05 | 61062.0 |
| 2024-12-12 17:00:00 | AAPL | Stock | 248.12 | 248.12 | 247.3 | 247.41 | 35200.0 |
| 2024-12-12 17:30:00 | AAPL | Stock | 247.4 | 247.96 | 247.0 | 247.58 | 28980.0 |
| 2024-12-12 18:00:00 | AAPL | Stock | 247.45 | 247.45 | 246.51 | 246.68 | 39597.0 |
| 2024-12-12 18:30:00 | AAPL | Stock | 246.58 | 247.0 | 246.58 | 246.8552 | 12989.0 |
| 2024-12-12 19:00:00 | AAPL | Stock | 246.7801 | 247.1854 | 246.7 | 247.1854 | 5577.0 |
| 2024-12-12 19:30:00 | AAPL | Stock | 247.2 | 247.3528 | 247.0 | 247.15 | 8069.0 |
| 2024-12-12 04:00:00 | MSFT | Stock | 446.99 | 447.68 | 446.99 | 447.46 | 1290.0 |
| 2024-12-12 04:30:00 | MSFT | Stock | 447.3 | 447.5 | 446.96 | 446.96 | 1806.0 |
| 2024-12-12 05:00:00 | MSFT | Stock | 446.8 | 447.02 | 446.8 | 447.02 | 3718.0 |
| 2024-12-12 05:30:00 | MSFT | Stock | 447.21 | 447.21 | 447.14 | 447.14 | 322.0 |
| 2024-12-12 06:00:00 | MSFT | Stock | 447.14 | 447.14 | 446.55 | 446.55 | 4284.0 |
| 2024-12-12 06:30:00 | MSFT | Stock | 446.9 | 446.94 | 446.9 | 446.9 | 815.0 |
| 2024-12-12 07:00:00 | MSFT | Stock | 446.89 | 447.45 | 446.89 | 447.4 | 5614.0 |
| 2024-12-12 07:30:00 | MSFT | Stock | 447.3 | 448.19 | 447.11 | 447.87 | 8011.0 |
| 2024-12-12 08:00:00 | MSFT | Stock | 446.96 | 449.17 | 446.96 | 447.63 | 20458.0 |
| 2024-12-12 08:30:00 | MSFT | Stock | 447.3 | 448.3599 | 447.1 | 447.58 | 32176.0 |
| 2024-12-12 09:00:00 | MSFT | Stock | 447.78 | 450.61 | 446.9 | 449.81 | 82324.0 |
| 2024-12-12 09:30:00 | MSFT | Stock | 449.81 | 453.6 | 449.11 | 452.215 | 2189210.0 |
| 2024-12-12 10:00:00 | MSFT | Stock | 452.32 | 453.91 | 450.5 | 453.0 | 1242614.0 |
| 2024-12-12 10:30:00 | MSFT | Stock | 453.0 | 455.7699 | 452.8201 | 455.37 | 1029699.0 |
| 2024-12-12 11:00:00 | MSFT | Stock | 455.325 | 456.1648 | 454.37 | 454.55 | 672454.0 |
| 2024-12-12 11:30:00 | MSFT | Stock | 454.61 | 454.615 | 452.85 | 453.425 | 468515.0 |
| 2024-12-12 12:00:00 | MSFT | Stock | 453.4 | 455.24 | 453.32 | 454.1597 | 507291.0 |
| 2024-12-12 12:30:00 | MSFT | Stock | 454.155 | 454.6 | 453.35 | 454.45 | 292192.0 |
> showing 50 of 104,958 rows — these rows as CSV