PREVIEW / stock_30min / 2021-01-25
file: by_date/stock_30min/2021/2021-01-25.parquet size: 2.3 MB rows: 120,322 symbols: 2,727
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-01-25 04:00:00 | AAPL | Stock | 141.02 | 143.0 | 141.02 | 142.35 | 128918.0 |
| 2021-01-25 04:30:00 | AAPL | Stock | 142.37 | 142.44 | 141.81 | 141.87 | 54387.0 |
| 2021-01-25 05:00:00 | AAPL | Stock | 141.9 | 142.14 | 141.51 | 142.14 | 61864.0 |
| 2021-01-25 05:30:00 | AAPL | Stock | 142.15 | 142.35 | 142.01 | 142.17 | 29183.0 |
| 2021-01-25 06:00:00 | AAPL | Stock | 142.12 | 142.43 | 142.1 | 142.2 | 29103.0 |
| 2021-01-25 06:30:00 | AAPL | Stock | 142.2 | 142.35 | 141.6 | 141.9 | 75169.0 |
| 2021-01-25 07:00:00 | AAPL | Stock | 141.92 | 143.1 | 141.89 | 142.81 | 661651.0 |
| 2021-01-25 07:30:00 | AAPL | Stock | 142.82 | 142.88 | 142.4 | 142.82 | 329968.0 |
| 2021-01-25 08:00:00 | AAPL | Stock | 142.81 | 143.09 | 139.07 | 142.84 | 758865.0 |
| 2021-01-25 08:30:00 | AAPL | Stock | 142.82 | 142.9 | 142.63 | 142.65 | 445200.0 |
| 2021-01-25 09:00:00 | AAPL | Stock | 142.67 | 143.24 | 142.5 | 143.0 | 769625.0 |
| 2021-01-25 09:30:00 | AAPL | Stock | 143.03 | 145.09 | 142.93 | 144.935 | 23094275.0 |
| 2021-01-25 10:00:00 | AAPL | Stock | 144.94 | 144.99 | 143.88 | 144.23 | 9800050.0 |
| 2021-01-25 10:30:00 | AAPL | Stock | 144.23 | 144.32 | 140.88 | 141.13 | 11777631.0 |
| 2021-01-25 11:00:00 | AAPL | Stock | 141.09 | 141.9 | 136.54 | 141.22 | 20670193.0 |
| 2021-01-25 11:30:00 | AAPL | Stock | 141.22 | 142.77 | 141.16 | 142.59 | 8896694.0 |
| 2021-01-25 12:00:00 | AAPL | Stock | 142.6 | 142.95 | 140.91 | 141.19 | 8007282.0 |
| 2021-01-25 12:30:00 | AAPL | Stock | 141.18 | 142.83 | 141.04 | 142.43 | 6464472.0 |
| 2021-01-25 13:00:00 | AAPL | Stock | 142.43 | 143.29 | 142.16 | 142.99 | 6382645.0 |
| 2021-01-25 13:30:00 | AAPL | Stock | 143.01 | 143.25 | 142.3 | 142.66 | 5580948.0 |
| 2021-01-25 14:00:00 | AAPL | Stock | 142.67 | 142.839 | 141.79 | 142.582 | 4536597.0 |
| 2021-01-25 14:30:00 | AAPL | Stock | 142.58 | 143.0 | 142.462 | 142.69 | 4157860.0 |
| 2021-01-25 15:00:00 | AAPL | Stock | 142.695 | 142.825 | 141.75 | 142.061 | 5398350.0 |
| 2021-01-25 15:30:00 | AAPL | Stock | 142.06 | 143.13 | 141.99 | 142.9 | 8849002.0 |
| 2021-01-25 16:00:00 | AAPL | Stock | 142.92 | 143.8 | 142.88 | 143.72 | 6200801.0 |
| 2021-01-25 16:30:00 | AAPL | Stock | 143.77 | 143.77 | 143.2 | 143.55 | 120205.0 |
| 2021-01-25 17:00:00 | AAPL | Stock | 143.55 | 143.57 | 143.02 | 143.06 | 119723.0 |
| 2021-01-25 17:30:00 | AAPL | Stock | 143.08 | 143.23 | 142.51 | 142.82 | 143100.0 |
| 2021-01-25 18:00:00 | AAPL | Stock | 142.75 | 143.2 | 142.71 | 143.08 | 101929.0 |
| 2021-01-25 18:30:00 | AAPL | Stock | 143.09 | 143.1 | 142.92 | 143.02 | 56023.0 |
| 2021-01-25 19:00:00 | AAPL | Stock | 143.02 | 143.09 | 142.7 | 142.7 | 66380.0 |
| 2021-01-25 19:30:00 | AAPL | Stock | 142.72 | 142.94 | 142.61 | 142.72 | 117054.0 |
| 2021-01-25 04:00:00 | MSFT | Stock | 228.3 | 229.5 | 228.3 | 229.5 | 12813.0 |
| 2021-01-25 04:30:00 | MSFT | Stock | 229.7 | 230.01 | 229.7 | 229.7 | 28213.0 |
| 2021-01-25 05:00:00 | MSFT | Stock | 229.82 | 229.86 | 229.21 | 229.5 | 11751.0 |
| 2021-01-25 05:30:00 | MSFT | Stock | 229.27 | 229.8 | 229.27 | 229.73 | 6044.0 |
| 2021-01-25 06:00:00 | MSFT | Stock | 229.73 | 230.0 | 229.5 | 229.8 | 7652.0 |
| 2021-01-25 06:30:00 | MSFT | Stock | 229.85 | 230.05 | 229.21 | 229.21 | 15887.0 |
| 2021-01-25 07:00:00 | MSFT | Stock | 229.04 | 229.89 | 229.0 | 229.05 | 61976.0 |
| 2021-01-25 07:30:00 | MSFT | Stock | 229.11 | 229.37 | 228.85 | 228.85 | 20474.0 |
| 2021-01-25 08:00:00 | MSFT | Stock | 229.207 | 229.69 | 225.39 | 229.16 | 70595.0 |
| 2021-01-25 08:30:00 | MSFT | Stock | 229.1 | 229.47 | 228.8 | 228.8 | 60720.0 |
| 2021-01-25 09:00:00 | MSFT | Stock | 228.9 | 229.38 | 228.51 | 229.23 | 54875.0 |
| 2021-01-25 09:30:00 | MSFT | Stock | 229.23 | 229.74 | 227.26 | 227.395 | 3014073.0 |
| 2021-01-25 10:00:00 | MSFT | Stock | 227.37 | 228.81 | 226.91 | 228.57 | 2436252.0 |
| 2021-01-25 10:30:00 | MSFT | Stock | 228.56 | 229.17 | 225.96 | 226.184 | 2142123.0 |
| 2021-01-25 11:00:00 | MSFT | Stock | 226.17 | 226.72 | 224.22 | 225.68 | 2310292.0 |
| 2021-01-25 11:30:00 | MSFT | Stock | 225.75 | 227.06 | 225.53 | 226.98 | 990210.0 |
| 2021-01-25 12:00:00 | MSFT | Stock | 226.99 | 227.47 | 225.28 | 225.94 | 1202620.0 |
| 2021-01-25 12:30:00 | MSFT | Stock | 225.95 | 227.75 | 225.6 | 227.56 | 1118011.0 |
> showing 50 of 120,322 rows — these rows as CSV