PREVIEW / stock_30min / 2023-11-10
file: by_date/stock_30min/2023/2023-11-10.parquet size: 2.0 MB rows: 95,613 symbols: 1,299
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 |
|---|---|---|---|---|---|---|---|
| 2023-11-10 04:00:00 | AAPL | Stock | 182.08 | 182.32 | 181.83 | 181.87 | 13837.0 |
| 2023-11-10 04:30:00 | AAPL | Stock | 181.86 | 182.32 | 181.78 | 182.32 | 6969.0 |
| 2023-11-10 05:00:00 | AAPL | Stock | 182.17 | 182.17 | 182.0 | 182.0 | 1868.0 |
| 2023-11-10 05:30:00 | AAPL | Stock | 181.94 | 182.16 | 181.92 | 182.16 | 6372.0 |
| 2023-11-10 06:00:00 | AAPL | Stock | 182.1 | 182.17 | 182.01 | 182.13 | 5663.0 |
| 2023-11-10 06:30:00 | AAPL | Stock | 182.02 | 182.04 | 181.89 | 182.04 | 2718.0 |
| 2023-11-10 07:00:00 | AAPL | Stock | 182.05 | 182.49 | 182.04 | 182.49 | 8048.0 |
| 2023-11-10 07:30:00 | AAPL | Stock | 182.48 | 183.0 | 182.45 | 182.99 | 26052.0 |
| 2023-11-10 08:00:00 | AAPL | Stock | 182.07 | 183.07 | 181.71 | 182.95 | 43002.0 |
| 2023-11-10 08:30:00 | AAPL | Stock | 182.9 | 183.45 | 182.882 | 183.37 | 65703.0 |
| 2023-11-10 09:00:00 | AAPL | Stock | 183.3603 | 183.97 | 183.21 | 183.97 | 144077.0 |
| 2023-11-10 09:30:00 | AAPL | Stock | 183.97 | 184.79 | 183.67 | 184.18 | 6699263.0 |
| 2023-11-10 10:00:00 | AAPL | Stock | 184.17 | 184.49 | 183.53 | 183.7799 | 3972242.0 |
| 2023-11-10 10:30:00 | AAPL | Stock | 183.78 | 184.32 | 183.615 | 184.32 | 2441554.0 |
| 2023-11-10 11:00:00 | AAPL | Stock | 184.33 | 184.94 | 184.3 | 184.75 | 3002801.0 |
| 2023-11-10 11:30:00 | AAPL | Stock | 184.76 | 184.77 | 184.43 | 184.73 | 1716033.0 |
| 2023-11-10 12:00:00 | AAPL | Stock | 184.73 | 185.0 | 184.66 | 184.94 | 1819224.0 |
| 2023-11-10 12:30:00 | AAPL | Stock | 184.9401 | 185.43 | 184.88 | 185.2837 | 3511264.0 |
| 2023-11-10 13:00:00 | AAPL | Stock | 185.28 | 185.51 | 185.16 | 185.405 | 2081366.0 |
| 2023-11-10 13:30:00 | AAPL | Stock | 185.405 | 185.83 | 185.4 | 185.7401 | 2475889.0 |
| 2023-11-10 14:00:00 | AAPL | Stock | 185.75 | 185.975 | 185.7 | 185.85 | 1995405.0 |
| 2023-11-10 14:30:00 | AAPL | Stock | 185.85 | 185.87 | 185.555 | 185.5801 | 2133159.0 |
| 2023-11-10 15:00:00 | AAPL | Stock | 185.585 | 186.13 | 185.58 | 186.11 | 2879752.0 |
| 2023-11-10 15:30:00 | AAPL | Stock | 186.11 | 186.565 | 185.955 | 186.34 | 6590887.0 |
| 2023-11-10 16:00:00 | AAPL | Stock | 186.34 | 186.51 | 186.26 | 186.26 | 10773719.0 |
| 2023-11-10 16:30:00 | AAPL | Stock | 186.25 | 186.4 | 186.01 | 186.11 | 371872.0 |
| 2023-11-10 17:00:00 | AAPL | Stock | 186.11 | 186.4 | 186.0 | 186.0 | 60368.0 |
| 2023-11-10 17:30:00 | AAPL | Stock | 186.0 | 186.07 | 185.94 | 186.01 | 25733.0 |
| 2023-11-10 18:00:00 | AAPL | Stock | 186.0 | 186.1 | 185.95 | 186.1 | 17161.0 |
| 2023-11-10 18:30:00 | AAPL | Stock | 186.08 | 186.08 | 186.0 | 186.03 | 4444.0 |
| 2023-11-10 19:00:00 | AAPL | Stock | 186.03 | 186.11 | 186.0 | 186.11 | 5801.0 |
| 2023-11-10 19:30:00 | AAPL | Stock | 186.06 | 186.26 | 186.0 | 186.26 | 12709.0 |
| 2023-11-10 04:00:00 | MSFT | Stock | 360.99 | 361.1 | 360.34 | 360.34 | 6248.0 |
| 2023-11-10 04:30:00 | MSFT | Stock | 360.0 | 360.28 | 359.78 | 360.15 | 6399.0 |
| 2023-11-10 05:00:00 | MSFT | Stock | 360.04 | 360.05 | 359.96 | 359.96 | 825.0 |
| 2023-11-10 05:30:00 | MSFT | Stock | 359.86 | 360.2 | 359.86 | 360.06 | 1393.0 |
| 2023-11-10 06:00:00 | MSFT | Stock | 359.85 | 359.85 | 359.6 | 359.61 | 628.0 |
| 2023-11-10 06:30:00 | MSFT | Stock | 359.7 | 360.36 | 359.7 | 360.36 | 5282.0 |
| 2023-11-10 07:00:00 | MSFT | Stock | 360.36 | 360.5 | 360.2 | 360.38 | 11364.0 |
| 2023-11-10 07:30:00 | MSFT | Stock | 360.41 | 360.7 | 360.31 | 360.7 | 27659.0 |
| 2023-11-10 08:00:00 | MSFT | Stock | 360.37 | 361.2815 | 360.1 | 361.15 | 45202.0 |
| 2023-11-10 08:30:00 | MSFT | Stock | 361.15 | 361.77 | 360.9 | 361.75 | 30197.0 |
| 2023-11-10 09:00:00 | MSFT | Stock | 361.75 | 362.48 | 361.31 | 361.89 | 42011.0 |
| 2023-11-10 09:30:00 | MSFT | Stock | 361.69 | 364.31 | 361.07 | 363.92 | 1892137.0 |
| 2023-11-10 10:00:00 | MSFT | Stock | 363.89 | 364.6 | 363.09 | 363.78 | 1056876.0 |
| 2023-11-10 10:30:00 | MSFT | Stock | 363.82 | 365.21 | 363.685 | 365.19 | 952992.0 |
| 2023-11-10 11:00:00 | MSFT | Stock | 365.21 | 367.3798 | 365.21 | 366.785 | 1730410.0 |
| 2023-11-10 11:30:00 | MSFT | Stock | 366.8 | 367.13 | 366.075 | 366.96 | 775169.0 |
| 2023-11-10 12:00:00 | MSFT | Stock | 366.975 | 368.09 | 366.85 | 367.31 | 912522.0 |
| 2023-11-10 12:30:00 | MSFT | Stock | 367.38 | 368.8 | 367.347 | 368.2116 | 786901.0 |
> showing 50 of 95,613 rows — these rows as CSV