PREVIEW / stock_30min / 2023-08-21
file: by_date/stock_30min/2023/2023-08-21.parquet size: 2.0 MB rows: 98,719 symbols: 1,474
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 |
|---|---|---|---|---|---|---|---|
| 2023-08-21 04:00:00 | AAPL | Stock | 175.02 | 175.22 | 174.82 | 175.0 | 8155.0 |
| 2023-08-21 04:30:00 | AAPL | Stock | 175.05 | 175.07 | 174.98 | 175.0 | 17139.0 |
| 2023-08-21 05:00:00 | AAPL | Stock | 175.0 | 175.2 | 175.0 | 175.12 | 4449.0 |
| 2023-08-21 05:30:00 | AAPL | Stock | 175.08 | 175.08 | 175.0 | 175.08 | 7335.0 |
| 2023-08-21 06:00:00 | AAPL | Stock | 175.1 | 175.25 | 175.05 | 175.06 | 6610.0 |
| 2023-08-21 06:30:00 | AAPL | Stock | 175.08 | 175.2 | 175.0 | 175.04 | 22309.0 |
| 2023-08-21 07:00:00 | AAPL | Stock | 175.1 | 175.21 | 175.02 | 175.16 | 17265.0 |
| 2023-08-21 07:30:00 | AAPL | Stock | 175.2 | 175.42 | 175.19 | 175.42 | 13306.0 |
| 2023-08-21 08:00:00 | AAPL | Stock | 175.2176 | 175.49 | 174.57 | 175.45 | 87431.0 |
| 2023-08-21 08:30:00 | AAPL | Stock | 175.4 | 175.44 | 175.16 | 175.19 | 49397.0 |
| 2023-08-21 09:00:00 | AAPL | Stock | 175.23 | 175.4 | 175.02 | 175.05 | 116772.0 |
| 2023-08-21 09:30:00 | AAPL | Stock | 175.1 | 175.4 | 174.35 | 175.4 | 4261959.0 |
| 2023-08-21 10:00:00 | AAPL | Stock | 175.4 | 175.57 | 173.95 | 174.02 | 3362943.0 |
| 2023-08-21 10:30:00 | AAPL | Stock | 174.03 | 174.62 | 173.92 | 174.24 | 2103697.0 |
| 2023-08-21 11:00:00 | AAPL | Stock | 174.24 | 174.47 | 173.735 | 173.99 | 1892500.0 |
| 2023-08-21 11:30:00 | AAPL | Stock | 173.99 | 174.24 | 173.8601 | 174.1501 | 1586703.0 |
| 2023-08-21 12:00:00 | AAPL | Stock | 174.14 | 174.82 | 174.05 | 174.775 | 1667909.0 |
| 2023-08-21 12:30:00 | AAPL | Stock | 174.78 | 175.14 | 174.68 | 175.073 | 1641934.0 |
| 2023-08-21 13:00:00 | AAPL | Stock | 175.08 | 175.525 | 174.86 | 175.36 | 1668248.0 |
| 2023-08-21 13:30:00 | AAPL | Stock | 175.3573 | 175.61 | 175.18 | 175.25 | 1454859.0 |
| 2023-08-21 14:00:00 | AAPL | Stock | 175.25 | 175.75 | 175.12 | 175.54 | 1334203.0 |
| 2023-08-21 14:30:00 | AAPL | Stock | 175.55 | 175.91 | 175.4729 | 175.655 | 1468742.0 |
| 2023-08-21 15:00:00 | AAPL | Stock | 175.66 | 175.9782 | 175.65 | 175.74 | 1878270.0 |
| 2023-08-21 15:30:00 | AAPL | Stock | 175.74 | 176.13 | 175.64 | 175.8 | 3972916.0 |
| 2023-08-21 16:00:00 | AAPL | Stock | 175.84 | 175.84 | 175.5 | 175.6 | 9168102.0 |
| 2023-08-21 16:30:00 | AAPL | Stock | 175.6012 | 175.84 | 175.51 | 175.51 | 56409.0 |
| 2023-08-21 17:00:00 | AAPL | Stock | 175.53 | 175.64 | 175.53 | 175.53 | 12558.0 |
| 2023-08-21 17:30:00 | AAPL | Stock | 175.6296 | 175.63 | 175.55 | 175.6 | 4335.0 |
| 2023-08-21 18:00:00 | AAPL | Stock | 175.6 | 175.6 | 175.5 | 175.56 | 16252.0 |
| 2023-08-21 18:30:00 | AAPL | Stock | 175.5101 | 175.58 | 175.5 | 175.55 | 12356.0 |
| 2023-08-21 19:00:00 | AAPL | Stock | 175.54 | 175.55 | 175.51 | 175.51 | 11600.0 |
| 2023-08-21 19:30:00 | AAPL | Stock | 175.55 | 175.62 | 175.4 | 175.4 | 22576.0 |
| 2023-08-21 04:00:00 | MSFT | Stock | 317.5 | 318.0 | 317.5 | 318.0 | 3637.0 |
| 2023-08-21 04:30:00 | MSFT | Stock | 318.16 | 318.16 | 318.16 | 318.16 | 575.0 |
| 2023-08-21 05:00:00 | MSFT | Stock | 318.19 | 318.38 | 318.03 | 318.28 | 1474.0 |
| 2023-08-21 05:30:00 | MSFT | Stock | 318.1 | 318.35 | 318.1 | 318.32 | 325.0 |
| 2023-08-21 06:00:00 | MSFT | Stock | 318.35 | 318.4 | 318.25 | 318.25 | 1536.0 |
| 2023-08-21 06:30:00 | MSFT | Stock | 317.88 | 317.88 | 317.79 | 317.8 | 1115.0 |
| 2023-08-21 07:00:00 | MSFT | Stock | 317.71 | 318.35 | 317.71 | 318.21 | 9839.0 |
| 2023-08-21 07:30:00 | MSFT | Stock | 318.21 | 318.38 | 318.2 | 318.35 | 1240.0 |
| 2023-08-21 08:00:00 | MSFT | Stock | 317.9537 | 318.5 | 316.42 | 317.9051 | 26105.0 |
| 2023-08-21 08:30:00 | MSFT | Stock | 317.92 | 318.05 | 317.4104 | 317.4104 | 7243.0 |
| 2023-08-21 09:00:00 | MSFT | Stock | 317.6279 | 317.88 | 316.95 | 317.88 | 18999.0 |
| 2023-08-21 09:30:00 | MSFT | Stock | 317.93 | 319.94 | 317.04 | 319.92 | 1437782.0 |
| 2023-08-21 10:00:00 | MSFT | Stock | 319.893 | 321.055 | 317.8562 | 318.07 | 1255919.0 |
| 2023-08-21 10:30:00 | MSFT | Stock | 318.02 | 319.43 | 317.77 | 318.76 | 768661.0 |
| 2023-08-21 11:00:00 | MSFT | Stock | 318.8 | 319.4 | 317.6101 | 317.75 | 559691.0 |
| 2023-08-21 11:30:00 | MSFT | Stock | 317.73 | 318.75 | 317.66 | 318.35 | 489022.0 |
| 2023-08-21 12:00:00 | MSFT | Stock | 318.28 | 319.91 | 318.1 | 319.855 | 420854.0 |
| 2023-08-21 12:30:00 | MSFT | Stock | 319.86 | 321.0 | 319.72 | 320.91 | 586716.0 |
> showing 50 of 98,719 rows — these rows as CSV