PREVIEW / stock_30min / 2024-04-30
file: by_date/stock_30min/2024/2024-04-30.parquet size: 2.0 MB rows: 97,988 symbols: 981
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-04-30 04:00:00 | AAPL | Stock | 173.22 | 173.97 | 173.12 | 173.85 | 9779.0 |
| 2024-04-30 04:30:00 | AAPL | Stock | 173.95 | 174.06 | 173.95 | 173.97 | 1752.0 |
| 2024-04-30 05:00:00 | AAPL | Stock | 173.95 | 174.09 | 173.95 | 174.05 | 3468.0 |
| 2024-04-30 05:30:00 | AAPL | Stock | 174.08 | 174.5 | 174.08 | 174.2 | 13319.0 |
| 2024-04-30 06:00:00 | AAPL | Stock | 174.36 | 174.4 | 174.3 | 174.31 | 7136.0 |
| 2024-04-30 06:30:00 | AAPL | Stock | 174.31 | 174.34 | 174.23 | 174.23 | 4467.0 |
| 2024-04-30 07:00:00 | AAPL | Stock | 174.22 | 174.22 | 173.84 | 173.93 | 13568.0 |
| 2024-04-30 07:30:00 | AAPL | Stock | 173.87 | 173.94 | 173.75 | 173.75 | 2731.0 |
| 2024-04-30 08:00:00 | AAPL | Stock | 173.95 | 174.5 | 173.65 | 173.68 | 93447.0 |
| 2024-04-30 08:30:00 | AAPL | Stock | 173.65 | 173.65 | 172.79 | 173.28 | 83934.0 |
| 2024-04-30 09:00:00 | AAPL | Stock | 173.21 | 173.6 | 173.15 | 173.2 | 47782.0 |
| 2024-04-30 09:30:00 | AAPL | Stock | 173.2 | 174.74 | 172.65 | 174.46 | 4611667.0 |
| 2024-04-30 10:00:00 | AAPL | Stock | 174.46 | 174.99 | 174.24 | 174.43 | 2516797.0 |
| 2024-04-30 10:30:00 | AAPL | Stock | 174.425 | 174.95 | 174.025 | 174.16 | 2440697.0 |
| 2024-04-30 11:00:00 | AAPL | Stock | 174.17 | 174.4 | 173.72 | 173.865 | 2226624.0 |
| 2024-04-30 11:30:00 | AAPL | Stock | 173.8699 | 174.19 | 173.605 | 174.15 | 1481982.0 |
| 2024-04-30 12:00:00 | AAPL | Stock | 174.15 | 174.1999 | 173.67 | 173.8366 | 1146643.0 |
| 2024-04-30 12:30:00 | AAPL | Stock | 173.84 | 173.88 | 173.245 | 173.865 | 1626587.0 |
| 2024-04-30 13:00:00 | AAPL | Stock | 173.86 | 173.93 | 173.22 | 173.2753 | 1448798.0 |
| 2024-04-30 13:30:00 | AAPL | Stock | 173.305 | 173.75 | 173.1 | 173.68 | 1234542.0 |
| 2024-04-30 14:00:00 | AAPL | Stock | 173.68 | 173.8799 | 173.16 | 173.18 | 1327328.0 |
| 2024-04-30 14:30:00 | AAPL | Stock | 173.19 | 173.345 | 172.84 | 173.1223 | 1441175.0 |
| 2024-04-30 15:00:00 | AAPL | Stock | 173.1201 | 173.26 | 172.56 | 172.73 | 1857554.0 |
| 2024-04-30 15:30:00 | AAPL | Stock | 172.74 | 172.94 | 170.0 | 170.05 | 9906337.0 |
| 2024-04-30 16:00:00 | AAPL | Stock | 170.38 | 170.89 | 168.45 | 170.0 | 18198348.0 |
| 2024-04-30 16:30:00 | AAPL | Stock | 169.95 | 170.5 | 169.31 | 169.9 | 241461.0 |
| 2024-04-30 17:00:00 | AAPL | Stock | 169.89 | 169.93 | 169.6093 | 169.78 | 38377.0 |
| 2024-04-30 17:30:00 | AAPL | Stock | 169.8 | 170.0 | 169.6492 | 169.76 | 28325.0 |
| 2024-04-30 18:00:00 | AAPL | Stock | 169.93 | 170.3 | 169.75 | 170.0 | 42604.0 |
| 2024-04-30 18:30:00 | AAPL | Stock | 170.0195 | 170.33 | 170.0 | 170.28 | 30559.0 |
| 2024-04-30 19:00:00 | AAPL | Stock | 170.23 | 170.31 | 170.04 | 170.0997 | 11612.0 |
| 2024-04-30 19:30:00 | AAPL | Stock | 170.1 | 170.26 | 169.96 | 169.96 | 18752.0 |
| 2024-04-30 04:00:00 | MSFT | Stock | 402.3 | 402.3 | 401.65 | 401.65 | 1278.0 |
| 2024-04-30 04:30:00 | MSFT | Stock | 401.65 | 401.66 | 401.65 | 401.66 | 793.0 |
| 2024-04-30 05:00:00 | MSFT | Stock | 401.2 | 401.2 | 401.2 | 401.2 | 100.0 |
| 2024-04-30 05:30:00 | MSFT | Stock | 401.2 | 401.2 | 401.2 | 401.2 | 100.0 |
| 2024-04-30 06:00:00 | MSFT | Stock | 400.85 | 400.94 | 400.85 | 400.94 | 605.0 |
| 2024-04-30 06:30:00 | MSFT | Stock | 400.97 | 400.98 | 400.95 | 400.95 | 300.0 |
| 2024-04-30 07:00:00 | MSFT | Stock | 401.55 | 401.68 | 401.45 | 401.53 | 2469.0 |
| 2024-04-30 07:30:00 | MSFT | Stock | 401.51 | 401.51 | 401.35 | 401.41 | 1886.0 |
| 2024-04-30 08:00:00 | MSFT | Stock | 401.1736 | 402.34 | 400.91 | 401.03 | 9313.0 |
| 2024-04-30 08:30:00 | MSFT | Stock | 401.0 | 401.0 | 399.65 | 400.5 | 18610.0 |
| 2024-04-30 09:00:00 | MSFT | Stock | 400.38 | 401.59 | 400.2 | 401.24 | 15083.0 |
| 2024-04-30 09:30:00 | MSFT | Stock | 401.49 | 402.16 | 398.55 | 399.73 | 1598767.0 |
| 2024-04-30 10:00:00 | MSFT | Stock | 399.61 | 399.83 | 398.66 | 398.79 | 1038216.0 |
| 2024-04-30 10:30:00 | MSFT | Stock | 398.79 | 399.68 | 398.78 | 399.05 | 635405.0 |
| 2024-04-30 11:00:00 | MSFT | Stock | 399.04 | 399.04 | 396.66 | 396.8 | 1196872.0 |
| 2024-04-30 11:30:00 | MSFT | Stock | 396.8 | 397.582 | 396.4004 | 397.34 | 1218658.0 |
| 2024-04-30 12:00:00 | MSFT | Stock | 397.365 | 397.55 | 396.72 | 396.92 | 643203.0 |
| 2024-04-30 12:30:00 | MSFT | Stock | 396.93 | 396.93 | 394.8 | 395.37 | 667070.0 |
> showing 50 of 97,988 rows — these rows as CSV