PREVIEW / stock_30min / 2021-06-07
file: by_date/stock_30min/2021/2021-06-07.parquet size: 2.2 MB rows: 112,885 symbols: 2,962
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-06-07 04:00:00 | AAPL | Stock | 125.64 | 125.65 | 125.2 | 125.25 | 29894.0 |
| 2021-06-07 04:30:00 | AAPL | Stock | 125.23 | 125.36 | 125.21 | 125.36 | 17201.0 |
| 2021-06-07 05:00:00 | AAPL | Stock | 125.36 | 125.36 | 125.08 | 125.1 | 12233.0 |
| 2021-06-07 05:30:00 | AAPL | Stock | 125.1 | 125.2 | 125.1 | 125.2 | 1734.0 |
| 2021-06-07 06:00:00 | AAPL | Stock | 125.2 | 125.3 | 125.17 | 125.29 | 3219.0 |
| 2021-06-07 06:30:00 | AAPL | Stock | 125.29 | 125.4 | 125.28 | 125.35 | 5295.0 |
| 2021-06-07 07:00:00 | AAPL | Stock | 125.36 | 126.26 | 125.34 | 126.11 | 118417.0 |
| 2021-06-07 07:30:00 | AAPL | Stock | 126.11 | 126.26 | 125.9 | 126.15 | 61110.0 |
| 2021-06-07 08:00:00 | AAPL | Stock | 126.0001 | 126.27 | 125.43 | 126.11 | 189933.0 |
| 2021-06-07 08:30:00 | AAPL | Stock | 126.14 | 126.47 | 126.14 | 126.35 | 221144.0 |
| 2021-06-07 09:00:00 | AAPL | Stock | 126.34 | 126.34 | 125.9 | 126.18 | 240065.0 |
| 2021-06-07 09:30:00 | AAPL | Stock | 126.18 | 126.32 | 124.89 | 125.23 | 10545027.0 |
| 2021-06-07 10:00:00 | AAPL | Stock | 125.2384 | 125.37 | 124.86 | 125.3 | 5616719.0 |
| 2021-06-07 10:30:00 | AAPL | Stock | 125.3 | 125.41 | 124.96 | 125.1 | 4208327.0 |
| 2021-06-07 11:00:00 | AAPL | Stock | 125.09 | 125.2 | 124.8321 | 124.97 | 4311561.0 |
| 2021-06-07 11:30:00 | AAPL | Stock | 124.98 | 125.06 | 124.91 | 125.005 | 3210448.0 |
| 2021-06-07 12:00:00 | AAPL | Stock | 125.005 | 125.24 | 124.99 | 125.11 | 2624810.0 |
| 2021-06-07 12:30:00 | AAPL | Stock | 125.1147 | 125.44 | 125.1147 | 125.335 | 3284707.0 |
| 2021-06-07 13:00:00 | AAPL | Stock | 125.33 | 125.48 | 125.12 | 125.2024 | 2587425.0 |
| 2021-06-07 13:30:00 | AAPL | Stock | 125.21 | 125.23 | 125.0117 | 125.02 | 2631542.0 |
| 2021-06-07 14:00:00 | AAPL | Stock | 125.03 | 125.21 | 125.0 | 125.145 | 1927966.0 |
| 2021-06-07 14:30:00 | AAPL | Stock | 125.15 | 125.25 | 124.91 | 125.2108 | 3878120.0 |
| 2021-06-07 15:00:00 | AAPL | Stock | 125.2111 | 125.77 | 125.155 | 125.73 | 4249588.0 |
| 2021-06-07 15:30:00 | AAPL | Stock | 125.726 | 126.03 | 125.545 | 125.9 | 6642305.0 |
| 2021-06-07 16:00:00 | AAPL | Stock | 125.97 | 126.04 | 125.301 | 126.01 | 5471836.0 |
| 2021-06-07 16:30:00 | AAPL | Stock | 126.02 | 126.1 | 126.0 | 126.0 | 50983.0 |
| 2021-06-07 17:00:00 | AAPL | Stock | 126.0 | 126.02 | 125.85 | 125.96 | 38990.0 |
| 2021-06-07 17:30:00 | AAPL | Stock | 125.97 | 125.97 | 125.86 | 125.94 | 31510.0 |
| 2021-06-07 18:00:00 | AAPL | Stock | 125.96 | 126.0 | 125.92 | 125.96 | 18277.0 |
| 2021-06-07 18:30:00 | AAPL | Stock | 125.96 | 125.97 | 125.8 | 125.87 | 36570.0 |
| 2021-06-07 19:00:00 | AAPL | Stock | 125.87 | 125.97 | 125.81 | 125.91 | 41117.0 |
| 2021-06-07 19:30:00 | AAPL | Stock | 125.92 | 125.98 | 125.89 | 125.96 | 28767.0 |
| 2021-06-07 04:00:00 | MSFT | Stock | 249.97 | 249.97 | 249.56 | 249.56 | 200.0 |
| 2021-06-07 04:30:00 | MSFT | Stock | 249.88 | 250.01 | 249.88 | 250.01 | 285.0 |
| 2021-06-07 05:00:00 | MSFT | Stock | 250.2 | 250.2 | 249.73 | 249.74 | 1042.0 |
| 2021-06-07 05:30:00 | MSFT | Stock | 249.58 | 249.58 | 249.58 | 249.58 | 293.0 |
| 2021-06-07 06:00:00 | MSFT | Stock | 249.4 | 249.58 | 249.35 | 249.58 | 1541.0 |
| 2021-06-07 07:00:00 | MSFT | Stock | 249.74 | 250.45 | 249.6 | 250.0 | 8795.0 |
| 2021-06-07 07:30:00 | MSFT | Stock | 249.97 | 250.7 | 249.92 | 250.28 | 15367.0 |
| 2021-06-07 08:00:00 | MSFT | Stock | 249.88 | 250.47 | 249.75 | 250.11 | 24665.0 |
| 2021-06-07 08:30:00 | MSFT | Stock | 250.2699 | 250.7 | 250.166 | 250.17 | 12885.0 |
| 2021-06-07 09:00:00 | MSFT | Stock | 250.27 | 250.27 | 249.53 | 249.86 | 27080.0 |
| 2021-06-07 09:30:00 | MSFT | Stock | 249.98 | 252.22 | 249.81 | 252.11 | 2416795.0 |
| 2021-06-07 10:00:00 | MSFT | Stock | 252.12 | 252.44 | 251.96 | 252.16 | 1201078.0 |
| 2021-06-07 10:30:00 | MSFT | Stock | 252.17 | 252.96 | 251.95 | 252.95 | 1322541.0 |
| 2021-06-07 11:00:00 | MSFT | Stock | 252.95 | 253.22 | 252.51 | 252.84 | 1675235.0 |
| 2021-06-07 11:30:00 | MSFT | Stock | 252.86 | 252.959 | 252.22 | 252.3993 | 899376.0 |
| 2021-06-07 12:00:00 | MSFT | Stock | 252.4 | 252.82 | 252.24 | 252.41 | 880680.0 |
| 2021-06-07 12:30:00 | MSFT | Stock | 252.41 | 252.56 | 252.28 | 252.29 | 496880.0 |
| 2021-06-07 13:00:00 | MSFT | Stock | 252.31 | 252.4 | 252.04 | 252.105 | 600609.0 |
> showing 50 of 112,885 rows — these rows as CSV