PREVIEW / stock_30min / 2021-11-11
file: by_date/stock_30min/2021/2021-11-11.parquet size: 2.2 MB rows: 111,877 symbols: 2,675
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-11-11 04:00:00 | AAPL | Stock | 148.21 | 148.6 | 148.1 | 148.52 | 23273.0 |
| 2021-11-11 04:30:00 | AAPL | Stock | 148.58 | 148.75 | 148.55 | 148.67 | 12244.0 |
| 2021-11-11 05:00:00 | AAPL | Stock | 148.7 | 148.7 | 148.6 | 148.6 | 5690.0 |
| 2021-11-11 05:30:00 | AAPL | Stock | 148.6 | 148.65 | 148.38 | 148.57 | 12994.0 |
| 2021-11-11 06:00:00 | AAPL | Stock | 148.63 | 148.63 | 148.51 | 148.55 | 3195.0 |
| 2021-11-11 06:30:00 | AAPL | Stock | 148.59 | 148.74 | 148.59 | 148.68 | 3591.0 |
| 2021-11-11 07:00:00 | AAPL | Stock | 148.69 | 148.78 | 148.61 | 148.65 | 22456.0 |
| 2021-11-11 07:30:00 | AAPL | Stock | 148.65 | 148.73 | 148.41 | 148.65 | 58676.0 |
| 2021-11-11 08:00:00 | AAPL | Stock | 148.65 | 148.77 | 147.551 | 148.63 | 117850.0 |
| 2021-11-11 08:30:00 | AAPL | Stock | 148.61 | 148.8 | 148.56 | 148.79 | 99572.0 |
| 2021-11-11 09:00:00 | AAPL | Stock | 148.78 | 149.1 | 148.54 | 148.96 | 295690.0 |
| 2021-11-11 09:30:00 | AAPL | Stock | 148.95 | 149.43 | 148.15 | 148.67 | 5412663.0 |
| 2021-11-11 10:00:00 | AAPL | Stock | 148.68 | 148.68 | 148.17 | 148.43 | 2710422.0 |
| 2021-11-11 10:30:00 | AAPL | Stock | 148.43 | 148.66 | 148.26 | 148.375 | 2420618.0 |
| 2021-11-11 11:00:00 | AAPL | Stock | 148.38 | 148.46 | 148.16 | 148.329 | 1852096.0 |
| 2021-11-11 11:30:00 | AAPL | Stock | 148.3213 | 148.57 | 148.23 | 148.263 | 1846916.0 |
| 2021-11-11 12:00:00 | AAPL | Stock | 148.2689 | 148.31 | 147.87 | 148.02 | 2017275.0 |
| 2021-11-11 12:30:00 | AAPL | Stock | 148.02 | 148.12 | 147.9 | 147.98 | 1370645.0 |
| 2021-11-11 13:00:00 | AAPL | Stock | 147.975 | 147.9752 | 147.681 | 147.79 | 1743259.0 |
| 2021-11-11 13:30:00 | AAPL | Stock | 147.78 | 147.86 | 147.705 | 147.845 | 1197912.0 |
| 2021-11-11 14:00:00 | AAPL | Stock | 147.845 | 148.08 | 147.805 | 147.935 | 1479171.0 |
| 2021-11-11 14:30:00 | AAPL | Stock | 147.9362 | 148.3 | 147.9301 | 148.0601 | 1838132.0 |
| 2021-11-11 15:00:00 | AAPL | Stock | 148.06 | 148.12 | 147.82 | 147.99 | 1781739.0 |
| 2021-11-11 15:30:00 | AAPL | Stock | 147.995 | 148.15 | 147.76 | 147.87 | 3237267.0 |
| 2021-11-11 16:00:00 | AAPL | Stock | 147.87 | 147.95 | 147.8 | 147.83 | 3600053.0 |
| 2021-11-11 16:30:00 | AAPL | Stock | 147.88 | 147.92 | 147.83 | 147.9 | 32043.0 |
| 2021-11-11 17:00:00 | AAPL | Stock | 147.92 | 147.98 | 147.89 | 147.89 | 35390.0 |
| 2021-11-11 17:30:00 | AAPL | Stock | 147.88 | 147.92 | 147.8 | 147.9 | 22365.0 |
| 2021-11-11 18:00:00 | AAPL | Stock | 147.9 | 147.98 | 147.88 | 147.94 | 21368.0 |
| 2021-11-11 18:30:00 | AAPL | Stock | 147.95 | 148.05 | 147.95 | 148.03 | 24133.0 |
| 2021-11-11 19:00:00 | AAPL | Stock | 148.05 | 148.2501 | 148.05 | 148.19 | 34156.0 |
| 2021-11-11 19:30:00 | AAPL | Stock | 148.19 | 148.29 | 148.17 | 148.25 | 37050.0 |
| 2021-11-11 04:00:00 | MSFT | Stock | 331.5 | 332.0 | 331.22 | 332.0 | 2253.0 |
| 2021-11-11 04:30:00 | MSFT | Stock | 332.21 | 332.34 | 332.21 | 332.34 | 425.0 |
| 2021-11-11 05:00:00 | MSFT | Stock | 332.34 | 332.34 | 332.25 | 332.31 | 868.0 |
| 2021-11-11 05:30:00 | MSFT | Stock | 332.21 | 332.22 | 331.8 | 332.17 | 2318.0 |
| 2021-11-11 06:00:00 | MSFT | Stock | 332.17 | 332.17 | 332.02 | 332.04 | 1841.0 |
| 2021-11-11 06:30:00 | MSFT | Stock | 332.12 | 332.24 | 332.12 | 332.24 | 1362.0 |
| 2021-11-11 07:00:00 | MSFT | Stock | 332.16 | 332.88 | 332.16 | 332.5 | 11885.0 |
| 2021-11-11 07:30:00 | MSFT | Stock | 332.5 | 332.55 | 332.25 | 332.46 | 10191.0 |
| 2021-11-11 08:00:00 | MSFT | Stock | 332.35 | 332.94 | 332.2 | 332.5 | 21840.0 |
| 2021-11-11 08:30:00 | MSFT | Stock | 332.5 | 332.7507 | 332.39 | 332.54 | 15593.0 |
| 2021-11-11 09:00:00 | MSFT | Stock | 332.64 | 332.65 | 331.13 | 331.75 | 52196.0 |
| 2021-11-11 09:30:00 | MSFT | Stock | 331.73 | 333.31 | 330.51 | 333.11 | 1301064.0 |
| 2021-11-11 10:00:00 | MSFT | Stock | 333.11 | 333.15 | 332.23 | 332.8502 | 618662.0 |
| 2021-11-11 10:30:00 | MSFT | Stock | 332.83 | 333.4 | 332.5466 | 332.5466 | 598676.0 |
| 2021-11-11 11:00:00 | MSFT | Stock | 332.55 | 333.14 | 332.33 | 333.025 | 452311.0 |
| 2021-11-11 11:30:00 | MSFT | Stock | 333.015 | 333.7746 | 332.9477 | 333.36 | 568319.0 |
| 2021-11-11 12:00:00 | MSFT | Stock | 333.37 | 333.46 | 332.62 | 333.19 | 448526.0 |
| 2021-11-11 12:30:00 | MSFT | Stock | 333.18 | 333.54 | 333.06 | 333.09 | 401996.0 |
> showing 50 of 111,877 rows — these rows as CSV