PREVIEW / stock_30min / 2024-09-16
file: by_date/stock_30min/2024/2024-09-16.parquet size: 2.0 MB rows: 99,573 symbols: 824
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-09-16 04:00:00 | AAPL | Stock | 222.2 | 222.2 | 219.35 | 219.5 | 45284.0 |
| 2024-09-16 04:30:00 | AAPL | Stock | 219.4 | 219.5 | 218.34 | 219.21 | 14364.0 |
| 2024-09-16 05:00:00 | AAPL | Stock | 219.16 | 219.17 | 218.52 | 218.96 | 19793.0 |
| 2024-09-16 05:30:00 | AAPL | Stock | 218.88 | 219.0 | 218.5 | 218.82 | 13422.0 |
| 2024-09-16 06:00:00 | AAPL | Stock | 218.75 | 218.9 | 217.71 | 217.9 | 32762.0 |
| 2024-09-16 06:30:00 | AAPL | Stock | 217.81 | 218.25 | 217.58 | 218.2 | 65435.0 |
| 2024-09-16 07:00:00 | AAPL | Stock | 218.25 | 218.6 | 217.0 | 217.18 | 164344.0 |
| 2024-09-16 07:30:00 | AAPL | Stock | 217.25 | 217.65 | 216.93 | 217.0 | 125678.0 |
| 2024-09-16 08:00:00 | AAPL | Stock | 217.0 | 221.96 | 216.75 | 217.0 | 274274.0 |
| 2024-09-16 08:30:00 | AAPL | Stock | 217.0 | 217.24 | 216.82 | 217.015 | 228553.0 |
| 2024-09-16 09:00:00 | AAPL | Stock | 217.0 | 217.15 | 216.12 | 216.44 | 487961.0 |
| 2024-09-16 09:30:00 | AAPL | Stock | 216.52 | 216.81 | 213.92 | 215.195 | 11179218.0 |
| 2024-09-16 10:00:00 | AAPL | Stock | 215.18 | 217.22 | 215.14 | 216.66 | 4486644.0 |
| 2024-09-16 10:30:00 | AAPL | Stock | 216.6401 | 216.92 | 215.02 | 215.3 | 3328234.0 |
| 2024-09-16 11:00:00 | AAPL | Stock | 215.29 | 216.58 | 214.84 | 216.5565 | 3039320.0 |
| 2024-09-16 11:30:00 | AAPL | Stock | 216.55 | 216.58 | 215.495 | 215.955 | 1784789.0 |
| 2024-09-16 12:00:00 | AAPL | Stock | 215.97 | 216.05 | 214.91 | 215.4 | 1897744.0 |
| 2024-09-16 12:30:00 | AAPL | Stock | 215.39 | 215.71 | 214.9201 | 215.59 | 1522123.0 |
| 2024-09-16 13:00:00 | AAPL | Stock | 215.59 | 215.98 | 215.52 | 215.965 | 1288545.0 |
| 2024-09-16 13:30:00 | AAPL | Stock | 215.96 | 216.4 | 215.75 | 216.21 | 1476310.0 |
| 2024-09-16 14:00:00 | AAPL | Stock | 216.215 | 216.52 | 216.11 | 216.43 | 1182339.0 |
| 2024-09-16 14:30:00 | AAPL | Stock | 216.425 | 216.45 | 215.98 | 216.4 | 1400199.0 |
| 2024-09-16 15:00:00 | AAPL | Stock | 216.405 | 216.4668 | 215.92 | 216.225 | 1637059.0 |
| 2024-09-16 15:30:00 | AAPL | Stock | 216.225 | 216.7 | 216.18 | 216.3 | 3868964.0 |
| 2024-09-16 16:00:00 | AAPL | Stock | 216.32 | 216.32 | 216.17 | 216.29 | 5984022.0 |
| 2024-09-16 16:30:00 | AAPL | Stock | 216.25 | 216.32 | 216.0 | 216.1 | 784353.0 |
| 2024-09-16 17:00:00 | AAPL | Stock | 216.09 | 216.32 | 216.0 | 216.0499 | 109932.0 |
| 2024-09-16 17:30:00 | AAPL | Stock | 216.02 | 216.09 | 216.0 | 216.0376 | 15617.0 |
| 2024-09-16 18:00:00 | AAPL | Stock | 216.002 | 216.1786 | 216.0 | 216.0514 | 18103.0 |
| 2024-09-16 18:30:00 | AAPL | Stock | 216.1 | 216.174 | 216.06 | 216.1308 | 6443.0 |
| 2024-09-16 19:00:00 | AAPL | Stock | 216.155 | 216.2 | 216.13 | 216.15 | 14080.0 |
| 2024-09-16 19:30:00 | AAPL | Stock | 216.15 | 216.25 | 216.1025 | 216.249 | 23488.0 |
| 2024-09-16 04:00:00 | MSFT | Stock | 431.35 | 431.43 | 431.22 | 431.22 | 544.0 |
| 2024-09-16 04:30:00 | MSFT | Stock | 431.27 | 431.27 | 430.6 | 431.0 | 507.0 |
| 2024-09-16 05:00:00 | MSFT | Stock | 431.35 | 431.35 | 431.2 | 431.2 | 200.0 |
| 2024-09-16 05:30:00 | MSFT | Stock | 431.49 | 431.49 | 431.49 | 431.49 | 160.0 |
| 2024-09-16 06:00:00 | MSFT | Stock | 430.12 | 430.62 | 430.0 | 430.29 | 1000.0 |
| 2024-09-16 06:30:00 | MSFT | Stock | 430.07 | 430.07 | 429.92 | 429.92 | 2104.0 |
| 2024-09-16 07:00:00 | MSFT | Stock | 429.81 | 430.78 | 429.81 | 430.15 | 3699.0 |
| 2024-09-16 07:30:00 | MSFT | Stock | 429.88 | 430.1 | 429.7 | 430.01 | 1730.0 |
| 2024-09-16 08:00:00 | MSFT | Stock | 430.55 | 430.66 | 429.1063 | 429.5 | 13439.0 |
| 2024-09-16 08:30:00 | MSFT | Stock | 429.1 | 429.75 | 429.0058 | 429.7 | 3234.0 |
| 2024-09-16 09:00:00 | MSFT | Stock | 429.87 | 430.61 | 429.5586 | 430.6 | 7404.0 |
| 2024-09-16 09:30:00 | MSFT | Stock | 430.59 | 433.53 | 428.22 | 432.145 | 1438090.0 |
| 2024-09-16 10:00:00 | MSFT | Stock | 431.98 | 432.64 | 430.66 | 431.145 | 555690.0 |
| 2024-09-16 10:30:00 | MSFT | Stock | 431.13 | 431.146 | 429.44 | 429.79 | 741827.0 |
| 2024-09-16 11:00:00 | MSFT | Stock | 429.81 | 431.86 | 428.92 | 431.07 | 705617.0 |
| 2024-09-16 11:30:00 | MSFT | Stock | 431.065 | 431.18 | 429.245 | 430.0 | 468020.0 |
| 2024-09-16 12:00:00 | MSFT | Stock | 430.02 | 430.11 | 428.82 | 429.737 | 389344.0 |
| 2024-09-16 12:30:00 | MSFT | Stock | 429.7001 | 429.98 | 429.15 | 429.81 | 285266.0 |
> showing 50 of 99,573 rows — these rows as CSV