PREVIEW / stock_30min / 2023-10-05
file: by_date/stock_30min/2023/2023-10-05.parquet size: 2.0 MB rows: 95,869 symbols: 1,396
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 |
|---|---|---|---|---|---|---|---|
| 2023-10-05 04:00:00 | AAPL | Stock | 173.23 | 173.34 | 173.2 | 173.34 | 2371.0 |
| 2023-10-05 04:30:00 | AAPL | Stock | 173.39 | 173.4 | 172.92 | 172.92 | 2659.0 |
| 2023-10-05 05:00:00 | AAPL | Stock | 172.9 | 173.09 | 172.8 | 173.0 | 26924.0 |
| 2023-10-05 05:30:00 | AAPL | Stock | 172.9 | 173.05 | 172.9 | 173.05 | 795.0 |
| 2023-10-05 06:00:00 | AAPL | Stock | 173.08 | 173.35 | 173.08 | 173.3 | 2893.0 |
| 2023-10-05 06:30:00 | AAPL | Stock | 173.3 | 173.51 | 173.3 | 173.48 | 3039.0 |
| 2023-10-05 07:00:00 | AAPL | Stock | 173.41 | 173.68 | 173.34 | 173.5 | 16927.0 |
| 2023-10-05 07:30:00 | AAPL | Stock | 173.52 | 173.85 | 173.52 | 173.77 | 13942.0 |
| 2023-10-05 08:00:00 | AAPL | Stock | 173.69 | 174.1106 | 172.805 | 173.6 | 74738.0 |
| 2023-10-05 08:30:00 | AAPL | Stock | 173.66 | 173.67 | 172.8 | 173.3 | 74616.0 |
| 2023-10-05 09:00:00 | AAPL | Stock | 173.27 | 173.8 | 173.0 | 173.77 | 74971.0 |
| 2023-10-05 09:30:00 | AAPL | Stock | 173.74 | 174.408 | 173.45 | 173.8723 | 4611966.0 |
| 2023-10-05 10:00:00 | AAPL | Stock | 173.87 | 173.875 | 173.07 | 173.69 | 3284869.0 |
| 2023-10-05 10:30:00 | AAPL | Stock | 173.69 | 173.7562 | 172.68 | 173.0 | 2850116.0 |
| 2023-10-05 11:00:00 | AAPL | Stock | 173.0 | 173.65 | 172.83 | 173.6 | 2737778.0 |
| 2023-10-05 11:30:00 | AAPL | Stock | 173.605 | 173.83 | 173.265 | 173.4801 | 2384625.0 |
| 2023-10-05 12:00:00 | AAPL | Stock | 173.485 | 174.03 | 173.36 | 173.97 | 2015058.0 |
| 2023-10-05 12:30:00 | AAPL | Stock | 173.9601 | 174.03 | 173.62 | 173.947 | 1406190.0 |
| 2023-10-05 13:00:00 | AAPL | Stock | 173.9446 | 174.16 | 173.645 | 174.1582 | 1698977.0 |
| 2023-10-05 13:30:00 | AAPL | Stock | 174.15 | 175.03 | 173.96 | 174.89 | 3340403.0 |
| 2023-10-05 14:00:00 | AAPL | Stock | 174.88 | 175.2 | 174.75 | 174.9599 | 2231822.0 |
| 2023-10-05 14:30:00 | AAPL | Stock | 174.95 | 175.45 | 174.905 | 175.33 | 2341384.0 |
| 2023-10-05 15:00:00 | AAPL | Stock | 175.335 | 175.39 | 174.87 | 175.12 | 1829317.0 |
| 2023-10-05 15:30:00 | AAPL | Stock | 175.12 | 175.22 | 174.84 | 174.97 | 4184918.0 |
| 2023-10-05 16:00:00 | AAPL | Stock | 174.97 | 174.98 | 174.74 | 174.7877 | 5926612.0 |
| 2023-10-05 16:30:00 | AAPL | Stock | 174.77 | 174.91 | 174.72 | 174.8398 | 67629.0 |
| 2023-10-05 17:00:00 | AAPL | Stock | 174.91 | 174.91 | 174.76 | 174.78 | 30828.0 |
| 2023-10-05 17:30:00 | AAPL | Stock | 174.77 | 174.88 | 174.76 | 174.7697 | 3711.0 |
| 2023-10-05 18:00:00 | AAPL | Stock | 174.77 | 174.84 | 174.77 | 174.84 | 4309.0 |
| 2023-10-05 18:30:00 | AAPL | Stock | 174.82 | 174.83 | 174.76 | 174.77 | 5304.0 |
| 2023-10-05 19:00:00 | AAPL | Stock | 174.78 | 174.81 | 174.76 | 174.76 | 3799.0 |
| 2023-10-05 19:30:00 | AAPL | Stock | 174.67 | 174.79 | 174.67 | 174.75 | 14770.0 |
| 2023-10-05 04:00:00 | MSFT | Stock | 318.96 | 319.0 | 318.96 | 319.0 | 320.0 |
| 2023-10-05 04:30:00 | MSFT | Stock | 319.0 | 319.03 | 318.9 | 319.03 | 492.0 |
| 2023-10-05 05:00:00 | MSFT | Stock | 318.11 | 318.13 | 318.11 | 318.13 | 614.0 |
| 2023-10-05 05:30:00 | MSFT | Stock | 318.04 | 318.04 | 318.0 | 318.0 | 300.0 |
| 2023-10-05 06:00:00 | MSFT | Stock | 318.45 | 318.87 | 318.45 | 318.87 | 320.0 |
| 2023-10-05 06:30:00 | MSFT | Stock | 319.02 | 319.1 | 318.85 | 318.85 | 320.0 |
| 2023-10-05 07:00:00 | MSFT | Stock | 319.01 | 319.5 | 319.01 | 319.4 | 2131.0 |
| 2023-10-05 07:30:00 | MSFT | Stock | 319.69 | 320.21 | 319.69 | 320.18 | 6819.0 |
| 2023-10-05 08:00:00 | MSFT | Stock | 319.53 | 320.4 | 319.13 | 319.2 | 15485.0 |
| 2023-10-05 08:30:00 | MSFT | Stock | 319.2 | 319.2 | 317.77 | 318.35 | 29196.0 |
| 2023-10-05 09:00:00 | MSFT | Stock | 318.4704 | 319.49 | 318.0 | 319.26 | 19033.0 |
| 2023-10-05 09:30:00 | MSFT | Stock | 319.24 | 319.98 | 316.62 | 317.44 | 1464823.0 |
| 2023-10-05 10:00:00 | MSFT | Stock | 317.47 | 317.58 | 316.131 | 316.78 | 880068.0 |
| 2023-10-05 10:30:00 | MSFT | Stock | 316.74 | 316.87 | 314.9 | 315.37 | 703379.0 |
| 2023-10-05 11:00:00 | MSFT | Stock | 315.33 | 316.415 | 315.01 | 316.19 | 673671.0 |
| 2023-10-05 11:30:00 | MSFT | Stock | 316.2 | 317.34 | 315.83 | 316.505 | 644507.0 |
| 2023-10-05 12:00:00 | MSFT | Stock | 316.5767 | 317.45 | 316.44 | 317.15 | 631015.0 |
| 2023-10-05 12:30:00 | MSFT | Stock | 317.1787 | 317.3871 | 316.45 | 316.767 | 373818.0 |
> showing 50 of 95,869 rows — these rows as CSV