PREVIEW / stock_30min / 2024-09-06
file: by_date/stock_30min/2024/2024-09-06.parquet size: 2.0 MB rows: 96,820 symbols: 802
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-09-06 04:00:00 | AAPL | Stock | 219.0 | 221.87 | 219.0 | 221.55 | 6429.0 |
| 2024-09-06 04:30:00 | AAPL | Stock | 221.55 | 221.55 | 221.22 | 221.22 | 1897.0 |
| 2024-09-06 05:00:00 | AAPL | Stock | 221.17 | 221.18 | 220.71 | 221.18 | 1477.0 |
| 2024-09-06 05:30:00 | AAPL | Stock | 221.03 | 221.24 | 221.03 | 221.24 | 1392.0 |
| 2024-09-06 06:00:00 | AAPL | Stock | 221.25 | 221.3 | 221.25 | 221.27 | 950.0 |
| 2024-09-06 06:30:00 | AAPL | Stock | 221.22 | 221.22 | 220.95 | 220.95 | 894.0 |
| 2024-09-06 07:00:00 | AAPL | Stock | 221.09 | 222.1 | 221.0 | 221.25 | 15249.0 |
| 2024-09-06 07:30:00 | AAPL | Stock | 221.32 | 221.55 | 220.9 | 221.35 | 23472.0 |
| 2024-09-06 08:00:00 | AAPL | Stock | 221.8256 | 222.02 | 220.85 | 221.86 | 48295.0 |
| 2024-09-06 08:30:00 | AAPL | Stock | 221.48 | 223.652 | 220.96 | 223.4 | 211284.0 |
| 2024-09-06 09:00:00 | AAPL | Stock | 223.38 | 224.4996 | 223.0765 | 224.08 | 118258.0 |
| 2024-09-06 09:30:00 | AAPL | Stock | 224.0 | 225.24 | 222.8 | 224.045 | 4994367.0 |
| 2024-09-06 10:00:00 | AAPL | Stock | 224.045 | 224.75 | 222.38 | 222.69 | 3114198.0 |
| 2024-09-06 10:30:00 | AAPL | Stock | 222.67 | 223.029 | 220.93 | 221.4 | 2371798.0 |
| 2024-09-06 11:00:00 | AAPL | Stock | 221.41 | 222.57 | 220.83 | 221.25 | 2194544.0 |
| 2024-09-06 11:30:00 | AAPL | Stock | 221.25 | 222.07 | 220.82 | 220.96 | 1270542.0 |
| 2024-09-06 12:00:00 | AAPL | Stock | 220.955 | 221.35 | 220.662 | 220.69 | 1181179.0 |
| 2024-09-06 12:30:00 | AAPL | Stock | 220.7 | 221.25 | 220.46 | 220.68 | 1326984.0 |
| 2024-09-06 13:00:00 | AAPL | Stock | 220.68 | 221.64 | 220.61 | 220.95 | 1280726.0 |
| 2024-09-06 13:30:00 | AAPL | Stock | 220.95 | 221.09 | 220.08 | 220.265 | 1116049.0 |
| 2024-09-06 14:00:00 | AAPL | Stock | 220.3079 | 220.52 | 219.77 | 220.19 | 1068385.0 |
| 2024-09-06 14:30:00 | AAPL | Stock | 220.19 | 220.68 | 219.82 | 220.54 | 1202525.0 |
| 2024-09-06 15:00:00 | AAPL | Stock | 220.545 | 221.47 | 220.45 | 221.06 | 1692025.0 |
| 2024-09-06 15:30:00 | AAPL | Stock | 221.0625 | 221.55 | 220.14 | 220.95 | 3281423.0 |
| 2024-09-06 16:00:00 | AAPL | Stock | 220.82 | 221.26 | 220.0 | 220.13 | 9159742.0 |
| 2024-09-06 16:30:00 | AAPL | Stock | 220.15 | 221.82 | 219.77 | 219.93 | 202387.0 |
| 2024-09-06 17:00:00 | AAPL | Stock | 220.03 | 220.82 | 219.96 | 220.1 | 152816.0 |
| 2024-09-06 17:30:00 | AAPL | Stock | 220.038 | 220.82 | 219.87 | 219.9 | 10055.0 |
| 2024-09-06 18:00:00 | AAPL | Stock | 219.9 | 220.2 | 219.8 | 220.15 | 18381.0 |
| 2024-09-06 18:30:00 | AAPL | Stock | 220.1009 | 220.2925 | 220.04 | 220.1128 | 6033.0 |
| 2024-09-06 19:00:00 | AAPL | Stock | 220.2 | 220.3061 | 220.1251 | 220.25 | 5529.0 |
| 2024-09-06 19:30:00 | AAPL | Stock | 220.25 | 220.39 | 220.01 | 220.1434 | 7157.0 |
| 2024-09-06 04:00:00 | MSFT | Stock | 407.78 | 407.78 | 405.0 | 406.03 | 1250.0 |
| 2024-09-06 04:30:00 | MSFT | Stock | 406.33 | 406.4 | 405.8 | 405.8 | 1655.0 |
| 2024-09-06 05:00:00 | MSFT | Stock | 405.61 | 405.7 | 405.05 | 405.05 | 4093.0 |
| 2024-09-06 05:30:00 | MSFT | Stock | 405.05 | 405.5 | 404.89 | 405.5 | 1403.0 |
| 2024-09-06 06:00:00 | MSFT | Stock | 405.27 | 405.27 | 400.66 | 403.34 | 9182.0 |
| 2024-09-06 06:30:00 | MSFT | Stock | 403.55 | 404.0 | 403.0 | 403.28 | 8990.0 |
| 2024-09-06 07:00:00 | MSFT | Stock | 403.69 | 405.26 | 403.69 | 405.0 | 4488.0 |
| 2024-09-06 07:30:00 | MSFT | Stock | 404.75 | 406.35 | 404.75 | 406.25 | 6260.0 |
| 2024-09-06 08:00:00 | MSFT | Stock | 404.0042 | 406.5 | 404.0 | 406.0 | 18813.0 |
| 2024-09-06 08:30:00 | MSFT | Stock | 405.42 | 409.45 | 404.55 | 408.98 | 46689.0 |
| 2024-09-06 09:00:00 | MSFT | Stock | 409.1711 | 409.3635 | 408.22 | 409.22 | 12237.0 |
| 2024-09-06 09:30:00 | MSFT | Stock | 409.49 | 410.65 | 407.2 | 407.57 | 1003933.0 |
| 2024-09-06 10:00:00 | MSFT | Stock | 407.565 | 408.42 | 405.71 | 405.71 | 536790.0 |
| 2024-09-06 10:30:00 | MSFT | Stock | 405.74 | 406.0 | 401.98 | 402.7 | 862574.0 |
| 2024-09-06 11:00:00 | MSFT | Stock | 402.65 | 405.23 | 401.92 | 402.62 | 696073.0 |
| 2024-09-06 11:30:00 | MSFT | Stock | 402.66 | 403.77 | 401.69 | 401.7025 | 463798.0 |
| 2024-09-06 12:00:00 | MSFT | Stock | 401.74 | 402.33 | 401.462 | 401.61 | 586439.0 |
| 2024-09-06 12:30:00 | MSFT | Stock | 401.66 | 403.04 | 401.56 | 402.485 | 358439.0 |
> showing 50 of 96,820 rows — these rows as CSV