PREVIEW / stock_30min / 2021-02-11
file: by_date/stock_30min/2021/2021-02-11.parquet size: 2.4 MB rows: 122,156 symbols: 2,809
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-02-11 04:00:00 | AAPL | Stock | 135.44 | 135.58 | 135.25 | 135.51 | 10448.0 |
| 2021-02-11 04:30:00 | AAPL | Stock | 135.5 | 135.63 | 135.5 | 135.6 | 8056.0 |
| 2021-02-11 05:00:00 | AAPL | Stock | 135.6 | 135.75 | 135.6 | 135.6 | 4634.0 |
| 2021-02-11 05:30:00 | AAPL | Stock | 135.65 | 135.75 | 135.65 | 135.75 | 1070.0 |
| 2021-02-11 06:00:00 | AAPL | Stock | 135.7 | 135.8 | 135.7 | 135.8 | 3544.0 |
| 2021-02-11 06:30:00 | AAPL | Stock | 135.8 | 135.82 | 135.68 | 135.78 | 5022.0 |
| 2021-02-11 07:00:00 | AAPL | Stock | 135.73 | 135.8 | 135.36 | 135.56 | 98815.0 |
| 2021-02-11 07:30:00 | AAPL | Stock | 135.58 | 135.63 | 135.29 | 135.52 | 65732.0 |
| 2021-02-11 08:00:00 | AAPL | Stock | 135.53 | 135.78 | 135.3 | 135.66 | 187743.0 |
| 2021-02-11 08:30:00 | AAPL | Stock | 135.67 | 135.84 | 135.44 | 135.6 | 121516.0 |
| 2021-02-11 09:00:00 | AAPL | Stock | 135.6 | 136.0 | 135.53 | 135.98 | 189904.0 |
| 2021-02-11 09:30:00 | AAPL | Stock | 135.92 | 136.39 | 135.0 | 135.04 | 9117162.0 |
| 2021-02-11 10:00:00 | AAPL | Stock | 135.05 | 135.415 | 134.92 | 135.271 | 4676769.0 |
| 2021-02-11 10:30:00 | AAPL | Stock | 135.27 | 135.54 | 134.97 | 135.106 | 3685284.0 |
| 2021-02-11 11:00:00 | AAPL | Stock | 135.12 | 135.22 | 134.95 | 135.039 | 2274027.0 |
| 2021-02-11 11:30:00 | AAPL | Stock | 135.03 | 135.22 | 134.75 | 134.9 | 2635204.0 |
| 2021-02-11 12:00:00 | AAPL | Stock | 134.91 | 135.0 | 134.04 | 134.065 | 4037526.0 |
| 2021-02-11 12:30:00 | AAPL | Stock | 134.08 | 134.44 | 133.88 | 134.28 | 3660728.0 |
| 2021-02-11 13:00:00 | AAPL | Stock | 134.285 | 134.32 | 133.96 | 134.287 | 2328404.0 |
| 2021-02-11 13:30:00 | AAPL | Stock | 134.285 | 134.39 | 134.17 | 134.185 | 1600294.0 |
| 2021-02-11 14:00:00 | AAPL | Stock | 134.18 | 134.189 | 133.77 | 134.04 | 3540901.0 |
| 2021-02-11 14:30:00 | AAPL | Stock | 134.049 | 134.34 | 133.98 | 134.335 | 2350848.0 |
| 2021-02-11 15:00:00 | AAPL | Stock | 134.335 | 134.92 | 134.3 | 134.76 | 3053803.0 |
| 2021-02-11 15:30:00 | AAPL | Stock | 134.76 | 135.28 | 134.61 | 135.12 | 5178861.0 |
| 2021-02-11 16:00:00 | AAPL | Stock | 135.12 | 135.23 | 134.85 | 134.98 | 4565643.0 |
| 2021-02-11 16:30:00 | AAPL | Stock | 135.0 | 135.05 | 134.91 | 134.95 | 39781.0 |
| 2021-02-11 17:00:00 | AAPL | Stock | 134.95 | 135.13 | 134.88 | 134.89 | 120355.0 |
| 2021-02-11 17:30:00 | AAPL | Stock | 134.89 | 134.96 | 134.8 | 134.9 | 23320.0 |
| 2021-02-11 18:00:00 | AAPL | Stock | 134.84 | 134.99 | 134.8 | 134.97 | 26072.0 |
| 2021-02-11 18:30:00 | AAPL | Stock | 134.97 | 134.99 | 134.85 | 134.96 | 19713.0 |
| 2021-02-11 19:00:00 | AAPL | Stock | 134.94 | 134.98 | 134.9 | 134.94 | 22691.0 |
| 2021-02-11 19:30:00 | AAPL | Stock | 134.93 | 134.98 | 134.81 | 134.91 | 51524.0 |
| 2021-02-11 04:00:00 | MSFT | Stock | 243.22 | 243.84 | 243.22 | 243.84 | 2371.0 |
| 2021-02-11 04:30:00 | MSFT | Stock | 244.0 | 244.0 | 244.0 | 244.0 | 114.0 |
| 2021-02-11 05:00:00 | MSFT | Stock | 243.84 | 244.08 | 243.84 | 244.0 | 3756.0 |
| 2021-02-11 05:30:00 | MSFT | Stock | 244.0 | 244.02 | 244.0 | 244.02 | 229.0 |
| 2021-02-11 06:00:00 | MSFT | Stock | 243.79 | 243.85 | 243.79 | 243.84 | 555.0 |
| 2021-02-11 06:30:00 | MSFT | Stock | 243.99 | 243.99 | 243.84 | 243.98 | 1114.0 |
| 2021-02-11 07:00:00 | MSFT | Stock | 243.55 | 243.8 | 243.43 | 243.77 | 13549.0 |
| 2021-02-11 07:30:00 | MSFT | Stock | 243.76 | 243.8 | 243.42 | 243.75 | 10353.0 |
| 2021-02-11 08:00:00 | MSFT | Stock | 243.77 | 243.95 | 243.51 | 243.9 | 19744.0 |
| 2021-02-11 08:30:00 | MSFT | Stock | 243.82 | 244.25 | 243.71 | 244.0 | 20619.0 |
| 2021-02-11 09:00:00 | MSFT | Stock | 244.02 | 244.76 | 243.6 | 244.76 | 29884.0 |
| 2021-02-11 09:30:00 | MSFT | Stock | 244.52 | 245.15 | 242.6 | 242.625 | 1709452.0 |
| 2021-02-11 10:00:00 | MSFT | Stock | 242.65 | 243.48 | 242.6 | 243.146 | 851828.0 |
| 2021-02-11 10:30:00 | MSFT | Stock | 243.11 | 243.84 | 242.64 | 243.17 | 677986.0 |
| 2021-02-11 11:00:00 | MSFT | Stock | 243.18 | 243.56 | 242.86 | 243.425 | 569050.0 |
| 2021-02-11 11:30:00 | MSFT | Stock | 243.42 | 243.82 | 243.25 | 243.459 | 413771.0 |
| 2021-02-11 12:00:00 | MSFT | Stock | 243.46 | 243.71 | 242.64 | 242.68 | 619170.0 |
| 2021-02-11 12:30:00 | MSFT | Stock | 242.73 | 243.3 | 242.19 | 242.86 | 590112.0 |
> showing 50 of 122,156 rows — these rows as CSV