PREVIEW / stock_30min / 2021-01-06
file: by_date/stock_30min/2021/2021-01-06.parquet size: 2.3 MB rows: 114,880 symbols: 2,679
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-06 04:00:00 | AAPL | Stock | 128.5 | 129.03 | 128.0 | 128.42 | 79173.0 |
| 2021-01-06 04:30:00 | AAPL | Stock | 128.42 | 128.99 | 128.21 | 128.56 | 29402.0 |
| 2021-01-06 05:00:00 | AAPL | Stock | 128.43 | 128.93 | 128.02 | 128.02 | 59501.0 |
| 2021-01-06 05:30:00 | AAPL | Stock | 128.01 | 128.59 | 127.8 | 128.08 | 86376.0 |
| 2021-01-06 06:00:00 | AAPL | Stock | 128.08 | 128.25 | 127.52 | 128.09 | 51808.0 |
| 2021-01-06 06:30:00 | AAPL | Stock | 128.06 | 128.55 | 127.61 | 128.48 | 48427.0 |
| 2021-01-06 07:00:00 | AAPL | Stock | 128.55 | 129.13 | 128.32 | 128.94 | 399301.0 |
| 2021-01-06 07:30:00 | AAPL | Stock | 128.92 | 129.2 | 128.2 | 128.36 | 339126.0 |
| 2021-01-06 08:00:00 | AAPL | Stock | 128.36 | 129.16 | 128.23 | 128.93 | 554036.0 |
| 2021-01-06 08:30:00 | AAPL | Stock | 128.92 | 128.92 | 128.01 | 128.15 | 459527.0 |
| 2021-01-06 09:00:00 | AAPL | Stock | 128.149 | 128.78 | 127.5 | 127.72 | 831577.0 |
| 2021-01-06 09:30:00 | AAPL | Stock | 127.72 | 128.52 | 126.55 | 128.06 | 21167942.0 |
| 2021-01-06 10:00:00 | AAPL | Stock | 128.07 | 129.21 | 127.59 | 128.95 | 10098155.0 |
| 2021-01-06 10:30:00 | AAPL | Stock | 128.96 | 129.74 | 128.815 | 129.387 | 9021668.0 |
| 2021-01-06 11:00:00 | AAPL | Stock | 129.39 | 131.05 | 129.1 | 130.42 | 9868173.0 |
| 2021-01-06 11:30:00 | AAPL | Stock | 130.43 | 130.768 | 129.89 | 130.12 | 6994125.0 |
| 2021-01-06 12:00:00 | AAPL | Stock | 130.13 | 130.705 | 130.06 | 130.325 | 5092765.0 |
| 2021-01-06 12:30:00 | AAPL | Stock | 130.329 | 130.54 | 129.88 | 130.01 | 4026700.0 |
| 2021-01-06 13:00:00 | AAPL | Stock | 130.02 | 130.26 | 129.21 | 129.24 | 6037799.0 |
| 2021-01-06 13:30:00 | AAPL | Stock | 129.25 | 129.6 | 128.94 | 129.25 | 5485143.0 |
| 2021-01-06 14:00:00 | AAPL | Stock | 129.255 | 129.45 | 127.75 | 127.8 | 7586218.0 |
| 2021-01-06 14:30:00 | AAPL | Stock | 127.79 | 128.22 | 127.1 | 127.94 | 11395118.0 |
| 2021-01-06 15:00:00 | AAPL | Stock | 127.93 | 128.22 | 126.94 | 127.48 | 9001465.0 |
| 2021-01-06 15:30:00 | AAPL | Stock | 127.49 | 127.59 | 126.382 | 126.58 | 17212854.0 |
| 2021-01-06 16:00:00 | AAPL | Stock | 126.68 | 126.9 | 126.31 | 126.8 | 10407613.0 |
| 2021-01-06 16:30:00 | AAPL | Stock | 126.8 | 127.24 | 126.6 | 127.08 | 269982.0 |
| 2021-01-06 17:00:00 | AAPL | Stock | 127.1 | 127.4 | 127.0 | 127.4 | 166617.0 |
| 2021-01-06 17:30:00 | AAPL | Stock | 127.41 | 127.46 | 127.25 | 127.26 | 153541.0 |
| 2021-01-06 18:00:00 | AAPL | Stock | 127.251 | 127.37 | 127.05 | 127.35 | 109290.0 |
| 2021-01-06 18:30:00 | AAPL | Stock | 127.38 | 127.47 | 127.21 | 127.35 | 91233.0 |
| 2021-01-06 19:00:00 | AAPL | Stock | 127.28 | 127.5 | 127.28 | 127.41 | 98490.0 |
| 2021-01-06 19:30:00 | AAPL | Stock | 127.44 | 127.8 | 127.41 | 127.62 | 167835.0 |
| 2021-01-06 04:00:00 | MSFT | Stock | 213.95 | 214.44 | 213.04 | 213.5 | 27832.0 |
| 2021-01-06 04:30:00 | MSFT | Stock | 213.51 | 214.5 | 213.35 | 214.48 | 17449.0 |
| 2021-01-06 05:00:00 | MSFT | Stock | 214.48 | 214.84 | 213.3 | 213.3 | 21499.0 |
| 2021-01-06 05:30:00 | MSFT | Stock | 213.06 | 214.0 | 212.56 | 212.86 | 29535.0 |
| 2021-01-06 06:00:00 | MSFT | Stock | 213.4 | 213.47 | 212.5 | 213.16 | 14975.0 |
| 2021-01-06 06:30:00 | MSFT | Stock | 213.05 | 214.26 | 212.58 | 213.72 | 14255.0 |
| 2021-01-06 07:00:00 | MSFT | Stock | 214.15 | 214.94 | 213.78 | 214.4 | 45494.0 |
| 2021-01-06 07:30:00 | MSFT | Stock | 214.56 | 214.8 | 213.61 | 213.9 | 46035.0 |
| 2021-01-06 08:00:00 | MSFT | Stock | 214.45 | 215.27 | 213.7 | 214.52 | 70054.0 |
| 2021-01-06 08:30:00 | MSFT | Stock | 214.6 | 214.72 | 213.24 | 213.352 | 108099.0 |
| 2021-01-06 09:00:00 | MSFT | Stock | 213.38 | 214.66 | 212.12 | 212.2 | 234022.0 |
| 2021-01-06 09:30:00 | MSFT | Stock | 212.22 | 214.35 | 212.0 | 213.25 | 5238306.0 |
| 2021-01-06 10:00:00 | MSFT | Stock | 213.24 | 215.2 | 212.83 | 214.772 | 2272609.0 |
| 2021-01-06 10:30:00 | MSFT | Stock | 214.77 | 216.15 | 214.74 | 215.13 | 1643614.0 |
| 2021-01-06 11:00:00 | MSFT | Stock | 215.13 | 216.49 | 214.86 | 215.74 | 1329410.0 |
| 2021-01-06 11:30:00 | MSFT | Stock | 215.76 | 215.89 | 215.052 | 215.51 | 903893.0 |
| 2021-01-06 12:00:00 | MSFT | Stock | 215.52 | 216.43 | 215.52 | 216.07 | 1029706.0 |
| 2021-01-06 12:30:00 | MSFT | Stock | 216.05 | 216.17 | 215.56 | 215.748 | 759397.0 |
> showing 50 of 114,880 rows — these rows as CSV