PREVIEW / stock_30min / 2024-07-08
file: by_date/stock_30min/2024/2024-07-08.parquet size: 2.0 MB rows: 98,636 symbols: 923
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-07-08 04:00:00 | AAPL | Stock | 227.6 | 227.6 | 226.61 | 227.56 | 11404.0 |
| 2024-07-08 04:30:00 | AAPL | Stock | 227.57 | 227.57 | 227.14 | 227.5 | 11973.0 |
| 2024-07-08 05:00:00 | AAPL | Stock | 227.36 | 227.55 | 227.29 | 227.55 | 3750.0 |
| 2024-07-08 05:30:00 | AAPL | Stock | 227.4 | 227.4 | 227.13 | 227.16 | 5684.0 |
| 2024-07-08 06:00:00 | AAPL | Stock | 227.23 | 227.26 | 227.23 | 227.26 | 2445.0 |
| 2024-07-08 06:30:00 | AAPL | Stock | 227.24 | 227.27 | 227.07 | 227.1 | 4750.0 |
| 2024-07-08 07:00:00 | AAPL | Stock | 227.1 | 227.22 | 226.88 | 227.22 | 28276.0 |
| 2024-07-08 07:30:00 | AAPL | Stock | 227.25 | 227.88 | 227.25 | 227.84 | 26813.0 |
| 2024-07-08 08:00:00 | AAPL | Stock | 227.0 | 228.21 | 225.775 | 227.37 | 192722.0 |
| 2024-07-08 08:30:00 | AAPL | Stock | 227.47 | 227.6 | 227.31 | 227.48 | 95846.0 |
| 2024-07-08 09:00:00 | AAPL | Stock | 227.48 | 227.5 | 226.34 | 227.07 | 145945.0 |
| 2024-07-08 09:30:00 | AAPL | Stock | 227.09 | 227.35 | 223.4 | 223.67 | 8700394.0 |
| 2024-07-08 10:00:00 | AAPL | Stock | 223.67 | 225.39 | 223.25 | 225.2 | 4037003.0 |
| 2024-07-08 10:30:00 | AAPL | Stock | 225.1998 | 225.82 | 224.7832 | 225.42 | 2911436.0 |
| 2024-07-08 11:00:00 | AAPL | Stock | 225.43 | 226.81 | 225.4001 | 226.51 | 3477155.0 |
| 2024-07-08 11:30:00 | AAPL | Stock | 226.53 | 227.01 | 226.27 | 226.5 | 2093139.0 |
| 2024-07-08 12:00:00 | AAPL | Stock | 226.49 | 226.59 | 225.79 | 226.52 | 1713001.0 |
| 2024-07-08 12:30:00 | AAPL | Stock | 226.51 | 226.77 | 226.05 | 226.68 | 1437274.0 |
| 2024-07-08 13:00:00 | AAPL | Stock | 226.69 | 226.9 | 226.26 | 226.5999 | 1492267.0 |
| 2024-07-08 13:30:00 | AAPL | Stock | 226.58 | 227.07 | 226.39 | 226.46 | 1660662.0 |
| 2024-07-08 14:00:00 | AAPL | Stock | 226.45 | 227.45 | 226.4026 | 227.33 | 2335636.0 |
| 2024-07-08 14:30:00 | AAPL | Stock | 227.33 | 227.36 | 226.4 | 226.976 | 1542023.0 |
| 2024-07-08 15:00:00 | AAPL | Stock | 226.975 | 227.22 | 226.725 | 226.825 | 2015565.0 |
| 2024-07-08 15:30:00 | AAPL | Stock | 226.81 | 227.85 | 226.7601 | 227.8 | 4995788.0 |
| 2024-07-08 16:00:00 | AAPL | Stock | 227.82 | 227.88 | 227.6 | 227.65 | 6364614.0 |
| 2024-07-08 16:30:00 | AAPL | Stock | 227.6497 | 227.82 | 227.58 | 227.65 | 23160.0 |
| 2024-07-08 17:00:00 | AAPL | Stock | 227.64 | 227.65 | 227.54 | 227.65 | 15633.0 |
| 2024-07-08 17:30:00 | AAPL | Stock | 227.64 | 227.95 | 227.55 | 227.95 | 124418.0 |
| 2024-07-08 18:00:00 | AAPL | Stock | 227.9 | 227.98 | 227.81 | 227.97 | 20872.0 |
| 2024-07-08 18:30:00 | AAPL | Stock | 227.97 | 227.98 | 227.81 | 227.86 | 6105.0 |
| 2024-07-08 19:00:00 | AAPL | Stock | 227.9176 | 228.19 | 227.88 | 228.1335 | 26646.0 |
| 2024-07-08 19:30:00 | AAPL | Stock | 228.19 | 228.49 | 228.14 | 228.39 | 34838.0 |
| 2024-07-08 04:00:00 | MSFT | Stock | 469.15 | 469.28 | 468.54 | 468.54 | 1790.0 |
| 2024-07-08 04:30:00 | MSFT | Stock | 468.7 | 468.7 | 468.21 | 468.21 | 675.0 |
| 2024-07-08 05:00:00 | MSFT | Stock | 468.5 | 468.65 | 468.5 | 468.65 | 720.0 |
| 2024-07-08 05:30:00 | MSFT | Stock | 468.7 | 468.76 | 468.64 | 468.76 | 685.0 |
| 2024-07-08 06:00:00 | MSFT | Stock | 468.7 | 468.7 | 468.5 | 468.5 | 1210.0 |
| 2024-07-08 07:00:00 | MSFT | Stock | 468.2 | 468.75 | 467.65 | 468.0 | 5772.0 |
| 2024-07-08 07:30:00 | MSFT | Stock | 468.3 | 468.4 | 468.01 | 468.01 | 1427.0 |
| 2024-07-08 08:00:00 | MSFT | Stock | 467.63 | 469.55 | 466.392 | 467.91 | 22014.0 |
| 2024-07-08 08:30:00 | MSFT | Stock | 467.86 | 467.86 | 467.15 | 467.35 | 10687.0 |
| 2024-07-08 09:00:00 | MSFT | Stock | 467.14 | 467.92 | 466.48 | 466.6 | 16699.0 |
| 2024-07-08 09:30:00 | MSFT | Stock | 466.69 | 467.7 | 464.7656 | 466.63 | 1203600.0 |
| 2024-07-08 10:00:00 | MSFT | Stock | 466.66 | 466.82 | 464.46 | 465.6311 | 601313.0 |
| 2024-07-08 10:30:00 | MSFT | Stock | 465.7 | 466.07 | 464.5501 | 465.5236 | 464787.0 |
| 2024-07-08 11:00:00 | MSFT | Stock | 465.5078 | 466.06 | 465.17 | 466.06 | 333463.0 |
| 2024-07-08 11:30:00 | MSFT | Stock | 466.045 | 466.85 | 465.81 | 466.325 | 335984.0 |
| 2024-07-08 12:00:00 | MSFT | Stock | 466.39 | 466.41 | 465.27 | 465.515 | 259015.0 |
| 2024-07-08 12:30:00 | MSFT | Stock | 465.47 | 465.7399 | 465.16 | 465.53 | 164042.0 |
| 2024-07-08 13:00:00 | MSFT | Stock | 465.53 | 465.73 | 465.04 | 465.55 | 201167.0 |
> showing 50 of 98,636 rows — these rows as CSV