PREVIEW / stock_30min / 2023-03-02
file: by_date/stock_30min/2023/2023-03-02.parquet size: 2.1 MB rows: 101,322 symbols: 1,822
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-03-02 04:00:00 | AAPL | Stock | 144.96 | 144.96 | 144.01 | 144.01 | 23284.0 |
| 2023-03-02 04:30:00 | AAPL | Stock | 144.22 | 144.22 | 143.88 | 143.88 | 11672.0 |
| 2023-03-02 05:00:00 | AAPL | Stock | 143.85 | 143.97 | 143.6 | 143.94 | 13420.0 |
| 2023-03-02 05:30:00 | AAPL | Stock | 143.97 | 144.02 | 143.85 | 144.02 | 14070.0 |
| 2023-03-02 06:00:00 | AAPL | Stock | 144.1 | 144.37 | 144.06 | 144.2 | 8896.0 |
| 2023-03-02 06:30:00 | AAPL | Stock | 144.21 | 144.39 | 144.16 | 144.39 | 5733.0 |
| 2023-03-02 07:00:00 | AAPL | Stock | 144.4 | 144.82 | 144.38 | 144.42 | 21647.0 |
| 2023-03-02 07:30:00 | AAPL | Stock | 144.42 | 144.44 | 144.11 | 144.22 | 29582.0 |
| 2023-03-02 08:00:00 | AAPL | Stock | 144.39 | 144.947 | 144.0 | 144.0001 | 110503.0 |
| 2023-03-02 08:30:00 | AAPL | Stock | 144.0599 | 144.0599 | 143.54 | 143.69 | 144290.0 |
| 2023-03-02 09:00:00 | AAPL | Stock | 143.68 | 144.43 | 143.68 | 144.39 | 174922.0 |
| 2023-03-02 09:30:00 | AAPL | Stock | 144.4 | 144.79 | 144.03 | 144.34 | 5570258.0 |
| 2023-03-02 10:00:00 | AAPL | Stock | 144.355 | 144.705 | 143.9 | 144.55 | 3710706.0 |
| 2023-03-02 10:30:00 | AAPL | Stock | 144.56 | 144.66 | 144.18 | 144.4871 | 2273883.0 |
| 2023-03-02 11:00:00 | AAPL | Stock | 144.485 | 144.7315 | 144.13 | 144.2 | 1778941.0 |
| 2023-03-02 11:30:00 | AAPL | Stock | 144.2099 | 144.38 | 143.9714 | 144.3489 | 1724390.0 |
| 2023-03-02 12:00:00 | AAPL | Stock | 144.355 | 144.6184 | 144.34 | 144.36 | 1554127.0 |
| 2023-03-02 12:30:00 | AAPL | Stock | 144.36 | 144.66 | 144.2215 | 144.45 | 1838823.0 |
| 2023-03-02 13:00:00 | AAPL | Stock | 144.46 | 144.66 | 144.28 | 144.56 | 1414009.0 |
| 2023-03-02 13:30:00 | AAPL | Stock | 144.55 | 145.5599 | 144.54 | 145.54 | 2728742.0 |
| 2023-03-02 14:00:00 | AAPL | Stock | 145.55 | 145.99 | 145.39 | 145.8741 | 3335653.0 |
| 2023-03-02 14:30:00 | AAPL | Stock | 145.88 | 146.0482 | 145.68 | 145.855 | 2012595.0 |
| 2023-03-02 15:00:00 | AAPL | Stock | 145.84 | 146.31 | 145.5647 | 146.1942 | 2619038.0 |
| 2023-03-02 15:30:00 | AAPL | Stock | 146.19 | 146.71 | 145.73 | 145.9101 | 6130870.0 |
| 2023-03-02 16:00:00 | AAPL | Stock | 145.94 | 146.0 | 145.72 | 145.79 | 8477100.0 |
| 2023-03-02 16:30:00 | AAPL | Stock | 145.79 | 145.91 | 145.71 | 145.8 | 74605.0 |
| 2023-03-02 17:00:00 | AAPL | Stock | 145.81 | 145.81 | 145.53 | 145.53 | 22212.0 |
| 2023-03-02 17:30:00 | AAPL | Stock | 145.6 | 145.6 | 145.3 | 145.31 | 13500.0 |
| 2023-03-02 18:00:00 | AAPL | Stock | 145.38 | 145.58 | 145.32 | 145.58 | 7075.0 |
| 2023-03-02 18:30:00 | AAPL | Stock | 145.48 | 145.55 | 145.4 | 145.45 | 5800.0 |
| 2023-03-02 19:00:00 | AAPL | Stock | 145.43 | 145.6 | 145.3 | 145.3 | 9121.0 |
| 2023-03-02 19:30:00 | AAPL | Stock | 145.31 | 145.68 | 145.3 | 145.6 | 11514.0 |
| 2023-03-02 04:00:00 | MSFT | Stock | 246.22 | 246.27 | 245.5 | 245.8 | 13271.0 |
| 2023-03-02 04:30:00 | MSFT | Stock | 245.94 | 245.97 | 245.51 | 245.61 | 5976.0 |
| 2023-03-02 05:00:00 | MSFT | Stock | 245.58 | 245.6 | 245.0 | 245.55 | 8205.0 |
| 2023-03-02 05:30:00 | MSFT | Stock | 245.61 | 245.9 | 245.43 | 245.9 | 3624.0 |
| 2023-03-02 06:00:00 | MSFT | Stock | 245.9 | 246.78 | 245.9 | 246.67 | 4515.0 |
| 2023-03-02 06:30:00 | MSFT | Stock | 246.65 | 246.7 | 246.65 | 246.67 | 804.0 |
| 2023-03-02 07:00:00 | MSFT | Stock | 246.8 | 247.47 | 246.65 | 246.66 | 8768.0 |
| 2023-03-02 07:30:00 | MSFT | Stock | 246.8 | 246.85 | 245.0 | 245.02 | 37238.0 |
| 2023-03-02 08:00:00 | MSFT | Stock | 247.0 | 247.37 | 243.35 | 246.0 | 111577.0 |
| 2023-03-02 08:30:00 | MSFT | Stock | 245.86 | 245.86 | 244.71 | 244.75 | 55299.0 |
| 2023-03-02 09:00:00 | MSFT | Stock | 245.1 | 246.6 | 245.0313 | 246.59 | 49461.0 |
| 2023-03-02 09:30:00 | MSFT | Stock | 246.55 | 247.59 | 245.61 | 246.61 | 2841362.0 |
| 2023-03-02 10:00:00 | MSFT | Stock | 246.66 | 247.82 | 246.53 | 247.605 | 1507230.0 |
| 2023-03-02 10:30:00 | MSFT | Stock | 247.61 | 247.75 | 246.75 | 247.63 | 975432.0 |
| 2023-03-02 11:00:00 | MSFT | Stock | 247.6599 | 247.91 | 246.88 | 246.93 | 931488.0 |
| 2023-03-02 11:30:00 | MSFT | Stock | 246.94 | 247.46 | 246.6 | 247.42 | 628847.0 |
| 2023-03-02 12:00:00 | MSFT | Stock | 247.44 | 247.6 | 246.88 | 247.26 | 538181.0 |
| 2023-03-02 12:30:00 | MSFT | Stock | 247.26 | 247.65 | 247.09 | 247.33 | 473594.0 |
> showing 50 of 101,322 rows — these rows as CSV