PREVIEW / stock_30min / 2022-02-01
file: by_date/stock_30min/2022/2022-02-01.parquet size: 2.2 MB rows: 109,580 symbols: 2,634
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-02-01 04:00:00 | AAPL | Stock | 174.5 | 175.38 | 174.33 | 174.33 | 26794.0 |
| 2022-02-01 04:30:00 | AAPL | Stock | 174.28 | 174.6 | 174.02 | 174.5 | 9448.0 |
| 2022-02-01 05:00:00 | AAPL | Stock | 174.17 | 174.6 | 174.1 | 174.5 | 11377.0 |
| 2022-02-01 05:30:00 | AAPL | Stock | 174.53 | 174.69 | 174.25 | 174.25 | 8503.0 |
| 2022-02-01 06:00:00 | AAPL | Stock | 174.37 | 174.43 | 174.02 | 174.22 | 10608.0 |
| 2022-02-01 06:30:00 | AAPL | Stock | 174.22 | 174.48 | 174.02 | 174.26 | 11189.0 |
| 2022-02-01 07:00:00 | AAPL | Stock | 174.22 | 174.92 | 174.2 | 174.89 | 74765.0 |
| 2022-02-01 07:30:00 | AAPL | Stock | 174.93 | 175.23 | 174.8 | 175.05 | 102537.0 |
| 2022-02-01 08:00:00 | AAPL | Stock | 174.4999 | 175.31 | 174.34 | 175.07 | 297117.0 |
| 2022-02-01 08:30:00 | AAPL | Stock | 175.04 | 175.1 | 174.8 | 174.94 | 211687.0 |
| 2022-02-01 09:00:00 | AAPL | Stock | 174.94 | 174.97 | 174.01 | 174.03 | 386964.0 |
| 2022-02-01 09:30:00 | AAPL | Stock | 174.01 | 174.59 | 172.31 | 173.3088 | 11429794.0 |
| 2022-02-01 10:00:00 | AAPL | Stock | 173.28 | 173.39 | 172.35 | 172.9 | 5545388.0 |
| 2022-02-01 10:30:00 | AAPL | Stock | 172.91 | 173.75 | 172.53 | 173.74 | 4923974.0 |
| 2022-02-01 11:00:00 | AAPL | Stock | 173.73 | 174.145 | 173.5 | 173.98 | 4299424.0 |
| 2022-02-01 11:30:00 | AAPL | Stock | 173.975 | 174.435 | 173.73 | 174.21 | 3951512.0 |
| 2022-02-01 12:00:00 | AAPL | Stock | 174.205 | 174.2599 | 173.48 | 173.78 | 3210705.0 |
| 2022-02-01 12:30:00 | AAPL | Stock | 173.79 | 173.8 | 172.98 | 173.39 | 2844534.0 |
| 2022-02-01 13:00:00 | AAPL | Stock | 173.38 | 173.38 | 172.9 | 173.01 | 2305291.0 |
| 2022-02-01 13:30:00 | AAPL | Stock | 173.014 | 173.21 | 172.58 | 173.073 | 2453772.0 |
| 2022-02-01 14:00:00 | AAPL | Stock | 173.08 | 173.3 | 172.51 | 173.0924 | 2738767.0 |
| 2022-02-01 14:30:00 | AAPL | Stock | 173.095 | 173.33 | 172.81 | 173.17 | 2508120.0 |
| 2022-02-01 15:00:00 | AAPL | Stock | 173.1712 | 174.19 | 173.1099 | 174.1272 | 4046292.0 |
| 2022-02-01 15:30:00 | AAPL | Stock | 174.13 | 174.84 | 174.02 | 174.61 | 8106606.0 |
| 2022-02-01 16:00:00 | AAPL | Stock | 174.58 | 174.75 | 173.97 | 174.44 | 7541403.0 |
| 2022-02-01 16:30:00 | AAPL | Stock | 174.46 | 174.98 | 174.09 | 174.5901 | 113069.0 |
| 2022-02-01 17:00:00 | AAPL | Stock | 174.59 | 174.61 | 174.25 | 174.52 | 78807.0 |
| 2022-02-01 17:30:00 | AAPL | Stock | 174.53 | 174.61 | 174.25 | 174.31 | 43494.0 |
| 2022-02-01 18:00:00 | AAPL | Stock | 174.32 | 174.32 | 173.95 | 174.2 | 40364.0 |
| 2022-02-01 18:30:00 | AAPL | Stock | 174.2 | 174.3 | 174.1 | 174.3 | 27378.0 |
| 2022-02-01 19:00:00 | AAPL | Stock | 174.28 | 174.49 | 174.25 | 174.36 | 24196.0 |
| 2022-02-01 19:30:00 | AAPL | Stock | 174.34 | 174.59 | 174.12 | 174.45 | 47312.0 |
| 2022-02-01 04:00:00 | MSFT | Stock | 311.79 | 311.92 | 310.01 | 310.01 | 4609.0 |
| 2022-02-01 04:30:00 | MSFT | Stock | 310.0 | 310.67 | 310.0 | 310.49 | 1795.0 |
| 2022-02-01 05:00:00 | MSFT | Stock | 310.64 | 310.95 | 310.64 | 310.79 | 1080.0 |
| 2022-02-01 05:30:00 | MSFT | Stock | 310.99 | 311.09 | 309.91 | 310.3 | 1511.0 |
| 2022-02-01 06:00:00 | MSFT | Stock | 310.48 | 310.76 | 309.86 | 309.86 | 2556.0 |
| 2022-02-01 06:30:00 | MSFT | Stock | 310.15 | 310.35 | 309.7 | 309.95 | 2574.0 |
| 2022-02-01 07:00:00 | MSFT | Stock | 309.99 | 310.84 | 309.25 | 310.35 | 11484.0 |
| 2022-02-01 07:30:00 | MSFT | Stock | 310.74 | 311.0 | 310.43 | 310.8 | 18111.0 |
| 2022-02-01 08:00:00 | MSFT | Stock | 310.6158 | 311.757 | 309.74 | 310.8 | 29217.0 |
| 2022-02-01 08:30:00 | MSFT | Stock | 310.78 | 311.0 | 310.38 | 310.75 | 17942.0 |
| 2022-02-01 09:00:00 | MSFT | Stock | 310.75 | 311.2 | 310.06 | 310.64 | 42926.0 |
| 2022-02-01 09:30:00 | MSFT | Stock | 310.48 | 310.73 | 306.0301 | 307.06 | 3821739.0 |
| 2022-02-01 10:00:00 | MSFT | Stock | 307.15 | 307.82 | 305.31 | 306.46 | 2561470.0 |
| 2022-02-01 10:30:00 | MSFT | Stock | 306.455 | 307.17 | 305.4 | 307.0739 | 2393670.0 |
| 2022-02-01 11:00:00 | MSFT | Stock | 307.05 | 308.02 | 306.61 | 307.65 | 2054385.0 |
| 2022-02-01 11:30:00 | MSFT | Stock | 307.64 | 308.7048 | 306.82 | 308.355 | 1900098.0 |
| 2022-02-01 12:00:00 | MSFT | Stock | 308.37 | 308.54 | 307.0 | 307.47 | 1219992.0 |
| 2022-02-01 12:30:00 | MSFT | Stock | 307.4899 | 307.58 | 305.88 | 306.7 | 1164579.0 |
> showing 50 of 109,580 rows — these rows as CSV