PREVIEW / stock_30min / 2024-01-16
file: by_date/stock_30min/2024/2024-01-16.parquet size: 2.1 MB rows: 100,605 symbols: 1,200
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-16 04:00:00 | AAPL | Stock | 183.53 | 184.38 | 182.83 | 182.87 | 18733.0 |
| 2024-01-16 04:30:00 | AAPL | Stock | 182.87 | 183.11 | 182.76 | 183.0 | 22330.0 |
| 2024-01-16 05:00:00 | AAPL | Stock | 183.06 | 183.12 | 182.74 | 182.75 | 4699.0 |
| 2024-01-16 05:30:00 | AAPL | Stock | 182.74 | 182.74 | 182.56 | 182.56 | 7342.0 |
| 2024-01-16 06:00:00 | AAPL | Stock | 182.6 | 182.72 | 182.6 | 182.64 | 11050.0 |
| 2024-01-16 06:30:00 | AAPL | Stock | 182.69 | 182.94 | 182.64 | 182.85 | 10143.0 |
| 2024-01-16 07:00:00 | AAPL | Stock | 182.89 | 183.3 | 182.8 | 183.3 | 47574.0 |
| 2024-01-16 07:30:00 | AAPL | Stock | 183.45 | 183.45 | 182.98 | 183.05 | 47583.0 |
| 2024-01-16 08:00:00 | AAPL | Stock | 182.9 | 185.0 | 182.7 | 182.86 | 152283.0 |
| 2024-01-16 08:30:00 | AAPL | Stock | 182.87 | 183.11 | 182.39 | 182.46 | 123669.0 |
| 2024-01-16 09:00:00 | AAPL | Stock | 182.48 | 182.5 | 181.7 | 182.25 | 214159.0 |
| 2024-01-16 09:30:00 | AAPL | Stock | 182.25 | 182.66 | 180.934 | 181.34 | 8204761.0 |
| 2024-01-16 10:00:00 | AAPL | Stock | 181.36 | 182.85 | 181.03 | 182.76 | 4737001.0 |
| 2024-01-16 10:30:00 | AAPL | Stock | 182.77 | 183.9 | 182.52 | 183.78 | 4206501.0 |
| 2024-01-16 11:00:00 | AAPL | Stock | 183.78 | 184.26 | 182.93 | 183.95 | 4440830.0 |
| 2024-01-16 11:30:00 | AAPL | Stock | 183.96 | 184.16 | 182.77 | 182.9 | 2032454.0 |
| 2024-01-16 12:00:00 | AAPL | Stock | 182.89 | 182.95 | 182.38 | 182.415 | 2357959.0 |
| 2024-01-16 12:30:00 | AAPL | Stock | 182.42 | 182.6 | 182.22 | 182.255 | 1712517.0 |
| 2024-01-16 13:00:00 | AAPL | Stock | 182.26 | 182.93 | 182.21 | 182.735 | 1819974.0 |
| 2024-01-16 13:30:00 | AAPL | Stock | 182.75 | 182.9499 | 182.275 | 182.395 | 1543995.0 |
| 2024-01-16 14:00:00 | AAPL | Stock | 182.4 | 182.615 | 182.14 | 182.4586 | 1637083.0 |
| 2024-01-16 14:30:00 | AAPL | Stock | 182.455 | 182.94 | 182.27 | 182.9 | 1814790.0 |
| 2024-01-16 15:00:00 | AAPL | Stock | 182.9 | 183.26 | 182.835 | 183.17 | 1601972.0 |
| 2024-01-16 15:30:00 | AAPL | Stock | 183.18 | 183.63 | 183.135 | 183.61 | 3869255.0 |
| 2024-01-16 16:00:00 | AAPL | Stock | 183.61 | 183.69 | 183.54 | 183.57 | 8936728.0 |
| 2024-01-16 16:30:00 | AAPL | Stock | 183.56 | 183.63 | 183.37 | 183.46 | 27027.0 |
| 2024-01-16 17:00:00 | AAPL | Stock | 183.43 | 183.63 | 183.14 | 183.23 | 67795.0 |
| 2024-01-16 17:30:00 | AAPL | Stock | 183.25 | 183.34 | 183.14 | 183.2501 | 7177.0 |
| 2024-01-16 18:00:00 | AAPL | Stock | 183.29 | 183.29 | 183.15 | 183.23 | 5635.0 |
| 2024-01-16 18:30:00 | AAPL | Stock | 183.22 | 183.33 | 183.12 | 183.2 | 7896.0 |
| 2024-01-16 19:00:00 | AAPL | Stock | 183.15 | 183.35 | 183.13 | 183.16 | 5158.0 |
| 2024-01-16 19:30:00 | AAPL | Stock | 183.24 | 183.24 | 183.0 | 183.04 | 11777.0 |
| 2024-01-16 04:00:00 | MSFT | Stock | 388.44 | 388.57 | 387.67 | 388.1 | 4951.0 |
| 2024-01-16 04:30:00 | MSFT | Stock | 388.11 | 389.28 | 388.11 | 389.28 | 2542.0 |
| 2024-01-16 05:00:00 | MSFT | Stock | 389.42 | 389.89 | 389.1 | 389.11 | 2527.0 |
| 2024-01-16 05:30:00 | MSFT | Stock | 389.08 | 389.67 | 389.08 | 389.41 | 1891.0 |
| 2024-01-16 06:00:00 | MSFT | Stock | 389.35 | 389.4 | 389.35 | 389.39 | 2036.0 |
| 2024-01-16 06:30:00 | MSFT | Stock | 389.65 | 390.65 | 389.65 | 390.6 | 1624.0 |
| 2024-01-16 07:00:00 | MSFT | Stock | 390.7 | 391.38 | 389.99 | 390.8 | 25664.0 |
| 2024-01-16 07:30:00 | MSFT | Stock | 390.9 | 392.0 | 390.73 | 392.0 | 35644.0 |
| 2024-01-16 08:00:00 | MSFT | Stock | 390.4 | 392.0 | 386.76 | 391.46 | 113855.0 |
| 2024-01-16 08:30:00 | MSFT | Stock | 391.52 | 393.8 | 391.43 | 393.7561 | 99119.0 |
| 2024-01-16 09:00:00 | MSFT | Stock | 393.75 | 393.94 | 393.2123 | 393.68 | 96508.0 |
| 2024-01-16 09:30:00 | MSFT | Stock | 393.72 | 394.03 | 389.47 | 391.93 | 3810500.0 |
| 2024-01-16 10:00:00 | MSFT | Stock | 391.96 | 392.47 | 390.78 | 392.12 | 1756735.0 |
| 2024-01-16 10:30:00 | MSFT | Stock | 392.095 | 393.22 | 391.25 | 392.81 | 1156561.0 |
| 2024-01-16 11:00:00 | MSFT | Stock | 392.86 | 393.04 | 390.32 | 391.65 | 1107575.0 |
| 2024-01-16 11:30:00 | MSFT | Stock | 391.69 | 392.3199 | 390.23 | 390.58 | 691035.0 |
| 2024-01-16 12:00:00 | MSFT | Stock | 390.56 | 390.991 | 389.73 | 389.78 | 661901.0 |
| 2024-01-16 12:30:00 | MSFT | Stock | 389.76 | 390.0 | 388.31 | 388.38 | 714046.0 |
> showing 50 of 100,605 rows — these rows as CSV