PREVIEW / stock_30min / 2025-01-16
file: by_date/stock_30min/2025/2025-01-16.parquet size: 2.2 MB rows: 106,015 symbols: 585
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 |
|---|---|---|---|---|---|---|---|
| 2025-01-16 04:00:00 | AAPL | Stock | 240.4 | 241.41 | 239.53 | 239.53 | 22446.0 |
| 2025-01-16 04:30:00 | AAPL | Stock | 239.55 | 239.55 | 238.88 | 239.5 | 10773.0 |
| 2025-01-16 05:00:00 | AAPL | Stock | 239.28 | 239.65 | 239.14 | 239.59 | 2391.0 |
| 2025-01-16 05:30:00 | AAPL | Stock | 239.59 | 239.68 | 239.55 | 239.55 | 4378.0 |
| 2025-01-16 06:00:00 | AAPL | Stock | 239.55 | 239.61 | 239.5 | 239.53 | 2303.0 |
| 2025-01-16 06:30:00 | AAPL | Stock | 239.55 | 239.61 | 239.46 | 239.6 | 2281.0 |
| 2025-01-16 07:00:00 | AAPL | Stock | 239.58 | 239.6 | 238.93 | 238.96 | 14381.0 |
| 2025-01-16 07:30:00 | AAPL | Stock | 238.9 | 239.06 | 238.7 | 238.7 | 4472.0 |
| 2025-01-16 08:00:00 | AAPL | Stock | 239.16 | 241.41 | 238.0 | 238.82 | 67761.0 |
| 2025-01-16 08:30:00 | AAPL | Stock | 238.87 | 239.09 | 238.51 | 238.7 | 32784.0 |
| 2025-01-16 09:00:00 | AAPL | Stock | 238.77 | 238.82 | 237.07 | 237.32 | 144474.0 |
| 2025-01-16 09:30:00 | AAPL | Stock | 237.32 | 238.01 | 234.74 | 234.845 | 4379785.0 |
| 2025-01-16 10:00:00 | AAPL | Stock | 234.845 | 235.17 | 232.7 | 232.818 | 3555775.0 |
| 2025-01-16 10:30:00 | AAPL | Stock | 232.802 | 233.02 | 231.16 | 231.9601 | 4967663.0 |
| 2025-01-16 11:00:00 | AAPL | Stock | 231.965 | 232.3125 | 230.16 | 230.585 | 3920680.0 |
| 2025-01-16 11:30:00 | AAPL | Stock | 230.59 | 230.79 | 229.75 | 230.6854 | 3772942.0 |
| 2025-01-16 12:00:00 | AAPL | Stock | 230.68 | 231.1 | 230.38 | 230.92 | 2324604.0 |
| 2025-01-16 12:30:00 | AAPL | Stock | 230.92 | 231.2 | 230.45 | 230.46 | 1994262.0 |
| 2025-01-16 13:00:00 | AAPL | Stock | 230.48 | 230.67 | 229.07 | 229.19 | 2600202.0 |
| 2025-01-16 13:30:00 | AAPL | Stock | 229.185 | 229.265 | 228.62 | 229.0 | 2519765.0 |
| 2025-01-16 14:00:00 | AAPL | Stock | 228.98 | 229.4 | 228.56 | 229.175 | 1931636.0 |
| 2025-01-16 14:30:00 | AAPL | Stock | 229.175 | 229.93 | 228.99 | 229.86 | 2195842.0 |
| 2025-01-16 15:00:00 | AAPL | Stock | 229.855 | 230.0686 | 228.9 | 229.025 | 2615298.0 |
| 2025-01-16 15:30:00 | AAPL | Stock | 229.01 | 229.2918 | 228.03 | 228.24 | 7389592.0 |
| 2025-01-16 16:00:00 | AAPL | Stock | 228.26 | 228.26 | 227.7 | 228.17 | 8485905.0 |
| 2025-01-16 16:30:00 | AAPL | Stock | 228.15 | 228.3 | 227.8 | 228.3 | 226687.0 |
| 2025-01-16 17:00:00 | AAPL | Stock | 228.33 | 228.37 | 228.05 | 228.2 | 42607.0 |
| 2025-01-16 17:30:00 | AAPL | Stock | 228.2 | 228.314 | 228.2 | 228.24 | 19149.0 |
| 2025-01-16 18:00:00 | AAPL | Stock | 228.2091 | 228.65 | 228.2091 | 228.4 | 28893.0 |
| 2025-01-16 18:30:00 | AAPL | Stock | 228.41 | 228.48 | 228.23 | 228.47 | 20868.0 |
| 2025-01-16 19:00:00 | AAPL | Stock | 228.45 | 228.58 | 228.4 | 228.53 | 23524.0 |
| 2025-01-16 19:30:00 | AAPL | Stock | 228.569 | 228.569 | 228.3512 | 228.4 | 28653.0 |
| 2025-01-16 04:00:00 | MSFT | Stock | 429.99 | 429.99 | 428.01 | 428.01 | 15442.0 |
| 2025-01-16 04:30:00 | MSFT | Stock | 427.92 | 428.31 | 427.27 | 428.11 | 2587.0 |
| 2025-01-16 05:00:00 | MSFT | Stock | 427.8 | 428.6 | 427.37 | 428.6 | 1263.0 |
| 2025-01-16 05:30:00 | MSFT | Stock | 429.0 | 429.0 | 428.77 | 428.99 | 2354.0 |
| 2025-01-16 06:00:00 | MSFT | Stock | 428.95 | 429.0 | 428.33 | 428.73 | 1700.0 |
| 2025-01-16 06:30:00 | MSFT | Stock | 428.69 | 429.29 | 428.69 | 429.15 | 2539.0 |
| 2025-01-16 07:00:00 | MSFT | Stock | 428.97 | 429.25 | 427.47 | 427.5 | 8830.0 |
| 2025-01-16 07:30:00 | MSFT | Stock | 427.49 | 428.02 | 427.35 | 427.48 | 4023.0 |
| 2025-01-16 08:00:00 | MSFT | Stock | 428.71 | 430.29 | 426.74 | 427.29 | 27857.0 |
| 2025-01-16 08:30:00 | MSFT | Stock | 427.48 | 428.0 | 427.2 | 427.6 | 5731.0 |
| 2025-01-16 09:00:00 | MSFT | Stock | 427.75 | 428.93 | 427.0 | 428.9 | 12370.0 |
| 2025-01-16 09:30:00 | MSFT | Stock | 428.695 | 429.49 | 425.62 | 426.825 | 1414089.0 |
| 2025-01-16 10:00:00 | MSFT | Stock | 426.825 | 428.1627 | 425.02 | 426.135 | 633869.0 |
| 2025-01-16 10:30:00 | MSFT | Stock | 426.09 | 427.6257 | 425.87 | 427.4099 | 411845.0 |
| 2025-01-16 11:00:00 | MSFT | Stock | 427.4 | 428.22 | 426.325 | 427.07 | 493748.0 |
| 2025-01-16 11:30:00 | MSFT | Stock | 427.075 | 427.35 | 426.03 | 427.26 | 247445.0 |
| 2025-01-16 12:00:00 | MSFT | Stock | 427.19 | 427.44 | 426.48 | 427.34 | 273130.0 |
| 2025-01-16 12:30:00 | MSFT | Stock | 427.35 | 427.46 | 426.7334 | 426.91 | 201436.0 |
> showing 50 of 106,015 rows — these rows as CSV