PREVIEW / stock_30min / 2021-02-19
file: by_date/stock_30min/2021/2021-02-19.parquet size: 2.4 MB rows: 120,208 symbols: 2,831
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-19 04:00:00 | AAPL | Stock | 129.75 | 129.91 | 129.48 | 129.9 | 17641.0 |
| 2021-02-19 04:30:00 | AAPL | Stock | 129.85 | 130.15 | 129.83 | 129.97 | 19628.0 |
| 2021-02-19 05:00:00 | AAPL | Stock | 129.98 | 130.21 | 129.85 | 130.1 | 10898.0 |
| 2021-02-19 05:30:00 | AAPL | Stock | 130.13 | 130.26 | 130.04 | 130.26 | 10852.0 |
| 2021-02-19 06:00:00 | AAPL | Stock | 130.31 | 130.39 | 130.0 | 130.1 | 13923.0 |
| 2021-02-19 06:30:00 | AAPL | Stock | 130.1 | 130.13 | 130.0 | 130.0 | 20121.0 |
| 2021-02-19 07:00:00 | AAPL | Stock | 130.0 | 130.8 | 129.9 | 130.7 | 157994.0 |
| 2021-02-19 07:30:00 | AAPL | Stock | 130.72 | 130.74 | 130.54 | 130.62 | 55169.0 |
| 2021-02-19 08:00:00 | AAPL | Stock | 130.13 | 130.8 | 130.0 | 130.7 | 286965.0 |
| 2021-02-19 08:30:00 | AAPL | Stock | 130.68 | 130.78 | 130.51 | 130.67 | 127924.0 |
| 2021-02-19 09:00:00 | AAPL | Stock | 130.67 | 130.69 | 130.11 | 130.19 | 302637.0 |
| 2021-02-19 09:30:00 | AAPL | Stock | 130.19 | 130.445 | 129.45 | 130.44 | 13238372.0 |
| 2021-02-19 10:00:00 | AAPL | Stock | 130.44 | 130.525 | 129.475 | 129.68 | 6089917.0 |
| 2021-02-19 10:30:00 | AAPL | Stock | 129.69 | 130.17 | 129.55 | 129.945 | 4062142.0 |
| 2021-02-19 11:00:00 | AAPL | Stock | 129.94 | 130.71 | 129.82 | 130.55 | 4859318.0 |
| 2021-02-19 11:30:00 | AAPL | Stock | 130.545 | 130.65 | 130.06 | 130.09 | 2941645.0 |
| 2021-02-19 12:00:00 | AAPL | Stock | 130.07 | 130.17 | 129.57 | 129.67 | 3765417.0 |
| 2021-02-19 12:30:00 | AAPL | Stock | 129.67 | 129.83 | 129.03 | 129.335 | 4841059.0 |
| 2021-02-19 13:00:00 | AAPL | Stock | 129.33 | 129.42 | 128.8 | 128.98 | 4555028.0 |
| 2021-02-19 13:30:00 | AAPL | Stock | 128.965 | 129.29 | 128.83 | 129.125 | 3085835.0 |
| 2021-02-19 14:00:00 | AAPL | Stock | 129.13 | 129.54 | 128.8 | 128.886 | 3352998.0 |
| 2021-02-19 14:30:00 | AAPL | Stock | 128.881 | 129.655 | 128.87 | 129.645 | 2882230.0 |
| 2021-02-19 15:00:00 | AAPL | Stock | 129.64 | 129.95 | 129.58 | 129.89 | 4491635.0 |
| 2021-02-19 15:30:00 | AAPL | Stock | 129.895 | 130.1 | 129.74 | 129.85 | 7255830.0 |
| 2021-02-19 16:00:00 | AAPL | Stock | 129.87 | 129.9 | 129.38 | 129.62 | 6971005.0 |
| 2021-02-19 16:30:00 | AAPL | Stock | 129.65 | 129.68 | 129.55 | 129.65 | 105796.0 |
| 2021-02-19 17:00:00 | AAPL | Stock | 129.65 | 129.69 | 129.6 | 129.62 | 36492.0 |
| 2021-02-19 17:30:00 | AAPL | Stock | 129.62 | 129.62 | 129.53 | 129.6 | 36348.0 |
| 2021-02-19 18:00:00 | AAPL | Stock | 129.58 | 129.69 | 129.52 | 129.59 | 16057.0 |
| 2021-02-19 18:30:00 | AAPL | Stock | 129.6 | 129.64 | 129.58 | 129.62 | 20137.0 |
| 2021-02-19 19:00:00 | AAPL | Stock | 129.62 | 129.66 | 129.62 | 129.62 | 28650.0 |
| 2021-02-19 19:30:00 | AAPL | Stock | 129.62 | 129.75 | 129.58 | 129.72 | 37619.0 |
| 2021-02-19 04:00:00 | MSFT | Stock | 243.87 | 243.88 | 243.72 | 243.88 | 1978.0 |
| 2021-02-19 04:30:00 | MSFT | Stock | 243.97 | 244.01 | 243.97 | 244.01 | 278.0 |
| 2021-02-19 05:00:00 | MSFT | Stock | 243.72 | 244.18 | 243.61 | 244.17 | 712.0 |
| 2021-02-19 05:30:00 | MSFT | Stock | 243.88 | 244.04 | 243.81 | 244.04 | 3445.0 |
| 2021-02-19 06:00:00 | MSFT | Stock | 243.85 | 243.98 | 243.67 | 243.85 | 1505.0 |
| 2021-02-19 07:00:00 | MSFT | Stock | 243.78 | 244.23 | 243.7 | 244.23 | 4321.0 |
| 2021-02-19 07:30:00 | MSFT | Stock | 244.16 | 244.53 | 244.1 | 244.53 | 6500.0 |
| 2021-02-19 08:00:00 | MSFT | Stock | 243.75 | 244.64 | 243.75 | 244.62 | 7413.0 |
| 2021-02-19 08:30:00 | MSFT | Stock | 244.6 | 244.69 | 244.264 | 244.6 | 4827.0 |
| 2021-02-19 09:00:00 | MSFT | Stock | 244.49 | 244.55 | 242.94 | 243.8 | 58998.0 |
| 2021-02-19 09:30:00 | MSFT | Stock | 243.8 | 243.86 | 241.24 | 241.64 | 3880234.0 |
| 2021-02-19 10:00:00 | MSFT | Stock | 241.66 | 242.07 | 241.36 | 241.67 | 1916694.0 |
| 2021-02-19 10:30:00 | MSFT | Stock | 241.69 | 242.25 | 241.35 | 242.13 | 916516.0 |
| 2021-02-19 11:00:00 | MSFT | Stock | 242.13 | 242.66 | 241.645 | 242.21 | 1113136.0 |
| 2021-02-19 11:30:00 | MSFT | Stock | 242.215 | 242.5 | 241.6 | 241.642 | 652994.0 |
| 2021-02-19 12:00:00 | MSFT | Stock | 241.64 | 241.822 | 240.84 | 240.9 | 1109014.0 |
| 2021-02-19 12:30:00 | MSFT | Stock | 240.9 | 241.18 | 240.397 | 241.035 | 1106871.0 |
| 2021-02-19 13:00:00 | MSFT | Stock | 241.04 | 241.04 | 240.18 | 240.81 | 685562.0 |
> showing 50 of 120,208 rows — these rows as CSV