PREVIEW / stock_30min / 2022-12-02
file: by_date/stock_30min/2022/2022-12-02.parquet size: 2.1 MB rows: 102,067 symbols: 2,066
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-12-02 04:00:00 | AAPL | Stock | 148.49 | 148.49 | 147.95 | 148.2 | 6374.0 |
| 2022-12-02 04:30:00 | AAPL | Stock | 148.23 | 148.38 | 148.2 | 148.37 | 7521.0 |
| 2022-12-02 05:00:00 | AAPL | Stock | 148.32 | 148.37 | 148.3 | 148.31 | 4760.0 |
| 2022-12-02 05:30:00 | AAPL | Stock | 148.36 | 148.36 | 148.36 | 148.36 | 100.0 |
| 2022-12-02 06:00:00 | AAPL | Stock | 148.28 | 148.28 | 148.15 | 148.21 | 5264.0 |
| 2022-12-02 06:30:00 | AAPL | Stock | 148.25 | 148.25 | 148.25 | 148.25 | 276.0 |
| 2022-12-02 07:00:00 | AAPL | Stock | 148.25 | 148.25 | 148.03 | 148.15 | 12627.0 |
| 2022-12-02 07:30:00 | AAPL | Stock | 148.2 | 148.24 | 148.1 | 148.24 | 14940.0 |
| 2022-12-02 08:00:00 | AAPL | Stock | 148.1691 | 148.57 | 147.38 | 148.3 | 82616.0 |
| 2022-12-02 08:30:00 | AAPL | Stock | 148.15 | 148.15 | 145.02 | 145.8 | 744510.0 |
| 2022-12-02 09:00:00 | AAPL | Stock | 145.74 | 146.28 | 145.52 | 146.0 | 169907.0 |
| 2022-12-02 09:30:00 | AAPL | Stock | 146.01 | 146.9 | 145.76 | 146.26 | 6878066.0 |
| 2022-12-02 10:00:00 | AAPL | Stock | 146.255 | 146.9 | 145.65 | 146.23 | 4521652.0 |
| 2022-12-02 10:30:00 | AAPL | Stock | 146.2299 | 146.66 | 146.0506 | 146.21 | 3830853.0 |
| 2022-12-02 11:00:00 | AAPL | Stock | 146.21 | 146.5001 | 145.88 | 146.46 | 2838850.0 |
| 2022-12-02 11:30:00 | AAPL | Stock | 146.465 | 146.98 | 146.38 | 146.6371 | 2984715.0 |
| 2022-12-02 12:00:00 | AAPL | Stock | 146.64 | 146.95 | 146.42 | 146.4499 | 2268252.0 |
| 2022-12-02 12:30:00 | AAPL | Stock | 146.4462 | 146.55 | 146.105 | 146.24 | 1542626.0 |
| 2022-12-02 13:00:00 | AAPL | Stock | 146.235 | 146.42 | 146.05 | 146.41 | 1727932.0 |
| 2022-12-02 13:30:00 | AAPL | Stock | 146.4125 | 146.6 | 146.3 | 146.4699 | 1603415.0 |
| 2022-12-02 14:00:00 | AAPL | Stock | 146.4699 | 146.52 | 146.09 | 146.285 | 1597530.0 |
| 2022-12-02 14:30:00 | AAPL | Stock | 146.2884 | 146.96 | 146.15 | 146.92 | 2503816.0 |
| 2022-12-02 15:00:00 | AAPL | Stock | 146.92 | 148.0 | 146.84 | 147.4408 | 5617939.0 |
| 2022-12-02 15:30:00 | AAPL | Stock | 147.445 | 147.94 | 146.9749 | 147.8 | 6451955.0 |
| 2022-12-02 16:00:00 | AAPL | Stock | 147.8 | 147.87 | 147.63 | 147.63 | 11866143.0 |
| 2022-12-02 16:30:00 | AAPL | Stock | 147.63 | 147.81 | 147.44 | 147.4407 | 47238.0 |
| 2022-12-02 17:00:00 | AAPL | Stock | 147.5 | 147.65 | 147.5 | 147.5968 | 12683.0 |
| 2022-12-02 17:30:00 | AAPL | Stock | 147.6 | 147.6 | 147.51 | 147.57 | 13415.0 |
| 2022-12-02 18:00:00 | AAPL | Stock | 147.6 | 147.6 | 147.56 | 147.57 | 1810.0 |
| 2022-12-02 18:30:00 | AAPL | Stock | 147.54 | 147.54 | 147.5 | 147.53 | 3507.0 |
| 2022-12-02 19:00:00 | AAPL | Stock | 147.53 | 147.53 | 147.41 | 147.41 | 2865.0 |
| 2022-12-02 19:30:00 | AAPL | Stock | 147.45 | 147.51 | 147.42 | 147.5 | 10176.0 |
| 2022-12-02 04:00:00 | MSFT | Stock | 254.24 | 254.24 | 254.24 | 254.24 | 100.0 |
| 2022-12-02 04:30:00 | MSFT | Stock | 254.46 | 254.7 | 254.46 | 254.7 | 615.0 |
| 2022-12-02 05:00:00 | MSFT | Stock | 254.55 | 254.55 | 254.55 | 254.55 | 152.0 |
| 2022-12-02 05:30:00 | MSFT | Stock | 254.45 | 254.45 | 254.45 | 254.45 | 100.0 |
| 2022-12-02 07:00:00 | MSFT | Stock | 254.19 | 254.19 | 253.71 | 254.01 | 4215.0 |
| 2022-12-02 07:30:00 | MSFT | Stock | 254.1 | 254.25 | 254.05 | 254.05 | 915.0 |
| 2022-12-02 08:00:00 | MSFT | Stock | 253.8849 | 254.337 | 253.5 | 253.5 | 10898.0 |
| 2022-12-02 08:30:00 | MSFT | Stock | 253.57 | 253.57 | 248.1 | 249.79 | 126541.0 |
| 2022-12-02 09:00:00 | MSFT | Stock | 249.71 | 250.25 | 248.92 | 249.81 | 37417.0 |
| 2022-12-02 09:30:00 | MSFT | Stock | 249.82 | 251.5 | 249.69 | 250.74 | 2117558.0 |
| 2022-12-02 10:00:00 | MSFT | Stock | 250.67 | 252.3099 | 250.12 | 251.72 | 1284401.0 |
| 2022-12-02 10:30:00 | MSFT | Stock | 251.71 | 252.8 | 251.24 | 251.605 | 866422.0 |
| 2022-12-02 11:00:00 | MSFT | Stock | 251.62 | 252.25 | 250.87 | 252.24 | 776481.0 |
| 2022-12-02 11:30:00 | MSFT | Stock | 252.25 | 253.8 | 251.96 | 252.82 | 927690.0 |
| 2022-12-02 12:00:00 | MSFT | Stock | 252.81 | 253.98 | 252.42 | 253.305 | 852274.0 |
| 2022-12-02 12:30:00 | MSFT | Stock | 253.305 | 253.42 | 252.53 | 253.02 | 610609.0 |
| 2022-12-02 13:00:00 | MSFT | Stock | 253.01 | 253.3 | 252.28 | 253.29 | 582203.0 |
| 2022-12-02 13:30:00 | MSFT | Stock | 253.3 | 253.8 | 252.9601 | 253.4518 | 520475.0 |
> showing 50 of 102,067 rows — these rows as CSV