PREVIEW / stock_30min / 2021-04-23
file: by_date/stock_30min/2021/2021-04-23.parquet size: 2.2 MB rows: 108,418 symbols: 2,963
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 |
|---|---|---|---|---|---|---|---|
| 2021-04-23 04:00:00 | AAPL | Stock | 132.15 | 132.15 | 132.0 | 132.09 | 15362.0 |
| 2021-04-23 04:30:00 | AAPL | Stock | 132.14 | 132.2 | 132.13 | 132.2 | 2791.0 |
| 2021-04-23 05:00:00 | AAPL | Stock | 132.15 | 132.15 | 132.03 | 132.1 | 9002.0 |
| 2021-04-23 05:30:00 | AAPL | Stock | 132.13 | 132.13 | 132.0 | 132.0 | 3481.0 |
| 2021-04-23 06:00:00 | AAPL | Stock | 132.03 | 132.2 | 132.02 | 132.16 | 3826.0 |
| 2021-04-23 06:30:00 | AAPL | Stock | 132.16 | 132.28 | 132.1 | 132.27 | 2118.0 |
| 2021-04-23 07:00:00 | AAPL | Stock | 132.2 | 132.41 | 132.05 | 132.3 | 72183.0 |
| 2021-04-23 07:30:00 | AAPL | Stock | 132.31 | 132.33 | 132.14 | 132.25 | 45578.0 |
| 2021-04-23 08:00:00 | AAPL | Stock | 132.1599 | 132.41 | 132.07 | 132.21 | 179390.0 |
| 2021-04-23 08:30:00 | AAPL | Stock | 132.23 | 132.24 | 132.05 | 132.15 | 75787.0 |
| 2021-04-23 09:00:00 | AAPL | Stock | 132.14 | 132.29 | 132.09 | 132.18 | 92682.0 |
| 2021-04-23 09:30:00 | AAPL | Stock | 132.19 | 133.38 | 132.16 | 133.175 | 7877838.0 |
| 2021-04-23 10:00:00 | AAPL | Stock | 133.17 | 133.47 | 133.04 | 133.1164 | 5156227.0 |
| 2021-04-23 10:30:00 | AAPL | Stock | 133.115 | 133.78 | 133.01 | 133.74 | 4905765.0 |
| 2021-04-23 11:00:00 | AAPL | Stock | 133.74 | 134.19 | 133.62 | 134.19 | 4687677.0 |
| 2021-04-23 11:30:00 | AAPL | Stock | 134.185 | 134.58 | 134.0601 | 134.38 | 4765118.0 |
| 2021-04-23 12:00:00 | AAPL | Stock | 134.375 | 134.53 | 134.163 | 134.28 | 3436230.0 |
| 2021-04-23 12:30:00 | AAPL | Stock | 134.2847 | 134.6 | 134.1 | 134.59 | 4084361.0 |
| 2021-04-23 13:00:00 | AAPL | Stock | 134.59 | 134.8328 | 134.49 | 134.7361 | 3819287.0 |
| 2021-04-23 13:30:00 | AAPL | Stock | 134.74 | 135.12 | 134.59 | 134.621 | 4888107.0 |
| 2021-04-23 14:00:00 | AAPL | Stock | 134.62 | 134.95 | 134.6 | 134.92 | 3511253.0 |
| 2021-04-23 14:30:00 | AAPL | Stock | 134.9258 | 135.1 | 134.84 | 134.8501 | 3637218.0 |
| 2021-04-23 15:00:00 | AAPL | Stock | 134.86 | 134.89 | 134.63 | 134.695 | 3891130.0 |
| 2021-04-23 15:30:00 | AAPL | Stock | 134.69 | 134.99 | 134.2 | 134.3 | 7554396.0 |
| 2021-04-23 16:00:00 | AAPL | Stock | 134.3 | 134.3414 | 134.17 | 134.26 | 6970031.0 |
| 2021-04-23 16:30:00 | AAPL | Stock | 134.25 | 134.28 | 134.18 | 134.21 | 40297.0 |
| 2021-04-23 17:00:00 | AAPL | Stock | 134.21 | 134.32 | 134.17 | 134.26 | 57236.0 |
| 2021-04-23 17:30:00 | AAPL | Stock | 134.26 | 134.31 | 134.2 | 134.25 | 49930.0 |
| 2021-04-23 18:00:00 | AAPL | Stock | 134.26 | 134.31 | 134.23 | 134.29 | 35720.0 |
| 2021-04-23 18:30:00 | AAPL | Stock | 134.26 | 134.28 | 134.24 | 134.26 | 22643.0 |
| 2021-04-23 19:00:00 | AAPL | Stock | 134.26 | 134.27 | 134.22 | 134.25 | 11626.0 |
| 2021-04-23 19:30:00 | AAPL | Stock | 134.25 | 134.3 | 134.23 | 134.29 | 25083.0 |
| 2021-04-23 04:00:00 | MSFT | Stock | 257.69 | 257.88 | 257.69 | 257.88 | 1948.0 |
| 2021-04-23 04:30:00 | MSFT | Stock | 258.01 | 258.23 | 258.0 | 258.13 | 1904.0 |
| 2021-04-23 05:00:00 | MSFT | Stock | 258.1 | 258.1 | 257.78 | 257.78 | 1260.0 |
| 2021-04-23 05:30:00 | MSFT | Stock | 257.75 | 257.75 | 257.73 | 257.74 | 1324.0 |
| 2021-04-23 06:00:00 | MSFT | Stock | 257.74 | 257.99 | 257.62 | 257.62 | 2890.0 |
| 2021-04-23 06:30:00 | MSFT | Stock | 257.9 | 258.2 | 257.9 | 258.01 | 3462.0 |
| 2021-04-23 07:00:00 | MSFT | Stock | 257.76 | 257.97 | 257.68 | 257.77 | 3644.0 |
| 2021-04-23 07:30:00 | MSFT | Stock | 257.76 | 258.0 | 257.72 | 257.8 | 10372.0 |
| 2021-04-23 08:00:00 | MSFT | Stock | 257.8499 | 258.0 | 257.17 | 257.75 | 41955.0 |
| 2021-04-23 08:30:00 | MSFT | Stock | 257.76 | 257.91 | 257.55 | 257.88 | 12810.0 |
| 2021-04-23 09:00:00 | MSFT | Stock | 257.9 | 257.94 | 257.65 | 257.79 | 20487.0 |
| 2021-04-23 09:30:00 | MSFT | Stock | 257.88 | 258.67 | 257.27 | 258.5 | 1426724.0 |
| 2021-04-23 10:00:00 | MSFT | Stock | 258.45 | 258.88 | 257.96 | 258.36 | 839253.0 |
| 2021-04-23 10:30:00 | MSFT | Stock | 258.4 | 259.85 | 258.14 | 259.81 | 918742.0 |
| 2021-04-23 11:00:00 | MSFT | Stock | 259.82 | 260.72 | 259.31 | 260.34 | 1078324.0 |
| 2021-04-23 11:30:00 | MSFT | Stock | 260.37 | 260.81 | 260.26 | 260.47 | 890447.0 |
| 2021-04-23 12:00:00 | MSFT | Stock | 260.48 | 260.89 | 260.36 | 260.89 | 643318.0 |
| 2021-04-23 12:30:00 | MSFT | Stock | 260.89 | 261.41 | 260.67 | 261.1 | 808144.0 |
> showing 50 of 108,418 rows — these rows as CSV