PREVIEW / stock_30min / 2024-01-05
file: by_date/stock_30min/2024/2024-01-05.parquet size: 2.0 MB rows: 98,270 symbols: 1,169
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 |
|---|---|---|---|---|---|---|---|
| 2024-01-05 04:00:00 | AAPL | Stock | 181.79 | 181.79 | 181.09 | 181.2 | 17953.0 |
| 2024-01-05 04:30:00 | AAPL | Stock | 181.05 | 181.07 | 180.8 | 180.8 | 5181.0 |
| 2024-01-05 05:00:00 | AAPL | Stock | 180.71 | 180.8 | 180.45 | 180.45 | 5578.0 |
| 2024-01-05 05:30:00 | AAPL | Stock | 180.65 | 180.73 | 180.58 | 180.6 | 11008.0 |
| 2024-01-05 06:00:00 | AAPL | Stock | 180.63 | 180.65 | 180.2 | 180.38 | 13766.0 |
| 2024-01-05 06:30:00 | AAPL | Stock | 180.38 | 180.75 | 180.25 | 180.75 | 9553.0 |
| 2024-01-05 07:00:00 | AAPL | Stock | 180.72 | 181.06 | 180.63 | 180.81 | 37896.0 |
| 2024-01-05 07:30:00 | AAPL | Stock | 180.82 | 180.82 | 180.55 | 180.55 | 15417.0 |
| 2024-01-05 08:00:00 | AAPL | Stock | 181.01 | 181.92 | 180.25 | 180.7696 | 163878.0 |
| 2024-01-05 08:30:00 | AAPL | Stock | 180.67 | 181.24 | 180.18 | 181.13 | 264518.0 |
| 2024-01-05 09:00:00 | AAPL | Stock | 181.14 | 181.94 | 181.14 | 181.94 | 248301.0 |
| 2024-01-05 09:30:00 | AAPL | Stock | 181.94 | 182.76 | 181.52 | 181.69 | 5823690.0 |
| 2024-01-05 10:00:00 | AAPL | Stock | 181.71 | 182.49 | 181.7 | 182.07 | 3619698.0 |
| 2024-01-05 10:30:00 | AAPL | Stock | 182.0663 | 182.65 | 181.965 | 182.65 | 2510570.0 |
| 2024-01-05 11:00:00 | AAPL | Stock | 182.66 | 182.74 | 182.01 | 182.0876 | 2138325.0 |
| 2024-01-05 11:30:00 | AAPL | Stock | 182.08 | 182.225 | 181.9101 | 182.1022 | 1503144.0 |
| 2024-01-05 12:00:00 | AAPL | Stock | 182.11 | 182.22 | 181.32 | 181.365 | 2284882.0 |
| 2024-01-05 12:30:00 | AAPL | Stock | 181.36 | 181.86 | 181.28 | 181.59 | 1679541.0 |
| 2024-01-05 13:00:00 | AAPL | Stock | 181.5933 | 181.76 | 181.21 | 181.74 | 1849079.0 |
| 2024-01-05 13:30:00 | AAPL | Stock | 181.745 | 182.23 | 181.7415 | 182.035 | 1977799.0 |
| 2024-01-05 14:00:00 | AAPL | Stock | 182.035 | 182.18 | 180.42 | 181.12 | 6507386.0 |
| 2024-01-05 14:30:00 | AAPL | Stock | 181.11 | 181.39 | 180.4701 | 180.485 | 3431911.0 |
| 2024-01-05 15:00:00 | AAPL | Stock | 180.49 | 180.58 | 180.17 | 180.28 | 3255808.0 |
| 2024-01-05 15:30:00 | AAPL | Stock | 180.2799 | 181.26 | 180.2381 | 181.18 | 5826251.0 |
| 2024-01-05 16:00:00 | AAPL | Stock | 181.17 | 181.27 | 180.76 | 180.89 | 7884560.0 |
| 2024-01-05 16:30:00 | AAPL | Stock | 180.88 | 181.18 | 180.8 | 180.87 | 81724.0 |
| 2024-01-05 17:00:00 | AAPL | Stock | 180.86 | 181.0869 | 180.86 | 180.96 | 21603.0 |
| 2024-01-05 17:30:00 | AAPL | Stock | 181.0 | 181.18 | 180.9411 | 181.03 | 13429.0 |
| 2024-01-05 18:00:00 | AAPL | Stock | 181.05 | 181.0565 | 180.9 | 180.9 | 18039.0 |
| 2024-01-05 18:30:00 | AAPL | Stock | 180.9 | 180.9065 | 180.8 | 180.83 | 15845.0 |
| 2024-01-05 19:00:00 | AAPL | Stock | 180.89 | 180.9 | 180.78 | 180.84 | 14023.0 |
| 2024-01-05 19:30:00 | AAPL | Stock | 180.8708 | 180.8799 | 180.74 | 180.78 | 14833.0 |
| 2024-01-05 04:00:00 | MSFT | Stock | 367.97 | 368.0 | 367.5 | 367.53 | 733.0 |
| 2024-01-05 04:30:00 | MSFT | Stock | 367.76 | 367.76 | 367.5 | 367.5 | 1423.0 |
| 2024-01-05 05:00:00 | MSFT | Stock | 367.66 | 367.86 | 367.65 | 367.65 | 1315.0 |
| 2024-01-05 05:30:00 | MSFT | Stock | 367.6 | 367.6 | 367.53 | 367.53 | 206.0 |
| 2024-01-05 06:00:00 | MSFT | Stock | 367.82 | 367.82 | 367.82 | 367.82 | 100.0 |
| 2024-01-05 06:30:00 | MSFT | Stock | 367.5 | 367.52 | 367.47 | 367.52 | 1780.0 |
| 2024-01-05 07:00:00 | MSFT | Stock | 367.47 | 367.79 | 367.41 | 367.79 | 2776.0 |
| 2024-01-05 07:30:00 | MSFT | Stock | 367.8 | 368.25 | 367.7 | 367.7 | 5077.0 |
| 2024-01-05 08:00:00 | MSFT | Stock | 367.5892 | 368.35 | 367.41 | 368.29 | 13906.0 |
| 2024-01-05 08:30:00 | MSFT | Stock | 368.1 | 368.6706 | 367.0 | 368.509 | 37751.0 |
| 2024-01-05 09:00:00 | MSFT | Stock | 368.3127 | 369.5 | 368.3127 | 369.01 | 34589.0 |
| 2024-01-05 09:30:00 | MSFT | Stock | 368.97 | 370.65 | 368.79 | 369.66 | 1476156.0 |
| 2024-01-05 10:00:00 | MSFT | Stock | 369.63 | 371.4637 | 369.58 | 371.3993 | 1244518.0 |
| 2024-01-05 10:30:00 | MSFT | Stock | 371.38 | 371.73 | 371.04 | 371.6712 | 683353.0 |
| 2024-01-05 11:00:00 | MSFT | Stock | 371.67 | 372.06 | 370.64 | 370.77 | 720980.0 |
| 2024-01-05 11:30:00 | MSFT | Stock | 370.78 | 371.19 | 370.215 | 370.765 | 488431.0 |
| 2024-01-05 12:00:00 | MSFT | Stock | 370.76 | 370.76 | 368.82 | 368.92 | 574370.0 |
| 2024-01-05 12:30:00 | MSFT | Stock | 368.86 | 369.4 | 368.81 | 368.9359 | 427862.0 |
> showing 50 of 98,270 rows — these rows as CSV