PREVIEW / stock_30min / 2024-01-04
file: by_date/stock_30min/2024/2024-01-04.parquet size: 2.1 MB rows: 100,091 symbols: 1,206
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-01-04 04:00:00 | AAPL | Stock | 183.3 | 183.3 | 182.7 | 183.0 | 37096.0 |
| 2024-01-04 04:30:00 | AAPL | Stock | 183.04 | 183.18 | 183.0 | 183.09 | 11921.0 |
| 2024-01-04 05:00:00 | AAPL | Stock | 183.01 | 183.08 | 182.85 | 183.0 | 9159.0 |
| 2024-01-04 05:30:00 | AAPL | Stock | 182.99 | 183.0 | 182.55 | 182.75 | 6455.0 |
| 2024-01-04 06:00:00 | AAPL | Stock | 182.77 | 183.14 | 182.77 | 183.14 | 9591.0 |
| 2024-01-04 06:30:00 | AAPL | Stock | 183.1 | 183.1 | 182.67 | 182.67 | 8257.0 |
| 2024-01-04 07:00:00 | AAPL | Stock | 182.75 | 183.25 | 182.75 | 183.0 | 27970.0 |
| 2024-01-04 07:30:00 | AAPL | Stock | 182.95 | 183.0 | 182.66 | 182.66 | 28785.0 |
| 2024-01-04 08:00:00 | AAPL | Stock | 182.83 | 184.94 | 181.95 | 182.25 | 278502.0 |
| 2024-01-04 08:30:00 | AAPL | Stock | 182.24 | 182.24 | 181.88 | 181.98 | 117765.0 |
| 2024-01-04 09:00:00 | AAPL | Stock | 181.96 | 182.55 | 181.8 | 181.98 | 251744.0 |
| 2024-01-04 09:30:00 | AAPL | Stock | 182.17 | 183.0872 | 181.2276 | 181.4801 | 8006431.0 |
| 2024-01-04 10:00:00 | AAPL | Stock | 181.48 | 182.1438 | 181.32 | 181.68 | 4686274.0 |
| 2024-01-04 10:30:00 | AAPL | Stock | 181.67 | 181.74 | 180.88 | 181.49 | 5295849.0 |
| 2024-01-04 11:00:00 | AAPL | Stock | 181.49 | 182.355 | 181.49 | 182.125 | 3568344.0 |
| 2024-01-04 11:30:00 | AAPL | Stock | 182.127 | 182.44 | 181.32 | 181.44 | 2939284.0 |
| 2024-01-04 12:00:00 | AAPL | Stock | 181.44 | 182.14 | 181.43 | 182.14 | 2542474.0 |
| 2024-01-04 12:30:00 | AAPL | Stock | 182.13 | 182.39 | 181.96 | 182.235 | 1922586.0 |
| 2024-01-04 13:00:00 | AAPL | Stock | 182.23 | 182.99 | 182.17 | 182.915 | 2385423.0 |
| 2024-01-04 13:30:00 | AAPL | Stock | 182.91 | 183.07 | 182.67 | 182.75 | 1722755.0 |
| 2024-01-04 14:00:00 | AAPL | Stock | 182.75 | 182.96 | 182.42 | 182.5 | 1865673.0 |
| 2024-01-04 14:30:00 | AAPL | Stock | 182.5 | 182.66 | 182.265 | 182.3 | 1819568.0 |
| 2024-01-04 15:00:00 | AAPL | Stock | 182.31 | 182.5499 | 181.8721 | 181.9401 | 2301110.0 |
| 2024-01-04 15:30:00 | AAPL | Stock | 181.945 | 182.415 | 181.43 | 181.92 | 6499040.0 |
| 2024-01-04 16:00:00 | AAPL | Stock | 181.92 | 182.0899 | 181.89 | 181.98 | 7761127.0 |
| 2024-01-04 16:30:00 | AAPL | Stock | 181.96 | 181.98 | 181.64 | 181.83 | 79100.0 |
| 2024-01-04 17:00:00 | AAPL | Stock | 181.82 | 181.85 | 181.69 | 181.81 | 14159.0 |
| 2024-01-04 17:30:00 | AAPL | Stock | 181.85 | 181.91 | 181.83 | 181.9 | 20102.0 |
| 2024-01-04 18:00:00 | AAPL | Stock | 181.91 | 182.1 | 181.91 | 182.01 | 12446.0 |
| 2024-01-04 18:30:00 | AAPL | Stock | 182.01 | 182.08 | 181.86 | 181.88 | 13757.0 |
| 2024-01-04 19:00:00 | AAPL | Stock | 181.88 | 181.91 | 181.83 | 181.91 | 8078.0 |
| 2024-01-04 19:30:00 | AAPL | Stock | 181.91 | 181.99 | 181.9 | 181.9101 | 14407.0 |
| 2024-01-04 04:00:00 | MSFT | Stock | 371.09 | 371.2 | 371.05 | 371.2 | 433.0 |
| 2024-01-04 04:30:00 | MSFT | Stock | 371.16 | 371.16 | 371.16 | 371.16 | 100.0 |
| 2024-01-04 05:00:00 | MSFT | Stock | 371.2 | 371.43 | 371.0 | 371.41 | 1221.0 |
| 2024-01-04 06:00:00 | MSFT | Stock | 371.49 | 371.49 | 371.49 | 371.49 | 100.0 |
| 2024-01-04 06:30:00 | MSFT | Stock | 371.5 | 371.59 | 371.5 | 371.58 | 356.0 |
| 2024-01-04 07:00:00 | MSFT | Stock | 371.31 | 371.71 | 371.15 | 371.5 | 4294.0 |
| 2024-01-04 07:30:00 | MSFT | Stock | 371.7 | 371.86 | 371.69 | 371.86 | 1802.0 |
| 2024-01-04 08:00:00 | MSFT | Stock | 371.7 | 371.99 | 370.44 | 371.84 | 18992.0 |
| 2024-01-04 08:30:00 | MSFT | Stock | 371.83 | 371.83 | 370.5 | 370.69 | 25279.0 |
| 2024-01-04 09:00:00 | MSFT | Stock | 370.5899 | 370.86 | 370.3 | 370.86 | 10691.0 |
| 2024-01-04 09:30:00 | MSFT | Stock | 370.665 | 372.64 | 370.5 | 371.54 | 1418675.0 |
| 2024-01-04 10:00:00 | MSFT | Stock | 371.525 | 372.47 | 371.06 | 371.94 | 824108.0 |
| 2024-01-04 10:30:00 | MSFT | Stock | 371.955 | 372.381 | 371.6 | 371.76 | 607208.0 |
| 2024-01-04 11:00:00 | MSFT | Stock | 371.77 | 373.1 | 371.77 | 372.1071 | 744345.0 |
| 2024-01-04 11:30:00 | MSFT | Stock | 372.1201 | 372.48 | 371.0 | 371.02 | 672566.0 |
| 2024-01-04 12:00:00 | MSFT | Stock | 371.03 | 371.46 | 370.661 | 370.975 | 516592.0 |
| 2024-01-04 12:30:00 | MSFT | Stock | 370.96 | 370.99 | 369.92 | 370.365 | 551263.0 |
| 2024-01-04 13:00:00 | MSFT | Stock | 370.36 | 370.64 | 370.1787 | 370.6 | 348447.0 |
> showing 50 of 100,091 rows — these rows as CSV