PREVIEW / stock_30min / 2022-02-02
file: by_date/stock_30min/2022/2022-02-02.parquet size: 2.2 MB rows: 110,141 symbols: 2,561
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-02-02 04:00:00 | AAPL | Stock | 174.19 | 174.95 | 174.11 | 174.62 | 22120.0 |
| 2022-02-02 04:30:00 | AAPL | Stock | 174.71 | 175.32 | 174.67 | 175.32 | 19874.0 |
| 2022-02-02 05:00:00 | AAPL | Stock | 175.31 | 175.31 | 174.8 | 174.83 | 9219.0 |
| 2022-02-02 05:30:00 | AAPL | Stock | 174.84 | 174.9 | 174.61 | 174.71 | 3897.0 |
| 2022-02-02 06:00:00 | AAPL | Stock | 174.66 | 174.66 | 174.41 | 174.59 | 8258.0 |
| 2022-02-02 06:30:00 | AAPL | Stock | 174.61 | 175.1 | 174.61 | 174.94 | 14550.0 |
| 2022-02-02 07:00:00 | AAPL | Stock | 174.96 | 175.23 | 174.8 | 175.11 | 67936.0 |
| 2022-02-02 07:30:00 | AAPL | Stock | 175.11 | 175.19 | 174.75 | 175.11 | 105026.0 |
| 2022-02-02 08:00:00 | AAPL | Stock | 174.9033 | 175.24 | 174.61 | 174.77 | 1715633.0 |
| 2022-02-02 08:30:00 | AAPL | Stock | 174.85 | 174.92 | 174.53 | 174.67 | 158046.0 |
| 2022-02-02 09:00:00 | AAPL | Stock | 174.61 | 175.0 | 174.41 | 174.74 | 192341.0 |
| 2022-02-02 09:30:00 | AAPL | Stock | 174.75 | 175.47 | 173.94 | 174.7 | 8756099.0 |
| 2022-02-02 10:00:00 | AAPL | Stock | 174.71 | 175.56 | 174.53 | 175.03 | 5809154.0 |
| 2022-02-02 10:30:00 | AAPL | Stock | 175.04 | 175.22 | 174.33 | 174.69 | 4452404.0 |
| 2022-02-02 11:00:00 | AAPL | Stock | 174.69 | 174.88 | 173.73 | 173.9321 | 4229529.0 |
| 2022-02-02 11:30:00 | AAPL | Stock | 173.945 | 174.38 | 173.33 | 174.365 | 3298280.0 |
| 2022-02-02 12:00:00 | AAPL | Stock | 174.3638 | 174.84 | 174.06 | 174.4855 | 2583217.0 |
| 2022-02-02 12:30:00 | AAPL | Stock | 174.485 | 175.05 | 174.25 | 175.0202 | 2565312.0 |
| 2022-02-02 13:00:00 | AAPL | Stock | 175.02 | 175.05 | 174.3 | 174.4799 | 2467710.0 |
| 2022-02-02 13:30:00 | AAPL | Stock | 174.4799 | 174.91 | 174.38 | 174.77 | 2009837.0 |
| 2022-02-02 14:00:00 | AAPL | Stock | 174.7791 | 175.05 | 174.29 | 174.93 | 3006198.0 |
| 2022-02-02 14:30:00 | AAPL | Stock | 174.9209 | 175.37 | 174.87 | 175.0626 | 3345320.0 |
| 2022-02-02 15:00:00 | AAPL | Stock | 175.06 | 175.69 | 174.86 | 175.22 | 3786101.0 |
| 2022-02-02 15:30:00 | AAPL | Stock | 175.22 | 175.88 | 174.985 | 175.83 | 7664883.0 |
| 2022-02-02 16:00:00 | AAPL | Stock | 175.83 | 175.84 | 174.0 | 174.65 | 8885835.0 |
| 2022-02-02 16:30:00 | AAPL | Stock | 174.66 | 175.84 | 174.56 | 174.81 | 142498.0 |
| 2022-02-02 17:00:00 | AAPL | Stock | 174.76 | 174.76 | 174.1 | 174.174 | 2774481.0 |
| 2022-02-02 17:30:00 | AAPL | Stock | 174.2 | 174.5 | 174.14 | 174.35 | 75200.0 |
| 2022-02-02 18:00:00 | AAPL | Stock | 174.48 | 174.81 | 174.32 | 174.32 | 75840.0 |
| 2022-02-02 18:30:00 | AAPL | Stock | 174.32 | 174.34 | 173.45 | 173.54 | 90215.0 |
| 2022-02-02 19:00:00 | AAPL | Stock | 173.51 | 174.2 | 173.5 | 174.0 | 41785.0 |
| 2022-02-02 19:30:00 | AAPL | Stock | 174.02 | 174.25 | 173.75 | 173.75 | 48927.0 |
| 2022-02-02 04:00:00 | MSFT | Stock | 309.14 | 309.9 | 308.26 | 309.65 | 9320.0 |
| 2022-02-02 04:30:00 | MSFT | Stock | 309.69 | 310.7 | 309.6 | 310.64 | 12612.0 |
| 2022-02-02 05:00:00 | MSFT | Stock | 310.44 | 310.45 | 309.91 | 310.06 | 2482.0 |
| 2022-02-02 05:30:00 | MSFT | Stock | 310.18 | 310.44 | 309.8 | 309.8 | 3063.0 |
| 2022-02-02 06:00:00 | MSFT | Stock | 310.0 | 310.0 | 309.44 | 309.89 | 3282.0 |
| 2022-02-02 06:30:00 | MSFT | Stock | 309.95 | 310.5 | 309.81 | 310.47 | 3481.0 |
| 2022-02-02 07:00:00 | MSFT | Stock | 310.5 | 310.6 | 309.85 | 310.6 | 30813.0 |
| 2022-02-02 07:30:00 | MSFT | Stock | 310.5 | 310.93 | 310.23 | 310.89 | 43999.0 |
| 2022-02-02 08:00:00 | MSFT | Stock | 310.5999 | 310.9 | 308.76 | 309.9 | 754760.0 |
| 2022-02-02 08:30:00 | MSFT | Stock | 309.9 | 310.4 | 309.6 | 309.6 | 29590.0 |
| 2022-02-02 09:00:00 | MSFT | Stock | 309.5 | 310.43 | 308.76 | 309.37 | 40790.0 |
| 2022-02-02 09:30:00 | MSFT | Stock | 309.53 | 313.8414 | 308.88 | 313.65 | 3858332.0 |
| 2022-02-02 10:00:00 | MSFT | Stock | 313.74 | 315.12 | 311.79 | 312.36 | 2883139.0 |
| 2022-02-02 10:30:00 | MSFT | Stock | 312.39 | 313.48 | 311.68 | 312.35 | 1536387.0 |
| 2022-02-02 11:00:00 | MSFT | Stock | 312.37 | 312.6599 | 309.75 | 310.48 | 1404388.0 |
| 2022-02-02 11:30:00 | MSFT | Stock | 310.45 | 311.15 | 309.55 | 311.11 | 1147052.0 |
| 2022-02-02 12:00:00 | MSFT | Stock | 311.11 | 312.02 | 310.65 | 310.92 | 1062039.0 |
| 2022-02-02 12:30:00 | MSFT | Stock | 310.94 | 312.71 | 310.53 | 312.645 | 881396.0 |
> showing 50 of 110,141 rows — these rows as CSV