PREVIEW / stock_30min / 2021-10-11
file: by_date/stock_30min/2021/2021-10-11.parquet size: 2.1 MB rows: 105,613 symbols: 2,623
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-11 04:00:00 | AAPL | Stock | 142.05 | 142.49 | 142.05 | 142.07 | 17512.0 |
| 2021-10-11 04:30:00 | AAPL | Stock | 142.14 | 142.29 | 142.03 | 142.18 | 10683.0 |
| 2021-10-11 05:00:00 | AAPL | Stock | 142.26 | 142.29 | 142.23 | 142.29 | 3598.0 |
| 2021-10-11 05:30:00 | AAPL | Stock | 142.29 | 142.46 | 142.22 | 142.38 | 8563.0 |
| 2021-10-11 06:00:00 | AAPL | Stock | 142.4 | 142.4 | 142.0 | 142.14 | 11351.0 |
| 2021-10-11 06:30:00 | AAPL | Stock | 142.1 | 142.1 | 141.81 | 141.85 | 41165.0 |
| 2021-10-11 07:00:00 | AAPL | Stock | 141.9 | 142.19 | 141.87 | 142.07 | 70173.0 |
| 2021-10-11 07:30:00 | AAPL | Stock | 142.06 | 142.07 | 141.73 | 141.92 | 73454.0 |
| 2021-10-11 08:00:00 | AAPL | Stock | 141.9001 | 142.1999 | 141.65 | 141.92 | 307569.0 |
| 2021-10-11 08:30:00 | AAPL | Stock | 141.88 | 142.25 | 141.85 | 142.12 | 120119.0 |
| 2021-10-11 09:00:00 | AAPL | Stock | 142.13 | 142.4 | 142.11 | 142.26 | 189894.0 |
| 2021-10-11 09:30:00 | AAPL | Stock | 142.3 | 144.0 | 141.81 | 143.93 | 8457323.0 |
| 2021-10-11 10:00:00 | AAPL | Stock | 143.93 | 144.81 | 143.93 | 144.7011 | 5728827.0 |
| 2021-10-11 10:30:00 | AAPL | Stock | 144.71 | 144.7499 | 144.19 | 144.445 | 3875029.0 |
| 2021-10-11 11:00:00 | AAPL | Stock | 144.45 | 144.7 | 144.34 | 144.45 | 2948120.0 |
| 2021-10-11 11:30:00 | AAPL | Stock | 144.44 | 144.65 | 144.404 | 144.43 | 2417633.0 |
| 2021-10-11 12:00:00 | AAPL | Stock | 144.43 | 144.4599 | 144.0 | 144.095 | 2959236.0 |
| 2021-10-11 12:30:00 | AAPL | Stock | 144.08 | 144.12 | 143.86 | 144.0675 | 2148298.0 |
| 2021-10-11 13:00:00 | AAPL | Stock | 144.055 | 144.055 | 143.48 | 143.55 | 2878276.0 |
| 2021-10-11 13:30:00 | AAPL | Stock | 143.555 | 143.6638 | 143.38 | 143.5867 | 2408273.0 |
| 2021-10-11 14:00:00 | AAPL | Stock | 143.58 | 143.84 | 143.48 | 143.6 | 2182557.0 |
| 2021-10-11 14:30:00 | AAPL | Stock | 143.6 | 143.67 | 143.23 | 143.41 | 2454509.0 |
| 2021-10-11 15:00:00 | AAPL | Stock | 143.41 | 143.53 | 143.13 | 143.18 | 2521124.0 |
| 2021-10-11 15:30:00 | AAPL | Stock | 143.17 | 143.28 | 142.75 | 142.8 | 5083372.0 |
| 2021-10-11 16:00:00 | AAPL | Stock | 142.81 | 142.82 | 142.5 | 142.65 | 6344453.0 |
| 2021-10-11 16:30:00 | AAPL | Stock | 142.61 | 142.81 | 142.5 | 142.58 | 40064.0 |
| 2021-10-11 17:00:00 | AAPL | Stock | 142.59 | 142.6 | 142.54 | 142.57 | 20268.0 |
| 2021-10-11 17:30:00 | AAPL | Stock | 142.58 | 142.6 | 142.54 | 142.6 | 15201.0 |
| 2021-10-11 18:00:00 | AAPL | Stock | 142.6 | 142.64 | 142.51 | 142.57 | 14673.0 |
| 2021-10-11 18:30:00 | AAPL | Stock | 142.55 | 142.58 | 142.5 | 142.53 | 12338.0 |
| 2021-10-11 19:00:00 | AAPL | Stock | 142.53 | 142.56 | 142.49 | 142.55 | 17902.0 |
| 2021-10-11 19:30:00 | AAPL | Stock | 142.55 | 142.63 | 142.52 | 142.59 | 31431.0 |
| 2021-10-11 04:00:00 | MSFT | Stock | 293.05 | 293.05 | 293.0 | 293.0 | 244.0 |
| 2021-10-11 05:00:00 | MSFT | Stock | 293.3 | 293.5 | 293.3 | 293.5 | 491.0 |
| 2021-10-11 05:30:00 | MSFT | Stock | 293.2 | 293.58 | 293.2 | 293.58 | 345.0 |
| 2021-10-11 06:00:00 | MSFT | Stock | 293.1 | 293.2 | 292.5 | 292.5 | 1839.0 |
| 2021-10-11 06:30:00 | MSFT | Stock | 292.68 | 292.68 | 291.73 | 291.81 | 3063.0 |
| 2021-10-11 07:00:00 | MSFT | Stock | 292.25 | 292.75 | 292.11 | 292.55 | 5320.0 |
| 2021-10-11 07:30:00 | MSFT | Stock | 292.51 | 292.51 | 291.67 | 291.93 | 15824.0 |
| 2021-10-11 08:00:00 | MSFT | Stock | 292.6 | 292.6 | 291.5563 | 292.019 | 29964.0 |
| 2021-10-11 08:30:00 | MSFT | Stock | 292.06 | 292.77 | 292.01 | 292.49 | 13956.0 |
| 2021-10-11 09:00:00 | MSFT | Stock | 292.59 | 293.45 | 292.59 | 293.24 | 23968.0 |
| 2021-10-11 09:30:00 | MSFT | Stock | 292.99 | 296.52 | 292.745 | 296.23 | 1631875.0 |
| 2021-10-11 10:00:00 | MSFT | Stock | 296.23 | 297.34 | 296.08 | 297.31 | 993690.0 |
| 2021-10-11 10:30:00 | MSFT | Stock | 297.31 | 297.42 | 296.66 | 297.1354 | 710738.0 |
| 2021-10-11 11:00:00 | MSFT | Stock | 297.14 | 297.97 | 296.84 | 297.02 | 887199.0 |
| 2021-10-11 11:30:00 | MSFT | Stock | 297.02 | 297.39 | 296.7 | 296.73 | 574896.0 |
| 2021-10-11 12:00:00 | MSFT | Stock | 296.74 | 296.77 | 295.84 | 296.57 | 752165.0 |
| 2021-10-11 12:30:00 | MSFT | Stock | 296.57 | 296.6561 | 295.99 | 296.6561 | 522146.0 |
| 2021-10-11 13:00:00 | MSFT | Stock | 296.6389 | 296.7168 | 295.6162 | 295.75 | 704442.0 |
> showing 50 of 105,613 rows — these rows as CSV