PREVIEW / stock_30min / 2021-05-28
file: by_date/stock_30min/2021/2021-05-28.parquet size: 2.2 MB rows: 110,256 symbols: 2,967
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-28 04:00:00 | AAPL | Stock | 126.04 | 126.18 | 126.0 | 126.15 | 5371.0 |
| 2021-05-28 04:30:00 | AAPL | Stock | 126.05 | 126.18 | 126.05 | 126.09 | 1618.0 |
| 2021-05-28 05:00:00 | AAPL | Stock | 126.12 | 126.22 | 126.07 | 126.22 | 1506.0 |
| 2021-05-28 05:30:00 | AAPL | Stock | 126.23 | 126.25 | 126.1 | 126.1 | 6879.0 |
| 2021-05-28 06:00:00 | AAPL | Stock | 126.17 | 126.18 | 126.05 | 126.05 | 1567.0 |
| 2021-05-28 06:30:00 | AAPL | Stock | 126.09 | 126.28 | 126.02 | 126.28 | 13639.0 |
| 2021-05-28 07:00:00 | AAPL | Stock | 126.17 | 126.28 | 125.7 | 125.95 | 111832.0 |
| 2021-05-28 07:30:00 | AAPL | Stock | 125.94 | 125.96 | 125.65 | 125.72 | 106845.0 |
| 2021-05-28 08:00:00 | AAPL | Stock | 126.0401 | 126.19 | 125.37 | 125.58 | 318265.0 |
| 2021-05-28 08:30:00 | AAPL | Stock | 125.63 | 125.72 | 125.36 | 125.58 | 270706.0 |
| 2021-05-28 09:00:00 | AAPL | Stock | 125.58 | 125.6 | 125.35 | 125.53 | 302301.0 |
| 2021-05-28 09:30:00 | AAPL | Stock | 125.57 | 125.8 | 124.58 | 125.46 | 10950963.0 |
| 2021-05-28 10:00:00 | AAPL | Stock | 125.46 | 125.71 | 125.15 | 125.1879 | 5048792.0 |
| 2021-05-28 10:30:00 | AAPL | Stock | 125.1982 | 125.62 | 125.13 | 125.17 | 3930413.0 |
| 2021-05-28 11:00:00 | AAPL | Stock | 125.18 | 125.2 | 124.88 | 125.06 | 4055179.0 |
| 2021-05-28 11:30:00 | AAPL | Stock | 125.0648 | 125.23 | 125.03 | 125.195 | 2759879.0 |
| 2021-05-28 12:00:00 | AAPL | Stock | 125.195 | 125.41 | 125.14 | 125.235 | 2687195.0 |
| 2021-05-28 12:30:00 | AAPL | Stock | 125.235 | 125.32 | 125.14 | 125.29 | 2409348.0 |
| 2021-05-28 13:00:00 | AAPL | Stock | 125.3 | 125.3799 | 124.83 | 124.84 | 4000498.0 |
| 2021-05-28 13:30:00 | AAPL | Stock | 124.845 | 124.975 | 124.735 | 124.87 | 3197453.0 |
| 2021-05-28 14:00:00 | AAPL | Stock | 124.88 | 125.09 | 124.8118 | 125.075 | 2715126.0 |
| 2021-05-28 14:30:00 | AAPL | Stock | 125.075 | 125.14 | 124.99 | 125.0782 | 2005242.0 |
| 2021-05-28 15:00:00 | AAPL | Stock | 125.075 | 125.11 | 124.93 | 125.0555 | 2874828.0 |
| 2021-05-28 15:30:00 | AAPL | Stock | 125.055 | 125.17 | 124.55 | 124.61 | 9121726.0 |
| 2021-05-28 16:00:00 | AAPL | Stock | 124.61 | 124.82 | 124.6 | 124.66 | 6836719.0 |
| 2021-05-28 16:30:00 | AAPL | Stock | 124.66 | 124.66 | 124.52 | 124.57 | 72241.0 |
| 2021-05-28 17:00:00 | AAPL | Stock | 124.58 | 124.65 | 124.57 | 124.59 | 50853.0 |
| 2021-05-28 17:30:00 | AAPL | Stock | 124.6 | 124.67 | 124.59 | 124.65 | 31772.0 |
| 2021-05-28 18:00:00 | AAPL | Stock | 124.6501 | 124.68 | 124.65 | 124.67 | 16648.0 |
| 2021-05-28 18:30:00 | AAPL | Stock | 124.67 | 124.7 | 124.65 | 124.67 | 19485.0 |
| 2021-05-28 19:00:00 | AAPL | Stock | 124.65 | 124.67 | 124.63 | 124.65 | 13113.0 |
| 2021-05-28 19:30:00 | AAPL | Stock | 124.65 | 124.67 | 124.61 | 124.61 | 20727.0 |
| 2021-05-28 04:00:00 | MSFT | Stock | 250.5 | 250.5 | 250.47 | 250.47 | 890.0 |
| 2021-05-28 04:30:00 | MSFT | Stock | 250.33 | 250.38 | 250.18 | 250.18 | 929.0 |
| 2021-05-28 05:30:00 | MSFT | Stock | 250.27 | 250.3 | 250.27 | 250.3 | 1164.0 |
| 2021-05-28 06:30:00 | MSFT | Stock | 250.6 | 250.71 | 250.6 | 250.6 | 2659.0 |
| 2021-05-28 07:00:00 | MSFT | Stock | 250.53 | 250.86 | 250.49 | 250.73 | 4197.0 |
| 2021-05-28 07:30:00 | MSFT | Stock | 250.67 | 250.71 | 250.6 | 250.71 | 864.0 |
| 2021-05-28 08:00:00 | MSFT | Stock | 250.6 | 250.7599 | 248.687 | 250.4999 | 7945.0 |
| 2021-05-28 08:30:00 | MSFT | Stock | 250.45 | 250.8199 | 250.41 | 250.43 | 12365.0 |
| 2021-05-28 09:00:00 | MSFT | Stock | 250.44 | 251.66 | 249.31 | 251.3 | 21079.0 |
| 2021-05-28 09:30:00 | MSFT | Stock | 251.24 | 252.07 | 250.34 | 251.21 | 1897828.0 |
| 2021-05-28 10:00:00 | MSFT | Stock | 251.19 | 251.4 | 250.43 | 250.695 | 821748.0 |
| 2021-05-28 10:30:00 | MSFT | Stock | 250.7 | 251.225 | 250.69 | 251.0 | 594061.0 |
| 2021-05-28 11:00:00 | MSFT | Stock | 251.02 | 251.18 | 250.81 | 251.12 | 541261.0 |
| 2021-05-28 11:30:00 | MSFT | Stock | 251.115 | 251.76 | 251.09 | 251.67 | 852802.0 |
| 2021-05-28 12:00:00 | MSFT | Stock | 251.68 | 252.08 | 251.6458 | 251.756 | 758684.0 |
| 2021-05-28 12:30:00 | MSFT | Stock | 251.765 | 251.77 | 251.26 | 251.54 | 427677.0 |
| 2021-05-28 13:00:00 | MSFT | Stock | 251.55 | 251.6697 | 250.8 | 250.85 | 653493.0 |
| 2021-05-28 13:30:00 | MSFT | Stock | 250.84 | 251.1 | 250.6 | 250.81 | 589064.0 |
> showing 50 of 110,256 rows — these rows as CSV