PREVIEW / stock_30min / 2022-12-29
file: by_date/stock_30min/2022/2022-12-29.parquet size: 2.1 MB rows: 102,635 symbols: 1,950
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 |
|---|---|---|---|---|---|---|---|
| 2022-12-29 04:00:00 | AAPL | Stock | 126.82 | 126.9 | 126.52 | 126.81 | 24134.0 |
| 2022-12-29 04:30:00 | AAPL | Stock | 126.82 | 126.9 | 126.71 | 126.84 | 9025.0 |
| 2022-12-29 05:00:00 | AAPL | Stock | 126.84 | 126.85 | 126.71 | 126.72 | 8400.0 |
| 2022-12-29 05:30:00 | AAPL | Stock | 126.76 | 126.92 | 126.75 | 126.9 | 13257.0 |
| 2022-12-29 06:00:00 | AAPL | Stock | 126.93 | 127.15 | 126.93 | 127.08 | 21131.0 |
| 2022-12-29 06:30:00 | AAPL | Stock | 127.1 | 127.27 | 127.01 | 127.25 | 21448.0 |
| 2022-12-29 07:00:00 | AAPL | Stock | 127.2 | 127.6 | 127.11 | 127.31 | 108990.0 |
| 2022-12-29 07:30:00 | AAPL | Stock | 127.31 | 127.31 | 127.07 | 127.3 | 25279.0 |
| 2022-12-29 08:00:00 | AAPL | Stock | 127.23 | 127.62 | 126.13 | 127.39 | 228248.0 |
| 2022-12-29 08:30:00 | AAPL | Stock | 127.3966 | 128.12 | 127.26 | 128.01 | 409579.0 |
| 2022-12-29 09:00:00 | AAPL | Stock | 127.98 | 128.19 | 127.83 | 128.05 | 235193.0 |
| 2022-12-29 09:30:00 | AAPL | Stock | 127.99 | 129.77 | 127.73 | 128.75 | 12170754.0 |
| 2022-12-29 10:00:00 | AAPL | Stock | 128.745 | 129.58 | 128.19 | 129.39 | 7261258.0 |
| 2022-12-29 10:30:00 | AAPL | Stock | 129.39 | 129.98 | 129.13 | 129.9542 | 5006799.0 |
| 2022-12-29 11:00:00 | AAPL | Stock | 129.96 | 130.06 | 129.44 | 129.85 | 4792143.0 |
| 2022-12-29 11:30:00 | AAPL | Stock | 129.86 | 130.4814 | 129.79 | 130.1005 | 4507348.0 |
| 2022-12-29 12:00:00 | AAPL | Stock | 130.11 | 130.37 | 129.82 | 129.9983 | 3440081.0 |
| 2022-12-29 12:30:00 | AAPL | Stock | 129.9924 | 130.0983 | 129.51 | 129.8401 | 3321815.0 |
| 2022-12-29 13:00:00 | AAPL | Stock | 129.845 | 129.93 | 129.325 | 129.52 | 2924694.0 |
| 2022-12-29 13:30:00 | AAPL | Stock | 129.52 | 130.075 | 129.405 | 130.035 | 2706339.0 |
| 2022-12-29 14:00:00 | AAPL | Stock | 130.03 | 130.24 | 129.98 | 130.0 | 2728545.0 |
| 2022-12-29 14:30:00 | AAPL | Stock | 130.002 | 130.1 | 129.73 | 129.775 | 2521669.0 |
| 2022-12-29 15:00:00 | AAPL | Stock | 129.765 | 130.015 | 129.7 | 129.95 | 3163579.0 |
| 2022-12-29 15:30:00 | AAPL | Stock | 129.95 | 130.22 | 129.56 | 129.6 | 5621266.0 |
| 2022-12-29 16:00:00 | AAPL | Stock | 129.61 | 129.6603 | 129.5 | 129.51 | 6500500.0 |
| 2022-12-29 16:30:00 | AAPL | Stock | 129.5 | 129.61 | 129.45 | 129.52 | 60789.0 |
| 2022-12-29 17:00:00 | AAPL | Stock | 129.5001 | 129.56 | 129.42 | 129.47 | 35272.0 |
| 2022-12-29 17:30:00 | AAPL | Stock | 129.45 | 129.52 | 129.43 | 129.52 | 23163.0 |
| 2022-12-29 18:00:00 | AAPL | Stock | 129.52 | 129.52 | 129.33 | 129.4099 | 20518.0 |
| 2022-12-29 18:30:00 | AAPL | Stock | 129.4099 | 129.41 | 129.31 | 129.39 | 10964.0 |
| 2022-12-29 19:00:00 | AAPL | Stock | 129.35 | 129.36 | 129.26 | 129.28 | 11835.0 |
| 2022-12-29 19:30:00 | AAPL | Stock | 129.25 | 129.28 | 129.21 | 129.25 | 24410.0 |
| 2022-12-29 04:00:00 | MSFT | Stock | 235.8 | 236.33 | 235.38 | 236.28 | 1976.0 |
| 2022-12-29 04:30:00 | MSFT | Stock | 236.19 | 236.21 | 236.18 | 236.19 | 3232.0 |
| 2022-12-29 05:30:00 | MSFT | Stock | 236.05 | 236.09 | 236.05 | 236.07 | 1070.0 |
| 2022-12-29 06:00:00 | MSFT | Stock | 236.1 | 236.18 | 236.0 | 236.0 | 3240.0 |
| 2022-12-29 06:30:00 | MSFT | Stock | 235.4 | 235.94 | 235.4 | 235.94 | 2959.0 |
| 2022-12-29 07:00:00 | MSFT | Stock | 235.57 | 235.7 | 235.21 | 235.4 | 8422.0 |
| 2022-12-29 07:30:00 | MSFT | Stock | 235.4 | 235.72 | 235.12 | 235.65 | 4776.0 |
| 2022-12-29 08:00:00 | MSFT | Stock | 235.65 | 236.0 | 234.56 | 235.74 | 12600.0 |
| 2022-12-29 08:30:00 | MSFT | Stock | 235.54 | 236.69 | 235.5 | 236.48 | 24030.0 |
| 2022-12-29 09:00:00 | MSFT | Stock | 236.4343 | 236.5 | 235.31 | 235.47 | 25217.0 |
| 2022-12-29 09:30:00 | MSFT | Stock | 235.65 | 238.65 | 235.65 | 238.06 | 1714577.0 |
| 2022-12-29 10:00:00 | MSFT | Stock | 238.07 | 238.97 | 237.71 | 238.75 | 1145276.0 |
| 2022-12-29 10:30:00 | MSFT | Stock | 238.7404 | 239.97 | 238.7404 | 239.84 | 1078031.0 |
| 2022-12-29 11:00:00 | MSFT | Stock | 239.86 | 240.0 | 239.21 | 239.71 | 749322.0 |
| 2022-12-29 11:30:00 | MSFT | Stock | 239.72 | 240.9 | 239.71 | 240.76 | 919551.0 |
| 2022-12-29 12:00:00 | MSFT | Stock | 240.78 | 241.06 | 240.4 | 240.9454 | 687480.0 |
| 2022-12-29 12:30:00 | MSFT | Stock | 240.9401 | 241.14 | 240.32 | 240.57 | 623634.0 |
| 2022-12-29 13:00:00 | MSFT | Stock | 240.57 | 240.69 | 240.055 | 240.5369 | 758223.0 |
> showing 50 of 102,635 rows — these rows as CSV