PREVIEW / stock_30min / 2021-05-05
file: by_date/stock_30min/2021/2021-05-05.parquet size: 2.2 MB rows: 111,366 symbols: 2,991
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-05 04:00:00 | AAPL | Stock | 128.4 | 128.8 | 128.36 | 128.8 | 36833.0 |
| 2021-05-05 04:30:00 | AAPL | Stock | 128.74 | 128.82 | 128.61 | 128.79 | 20469.0 |
| 2021-05-05 05:00:00 | AAPL | Stock | 128.79 | 129.08 | 128.74 | 129.0 | 16812.0 |
| 2021-05-05 05:30:00 | AAPL | Stock | 129.0 | 129.1 | 128.9 | 128.9 | 10693.0 |
| 2021-05-05 06:00:00 | AAPL | Stock | 128.9 | 129.05 | 128.89 | 128.98 | 22181.0 |
| 2021-05-05 06:30:00 | AAPL | Stock | 128.99 | 129.1 | 128.95 | 129.0 | 23241.0 |
| 2021-05-05 07:00:00 | AAPL | Stock | 129.0 | 129.01 | 128.67 | 128.85 | 162814.0 |
| 2021-05-05 07:30:00 | AAPL | Stock | 128.84 | 128.95 | 128.75 | 128.9 | 63509.0 |
| 2021-05-05 08:00:00 | AAPL | Stock | 128.78 | 129.23 | 128.68 | 129.09 | 394610.0 |
| 2021-05-05 08:30:00 | AAPL | Stock | 129.07 | 129.0999 | 128.71 | 128.95 | 228255.0 |
| 2021-05-05 09:00:00 | AAPL | Stock | 128.94 | 129.3 | 128.77 | 129.21 | 339613.0 |
| 2021-05-05 09:30:00 | AAPL | Stock | 129.21 | 130.45 | 129.19 | 129.7299 | 14781366.0 |
| 2021-05-05 10:00:00 | AAPL | Stock | 129.73 | 129.81 | 128.86 | 129.3918 | 8791118.0 |
| 2021-05-05 10:30:00 | AAPL | Stock | 129.3998 | 129.92 | 129.335 | 129.755 | 5643370.0 |
| 2021-05-05 11:00:00 | AAPL | Stock | 129.75 | 129.91 | 129.47 | 129.7101 | 3723076.0 |
| 2021-05-05 11:30:00 | AAPL | Stock | 129.71 | 130.2 | 129.66 | 130.1489 | 3711211.0 |
| 2021-05-05 12:00:00 | AAPL | Stock | 130.15 | 130.1899 | 129.79 | 129.8605 | 2835073.0 |
| 2021-05-05 12:30:00 | AAPL | Stock | 129.87 | 129.9101 | 129.411 | 129.45 | 2772968.0 |
| 2021-05-05 13:00:00 | AAPL | Stock | 129.44 | 129.52 | 129.16 | 129.3813 | 2722490.0 |
| 2021-05-05 13:30:00 | AAPL | Stock | 129.3899 | 129.59 | 129.25 | 129.3064 | 2539783.0 |
| 2021-05-05 14:00:00 | AAPL | Stock | 129.31 | 129.33 | 128.7 | 128.905 | 3612104.0 |
| 2021-05-05 14:30:00 | AAPL | Stock | 128.905 | 129.0 | 128.64 | 128.8 | 3156047.0 |
| 2021-05-05 15:00:00 | AAPL | Stock | 128.804 | 128.8299 | 127.97 | 128.0799 | 4933190.0 |
| 2021-05-05 15:30:00 | AAPL | Stock | 128.07 | 128.72 | 128.0 | 128.15 | 8076965.0 |
| 2021-05-05 16:00:00 | AAPL | Stock | 128.1 | 128.2 | 128.0 | 128.09 | 4826597.0 |
| 2021-05-05 16:30:00 | AAPL | Stock | 128.09 | 128.13 | 127.94 | 127.96 | 419141.0 |
| 2021-05-05 17:00:00 | AAPL | Stock | 127.95 | 127.97 | 127.81 | 127.97 | 55719.0 |
| 2021-05-05 17:30:00 | AAPL | Stock | 127.95 | 128.05 | 127.92 | 128.04 | 25456.0 |
| 2021-05-05 18:00:00 | AAPL | Stock | 128.02 | 128.1 | 127.92 | 128.0 | 30339.0 |
| 2021-05-05 18:30:00 | AAPL | Stock | 128.0 | 128.05 | 127.9101 | 127.97 | 16297.0 |
| 2021-05-05 19:00:00 | AAPL | Stock | 127.93 | 128.04 | 127.89 | 127.97 | 66300.0 |
| 2021-05-05 19:30:00 | AAPL | Stock | 127.97 | 128.0 | 127.89 | 127.98 | 63036.0 |
| 2021-05-05 04:00:00 | MSFT | Stock | 247.78 | 248.56 | 247.78 | 248.54 | 622.0 |
| 2021-05-05 04:30:00 | MSFT | Stock | 248.54 | 248.6 | 248.5 | 248.6 | 322.0 |
| 2021-05-05 05:00:00 | MSFT | Stock | 248.55 | 248.9 | 248.55 | 248.83 | 816.0 |
| 2021-05-05 05:30:00 | MSFT | Stock | 249.05 | 249.47 | 249.05 | 249.31 | 1785.0 |
| 2021-05-05 06:00:00 | MSFT | Stock | 249.3 | 249.3 | 248.96 | 248.99 | 1449.0 |
| 2021-05-05 06:30:00 | MSFT | Stock | 249.29 | 249.3 | 249.29 | 249.3 | 2688.0 |
| 2021-05-05 07:00:00 | MSFT | Stock | 249.05 | 249.3 | 248.56 | 249.1 | 14600.0 |
| 2021-05-05 07:30:00 | MSFT | Stock | 249.01 | 249.24 | 248.72 | 248.81 | 15481.0 |
| 2021-05-05 08:00:00 | MSFT | Stock | 248.76 | 249.4699 | 248.56 | 249.2 | 27072.0 |
| 2021-05-05 08:30:00 | MSFT | Stock | 249.16 | 249.16 | 247.99 | 248.9 | 21387.0 |
| 2021-05-05 09:00:00 | MSFT | Stock | 248.74 | 249.2566 | 248.6 | 249.06 | 28461.0 |
| 2021-05-05 09:30:00 | MSFT | Stock | 248.98 | 249.5 | 248.365 | 248.62 | 1795297.0 |
| 2021-05-05 10:00:00 | MSFT | Stock | 248.68 | 248.76 | 247.3901 | 248.11 | 1079868.0 |
| 2021-05-05 10:30:00 | MSFT | Stock | 248.1203 | 248.73 | 248.0 | 248.37 | 820887.0 |
| 2021-05-05 11:00:00 | MSFT | Stock | 248.37 | 248.58 | 247.77 | 248.04 | 650459.0 |
| 2021-05-05 11:30:00 | MSFT | Stock | 248.0499 | 248.76 | 247.93 | 248.6 | 453010.0 |
| 2021-05-05 12:00:00 | MSFT | Stock | 248.6 | 248.9 | 248.12 | 248.2115 | 637511.0 |
| 2021-05-05 12:30:00 | MSFT | Stock | 248.22 | 248.295 | 247.62 | 247.645 | 554799.0 |
> showing 50 of 111,366 rows — these rows as CSV