PREVIEW / stock_30min / 2024-07-30
file: by_date/stock_30min/2024/2024-07-30.parquet size: 2.0 MB rows: 97,647 symbols: 882
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-30 04:00:00 | AAPL | Stock | 218.42 | 219.1 | 218.42 | 218.61 | 3961.0 |
| 2024-07-30 04:30:00 | AAPL | Stock | 218.72 | 218.98 | 218.66 | 218.79 | 2964.0 |
| 2024-07-30 05:00:00 | AAPL | Stock | 218.8 | 218.98 | 218.7 | 218.7 | 1863.0 |
| 2024-07-30 05:30:00 | AAPL | Stock | 218.7 | 218.71 | 218.18 | 218.69 | 6076.0 |
| 2024-07-30 06:00:00 | AAPL | Stock | 218.74 | 218.9 | 218.74 | 218.9 | 2836.0 |
| 2024-07-30 06:30:00 | AAPL | Stock | 218.97 | 218.99 | 218.82 | 218.99 | 7776.0 |
| 2024-07-30 07:00:00 | AAPL | Stock | 219.0 | 219.0 | 218.82 | 218.88 | 7098.0 |
| 2024-07-30 07:30:00 | AAPL | Stock | 218.97 | 219.3 | 218.97 | 219.15 | 12876.0 |
| 2024-07-30 08:00:00 | AAPL | Stock | 218.9 | 219.2999 | 217.65 | 219.05 | 39248.0 |
| 2024-07-30 08:30:00 | AAPL | Stock | 219.02 | 219.65 | 219.02 | 219.59 | 29599.0 |
| 2024-07-30 09:00:00 | AAPL | Stock | 219.6 | 219.82 | 218.8 | 219.19 | 133125.0 |
| 2024-07-30 09:30:00 | AAPL | Stock | 219.2 | 220.325 | 218.56 | 219.64 | 3878685.0 |
| 2024-07-30 10:00:00 | AAPL | Stock | 219.66 | 220.0799 | 218.97 | 219.07 | 2357840.0 |
| 2024-07-30 10:30:00 | AAPL | Stock | 219.07 | 219.3358 | 218.04 | 218.7213 | 2095709.0 |
| 2024-07-30 11:00:00 | AAPL | Stock | 218.729 | 218.82 | 217.16 | 217.29 | 2416579.0 |
| 2024-07-30 11:30:00 | AAPL | Stock | 217.28 | 217.54 | 216.33 | 216.545 | 1657773.0 |
| 2024-07-30 12:00:00 | AAPL | Stock | 216.5533 | 217.2151 | 216.55 | 216.98 | 1056213.0 |
| 2024-07-30 12:30:00 | AAPL | Stock | 216.96 | 217.21 | 216.15 | 216.15 | 1211162.0 |
| 2024-07-30 13:00:00 | AAPL | Stock | 216.17 | 217.35 | 216.12 | 217.25 | 1297999.0 |
| 2024-07-30 13:30:00 | AAPL | Stock | 217.25 | 217.62 | 216.96 | 217.58 | 895128.0 |
| 2024-07-30 14:00:00 | AAPL | Stock | 217.585 | 218.74 | 217.58 | 218.285 | 1548418.0 |
| 2024-07-30 14:30:00 | AAPL | Stock | 218.28 | 218.465 | 217.97 | 218.2 | 1053086.0 |
| 2024-07-30 15:00:00 | AAPL | Stock | 218.21 | 218.71 | 217.975 | 218.63 | 1245801.0 |
| 2024-07-30 15:30:00 | AAPL | Stock | 218.64 | 219.92 | 218.45 | 218.79 | 4213639.0 |
| 2024-07-30 16:00:00 | AAPL | Stock | 218.79 | 218.8 | 216.52 | 217.86 | 6581950.0 |
| 2024-07-30 16:30:00 | AAPL | Stock | 217.82 | 218.8 | 217.03 | 217.45 | 701706.0 |
| 2024-07-30 17:00:00 | AAPL | Stock | 217.4 | 217.55 | 216.75 | 216.75 | 614436.0 |
| 2024-07-30 17:30:00 | AAPL | Stock | 216.75 | 218.8 | 216.66 | 217.12 | 39247.0 |
| 2024-07-30 18:00:00 | AAPL | Stock | 217.23 | 218.15 | 217.1 | 218.07 | 56452.0 |
| 2024-07-30 18:30:00 | AAPL | Stock | 218.05 | 218.15 | 217.05 | 217.61 | 25930.0 |
| 2024-07-30 19:00:00 | AAPL | Stock | 217.59 | 218.2 | 217.36 | 217.88 | 19386.0 |
| 2024-07-30 19:30:00 | AAPL | Stock | 217.86 | 218.4 | 217.55 | 218.1 | 22607.0 |
| 2024-07-30 04:00:00 | MSFT | Stock | 426.7 | 426.73 | 425.5 | 425.5 | 500.0 |
| 2024-07-30 04:30:00 | MSFT | Stock | 425.6 | 426.79 | 425.6 | 426.4 | 1433.0 |
| 2024-07-30 05:00:00 | MSFT | Stock | 426.38 | 427.14 | 426.37 | 427.1 | 2625.0 |
| 2024-07-30 05:30:00 | MSFT | Stock | 426.9 | 426.9 | 425.77 | 425.77 | 1902.0 |
| 2024-07-30 06:00:00 | MSFT | Stock | 425.89 | 426.11 | 425.89 | 426.11 | 1415.0 |
| 2024-07-30 06:30:00 | MSFT | Stock | 426.45 | 427.08 | 426.45 | 427.0 | 1962.0 |
| 2024-07-30 07:00:00 | MSFT | Stock | 427.0 | 427.1 | 426.5 | 426.5 | 4985.0 |
| 2024-07-30 07:30:00 | MSFT | Stock | 426.53 | 427.35 | 426.53 | 427.35 | 1427.0 |
| 2024-07-30 08:00:00 | MSFT | Stock | 426.99 | 427.67 | 426.23 | 426.5 | 26218.0 |
| 2024-07-30 08:30:00 | MSFT | Stock | 426.61 | 427.54 | 426.61 | 427.47 | 9837.0 |
| 2024-07-30 09:00:00 | MSFT | Stock | 427.5 | 428.3 | 427.0 | 428.18 | 23587.0 |
| 2024-07-30 09:30:00 | MSFT | Stock | 427.72 | 429.05 | 425.0 | 427.29 | 1701482.0 |
| 2024-07-30 10:00:00 | MSFT | Stock | 427.305 | 428.9 | 426.52 | 427.4 | 708054.0 |
| 2024-07-30 10:30:00 | MSFT | Stock | 427.43 | 427.43 | 424.6901 | 424.9967 | 743463.0 |
| 2024-07-30 11:00:00 | MSFT | Stock | 424.98 | 425.2199 | 421.8 | 422.27 | 736370.0 |
| 2024-07-30 11:30:00 | MSFT | Stock | 422.24 | 422.92 | 418.7333 | 419.465 | 1311762.0 |
| 2024-07-30 12:00:00 | MSFT | Stock | 419.45 | 421.59 | 419.33 | 420.32 | 659128.0 |
| 2024-07-30 12:30:00 | MSFT | Stock | 420.235 | 420.31 | 418.0 | 418.17 | 883183.0 |
> showing 50 of 97,647 rows — these rows as CSV