PREVIEW / stock_30min / 2024-01-09
file: by_date/stock_30min/2024/2024-01-09.parquet size: 2.0 MB rows: 98,912 symbols: 1,175
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-09 04:00:00 | AAPL | Stock | 185.34 | 185.34 | 184.85 | 184.9 | 15661.0 |
| 2024-01-09 04:30:00 | AAPL | Stock | 185.0 | 185.14 | 184.96 | 185.09 | 4232.0 |
| 2024-01-09 05:00:00 | AAPL | Stock | 185.1 | 185.1 | 184.98 | 185.1 | 7200.0 |
| 2024-01-09 05:30:00 | AAPL | Stock | 185.05 | 185.1 | 185.01 | 185.01 | 1308.0 |
| 2024-01-09 06:00:00 | AAPL | Stock | 185.0 | 185.0 | 184.8 | 184.81 | 2039.0 |
| 2024-01-09 06:30:00 | AAPL | Stock | 184.81 | 184.86 | 184.71 | 184.72 | 2823.0 |
| 2024-01-09 07:00:00 | AAPL | Stock | 184.76 | 184.8 | 184.3 | 184.31 | 29954.0 |
| 2024-01-09 07:30:00 | AAPL | Stock | 184.31 | 184.76 | 184.16 | 184.55 | 18926.0 |
| 2024-01-09 08:00:00 | AAPL | Stock | 184.8 | 186.43 | 184.24 | 184.31 | 103893.0 |
| 2024-01-09 08:30:00 | AAPL | Stock | 184.32 | 184.39 | 183.7 | 183.835 | 84813.0 |
| 2024-01-09 09:00:00 | AAPL | Stock | 183.87 | 184.1 | 183.75 | 184.03 | 70727.0 |
| 2024-01-09 09:30:00 | AAPL | Stock | 183.92 | 184.23 | 182.73 | 183.27 | 5254685.0 |
| 2024-01-09 10:00:00 | AAPL | Stock | 183.255 | 183.98 | 182.97 | 183.525 | 2774505.0 |
| 2024-01-09 10:30:00 | AAPL | Stock | 183.53 | 183.81 | 183.21 | 183.4925 | 1787243.0 |
| 2024-01-09 11:00:00 | AAPL | Stock | 183.49 | 184.26 | 183.49 | 184.23 | 1828056.0 |
| 2024-01-09 11:30:00 | AAPL | Stock | 184.23 | 184.8 | 184.15 | 184.79 | 1965058.0 |
| 2024-01-09 12:00:00 | AAPL | Stock | 184.795 | 184.83 | 184.375 | 184.44 | 1351213.0 |
| 2024-01-09 12:30:00 | AAPL | Stock | 184.44 | 184.81 | 184.39 | 184.72 | 1033252.0 |
| 2024-01-09 13:00:00 | AAPL | Stock | 184.72 | 184.92 | 184.39 | 184.4 | 1285984.0 |
| 2024-01-09 13:30:00 | AAPL | Stock | 184.4 | 184.73 | 184.04 | 184.48 | 1530407.0 |
| 2024-01-09 14:00:00 | AAPL | Stock | 184.49 | 184.685 | 184.215 | 184.315 | 1153653.0 |
| 2024-01-09 14:30:00 | AAPL | Stock | 184.3101 | 184.67 | 184.3002 | 184.6102 | 1297498.0 |
| 2024-01-09 15:00:00 | AAPL | Stock | 184.62 | 184.9 | 184.425 | 184.78 | 1793499.0 |
| 2024-01-09 15:30:00 | AAPL | Stock | 184.78 | 185.15 | 184.41 | 185.13 | 4504316.0 |
| 2024-01-09 16:00:00 | AAPL | Stock | 185.12 | 185.56 | 185.03 | 185.14 | 7021732.0 |
| 2024-01-09 16:30:00 | AAPL | Stock | 185.14 | 185.23 | 185.1203 | 185.23 | 21503.0 |
| 2024-01-09 17:00:00 | AAPL | Stock | 185.2 | 185.23 | 185.2 | 185.21 | 9005.0 |
| 2024-01-09 17:30:00 | AAPL | Stock | 185.21 | 185.28 | 185.2 | 185.23 | 6826.0 |
| 2024-01-09 18:00:00 | AAPL | Stock | 185.23 | 185.26 | 185.15 | 185.15 | 8501.0 |
| 2024-01-09 18:30:00 | AAPL | Stock | 185.2 | 185.48 | 185.15 | 185.48 | 5981.0 |
| 2024-01-09 19:00:00 | AAPL | Stock | 185.47 | 185.5 | 185.4 | 185.4999 | 8407.0 |
| 2024-01-09 19:30:00 | AAPL | Stock | 185.42 | 185.5 | 185.33 | 185.41 | 8097.0 |
| 2024-01-09 04:00:00 | MSFT | Stock | 374.2 | 374.2 | 373.49 | 373.5 | 2820.0 |
| 2024-01-09 04:30:00 | MSFT | Stock | 373.51 | 373.72 | 373.51 | 373.72 | 991.0 |
| 2024-01-09 05:00:00 | MSFT | Stock | 373.54 | 373.6 | 373.43 | 373.6 | 3519.0 |
| 2024-01-09 05:30:00 | MSFT | Stock | 373.8 | 373.8 | 372.0 | 373.08 | 14574.0 |
| 2024-01-09 06:00:00 | MSFT | Stock | 373.0 | 373.0 | 372.56 | 372.75 | 5396.0 |
| 2024-01-09 06:30:00 | MSFT | Stock | 372.7 | 372.77 | 372.6 | 372.66 | 2582.0 |
| 2024-01-09 07:00:00 | MSFT | Stock | 372.87 | 374.24 | 372.87 | 373.12 | 11333.0 |
| 2024-01-09 07:30:00 | MSFT | Stock | 373.35 | 373.55 | 373.35 | 373.55 | 4060.0 |
| 2024-01-09 08:00:00 | MSFT | Stock | 372.8695 | 375.25 | 372.8694 | 373.12 | 24667.0 |
| 2024-01-09 08:30:00 | MSFT | Stock | 373.06 | 373.06 | 372.25 | 372.35 | 21041.0 |
| 2024-01-09 09:00:00 | MSFT | Stock | 372.38 | 373.2638 | 371.97 | 372.07 | 47237.0 |
| 2024-01-09 09:30:00 | MSFT | Stock | 372.03 | 373.21 | 371.4175 | 371.94 | 1662374.0 |
| 2024-01-09 10:00:00 | MSFT | Stock | 371.9 | 372.8124 | 371.19 | 371.7339 | 1366240.0 |
| 2024-01-09 10:30:00 | MSFT | Stock | 371.79 | 374.51 | 371.66 | 373.58 | 1028505.0 |
| 2024-01-09 11:00:00 | MSFT | Stock | 373.58 | 374.5 | 373.47 | 374.32 | 646043.0 |
| 2024-01-09 11:30:00 | MSFT | Stock | 374.32 | 375.7 | 374.03 | 375.69 | 601033.0 |
| 2024-01-09 12:00:00 | MSFT | Stock | 375.69 | 375.77 | 375.21 | 375.2765 | 591849.0 |
| 2024-01-09 12:30:00 | MSFT | Stock | 375.2471 | 375.76 | 375.06 | 375.5804 | 497774.0 |
> showing 50 of 98,912 rows — these rows as CSV