PREVIEW / stock_30min / 2021-05-27
file: by_date/stock_30min/2021/2021-05-27.parquet size: 2.2 MB rows: 110,545 symbols: 2,971
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-05-27 04:00:00 | AAPL | Stock | 126.36 | 126.66 | 126.29 | 126.54 | 8654.0 |
| 2021-05-27 04:30:00 | AAPL | Stock | 126.55 | 126.55 | 126.3 | 126.35 | 2564.0 |
| 2021-05-27 05:00:00 | AAPL | Stock | 126.25 | 126.36 | 126.21 | 126.24 | 3361.0 |
| 2021-05-27 05:30:00 | AAPL | Stock | 126.25 | 126.7 | 126.2 | 126.36 | 9853.0 |
| 2021-05-27 06:00:00 | AAPL | Stock | 126.28 | 126.38 | 126.27 | 126.3 | 791.0 |
| 2021-05-27 06:30:00 | AAPL | Stock | 126.31 | 126.4 | 126.31 | 126.36 | 2685.0 |
| 2021-05-27 07:00:00 | AAPL | Stock | 126.38 | 126.49 | 126.35 | 126.36 | 41491.0 |
| 2021-05-27 07:30:00 | AAPL | Stock | 126.39 | 126.57 | 126.21 | 126.57 | 39583.0 |
| 2021-05-27 08:00:00 | AAPL | Stock | 126.44 | 126.74 | 126.2 | 126.39 | 244747.0 |
| 2021-05-27 08:30:00 | AAPL | Stock | 126.36 | 126.85 | 126.19 | 126.48 | 708756.0 |
| 2021-05-27 09:00:00 | AAPL | Stock | 126.5 | 126.69 | 126.21 | 126.39 | 216972.0 |
| 2021-05-27 09:30:00 | AAPL | Stock | 126.36 | 127.495 | 126.36 | 127.1299 | 8464282.0 |
| 2021-05-27 10:00:00 | AAPL | Stock | 127.11 | 127.48 | 126.915 | 127.42 | 4569871.0 |
| 2021-05-27 10:30:00 | AAPL | Stock | 127.42 | 127.64 | 127.06 | 127.065 | 4666923.0 |
| 2021-05-27 11:00:00 | AAPL | Stock | 127.06 | 127.24 | 126.91 | 126.915 | 3020483.0 |
| 2021-05-27 11:30:00 | AAPL | Stock | 126.91 | 126.92 | 126.7 | 126.815 | 3462273.0 |
| 2021-05-27 12:00:00 | AAPL | Stock | 126.82 | 126.89 | 126.731 | 126.7699 | 2037057.0 |
| 2021-05-27 12:30:00 | AAPL | Stock | 126.76 | 126.81 | 126.5199 | 126.6277 | 2553768.0 |
| 2021-05-27 13:00:00 | AAPL | Stock | 126.6239 | 126.71 | 126.52 | 126.555 | 1820094.0 |
| 2021-05-27 13:30:00 | AAPL | Stock | 126.56 | 126.63 | 126.21 | 126.28 | 3059252.0 |
| 2021-05-27 14:00:00 | AAPL | Stock | 126.28 | 126.3 | 125.8 | 125.9362 | 4168198.0 |
| 2021-05-27 14:30:00 | AAPL | Stock | 125.93 | 126.07 | 125.81 | 125.98 | 3036322.0 |
| 2021-05-27 15:00:00 | AAPL | Stock | 125.975 | 126.0 | 125.82 | 125.835 | 3344586.0 |
| 2021-05-27 15:30:00 | AAPL | Stock | 125.835 | 125.97 | 125.08 | 125.33 | 11352186.0 |
| 2021-05-27 16:00:00 | AAPL | Stock | 125.34 | 125.8 | 125.28 | 125.75 | 24847303.0 |
| 2021-05-27 16:30:00 | AAPL | Stock | 125.75 | 125.83 | 125.71 | 125.81 | 155022.0 |
| 2021-05-27 17:00:00 | AAPL | Stock | 125.81 | 125.9 | 125.28 | 125.9 | 301355.0 |
| 2021-05-27 17:30:00 | AAPL | Stock | 125.9 | 125.9 | 125.85 | 125.86 | 25763.0 |
| 2021-05-27 18:00:00 | AAPL | Stock | 125.86 | 125.9 | 125.84 | 125.88 | 14041.0 |
| 2021-05-27 18:30:00 | AAPL | Stock | 125.89 | 125.93 | 125.85 | 125.89 | 21761.0 |
| 2021-05-27 19:00:00 | AAPL | Stock | 125.89 | 125.9 | 125.84 | 125.9 | 13598.0 |
| 2021-05-27 19:30:00 | AAPL | Stock | 125.9 | 126.05 | 125.86 | 126.0401 | 52315.0 |
| 2021-05-27 04:00:00 | MSFT | Stock | 250.48 | 250.48 | 249.69 | 250.06 | 826.0 |
| 2021-05-27 04:30:00 | MSFT | Stock | 250.12 | 250.12 | 250.0 | 250.0 | 237.0 |
| 2021-05-27 05:00:00 | MSFT | Stock | 249.68 | 249.68 | 249.56 | 249.64 | 1851.0 |
| 2021-05-27 05:30:00 | MSFT | Stock | 249.48 | 249.48 | 249.4 | 249.44 | 601.0 |
| 2021-05-27 06:00:00 | MSFT | Stock | 249.44 | 250.0 | 249.44 | 250.0 | 784.0 |
| 2021-05-27 06:30:00 | MSFT | Stock | 250.12 | 250.12 | 250.11 | 250.11 | 600.0 |
| 2021-05-27 07:00:00 | MSFT | Stock | 250.33 | 250.5 | 250.04 | 250.04 | 7221.0 |
| 2021-05-27 07:30:00 | MSFT | Stock | 250.02 | 250.5 | 250.0 | 250.5 | 7297.0 |
| 2021-05-27 08:00:00 | MSFT | Stock | 250.68 | 251.0 | 250.0 | 250.37 | 31832.0 |
| 2021-05-27 08:30:00 | MSFT | Stock | 250.36 | 250.86 | 250.04 | 250.8 | 12262.0 |
| 2021-05-27 09:00:00 | MSFT | Stock | 250.79 | 251.49 | 250.79 | 251.12 | 26351.0 |
| 2021-05-27 09:30:00 | MSFT | Stock | 251.17 | 251.48 | 250.26 | 250.27 | 1683436.0 |
| 2021-05-27 10:00:00 | MSFT | Stock | 250.27 | 251.0 | 250.13 | 250.535 | 790927.0 |
| 2021-05-27 10:30:00 | MSFT | Stock | 250.53 | 251.39 | 250.53 | 250.72 | 879786.0 |
| 2021-05-27 11:00:00 | MSFT | Stock | 250.71 | 251.23 | 250.51 | 250.895 | 537179.0 |
| 2021-05-27 11:30:00 | MSFT | Stock | 250.9 | 251.12 | 250.67 | 250.975 | 579262.0 |
| 2021-05-27 12:00:00 | MSFT | Stock | 250.95 | 251.07 | 250.61 | 250.62 | 484362.0 |
| 2021-05-27 12:30:00 | MSFT | Stock | 250.63 | 250.799 | 250.38 | 250.58 | 477971.0 |
> showing 50 of 110,545 rows — these rows as CSV