PREVIEW / stock_30min / 2022-01-06
file: by_date/stock_30min/2022/2022-01-06.parquet size: 2.2 MB rows: 110,465 symbols: 2,607
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-01-06 04:00:00 | AAPL | Stock | 174.78 | 175.08 | 173.76 | 173.99 | 44881.0 |
| 2022-01-06 04:30:00 | AAPL | Stock | 174.0 | 174.02 | 173.77 | 174.0 | 19005.0 |
| 2022-01-06 05:00:00 | AAPL | Stock | 174.11 | 174.64 | 174.06 | 174.47 | 17767.0 |
| 2022-01-06 05:30:00 | AAPL | Stock | 174.47 | 174.6 | 173.88 | 173.89 | 39189.0 |
| 2022-01-06 06:00:00 | AAPL | Stock | 173.99 | 174.25 | 173.36 | 173.51 | 18473.0 |
| 2022-01-06 06:30:00 | AAPL | Stock | 173.5 | 173.72 | 173.16 | 173.55 | 21887.0 |
| 2022-01-06 07:00:00 | AAPL | Stock | 173.6 | 173.84 | 173.03 | 173.15 | 116428.0 |
| 2022-01-06 07:30:00 | AAPL | Stock | 173.15 | 173.37 | 172.87 | 173.13 | 114656.0 |
| 2022-01-06 08:00:00 | AAPL | Stock | 173.5901 | 173.82 | 172.81 | 173.58 | 414019.0 |
| 2022-01-06 08:30:00 | AAPL | Stock | 173.58 | 173.66 | 173.1 | 173.5599 | 293356.0 |
| 2022-01-06 09:00:00 | AAPL | Stock | 173.53 | 174.0 | 172.1 | 172.7 | 558761.0 |
| 2022-01-06 09:30:00 | AAPL | Stock | 172.7 | 175.3 | 172.11 | 173.979 | 12311924.0 |
| 2022-01-06 10:00:00 | AAPL | Stock | 173.95 | 174.27 | 172.17 | 173.52 | 8571009.0 |
| 2022-01-06 10:30:00 | AAPL | Stock | 173.51 | 174.3 | 173.09 | 173.5399 | 5843427.0 |
| 2022-01-06 11:00:00 | AAPL | Stock | 173.55 | 174.24 | 172.9691 | 173.2 | 5125172.0 |
| 2022-01-06 11:30:00 | AAPL | Stock | 173.195 | 173.41 | 172.74 | 172.985 | 3717626.0 |
| 2022-01-06 12:00:00 | AAPL | Stock | 172.98 | 173.28 | 172.58 | 173.0345 | 3525587.0 |
| 2022-01-06 12:30:00 | AAPL | Stock | 173.03 | 173.66 | 172.8 | 172.89 | 3323259.0 |
| 2022-01-06 13:00:00 | AAPL | Stock | 172.8981 | 173.37 | 172.6932 | 172.77 | 2786440.0 |
| 2022-01-06 13:30:00 | AAPL | Stock | 172.77 | 173.42 | 172.72 | 173.38 | 2480130.0 |
| 2022-01-06 14:00:00 | AAPL | Stock | 173.37 | 173.71 | 172.77 | 172.97 | 3336030.0 |
| 2022-01-06 14:30:00 | AAPL | Stock | 172.96 | 173.17 | 172.76 | 172.8985 | 2611194.0 |
| 2022-01-06 15:00:00 | AAPL | Stock | 172.89 | 173.38 | 172.3 | 172.5741 | 4447863.0 |
| 2022-01-06 15:30:00 | AAPL | Stock | 172.57 | 172.705 | 171.64 | 172.01 | 8048938.0 |
| 2022-01-06 16:00:00 | AAPL | Stock | 172.0 | 172.32 | 171.93 | 172.12 | 9739593.0 |
| 2022-01-06 16:30:00 | AAPL | Stock | 172.1 | 172.24 | 172.0 | 172.17 | 57475.0 |
| 2022-01-06 17:00:00 | AAPL | Stock | 172.23 | 172.34 | 172.12 | 172.32 | 17065.0 |
| 2022-01-06 17:30:00 | AAPL | Stock | 172.3 | 172.42 | 172.26 | 172.35 | 18992.0 |
| 2022-01-06 18:00:00 | AAPL | Stock | 172.35 | 172.5 | 172.28 | 172.45 | 33130.0 |
| 2022-01-06 18:30:00 | AAPL | Stock | 172.46 | 172.69 | 172.4 | 172.6 | 47771.0 |
| 2022-01-06 19:00:00 | AAPL | Stock | 172.6 | 172.7 | 172.58 | 172.67 | 21778.0 |
| 2022-01-06 19:30:00 | AAPL | Stock | 172.68 | 172.93 | 172.68 | 172.9 | 33848.0 |
| 2022-01-06 04:00:00 | MSFT | Stock | 316.06 | 317.08 | 315.03 | 316.08 | 5128.0 |
| 2022-01-06 04:30:00 | MSFT | Stock | 315.86 | 315.88 | 315.3 | 315.6 | 2222.0 |
| 2022-01-06 05:00:00 | MSFT | Stock | 315.76 | 316.38 | 315.76 | 316.38 | 1801.0 |
| 2022-01-06 05:30:00 | MSFT | Stock | 316.13 | 316.39 | 315.56 | 315.79 | 4432.0 |
| 2022-01-06 06:00:00 | MSFT | Stock | 315.75 | 315.75 | 315.01 | 315.01 | 8001.0 |
| 2022-01-06 06:30:00 | MSFT | Stock | 315.01 | 315.18 | 314.53 | 315.0 | 1102.0 |
| 2022-01-06 07:00:00 | MSFT | Stock | 315.17 | 316.25 | 314.79 | 315.11 | 29126.0 |
| 2022-01-06 07:30:00 | MSFT | Stock | 315.05 | 315.4 | 314.61 | 314.78 | 12700.0 |
| 2022-01-06 08:00:00 | MSFT | Stock | 314.7601 | 317.17 | 314.55 | 315.2722 | 62293.0 |
| 2022-01-06 08:30:00 | MSFT | Stock | 315.35 | 315.35 | 314.61 | 315.0 | 23391.0 |
| 2022-01-06 09:00:00 | MSFT | Stock | 314.9999 | 316.19 | 312.3 | 313.15 | 194271.0 |
| 2022-01-06 09:30:00 | MSFT | Stock | 313.15 | 317.46 | 311.49 | 314.5501 | 5039358.0 |
| 2022-01-06 10:00:00 | MSFT | Stock | 314.56 | 318.6502 | 312.62 | 317.46 | 3211345.0 |
| 2022-01-06 10:30:00 | MSFT | Stock | 317.41 | 318.7 | 316.15 | 318.05 | 2061232.0 |
| 2022-01-06 11:00:00 | MSFT | Stock | 318.03 | 318.48 | 315.07 | 315.53 | 1711116.0 |
| 2022-01-06 11:30:00 | MSFT | Stock | 315.55 | 316.8 | 314.65 | 316.16 | 1334842.0 |
| 2022-01-06 12:00:00 | MSFT | Stock | 316.16 | 316.71 | 314.88 | 315.95 | 1217129.0 |
| 2022-01-06 12:30:00 | MSFT | Stock | 315.94 | 317.8462 | 315.56 | 315.9702 | 1359068.0 |
> showing 50 of 110,465 rows — these rows as CSV