PREVIEW / stock_30min / 2001-01-24
file: by_date/stock_30min/2001/2001-01-24.parquet size: 457 KB rows: 26,555 symbols: 1,268
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 |
|---|---|---|---|---|---|---|---|
| 2001-01-24 08:00:00 | AAPL | Stock | 0.3761 | 0.3828 | 0.375 | 0.3772 | 744800.0 |
| 2001-01-24 08:30:00 | AAPL | Stock | 0.3772 | 0.3783 | 0.375 | 0.375 | 1674400.0 |
| 2001-01-24 09:00:00 | AAPL | Stock | 0.375 | 0.375 | 0.3694 | 0.3694 | 4244800.0 |
| 2001-01-24 09:30:00 | AAPL | Stock | 0.3683 | 0.3694 | 0.3616 | 0.3661 | 121917600.0 |
| 2001-01-24 10:00:00 | AAPL | Stock | 0.365 | 0.3661 | 0.3605 | 0.3616 | 55792800.0 |
| 2001-01-24 10:30:00 | AAPL | Stock | 0.3627 | 0.365 | 0.3594 | 0.365 | 32900000.0 |
| 2001-01-24 11:00:00 | AAPL | Stock | 0.365 | 0.3672 | 0.3594 | 0.3605 | 36075200.0 |
| 2001-01-24 11:30:00 | AAPL | Stock | 0.3605 | 0.3616 | 0.3549 | 0.356 | 69288800.0 |
| 2001-01-24 12:00:00 | AAPL | Stock | 0.356 | 0.3583 | 0.3527 | 0.356 | 33891200.0 |
| 2001-01-24 12:30:00 | AAPL | Stock | 0.3571 | 0.3594 | 0.3527 | 0.3549 | 30598400.0 |
| 2001-01-24 13:00:00 | AAPL | Stock | 0.3538 | 0.356 | 0.3527 | 0.3555 | 30206400.0 |
| 2001-01-24 13:30:00 | AAPL | Stock | 0.3549 | 0.356 | 0.3493 | 0.3527 | 27787200.0 |
| 2001-01-24 14:00:00 | AAPL | Stock | 0.3527 | 0.3594 | 0.3516 | 0.3549 | 25183200.0 |
| 2001-01-24 14:30:00 | AAPL | Stock | 0.3549 | 0.3577 | 0.3538 | 0.3549 | 11558400.0 |
| 2001-01-24 15:00:00 | AAPL | Stock | 0.356 | 0.3638 | 0.3549 | 0.3605 | 45057600.0 |
| 2001-01-24 15:30:00 | AAPL | Stock | 0.3616 | 0.3672 | 0.3594 | 0.3672 | 75493600.0 |
| 2001-01-24 16:00:00 | AAPL | Stock | 0.3661 | 0.3705 | 0.3588 | 0.3616 | 7565600.0 |
| 2001-01-24 16:30:00 | AAPL | Stock | 0.3661 | 0.3661 | 0.3638 | 0.3638 | 240800.0 |
| 2001-01-24 17:00:00 | AAPL | Stock | 0.3638 | 0.3661 | 0.3638 | 0.365 | 39200.0 |
| 2001-01-24 17:30:00 | AAPL | Stock | 0.3627 | 0.365 | 0.3627 | 0.365 | 33600.0 |
| 2001-01-24 18:00:00 | AAPL | Stock | 0.365 | 0.365 | 0.3627 | 0.3627 | 22400.0 |
| 2001-01-24 08:00:00 | MSFT | Stock | 30.8125 | 30.9688 | 30.5 | 30.6875 | 59600.0 |
| 2001-01-24 08:30:00 | MSFT | Stock | 30.6875 | 30.8438 | 30.625 | 30.625 | 88800.0 |
| 2001-01-24 09:00:00 | MSFT | Stock | 30.625 | 30.75 | 30.4375 | 30.5 | 475600.0 |
| 2001-01-24 09:30:00 | MSFT | Stock | 30.5 | 30.9688 | 30.4375 | 30.9375 | 10992800.0 |
| 2001-01-24 10:00:00 | MSFT | Stock | 30.9375 | 31.1562 | 30.8438 | 31.0938 | 10424600.0 |
| 2001-01-24 10:30:00 | MSFT | Stock | 31.0938 | 31.4375 | 31.0 | 31.2812 | 10246800.0 |
| 2001-01-24 11:00:00 | MSFT | Stock | 31.2812 | 31.5938 | 31.25 | 31.4688 | 9265000.0 |
| 2001-01-24 11:30:00 | MSFT | Stock | 31.4688 | 31.6562 | 31.375 | 31.5 | 6248200.0 |
| 2001-01-24 12:00:00 | MSFT | Stock | 31.5 | 31.5312 | 31.125 | 31.2812 | 5795000.0 |
| 2001-01-24 12:30:00 | MSFT | Stock | 31.2812 | 31.5312 | 31.2188 | 31.4375 | 5585800.0 |
| 2001-01-24 13:00:00 | MSFT | Stock | 31.4688 | 31.4688 | 31.1875 | 31.25 | 5969000.0 |
| 2001-01-24 13:30:00 | MSFT | Stock | 31.25 | 31.3125 | 31.0938 | 31.2812 | 3802000.0 |
| 2001-01-24 14:00:00 | MSFT | Stock | 31.2812 | 31.5 | 31.25 | 31.375 | 3460600.0 |
| 2001-01-24 14:30:00 | MSFT | Stock | 31.3438 | 31.5312 | 31.3125 | 31.5 | 3642800.0 |
| 2001-01-24 15:00:00 | MSFT | Stock | 31.5 | 31.7188 | 31.3125 | 31.4062 | 8493200.0 |
| 2001-01-24 15:30:00 | MSFT | Stock | 31.375 | 31.625 | 31.2812 | 31.4062 | 8215400.0 |
| 2001-01-24 16:00:00 | MSFT | Stock | 31.4688 | 31.5156 | 31.1094 | 31.375 | 2163000.0 |
| 2001-01-24 16:30:00 | MSFT | Stock | 31.4375 | 31.4688 | 31.3438 | 31.3438 | 4126400.0 |
| 2001-01-24 17:00:00 | MSFT | Stock | 31.3438 | 31.4062 | 31.0625 | 31.3125 | 11400.0 |
| 2001-01-24 17:30:00 | MSFT | Stock | 31.3438 | 31.375 | 31.3125 | 31.375 | 8600.0 |
| 2001-01-24 18:00:00 | MSFT | Stock | 31.375 | 31.4062 | 31.375 | 31.4062 | 1800.0 |
| 2001-01-24 08:00:00 | NVDA | Stock | 0.2292 | 0.2292 | 0.2286 | 0.2286 | 120000.0 |
| 2001-01-24 09:00:00 | NVDA | Stock | 0.2284 | 0.2294 | 0.2271 | 0.2284 | 888000.0 |
| 2001-01-24 09:30:00 | NVDA | Stock | 0.2289 | 0.2313 | 0.2214 | 0.225 | 43368000.0 |
| 2001-01-24 10:00:00 | NVDA | Stock | 0.2253 | 0.2258 | 0.2188 | 0.2193 | 17712000.0 |
| 2001-01-24 10:30:00 | NVDA | Stock | 0.2193 | 0.2193 | 0.2148 | 0.2177 | 33840000.0 |
| 2001-01-24 11:00:00 | NVDA | Stock | 0.2177 | 0.2247 | 0.2167 | 0.2243 | 36024000.0 |
| 2001-01-24 11:30:00 | NVDA | Stock | 0.224 | 0.2242 | 0.219 | 0.2219 | 29376000.0 |
| 2001-01-24 12:00:00 | NVDA | Stock | 0.2214 | 0.2229 | 0.2188 | 0.2208 | 31776000.0 |
> showing 50 of 26,555 rows — these rows as CSV