PREVIEW / stock_30min / 2022-01-11
file: by_date/stock_30min/2022/2022-01-11.parquet size: 2.2 MB rows: 108,333 symbols: 2,587
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 |
|---|---|---|---|---|---|---|---|
| 2022-01-11 04:00:00 | AAPL | Stock | 172.75 | 173.51 | 172.39 | 173.46 | 9770.0 |
| 2022-01-11 04:30:00 | AAPL | Stock | 173.45 | 173.95 | 173.45 | 173.76 | 19544.0 |
| 2022-01-11 05:00:00 | AAPL | Stock | 173.79 | 174.08 | 173.6 | 173.87 | 10228.0 |
| 2022-01-11 05:30:00 | AAPL | Stock | 173.83 | 173.99 | 173.8 | 173.93 | 4035.0 |
| 2022-01-11 06:00:00 | AAPL | Stock | 173.98 | 173.98 | 173.12 | 173.28 | 29691.0 |
| 2022-01-11 06:30:00 | AAPL | Stock | 173.27 | 173.69 | 173.27 | 173.56 | 14102.0 |
| 2022-01-11 07:00:00 | AAPL | Stock | 173.56 | 173.64 | 173.25 | 173.58 | 40856.0 |
| 2022-01-11 07:30:00 | AAPL | Stock | 173.62 | 173.65 | 173.02 | 173.05 | 32255.0 |
| 2022-01-11 08:00:00 | AAPL | Stock | 173.6299 | 173.65 | 172.93 | 173.12 | 208470.0 |
| 2022-01-11 08:30:00 | AAPL | Stock | 173.14 | 173.33 | 172.34 | 172.47 | 240130.0 |
| 2022-01-11 09:00:00 | AAPL | Stock | 172.44 | 172.49 | 171.84 | 172.29 | 285279.0 |
| 2022-01-11 09:30:00 | AAPL | Stock | 172.37 | 172.7 | 170.82 | 171.56 | 8414992.0 |
| 2022-01-11 10:00:00 | AAPL | Stock | 171.6 | 172.56 | 171.31 | 172.2 | 5451886.0 |
| 2022-01-11 10:30:00 | AAPL | Stock | 172.215 | 172.63 | 170.97 | 171.53 | 4809430.0 |
| 2022-01-11 11:00:00 | AAPL | Stock | 171.545 | 174.12 | 171.49 | 174.0734 | 6771760.0 |
| 2022-01-11 11:30:00 | AAPL | Stock | 174.065 | 174.98 | 173.79 | 174.83 | 5664976.0 |
| 2022-01-11 12:00:00 | AAPL | Stock | 174.84 | 175.035 | 173.95 | 174.0 | 4070905.0 |
| 2022-01-11 12:30:00 | AAPL | Stock | 174.01 | 174.44 | 172.59 | 174.2599 | 2489348.0 |
| 2022-01-11 13:00:00 | AAPL | Stock | 174.26 | 174.77 | 173.74 | 174.44 | 2439552.0 |
| 2022-01-11 13:30:00 | AAPL | Stock | 174.435 | 174.53 | 174.14 | 174.485 | 1803737.0 |
| 2022-01-11 14:00:00 | AAPL | Stock | 174.4899 | 174.56 | 173.87 | 174.46 | 2346134.0 |
| 2022-01-11 14:30:00 | AAPL | Stock | 174.465 | 175.105 | 174.21 | 174.8399 | 3526204.0 |
| 2022-01-11 15:00:00 | AAPL | Stock | 174.8398 | 175.1199 | 174.62 | 174.8302 | 3401449.0 |
| 2022-01-11 15:30:00 | AAPL | Stock | 174.84 | 175.18 | 174.4 | 175.09 | 7060598.0 |
| 2022-01-11 16:00:00 | AAPL | Stock | 175.08 | 175.13 | 174.94 | 175.05 | 7234870.0 |
| 2022-01-11 16:30:00 | AAPL | Stock | 175.07 | 175.13 | 175.05 | 175.13 | 62576.0 |
| 2022-01-11 17:00:00 | AAPL | Stock | 175.13 | 175.13 | 175.01 | 175.01 | 7233.0 |
| 2022-01-11 17:30:00 | AAPL | Stock | 175.02 | 175.08 | 175.01 | 175.08 | 7254.0 |
| 2022-01-11 18:00:00 | AAPL | Stock | 175.04 | 175.12 | 175.01 | 175.03 | 16958.0 |
| 2022-01-11 18:30:00 | AAPL | Stock | 175.06 | 175.1 | 175.0 | 175.1 | 7477.0 |
| 2022-01-11 19:00:00 | AAPL | Stock | 175.07 | 175.23 | 175.06 | 175.23 | 24965.0 |
| 2022-01-11 19:30:00 | AAPL | Stock | 175.21 | 175.25 | 175.12 | 175.25 | 43257.0 |
| 2022-01-11 04:00:00 | MSFT | Stock | 314.0 | 316.03 | 314.0 | 316.03 | 8329.0 |
| 2022-01-11 04:30:00 | MSFT | Stock | 315.87 | 316.36 | 315.72 | 316.36 | 1715.0 |
| 2022-01-11 05:00:00 | MSFT | Stock | 316.37 | 316.69 | 316.33 | 316.51 | 2794.0 |
| 2022-01-11 05:30:00 | MSFT | Stock | 316.85 | 316.85 | 316.56 | 316.56 | 2878.0 |
| 2022-01-11 06:00:00 | MSFT | Stock | 316.5 | 316.5 | 316.06 | 316.3 | 2528.0 |
| 2022-01-11 06:30:00 | MSFT | Stock | 316.34 | 316.48 | 316.25 | 316.48 | 967.0 |
| 2022-01-11 07:00:00 | MSFT | Stock | 316.25 | 316.52 | 316.02 | 316.37 | 19525.0 |
| 2022-01-11 07:30:00 | MSFT | Stock | 316.59 | 316.61 | 315.12 | 315.13 | 9514.0 |
| 2022-01-11 08:00:00 | MSFT | Stock | 316.4 | 316.6 | 315.0 | 315.49 | 35357.0 |
| 2022-01-11 08:30:00 | MSFT | Stock | 315.45 | 315.5 | 314.0 | 314.21 | 27154.0 |
| 2022-01-11 09:00:00 | MSFT | Stock | 314.17 | 314.34 | 312.76 | 313.29 | 40679.0 |
| 2022-01-11 09:30:00 | MSFT | Stock | 313.3 | 313.48 | 309.89 | 312.225 | 2981584.0 |
| 2022-01-11 10:00:00 | MSFT | Stock | 312.195 | 313.87 | 311.76 | 312.3 | 1587777.0 |
| 2022-01-11 10:30:00 | MSFT | Stock | 312.32 | 313.13 | 310.45 | 311.66 | 1062424.0 |
| 2022-01-11 11:00:00 | MSFT | Stock | 311.665 | 315.55 | 311.53 | 315.24 | 1619804.0 |
| 2022-01-11 11:30:00 | MSFT | Stock | 315.24 | 316.61 | 314.439 | 316.39 | 1609361.0 |
| 2022-01-11 12:00:00 | MSFT | Stock | 316.45 | 316.53 | 314.55 | 314.82 | 1051712.0 |
| 2022-01-11 12:30:00 | MSFT | Stock | 314.84 | 315.21 | 314.32 | 314.81 | 773814.0 |
> showing 50 of 108,333 rows — these rows as CSV