PREVIEW / stock_30min / 2021-04-26
file: by_date/stock_30min/2021/2021-04-26.parquet size: 2.2 MB rows: 111,875 symbols: 2,970
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-26 04:00:00 | AAPL | Stock | 133.9 | 134.19 | 133.75 | 134.05 | 21239.0 |
| 2021-04-26 04:30:00 | AAPL | Stock | 134.06 | 134.12 | 133.99 | 134.09 | 18181.0 |
| 2021-04-26 05:00:00 | AAPL | Stock | 134.16 | 134.16 | 133.9 | 134.0 | 7966.0 |
| 2021-04-26 05:30:00 | AAPL | Stock | 133.99 | 133.99 | 133.92 | 133.94 | 819.0 |
| 2021-04-26 06:00:00 | AAPL | Stock | 133.92 | 134.07 | 133.82 | 133.98 | 2806.0 |
| 2021-04-26 06:30:00 | AAPL | Stock | 133.91 | 133.97 | 133.85 | 133.88 | 5705.0 |
| 2021-04-26 07:00:00 | AAPL | Stock | 133.97 | 134.2 | 133.73 | 133.95 | 113175.0 |
| 2021-04-26 07:30:00 | AAPL | Stock | 133.95 | 134.55 | 133.93 | 134.46 | 163629.0 |
| 2021-04-26 08:00:00 | AAPL | Stock | 134.0501 | 134.55 | 133.82 | 134.43 | 270666.0 |
| 2021-04-26 08:30:00 | AAPL | Stock | 134.4499 | 134.68 | 134.28 | 134.61 | 171088.0 |
| 2021-04-26 09:00:00 | AAPL | Stock | 134.62 | 134.92 | 134.55 | 134.83 | 198888.0 |
| 2021-04-26 09:30:00 | AAPL | Stock | 134.83 | 134.96 | 133.56 | 134.09 | 11085712.0 |
| 2021-04-26 10:00:00 | AAPL | Stock | 134.08 | 134.65 | 134.0305 | 134.445 | 5235285.0 |
| 2021-04-26 10:30:00 | AAPL | Stock | 134.44 | 134.8 | 134.31 | 134.48 | 3706225.0 |
| 2021-04-26 11:00:00 | AAPL | Stock | 134.481 | 134.83 | 134.47 | 134.59 | 3136246.0 |
| 2021-04-26 11:30:00 | AAPL | Stock | 134.6 | 134.7 | 134.44 | 134.5001 | 2272509.0 |
| 2021-04-26 12:00:00 | AAPL | Stock | 134.5012 | 134.53 | 134.2083 | 134.27 | 2712633.0 |
| 2021-04-26 12:30:00 | AAPL | Stock | 134.27 | 134.64 | 134.23 | 134.49 | 2348520.0 |
| 2021-04-26 13:00:00 | AAPL | Stock | 134.485 | 134.69 | 134.44 | 134.56 | 2060754.0 |
| 2021-04-26 13:30:00 | AAPL | Stock | 134.565 | 134.65 | 134.35 | 134.405 | 2402304.0 |
| 2021-04-26 14:00:00 | AAPL | Stock | 134.405 | 134.7967 | 134.4 | 134.71 | 2746309.0 |
| 2021-04-26 14:30:00 | AAPL | Stock | 134.71 | 135.06 | 134.7017 | 135.025 | 3367940.0 |
| 2021-04-26 15:00:00 | AAPL | Stock | 135.025 | 135.06 | 134.57 | 134.6291 | 2871361.0 |
| 2021-04-26 15:30:00 | AAPL | Stock | 134.625 | 134.92 | 134.43 | 134.73 | 5973637.0 |
| 2021-04-26 16:00:00 | AAPL | Stock | 134.72 | 134.84 | 134.51 | 134.64 | 7323786.0 |
| 2021-04-26 16:30:00 | AAPL | Stock | 134.64 | 134.76 | 134.61 | 134.73 | 81759.0 |
| 2021-04-26 17:00:00 | AAPL | Stock | 134.74 | 134.76 | 134.72 | 134.74 | 34719.0 |
| 2021-04-26 17:30:00 | AAPL | Stock | 134.74 | 134.76 | 134.67 | 134.6901 | 67149.0 |
| 2021-04-26 18:00:00 | AAPL | Stock | 134.71 | 134.75 | 134.68 | 134.71 | 81159.0 |
| 2021-04-26 18:30:00 | AAPL | Stock | 134.74 | 134.75 | 134.68 | 134.72 | 24822.0 |
| 2021-04-26 19:00:00 | AAPL | Stock | 134.72 | 134.74 | 134.7 | 134.72 | 20443.0 |
| 2021-04-26 19:30:00 | AAPL | Stock | 134.73 | 134.9 | 134.72 | 134.9 | 43924.0 |
| 2021-04-26 04:00:00 | MSFT | Stock | 261.16 | 261.73 | 260.8 | 260.8 | 3464.0 |
| 2021-04-26 04:30:00 | MSFT | Stock | 260.85 | 260.85 | 260.5 | 260.5 | 2036.0 |
| 2021-04-26 05:00:00 | MSFT | Stock | 260.71 | 260.85 | 260.53 | 260.54 | 3785.0 |
| 2021-04-26 05:30:00 | MSFT | Stock | 260.35 | 260.35 | 260.34 | 260.34 | 200.0 |
| 2021-04-26 06:00:00 | MSFT | Stock | 260.61 | 260.61 | 260.52 | 260.52 | 558.0 |
| 2021-04-26 06:30:00 | MSFT | Stock | 260.55 | 260.67 | 260.55 | 260.56 | 2289.0 |
| 2021-04-26 07:00:00 | MSFT | Stock | 260.63 | 261.09 | 260.32 | 260.4 | 36326.0 |
| 2021-04-26 07:30:00 | MSFT | Stock | 260.33 | 260.75 | 260.3 | 260.51 | 19475.0 |
| 2021-04-26 08:00:00 | MSFT | Stock | 261.0 | 261.41 | 260.3 | 260.95 | 36790.0 |
| 2021-04-26 08:30:00 | MSFT | Stock | 260.9 | 261.2099 | 260.52 | 261.13 | 23934.0 |
| 2021-04-26 09:00:00 | MSFT | Stock | 261.08 | 261.69 | 261.04 | 261.65 | 29862.0 |
| 2021-04-26 09:30:00 | MSFT | Stock | 261.65 | 262.435 | 260.17 | 261.33 | 2404668.0 |
| 2021-04-26 10:00:00 | MSFT | Stock | 261.29 | 261.8 | 260.915 | 261.0242 | 1155728.0 |
| 2021-04-26 10:30:00 | MSFT | Stock | 261.0201 | 261.32 | 260.42 | 260.77 | 974838.0 |
| 2021-04-26 11:00:00 | MSFT | Stock | 260.77 | 261.6 | 260.77 | 261.275 | 728708.0 |
| 2021-04-26 11:30:00 | MSFT | Stock | 261.27 | 261.45 | 260.96 | 261.05 | 671756.0 |
| 2021-04-26 12:00:00 | MSFT | Stock | 261.055 | 261.295 | 260.87 | 261.14 | 630999.0 |
| 2021-04-26 12:30:00 | MSFT | Stock | 261.145 | 261.4 | 261.11 | 261.1648 | 472512.0 |
> showing 50 of 111,875 rows — these rows as CSV