PREVIEW / stock_30min / 2021-10-15
file: by_date/stock_30min/2021/2021-10-15.parquet size: 2.2 MB rows: 111,066 symbols: 2,685
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-15 04:00:00 | AAPL | Stock | 143.91 | 144.2 | 143.89 | 144.03 | 16008.0 |
| 2021-10-15 04:30:00 | AAPL | Stock | 144.1 | 144.23 | 144.1 | 144.17 | 8760.0 |
| 2021-10-15 05:00:00 | AAPL | Stock | 144.1 | 144.11 | 144.0 | 144.05 | 7059.0 |
| 2021-10-15 05:30:00 | AAPL | Stock | 144.05 | 144.21 | 144.0 | 144.21 | 10850.0 |
| 2021-10-15 06:00:00 | AAPL | Stock | 144.18 | 144.29 | 144.1 | 144.2 | 7358.0 |
| 2021-10-15 06:30:00 | AAPL | Stock | 144.2 | 144.25 | 144.1 | 144.14 | 9796.0 |
| 2021-10-15 07:00:00 | AAPL | Stock | 144.1 | 144.28 | 144.04 | 144.25 | 54983.0 |
| 2021-10-15 07:30:00 | AAPL | Stock | 144.27 | 144.38 | 144.11 | 144.18 | 37004.0 |
| 2021-10-15 08:00:00 | AAPL | Stock | 144.1699 | 144.37 | 143.401 | 144.15 | 169224.0 |
| 2021-10-15 08:30:00 | AAPL | Stock | 144.15 | 144.36 | 144.0 | 144.11 | 198376.0 |
| 2021-10-15 09:00:00 | AAPL | Stock | 144.11 | 144.3 | 143.495 | 143.77 | 377185.0 |
| 2021-10-15 09:30:00 | AAPL | Stock | 143.72 | 144.69 | 143.51 | 144.3316 | 11113452.0 |
| 2021-10-15 10:00:00 | AAPL | Stock | 144.335 | 144.38 | 143.8 | 143.855 | 4810322.0 |
| 2021-10-15 10:30:00 | AAPL | Stock | 143.85 | 144.39 | 143.81 | 144.3739 | 3922238.0 |
| 2021-10-15 11:00:00 | AAPL | Stock | 144.3735 | 144.44 | 144.01 | 144.2 | 3186901.0 |
| 2021-10-15 11:30:00 | AAPL | Stock | 144.195 | 144.26 | 143.66 | 143.735 | 3064602.0 |
| 2021-10-15 12:00:00 | AAPL | Stock | 143.7301 | 143.94 | 143.67 | 143.87 | 2232330.0 |
| 2021-10-15 12:30:00 | AAPL | Stock | 143.8685 | 144.27 | 143.84 | 144.2275 | 2493123.0 |
| 2021-10-15 13:00:00 | AAPL | Stock | 144.222 | 144.31 | 144.04 | 144.26 | 2219162.0 |
| 2021-10-15 13:30:00 | AAPL | Stock | 144.27 | 144.52 | 144.25 | 144.415 | 2405574.0 |
| 2021-10-15 14:00:00 | AAPL | Stock | 144.4114 | 144.62 | 144.36 | 144.505 | 2263018.0 |
| 2021-10-15 14:30:00 | AAPL | Stock | 144.505 | 144.67 | 144.39 | 144.635 | 2520303.0 |
| 2021-10-15 15:00:00 | AAPL | Stock | 144.64 | 144.6799 | 144.2801 | 144.6721 | 3541681.0 |
| 2021-10-15 15:30:00 | AAPL | Stock | 144.6746 | 144.895 | 144.3501 | 144.83 | 6758742.0 |
| 2021-10-15 16:00:00 | AAPL | Stock | 144.84 | 144.95 | 144.7 | 144.82 | 7774879.0 |
| 2021-10-15 16:30:00 | AAPL | Stock | 144.82 | 144.9 | 144.82 | 144.89 | 57536.0 |
| 2021-10-15 17:00:00 | AAPL | Stock | 144.9 | 144.92 | 144.85 | 144.86 | 20197.0 |
| 2021-10-15 17:30:00 | AAPL | Stock | 144.88 | 144.9 | 144.84 | 144.86 | 17196.0 |
| 2021-10-15 18:00:00 | AAPL | Stock | 144.8599 | 144.9 | 144.85 | 144.89 | 4502.0 |
| 2021-10-15 18:30:00 | AAPL | Stock | 144.87 | 144.87 | 144.8 | 144.81 | 12162.0 |
| 2021-10-15 19:00:00 | AAPL | Stock | 144.82 | 144.8799 | 144.81 | 144.82 | 8823.0 |
| 2021-10-15 19:30:00 | AAPL | Stock | 144.85 | 144.97 | 144.85 | 144.95 | 21552.0 |
| 2021-10-15 04:00:00 | MSFT | Stock | 302.75 | 303.48 | 302.75 | 303.48 | 908.0 |
| 2021-10-15 04:30:00 | MSFT | Stock | 303.35 | 303.48 | 303.34 | 303.34 | 709.0 |
| 2021-10-15 05:00:00 | MSFT | Stock | 303.32 | 303.32 | 303.01 | 303.01 | 1316.0 |
| 2021-10-15 05:30:00 | MSFT | Stock | 303.06 | 303.08 | 303.06 | 303.08 | 430.0 |
| 2021-10-15 06:00:00 | MSFT | Stock | 303.28 | 303.3 | 303.28 | 303.3 | 1887.0 |
| 2021-10-15 06:30:00 | MSFT | Stock | 303.38 | 303.47 | 303.38 | 303.47 | 5009.0 |
| 2021-10-15 07:00:00 | MSFT | Stock | 303.5 | 303.68 | 303.41 | 303.51 | 3421.0 |
| 2021-10-15 07:30:00 | MSFT | Stock | 303.6 | 303.8 | 303.4 | 303.4 | 10740.0 |
| 2021-10-15 08:00:00 | MSFT | Stock | 303.55 | 303.85 | 302.75 | 302.75 | 26761.0 |
| 2021-10-15 08:30:00 | MSFT | Stock | 303.43 | 303.55 | 302.9 | 302.95 | 27182.0 |
| 2021-10-15 09:00:00 | MSFT | Stock | 302.9 | 303.19 | 302.129 | 302.14 | 76716.0 |
| 2021-10-15 09:30:00 | MSFT | Stock | 302.14 | 303.1 | 301.08 | 301.38 | 3366003.0 |
| 2021-10-15 10:00:00 | MSFT | Stock | 301.41 | 301.44 | 300.71 | 300.77 | 1193388.0 |
| 2021-10-15 10:30:00 | MSFT | Stock | 300.77 | 301.12 | 300.5191 | 301.1099 | 1058072.0 |
| 2021-10-15 11:00:00 | MSFT | Stock | 301.1299 | 301.77 | 300.9201 | 301.53 | 966411.0 |
| 2021-10-15 11:30:00 | MSFT | Stock | 301.53 | 301.85 | 300.95 | 301.12 | 658883.0 |
| 2021-10-15 12:00:00 | MSFT | Stock | 301.11 | 302.51 | 301.0838 | 302.44 | 837129.0 |
| 2021-10-15 12:30:00 | MSFT | Stock | 302.4526 | 303.36 | 302.399 | 303.16 | 1070884.0 |
> showing 50 of 111,066 rows — these rows as CSV