PREVIEW / stock_30min / 2024-02-05
file: by_date/stock_30min/2024/2024-02-05.parquet size: 2.1 MB rows: 99,360 symbols: 1,164
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 |
|---|---|---|---|---|---|---|---|
| 2024-02-05 04:00:00 | AAPL | Stock | 186.0 | 186.5 | 185.75 | 186.06 | 45955.0 |
| 2024-02-05 04:30:00 | AAPL | Stock | 186.09 | 186.1 | 185.24 | 185.42 | 16801.0 |
| 2024-02-05 05:00:00 | AAPL | Stock | 185.44 | 185.65 | 185.36 | 185.63 | 9051.0 |
| 2024-02-05 05:30:00 | AAPL | Stock | 185.63 | 186.38 | 185.63 | 186.29 | 10950.0 |
| 2024-02-05 06:00:00 | AAPL | Stock | 186.2 | 186.59 | 186.0 | 186.3 | 21478.0 |
| 2024-02-05 06:30:00 | AAPL | Stock | 186.3 | 186.3 | 185.79 | 186.3 | 16008.0 |
| 2024-02-05 07:00:00 | AAPL | Stock | 186.19 | 187.4 | 186.09 | 186.96 | 69683.0 |
| 2024-02-05 07:30:00 | AAPL | Stock | 186.78 | 187.4 | 186.75 | 187.38 | 52596.0 |
| 2024-02-05 08:00:00 | AAPL | Stock | 186.15 | 187.55 | 185.25 | 186.91 | 194760.0 |
| 2024-02-05 08:30:00 | AAPL | Stock | 186.85 | 187.1 | 186.55 | 186.84 | 88790.0 |
| 2024-02-05 09:00:00 | AAPL | Stock | 186.86 | 188.4 | 186.73 | 188.13 | 278760.0 |
| 2024-02-05 09:30:00 | AAPL | Stock | 188.13 | 188.28 | 185.84 | 186.58 | 7751660.0 |
| 2024-02-05 10:00:00 | AAPL | Stock | 186.56 | 188.36 | 186.37 | 186.7 | 6395872.0 |
| 2024-02-05 10:30:00 | AAPL | Stock | 186.67 | 187.06 | 186.11 | 186.895 | 3127835.0 |
| 2024-02-05 11:00:00 | AAPL | Stock | 186.89 | 187.76 | 186.78 | 187.25 | 3039719.0 |
| 2024-02-05 11:30:00 | AAPL | Stock | 187.25 | 188.105 | 187.2301 | 187.985 | 2811837.0 |
| 2024-02-05 12:00:00 | AAPL | Stock | 187.98 | 188.49 | 187.89 | 188.43 | 2845068.0 |
| 2024-02-05 12:30:00 | AAPL | Stock | 188.43 | 189.25 | 188.42 | 189.065 | 3737585.0 |
| 2024-02-05 13:00:00 | AAPL | Stock | 189.07 | 189.075 | 188.53 | 188.5401 | 2421901.0 |
| 2024-02-05 13:30:00 | AAPL | Stock | 188.5401 | 189.02 | 188.53 | 188.72 | 1803017.0 |
| 2024-02-05 14:00:00 | AAPL | Stock | 188.715 | 188.9 | 188.385 | 188.465 | 1909178.0 |
| 2024-02-05 14:30:00 | AAPL | Stock | 188.487 | 188.84 | 188.37 | 188.5182 | 2317671.0 |
| 2024-02-05 15:00:00 | AAPL | Stock | 188.52 | 188.63 | 188.03 | 188.35 | 2739031.0 |
| 2024-02-05 15:30:00 | AAPL | Stock | 188.34 | 188.42 | 187.64 | 187.66 | 4137847.0 |
| 2024-02-05 16:00:00 | AAPL | Stock | 187.66 | 188.032 | 187.45 | 187.68 | 6320186.0 |
| 2024-02-05 16:30:00 | AAPL | Stock | 187.81 | 188.06 | 187.49 | 187.71 | 39435.0 |
| 2024-02-05 17:00:00 | AAPL | Stock | 187.71 | 187.7798 | 187.67 | 187.71 | 72501.0 |
| 2024-02-05 17:30:00 | AAPL | Stock | 187.68 | 187.71 | 187.61 | 187.65 | 8387.0 |
| 2024-02-05 18:00:00 | AAPL | Stock | 187.71 | 187.75 | 187.68 | 187.75 | 12972.0 |
| 2024-02-05 18:30:00 | AAPL | Stock | 187.75 | 187.85 | 187.62 | 187.62 | 21189.0 |
| 2024-02-05 19:00:00 | AAPL | Stock | 187.62 | 187.68 | 187.61 | 187.68 | 6926.0 |
| 2024-02-05 19:30:00 | AAPL | Stock | 187.75 | 187.93 | 187.65 | 187.8 | 33909.0 |
| 2024-02-05 04:00:00 | MSFT | Stock | 411.0 | 411.68 | 411.0 | 411.5 | 2387.0 |
| 2024-02-05 04:30:00 | MSFT | Stock | 411.68 | 412.2 | 411.5 | 411.71 | 1860.0 |
| 2024-02-05 05:00:00 | MSFT | Stock | 411.67 | 411.76 | 411.6 | 411.6 | 1425.0 |
| 2024-02-05 05:30:00 | MSFT | Stock | 411.92 | 411.92 | 411.69 | 411.7 | 2016.0 |
| 2024-02-05 06:00:00 | MSFT | Stock | 411.79 | 411.86 | 411.71 | 411.85 | 1268.0 |
| 2024-02-05 06:30:00 | MSFT | Stock | 411.87 | 412.0 | 411.86 | 412.0 | 758.0 |
| 2024-02-05 07:00:00 | MSFT | Stock | 411.92 | 412.25 | 411.55 | 411.6 | 16472.0 |
| 2024-02-05 07:30:00 | MSFT | Stock | 411.61 | 412.05 | 411.6 | 411.9 | 6792.0 |
| 2024-02-05 08:00:00 | MSFT | Stock | 411.9793 | 412.3 | 410.66 | 411.41 | 45454.0 |
| 2024-02-05 08:30:00 | MSFT | Stock | 411.45 | 411.59 | 410.85 | 411.1 | 22928.0 |
| 2024-02-05 09:00:00 | MSFT | Stock | 411.1 | 411.44 | 409.03 | 409.65 | 52482.0 |
| 2024-02-05 09:30:00 | MSFT | Stock | 409.49 | 411.16 | 407.32 | 408.325 | 2532671.0 |
| 2024-02-05 10:00:00 | MSFT | Stock | 408.325 | 408.49 | 405.13 | 406.6171 | 1479450.0 |
| 2024-02-05 10:30:00 | MSFT | Stock | 406.62 | 406.98 | 404.26 | 404.5878 | 1033933.0 |
| 2024-02-05 11:00:00 | MSFT | Stock | 404.585 | 405.37 | 403.99 | 404.09 | 910800.0 |
| 2024-02-05 11:30:00 | MSFT | Stock | 404.1 | 406.49 | 404.0909 | 406.28 | 884628.0 |
| 2024-02-05 12:00:00 | MSFT | Stock | 406.32 | 406.48 | 405.57 | 406.27 | 523299.0 |
| 2024-02-05 12:30:00 | MSFT | Stock | 406.29 | 406.8 | 405.685 | 405.82 | 644292.0 |
> showing 50 of 99,360 rows — these rows as CSV