PREVIEW / stock_30min / 2024-04-12
file: by_date/stock_30min/2024/2024-04-12.parquet size: 2.0 MB rows: 98,293 symbols: 1,014
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-04-12 04:00:00 | AAPL | Stock | 174.96 | 175.5 | 174.7 | 175.08 | 28899.0 |
| 2024-04-12 04:30:00 | AAPL | Stock | 175.05 | 175.16 | 174.83 | 174.84 | 14356.0 |
| 2024-04-12 05:00:00 | AAPL | Stock | 174.83 | 174.85 | 174.25 | 174.38 | 15558.0 |
| 2024-04-12 05:30:00 | AAPL | Stock | 174.32 | 174.45 | 174.17 | 174.36 | 8314.0 |
| 2024-04-12 06:00:00 | AAPL | Stock | 174.32 | 174.34 | 174.04 | 174.3 | 11687.0 |
| 2024-04-12 06:30:00 | AAPL | Stock | 174.3 | 174.3 | 173.49 | 173.93 | 33051.0 |
| 2024-04-12 07:00:00 | AAPL | Stock | 173.97 | 174.15 | 173.8 | 174.15 | 54598.0 |
| 2024-04-12 07:30:00 | AAPL | Stock | 174.19 | 174.95 | 174.15 | 174.63 | 74731.0 |
| 2024-04-12 08:00:00 | AAPL | Stock | 174.05 | 175.4 | 173.7888 | 174.55 | 147943.0 |
| 2024-04-12 08:30:00 | AAPL | Stock | 174.55 | 174.55 | 173.8 | 173.95 | 165090.0 |
| 2024-04-12 09:00:00 | AAPL | Stock | 173.985 | 174.45 | 173.62 | 174.29 | 224607.0 |
| 2024-04-12 09:30:00 | AAPL | Stock | 174.26 | 178.36 | 174.21 | 178.07 | 19670582.0 |
| 2024-04-12 10:00:00 | AAPL | Stock | 178.07 | 178.19 | 176.5 | 176.7425 | 9261382.0 |
| 2024-04-12 10:30:00 | AAPL | Stock | 176.74 | 176.78 | 175.745 | 175.8717 | 5774432.0 |
| 2024-04-12 11:00:00 | AAPL | Stock | 175.875 | 176.81 | 175.32 | 176.2543 | 5015921.0 |
| 2024-04-12 11:30:00 | AAPL | Stock | 176.26 | 176.99 | 175.9 | 175.91 | 3842737.0 |
| 2024-04-12 12:00:00 | AAPL | Stock | 175.93 | 176.22 | 175.565 | 175.6 | 3225313.0 |
| 2024-04-12 12:30:00 | AAPL | Stock | 175.6 | 175.66 | 174.92 | 175.01 | 3366992.0 |
| 2024-04-12 13:00:00 | AAPL | Stock | 175.02 | 175.61 | 174.8 | 175.35 | 3206407.0 |
| 2024-04-12 13:30:00 | AAPL | Stock | 175.34 | 176.0 | 175.235 | 175.4098 | 3005020.0 |
| 2024-04-12 14:00:00 | AAPL | Stock | 175.405 | 175.99 | 175.345 | 175.97 | 2667374.0 |
| 2024-04-12 14:30:00 | AAPL | Stock | 175.97 | 176.26 | 175.725 | 175.94 | 3532240.0 |
| 2024-04-12 15:00:00 | AAPL | Stock | 175.935 | 176.15 | 175.63 | 176.0175 | 3411605.0 |
| 2024-04-12 15:30:00 | AAPL | Stock | 176.015 | 176.74 | 175.955 | 176.56 | 8541361.0 |
| 2024-04-12 16:00:00 | AAPL | Stock | 176.57 | 176.92 | 176.54 | 176.9 | 9299934.0 |
| 2024-04-12 16:30:00 | AAPL | Stock | 176.93 | 176.94 | 176.55 | 176.91 | 128795.0 |
| 2024-04-12 17:00:00 | AAPL | Stock | 176.91 | 176.99 | 176.88 | 176.92 | 24002.0 |
| 2024-04-12 17:30:00 | AAPL | Stock | 176.55 | 176.91 | 176.55 | 176.57 | 36548.0 |
| 2024-04-12 18:00:00 | AAPL | Stock | 176.57 | 176.57 | 176.2209 | 176.37 | 48432.0 |
| 2024-04-12 18:30:00 | AAPL | Stock | 176.35 | 176.45 | 176.35 | 176.4051 | 4897.0 |
| 2024-04-12 19:00:00 | AAPL | Stock | 176.37 | 176.43 | 176.16 | 176.16 | 11143.0 |
| 2024-04-12 19:30:00 | AAPL | Stock | 176.16 | 176.25 | 176.02 | 176.21 | 24923.0 |
| 2024-04-12 04:00:00 | MSFT | Stock | 427.5 | 427.98 | 427.35 | 427.68 | 1858.0 |
| 2024-04-12 04:30:00 | MSFT | Stock | 427.71 | 427.71 | 427.71 | 427.71 | 125.0 |
| 2024-04-12 05:00:00 | MSFT | Stock | 427.02 | 427.02 | 426.7 | 426.7 | 1194.0 |
| 2024-04-12 05:30:00 | MSFT | Stock | 426.9 | 426.9 | 426.83 | 426.84 | 418.0 |
| 2024-04-12 06:00:00 | MSFT | Stock | 426.74 | 426.74 | 426.65 | 426.65 | 514.0 |
| 2024-04-12 06:30:00 | MSFT | Stock | 426.23 | 426.23 | 425.85 | 426.08 | 1383.0 |
| 2024-04-12 07:00:00 | MSFT | Stock | 426.39 | 426.64 | 425.83 | 426.01 | 8198.0 |
| 2024-04-12 07:30:00 | MSFT | Stock | 426.21 | 426.7 | 426.21 | 426.69 | 3507.0 |
| 2024-04-12 08:00:00 | MSFT | Stock | 426.351 | 428.5 | 425.93 | 427.0 | 18422.0 |
| 2024-04-12 08:30:00 | MSFT | Stock | 426.75 | 426.75 | 425.25 | 425.4 | 20168.0 |
| 2024-04-12 09:00:00 | MSFT | Stock | 425.41 | 425.41 | 424.0 | 424.07 | 20405.0 |
| 2024-04-12 09:30:00 | MSFT | Stock | 424.05 | 425.1794 | 422.52 | 424.83 | 1730395.0 |
| 2024-04-12 10:00:00 | MSFT | Stock | 424.86 | 424.91 | 422.317 | 422.53 | 879441.0 |
| 2024-04-12 10:30:00 | MSFT | Stock | 422.51 | 422.7099 | 420.74 | 421.0 | 758557.0 |
| 2024-04-12 11:00:00 | MSFT | Stock | 421.05 | 423.7 | 420.92 | 423.65 | 522927.0 |
| 2024-04-12 11:30:00 | MSFT | Stock | 423.67 | 424.44 | 423.015 | 423.83 | 545844.0 |
| 2024-04-12 12:00:00 | MSFT | Stock | 423.91 | 424.26 | 422.29 | 422.595 | 425826.0 |
| 2024-04-12 12:30:00 | MSFT | Stock | 422.615 | 422.775 | 421.1 | 421.1 | 481036.0 |
> showing 50 of 98,293 rows — these rows as CSV