PREVIEW / stock_30min / 2024-08-08
file: by_date/stock_30min/2024/2024-08-08.parquet size: 2.0 MB rows: 98,500 symbols: 864
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-08-08 04:00:00 | AAPL | Stock | 209.75 | 209.75 | 208.95 | 209.12 | 6448.0 |
| 2024-08-08 04:30:00 | AAPL | Stock | 209.2 | 209.8 | 209.19 | 209.8 | 10079.0 |
| 2024-08-08 05:00:00 | AAPL | Stock | 209.8 | 210.05 | 209.64 | 209.65 | 2826.0 |
| 2024-08-08 05:30:00 | AAPL | Stock | 209.73 | 209.77 | 209.2 | 209.37 | 1510.0 |
| 2024-08-08 06:00:00 | AAPL | Stock | 209.46 | 209.84 | 209.16 | 209.68 | 8222.0 |
| 2024-08-08 06:30:00 | AAPL | Stock | 209.65 | 209.66 | 209.49 | 209.61 | 10013.0 |
| 2024-08-08 07:00:00 | AAPL | Stock | 209.4 | 210.18 | 209.4 | 209.85 | 15776.0 |
| 2024-08-08 07:30:00 | AAPL | Stock | 209.85 | 210.04 | 209.66 | 209.76 | 6770.0 |
| 2024-08-08 08:00:00 | AAPL | Stock | 209.5 | 211.41 | 208.69 | 209.51 | 36716.0 |
| 2024-08-08 08:30:00 | AAPL | Stock | 209.64 | 212.327 | 209.64 | 211.6 | 161766.0 |
| 2024-08-08 09:00:00 | AAPL | Stock | 211.54 | 213.17 | 211.4 | 213.01 | 152787.0 |
| 2024-08-08 09:30:00 | AAPL | Stock | 213.11 | 213.21 | 208.83 | 210.73 | 4569108.0 |
| 2024-08-08 10:00:00 | AAPL | Stock | 210.67 | 212.64 | 210.5092 | 212.56 | 2898710.0 |
| 2024-08-08 10:30:00 | AAPL | Stock | 212.58 | 212.99 | 211.96 | 212.19 | 1810341.0 |
| 2024-08-08 11:00:00 | AAPL | Stock | 212.19 | 212.38 | 211.08 | 212.2 | 2035616.0 |
| 2024-08-08 11:30:00 | AAPL | Stock | 212.21 | 212.68 | 211.71 | 212.39 | 1444725.0 |
| 2024-08-08 12:00:00 | AAPL | Stock | 212.37 | 213.46 | 212.2325 | 213.25 | 2184590.0 |
| 2024-08-08 12:30:00 | AAPL | Stock | 213.265 | 213.47 | 212.5 | 213.175 | 1464605.0 |
| 2024-08-08 13:00:00 | AAPL | Stock | 213.22 | 214.0 | 212.6301 | 213.8976 | 1577168.0 |
| 2024-08-08 13:30:00 | AAPL | Stock | 213.9 | 214.2 | 213.43 | 213.68 | 1317635.0 |
| 2024-08-08 14:00:00 | AAPL | Stock | 213.67 | 213.84 | 212.7075 | 212.98 | 1239175.0 |
| 2024-08-08 14:30:00 | AAPL | Stock | 212.9959 | 213.43 | 212.6 | 212.915 | 1219737.0 |
| 2024-08-08 15:00:00 | AAPL | Stock | 212.91 | 213.415 | 212.11 | 212.1301 | 1826944.0 |
| 2024-08-08 15:30:00 | AAPL | Stock | 212.14 | 213.52 | 211.87 | 213.34 | 3619481.0 |
| 2024-08-08 16:00:00 | AAPL | Stock | 213.31 | 214.0 | 213.23 | 213.78 | 7191290.0 |
| 2024-08-08 16:30:00 | AAPL | Stock | 213.79 | 213.79 | 213.31 | 213.54 | 80467.0 |
| 2024-08-08 17:00:00 | AAPL | Stock | 213.5016 | 213.54 | 213.31 | 213.3996 | 442068.0 |
| 2024-08-08 17:30:00 | AAPL | Stock | 213.4 | 213.4675 | 213.2304 | 213.3534 | 2939.0 |
| 2024-08-08 18:00:00 | AAPL | Stock | 213.4 | 213.77 | 213.33 | 213.51 | 6253.0 |
| 2024-08-08 18:30:00 | AAPL | Stock | 213.6 | 213.61 | 213.41 | 213.465 | 8317.0 |
| 2024-08-08 19:00:00 | AAPL | Stock | 213.5 | 214.0 | 213.5 | 213.78 | 10713.0 |
| 2024-08-08 19:30:00 | AAPL | Stock | 213.6 | 214.0 | 213.6 | 213.9482 | 10733.0 |
| 2024-08-08 04:00:00 | MSFT | Stock | 397.28 | 397.84 | 396.99 | 397.44 | 3406.0 |
| 2024-08-08 04:30:00 | MSFT | Stock | 397.74 | 398.99 | 397.74 | 398.77 | 947.0 |
| 2024-08-08 05:00:00 | MSFT | Stock | 399.65 | 399.83 | 398.89 | 398.89 | 1700.0 |
| 2024-08-08 05:30:00 | MSFT | Stock | 398.88 | 399.53 | 398.08 | 398.34 | 2239.0 |
| 2024-08-08 06:00:00 | MSFT | Stock | 398.89 | 399.52 | 398.41 | 399.41 | 845.0 |
| 2024-08-08 06:30:00 | MSFT | Stock | 399.4 | 399.73 | 399.1 | 399.1 | 2496.0 |
| 2024-08-08 07:00:00 | MSFT | Stock | 398.81 | 399.1 | 398.1 | 399.1 | 10753.0 |
| 2024-08-08 07:30:00 | MSFT | Stock | 398.83 | 399.28 | 398.81 | 399.1 | 3178.0 |
| 2024-08-08 08:00:00 | MSFT | Stock | 399.02 | 399.82 | 397.58 | 399.51 | 35690.0 |
| 2024-08-08 08:30:00 | MSFT | Stock | 399.9 | 403.39 | 399.9 | 402.45 | 55799.0 |
| 2024-08-08 09:00:00 | MSFT | Stock | 402.12 | 404.4604 | 402.12 | 402.44 | 36661.0 |
| 2024-08-08 09:30:00 | MSFT | Stock | 402.45 | 403.01 | 399.9407 | 402.74 | 1137601.0 |
| 2024-08-08 10:00:00 | MSFT | Stock | 402.805 | 405.69 | 402.19 | 405.45 | 818258.0 |
| 2024-08-08 10:30:00 | MSFT | Stock | 405.445 | 405.86 | 404.15 | 404.39 | 688186.0 |
| 2024-08-08 11:00:00 | MSFT | Stock | 404.38 | 404.43 | 402.29 | 403.225 | 799994.0 |
| 2024-08-08 11:30:00 | MSFT | Stock | 403.23 | 403.77 | 402.1 | 403.59 | 441428.0 |
| 2024-08-08 12:00:00 | MSFT | Stock | 403.5 | 404.75 | 402.73 | 402.794 | 386968.0 |
| 2024-08-08 12:30:00 | MSFT | Stock | 402.8 | 402.93 | 401.17 | 402.55 | 373151.0 |
> showing 50 of 98,500 rows — these rows as CSV