PREVIEW / stock_30min / 2021-10-08
file: by_date/stock_30min/2021/2021-10-08.parquet size: 2.1 MB rows: 105,024 symbols: 2,682
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-10-08 04:00:00 | AAPL | Stock | 143.24 | 143.27 | 142.78 | 142.85 | 18444.0 |
| 2021-10-08 04:30:00 | AAPL | Stock | 142.89 | 142.89 | 142.65 | 142.7 | 21777.0 |
| 2021-10-08 05:00:00 | AAPL | Stock | 142.66 | 142.75 | 142.6 | 142.75 | 3859.0 |
| 2021-10-08 05:30:00 | AAPL | Stock | 142.78 | 143.05 | 142.76 | 143.05 | 1580.0 |
| 2021-10-08 06:00:00 | AAPL | Stock | 143.05 | 143.19 | 143.0 | 143.04 | 4935.0 |
| 2021-10-08 06:30:00 | AAPL | Stock | 143.17 | 143.17 | 143.05 | 143.05 | 1788.0 |
| 2021-10-08 07:00:00 | AAPL | Stock | 143.0 | 143.43 | 143.0 | 143.42 | 41382.0 |
| 2021-10-08 07:30:00 | AAPL | Stock | 143.44 | 143.49 | 143.36 | 143.44 | 33525.0 |
| 2021-10-08 08:00:00 | AAPL | Stock | 143.3301 | 143.7 | 143.05 | 143.6 | 186296.0 |
| 2021-10-08 08:30:00 | AAPL | Stock | 143.68 | 144.35 | 143.25 | 144.05 | 550625.0 |
| 2021-10-08 09:00:00 | AAPL | Stock | 144.09 | 144.18 | 143.8 | 144.03 | 310393.0 |
| 2021-10-08 09:30:00 | AAPL | Stock | 144.04 | 144.1781 | 143.0601 | 143.1823 | 7360663.0 |
| 2021-10-08 10:00:00 | AAPL | Stock | 143.18 | 143.96 | 143.165 | 143.7363 | 4438699.0 |
| 2021-10-08 10:30:00 | AAPL | Stock | 143.74 | 143.86 | 143.07 | 143.285 | 3991994.0 |
| 2021-10-08 11:00:00 | AAPL | Stock | 143.29 | 143.49 | 143.1701 | 143.29 | 2616225.0 |
| 2021-10-08 11:30:00 | AAPL | Stock | 143.29 | 143.36 | 142.95 | 143.0101 | 3004945.0 |
| 2021-10-08 12:00:00 | AAPL | Stock | 143.02 | 143.1972 | 142.83 | 142.8595 | 2607863.0 |
| 2021-10-08 12:30:00 | AAPL | Stock | 142.8507 | 143.25 | 142.8 | 142.97 | 2238959.0 |
| 2021-10-08 13:00:00 | AAPL | Stock | 142.975 | 143.06 | 142.56 | 142.67 | 2465374.0 |
| 2021-10-08 13:30:00 | AAPL | Stock | 142.65 | 142.955 | 142.62 | 142.865 | 2142863.0 |
| 2021-10-08 14:00:00 | AAPL | Stock | 142.87 | 143.34 | 142.8301 | 143.2917 | 2458767.0 |
| 2021-10-08 14:30:00 | AAPL | Stock | 143.3 | 143.4 | 143.03 | 143.065 | 2271115.0 |
| 2021-10-08 15:00:00 | AAPL | Stock | 143.0601 | 143.34 | 142.99 | 143.3008 | 2277168.0 |
| 2021-10-08 15:30:00 | AAPL | Stock | 143.305 | 143.305 | 142.783 | 143.01 | 5409479.0 |
| 2021-10-08 16:00:00 | AAPL | Stock | 142.99 | 143.2744 | 142.75 | 142.86 | 7903497.0 |
| 2021-10-08 16:30:00 | AAPL | Stock | 142.86 | 142.98 | 142.78 | 142.95 | 61421.0 |
| 2021-10-08 17:00:00 | AAPL | Stock | 142.96 | 142.99 | 142.86 | 142.9 | 15895.0 |
| 2021-10-08 17:30:00 | AAPL | Stock | 142.9 | 142.91 | 142.89 | 142.9 | 7706.0 |
| 2021-10-08 18:00:00 | AAPL | Stock | 142.9 | 142.93 | 142.89 | 142.9 | 7028.0 |
| 2021-10-08 18:30:00 | AAPL | Stock | 142.9 | 142.91 | 142.85 | 142.86 | 11075.0 |
| 2021-10-08 19:00:00 | AAPL | Stock | 142.85 | 142.9 | 142.85 | 142.86 | 6863.0 |
| 2021-10-08 19:30:00 | AAPL | Stock | 142.86 | 142.91 | 142.8 | 142.81 | 23715.0 |
| 2021-10-08 04:00:00 | MSFT | Stock | 294.81 | 294.81 | 294.1 | 294.11 | 1853.0 |
| 2021-10-08 05:00:00 | MSFT | Stock | 293.99 | 294.0 | 293.99 | 294.0 | 877.0 |
| 2021-10-08 05:30:00 | MSFT | Stock | 294.43 | 294.43 | 294.43 | 294.43 | 500.0 |
| 2021-10-08 06:00:00 | MSFT | Stock | 294.78 | 294.78 | 294.53 | 294.67 | 853.0 |
| 2021-10-08 07:00:00 | MSFT | Stock | 294.72 | 295.43 | 294.72 | 295.43 | 5773.0 |
| 2021-10-08 07:30:00 | MSFT | Stock | 295.45 | 295.45 | 295.27 | 295.27 | 2055.0 |
| 2021-10-08 08:00:00 | MSFT | Stock | 295.2298 | 295.8 | 294.79 | 295.56 | 7010.0 |
| 2021-10-08 08:30:00 | MSFT | Stock | 295.39 | 297.45 | 294.99 | 296.291 | 79252.0 |
| 2021-10-08 09:00:00 | MSFT | Stock | 296.5 | 296.9 | 295.98 | 296.08 | 35952.0 |
| 2021-10-08 09:30:00 | MSFT | Stock | 296.17 | 296.6409 | 294.57 | 295.1636 | 1614831.0 |
| 2021-10-08 10:00:00 | MSFT | Stock | 295.15 | 296.45 | 295.1 | 296.3 | 889398.0 |
| 2021-10-08 10:30:00 | MSFT | Stock | 296.34 | 296.52 | 294.86 | 295.47 | 879552.0 |
| 2021-10-08 11:00:00 | MSFT | Stock | 295.515 | 296.14 | 294.97 | 295.49 | 609334.0 |
| 2021-10-08 11:30:00 | MSFT | Stock | 295.49 | 295.53 | 294.5387 | 294.81 | 607078.0 |
| 2021-10-08 12:00:00 | MSFT | Stock | 294.8099 | 295.18 | 294.565 | 294.66 | 486589.0 |
| 2021-10-08 12:30:00 | MSFT | Stock | 294.64 | 295.45 | 294.51 | 294.81 | 480107.0 |
| 2021-10-08 13:00:00 | MSFT | Stock | 294.83 | 294.95 | 293.76 | 294.12 | 687836.0 |
| 2021-10-08 13:30:00 | MSFT | Stock | 294.04 | 294.87 | 293.87 | 294.77 | 506499.0 |
> showing 50 of 105,024 rows — these rows as CSV