PREVIEW / stock_30min / 2022-02-03
file: by_date/stock_30min/2022/2022-02-03.parquet size: 2.1 MB rows: 107,352 symbols: 2,520
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-03 04:00:00 | AAPL | Stock | 173.9 | 175.0 | 173.85 | 174.5 | 38725.0 |
| 2022-02-03 04:30:00 | AAPL | Stock | 174.6 | 174.6 | 173.68 | 173.68 | 10662.0 |
| 2022-02-03 05:00:00 | AAPL | Stock | 173.8 | 173.91 | 173.76 | 173.89 | 6424.0 |
| 2022-02-03 05:30:00 | AAPL | Stock | 173.95 | 173.95 | 173.64 | 173.66 | 4361.0 |
| 2022-02-03 06:00:00 | AAPL | Stock | 173.78 | 174.0 | 173.46 | 173.96 | 23370.0 |
| 2022-02-03 06:30:00 | AAPL | Stock | 173.87 | 174.4 | 173.81 | 174.32 | 18470.0 |
| 2022-02-03 07:00:00 | AAPL | Stock | 174.23 | 174.26 | 173.56 | 174.0 | 145198.0 |
| 2022-02-03 07:30:00 | AAPL | Stock | 174.02 | 174.58 | 173.94 | 174.21 | 97448.0 |
| 2022-02-03 08:00:00 | AAPL | Stock | 173.9789 | 174.5398 | 173.69 | 174.1 | 341420.0 |
| 2022-02-03 08:30:00 | AAPL | Stock | 174.2 | 174.5 | 173.5 | 173.68 | 278804.0 |
| 2022-02-03 09:00:00 | AAPL | Stock | 173.67 | 174.54 | 173.23 | 174.54 | 245397.0 |
| 2022-02-03 09:30:00 | AAPL | Stock | 174.48 | 175.29 | 173.85 | 174.7506 | 7769136.0 |
| 2022-02-03 10:00:00 | AAPL | Stock | 174.76 | 175.84 | 174.39 | 175.83 | 6557568.0 |
| 2022-02-03 10:30:00 | AAPL | Stock | 175.835 | 176.2399 | 175.04 | 175.26 | 4783067.0 |
| 2022-02-03 11:00:00 | AAPL | Stock | 175.265 | 176.03 | 174.82 | 175.05 | 3981745.0 |
| 2022-02-03 11:30:00 | AAPL | Stock | 175.04 | 175.08 | 174.55 | 174.58 | 3094897.0 |
| 2022-02-03 12:00:00 | AAPL | Stock | 174.57 | 175.3101 | 174.28 | 175.1301 | 3673088.0 |
| 2022-02-03 12:30:00 | AAPL | Stock | 175.13 | 175.465 | 174.86 | 175.29 | 2408175.0 |
| 2022-02-03 13:00:00 | AAPL | Stock | 175.29 | 175.7415 | 174.88 | 175.66 | 2366810.0 |
| 2022-02-03 13:30:00 | AAPL | Stock | 175.66 | 176.03 | 175.32 | 175.515 | 2969553.0 |
| 2022-02-03 14:00:00 | AAPL | Stock | 175.51 | 175.81 | 174.83 | 174.955 | 2969528.0 |
| 2022-02-03 14:30:00 | AAPL | Stock | 174.952 | 175.24 | 174.31 | 174.47 | 3280754.0 |
| 2022-02-03 15:00:00 | AAPL | Stock | 174.4715 | 174.94 | 174.1723 | 174.61 | 4032069.0 |
| 2022-02-03 15:30:00 | AAPL | Stock | 174.6 | 174.629 | 172.12 | 173.0 | 11300017.0 |
| 2022-02-03 16:00:00 | AAPL | Stock | 173.0 | 174.41 | 172.79 | 173.75 | 14329752.0 |
| 2022-02-03 16:30:00 | AAPL | Stock | 173.88 | 174.35 | 172.9 | 174.11 | 151494.0 |
| 2022-02-03 17:00:00 | AAPL | Stock | 174.07 | 174.39 | 172.9 | 174.0 | 2029883.0 |
| 2022-02-03 17:30:00 | AAPL | Stock | 173.98 | 174.13 | 173.81 | 174.0 | 53892.0 |
| 2022-02-03 18:00:00 | AAPL | Stock | 173.95 | 174.35 | 173.9 | 174.28 | 40591.0 |
| 2022-02-03 18:30:00 | AAPL | Stock | 174.28 | 174.3 | 174.13 | 174.2 | 31423.0 |
| 2022-02-03 19:00:00 | AAPL | Stock | 174.25 | 174.3 | 174.02 | 174.14 | 33101.0 |
| 2022-02-03 19:30:00 | AAPL | Stock | 174.15 | 174.17 | 173.9901 | 174.17 | 66443.0 |
| 2022-02-03 04:00:00 | MSFT | Stock | 311.58 | 311.98 | 310.27 | 310.27 | 6296.0 |
| 2022-02-03 04:30:00 | MSFT | Stock | 310.4 | 310.4 | 309.37 | 309.37 | 2370.0 |
| 2022-02-03 05:00:00 | MSFT | Stock | 309.36 | 309.99 | 309.22 | 309.75 | 5551.0 |
| 2022-02-03 05:30:00 | MSFT | Stock | 309.78 | 310.0 | 309.42 | 309.71 | 2699.0 |
| 2022-02-03 06:00:00 | MSFT | Stock | 309.71 | 310.0 | 309.03 | 309.4 | 9912.0 |
| 2022-02-03 06:30:00 | MSFT | Stock | 309.52 | 310.45 | 309.5 | 310.45 | 2651.0 |
| 2022-02-03 07:00:00 | MSFT | Stock | 310.25 | 310.5 | 309.6 | 310.1 | 27552.0 |
| 2022-02-03 07:30:00 | MSFT | Stock | 310.05 | 310.98 | 310.0 | 310.55 | 15943.0 |
| 2022-02-03 08:00:00 | MSFT | Stock | 310.206 | 310.8874 | 309.6 | 310.16 | 15092.0 |
| 2022-02-03 08:30:00 | MSFT | Stock | 310.75 | 310.98 | 309.01 | 309.0337 | 29717.0 |
| 2022-02-03 09:00:00 | MSFT | Stock | 309.15 | 309.68 | 308.46 | 309.48 | 50301.0 |
| 2022-02-03 09:30:00 | MSFT | Stock | 309.48 | 310.74 | 307.55 | 308.905 | 4208992.0 |
| 2022-02-03 10:00:00 | MSFT | Stock | 308.89 | 311.23 | 308.7 | 310.8618 | 1704465.0 |
| 2022-02-03 10:30:00 | MSFT | Stock | 310.8743 | 311.18 | 308.43 | 309.26 | 1308544.0 |
| 2022-02-03 11:00:00 | MSFT | Stock | 309.24 | 309.52 | 307.71 | 308.18 | 1244436.0 |
| 2022-02-03 11:30:00 | MSFT | Stock | 308.17 | 308.875 | 307.51 | 307.71 | 1047549.0 |
| 2022-02-03 12:00:00 | MSFT | Stock | 307.73 | 307.98 | 305.92 | 307.16 | 1698080.0 |
| 2022-02-03 12:30:00 | MSFT | Stock | 307.1705 | 307.8 | 306.08 | 306.51 | 1040232.0 |
> showing 50 of 107,352 rows — these rows as CSV