PREVIEW / stock_30min / 2021-01-13
file: by_date/stock_30min/2021/2021-01-13.parquet size: 2.3 MB rows: 114,049 symbols: 2,694
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-01-13 04:00:00 | AAPL | Stock | 129.3 | 130.0 | 129.3 | 129.61 | 10449.0 |
| 2021-01-13 04:30:00 | AAPL | Stock | 129.62 | 129.82 | 129.61 | 129.82 | 8545.0 |
| 2021-01-13 05:00:00 | AAPL | Stock | 129.78 | 130.0 | 129.7 | 129.7 | 29034.0 |
| 2021-01-13 05:30:00 | AAPL | Stock | 129.7 | 129.84 | 129.45 | 129.7 | 16345.0 |
| 2021-01-13 06:00:00 | AAPL | Stock | 129.79 | 129.92 | 129.23 | 129.5 | 21052.0 |
| 2021-01-13 06:30:00 | AAPL | Stock | 129.5 | 129.85 | 129.3 | 129.67 | 10182.0 |
| 2021-01-13 07:00:00 | AAPL | Stock | 129.73 | 129.8 | 128.9 | 129.15 | 231446.0 |
| 2021-01-13 07:30:00 | AAPL | Stock | 129.15 | 129.16 | 128.66 | 128.9 | 163447.0 |
| 2021-01-13 08:00:00 | AAPL | Stock | 129.39 | 129.7 | 128.29 | 128.79 | 283651.0 |
| 2021-01-13 08:30:00 | AAPL | Stock | 128.8 | 129.28 | 128.79 | 129.17 | 227487.0 |
| 2021-01-13 09:00:00 | AAPL | Stock | 129.16 | 129.2 | 128.61 | 128.69 | 270974.0 |
| 2021-01-13 09:30:00 | AAPL | Stock | 128.69 | 130.2 | 128.49 | 129.83 | 12008877.0 |
| 2021-01-13 10:00:00 | AAPL | Stock | 129.83 | 130.16 | 129.32 | 130.044 | 7667007.0 |
| 2021-01-13 10:30:00 | AAPL | Stock | 130.05 | 131.26 | 130.05 | 131.03 | 8098539.0 |
| 2021-01-13 11:00:00 | AAPL | Stock | 131.031 | 131.44 | 130.82 | 131.25 | 6191894.0 |
| 2021-01-13 11:30:00 | AAPL | Stock | 131.24 | 131.45 | 130.721 | 131.15 | 5605773.0 |
| 2021-01-13 12:00:00 | AAPL | Stock | 131.16 | 131.19 | 130.5 | 130.723 | 5198192.0 |
| 2021-01-13 12:30:00 | AAPL | Stock | 130.725 | 131.185 | 130.41 | 131.13 | 4209471.0 |
| 2021-01-13 13:00:00 | AAPL | Stock | 131.12 | 131.29 | 130.77 | 130.89 | 3015554.0 |
| 2021-01-13 13:30:00 | AAPL | Stock | 130.885 | 131.089 | 130.785 | 130.855 | 2215221.0 |
| 2021-01-13 14:00:00 | AAPL | Stock | 130.855 | 131.2 | 130.731 | 130.92 | 3219093.0 |
| 2021-01-13 14:30:00 | AAPL | Stock | 130.92 | 131.14 | 130.84 | 131.0 | 2727366.0 |
| 2021-01-13 15:00:00 | AAPL | Stock | 131.01 | 131.08 | 130.63 | 130.675 | 2879936.0 |
| 2021-01-13 15:30:00 | AAPL | Stock | 130.675 | 131.13 | 130.6 | 130.89 | 6316572.0 |
| 2021-01-13 16:00:00 | AAPL | Stock | 131.18 | 131.18 | 130.75 | 130.79 | 8598752.0 |
| 2021-01-13 16:30:00 | AAPL | Stock | 130.79 | 130.89 | 130.78 | 130.83 | 50151.0 |
| 2021-01-13 17:00:00 | AAPL | Stock | 130.79 | 130.85 | 130.76 | 130.84 | 18346.0 |
| 2021-01-13 17:30:00 | AAPL | Stock | 130.84 | 130.93 | 130.8 | 130.93 | 30505.0 |
| 2021-01-13 18:00:00 | AAPL | Stock | 130.93 | 131.1 | 130.81 | 131.03 | 45650.0 |
| 2021-01-13 18:30:00 | AAPL | Stock | 131.01 | 131.11 | 130.99 | 131.03 | 39269.0 |
| 2021-01-13 19:00:00 | AAPL | Stock | 130.95 | 131.19 | 130.95 | 131.15 | 30352.0 |
| 2021-01-13 19:30:00 | AAPL | Stock | 131.15 | 131.28 | 131.06 | 131.28 | 83578.0 |
| 2021-01-13 04:00:00 | MSFT | Stock | 215.3 | 215.3 | 215.3 | 215.3 | 2000.0 |
| 2021-01-13 05:00:00 | MSFT | Stock | 215.64 | 215.98 | 215.3 | 215.68 | 4192.0 |
| 2021-01-13 05:30:00 | MSFT | Stock | 215.31 | 215.4 | 215.2 | 215.2 | 2275.0 |
| 2021-01-13 06:00:00 | MSFT | Stock | 215.22 | 215.22 | 214.11 | 214.11 | 1210.0 |
| 2021-01-13 06:30:00 | MSFT | Stock | 214.38 | 214.52 | 214.38 | 214.52 | 1642.0 |
| 2021-01-13 07:00:00 | MSFT | Stock | 214.69 | 214.8 | 213.8 | 214.23 | 16202.0 |
| 2021-01-13 07:30:00 | MSFT | Stock | 214.23 | 214.3 | 213.75 | 213.75 | 9710.0 |
| 2021-01-13 08:00:00 | MSFT | Stock | 214.8 | 214.8 | 213.5 | 214.1 | 32575.0 |
| 2021-01-13 08:30:00 | MSFT | Stock | 214.1 | 214.3 | 214.07 | 214.25 | 6273.0 |
| 2021-01-13 09:00:00 | MSFT | Stock | 214.25 | 214.67 | 214.03 | 214.03 | 37898.0 |
| 2021-01-13 09:30:00 | MSFT | Stock | 214.04 | 215.58 | 213.9 | 214.79 | 2388141.0 |
| 2021-01-13 10:00:00 | MSFT | Stock | 214.74 | 215.17 | 214.12 | 214.945 | 1093579.0 |
| 2021-01-13 10:30:00 | MSFT | Stock | 214.95 | 215.83 | 214.86 | 215.79 | 1280924.0 |
| 2021-01-13 11:00:00 | MSFT | Stock | 215.79 | 215.98 | 214.92 | 215.59 | 1048988.0 |
| 2021-01-13 11:30:00 | MSFT | Stock | 215.58 | 216.13 | 215.395 | 215.95 | 599792.0 |
| 2021-01-13 12:00:00 | MSFT | Stock | 215.95 | 216.18 | 215.165 | 215.51 | 755583.0 |
| 2021-01-13 12:30:00 | MSFT | Stock | 215.521 | 216.14 | 215.09 | 215.805 | 639079.0 |
| 2021-01-13 13:00:00 | MSFT | Stock | 215.8 | 216.14 | 215.65 | 216.0 | 563646.0 |
> showing 50 of 114,049 rows — these rows as CSV