PREVIEW / stock_30min / 2001-01-18
file: by_date/stock_30min/2001/2001-01-18.parquet size: 470 KB rows: 27,813 symbols: 1,273
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-18 08:00:00 | AAPL | Stock | 0.3036 | 0.3192 | 0.3036 | 0.3158 | 3466400.0 |
| 2001-01-18 08:30:00 | AAPL | Stock | 0.3158 | 0.317 | 0.3125 | 0.3158 | 4883200.0 |
| 2001-01-18 09:00:00 | AAPL | Stock | 0.3158 | 0.3181 | 0.3092 | 0.3181 | 15814400.0 |
| 2001-01-18 09:30:00 | AAPL | Stock | 0.3181 | 0.3203 | 0.3147 | 0.3192 | 164931200.0 |
| 2001-01-18 10:00:00 | AAPL | Stock | 0.3181 | 0.3231 | 0.3181 | 0.3225 | 135721600.0 |
| 2001-01-18 10:30:00 | AAPL | Stock | 0.3214 | 0.3259 | 0.3214 | 0.3237 | 101108000.0 |
| 2001-01-18 11:00:00 | AAPL | Stock | 0.3248 | 0.3248 | 0.3203 | 0.3214 | 102379200.0 |
| 2001-01-18 11:30:00 | AAPL | Stock | 0.3214 | 0.3237 | 0.3203 | 0.3225 | 41322400.0 |
| 2001-01-18 12:00:00 | AAPL | Stock | 0.3225 | 0.3237 | 0.3203 | 0.3214 | 32782400.0 |
| 2001-01-18 12:30:00 | AAPL | Stock | 0.3214 | 0.3237 | 0.3181 | 0.3203 | 52231200.0 |
| 2001-01-18 13:00:00 | AAPL | Stock | 0.3214 | 0.3225 | 0.3203 | 0.3225 | 41176800.0 |
| 2001-01-18 13:30:00 | AAPL | Stock | 0.3225 | 0.3248 | 0.3214 | 0.3237 | 42498400.0 |
| 2001-01-18 14:00:00 | AAPL | Stock | 0.3237 | 0.327 | 0.3225 | 0.327 | 51833600.0 |
| 2001-01-18 14:30:00 | AAPL | Stock | 0.327 | 0.3292 | 0.3259 | 0.3259 | 65352000.0 |
| 2001-01-18 15:00:00 | AAPL | Stock | 0.327 | 0.3304 | 0.3259 | 0.3292 | 55641600.0 |
| 2001-01-18 15:30:00 | AAPL | Stock | 0.3292 | 0.3348 | 0.3281 | 0.3348 | 151502400.0 |
| 2001-01-18 16:00:00 | AAPL | Stock | 0.3343 | 0.3404 | 0.3225 | 0.3376 | 14924000.0 |
| 2001-01-18 16:30:00 | AAPL | Stock | 0.3376 | 0.3404 | 0.3225 | 0.3404 | 3841600.0 |
| 2001-01-18 17:00:00 | AAPL | Stock | 0.3393 | 0.3415 | 0.3337 | 0.3393 | 1108800.0 |
| 2001-01-18 17:30:00 | AAPL | Stock | 0.3404 | 0.3415 | 0.3393 | 0.3404 | 425600.0 |
| 2001-01-18 18:00:00 | AAPL | Stock | 0.3404 | 0.3415 | 0.3393 | 0.3404 | 425600.0 |
| 2001-01-18 08:00:00 | MSFT | Stock | 26.875 | 26.875 | 26.4375 | 26.625 | 76000.0 |
| 2001-01-18 08:30:00 | MSFT | Stock | 26.75 | 26.7812 | 26.4375 | 26.6562 | 107000.0 |
| 2001-01-18 09:00:00 | MSFT | Stock | 26.5312 | 27.0 | 26.5 | 26.8438 | 638600.0 |
| 2001-01-18 09:30:00 | MSFT | Stock | 26.8438 | 26.875 | 26.375 | 26.4062 | 8450000.0 |
| 2001-01-18 10:00:00 | MSFT | Stock | 26.4062 | 26.8438 | 26.3125 | 26.625 | 4777200.0 |
| 2001-01-18 10:30:00 | MSFT | Stock | 26.625 | 27.2188 | 26.5938 | 27.1562 | 5872200.0 |
| 2001-01-18 11:00:00 | MSFT | Stock | 27.1562 | 27.5 | 27.1562 | 27.4062 | 9176200.0 |
| 2001-01-18 11:30:00 | MSFT | Stock | 27.375 | 27.625 | 27.3125 | 27.5625 | 6681600.0 |
| 2001-01-18 12:00:00 | MSFT | Stock | 27.5 | 27.6875 | 27.4375 | 27.625 | 6016200.0 |
| 2001-01-18 12:30:00 | MSFT | Stock | 27.625 | 27.875 | 27.625 | 27.8438 | 6314800.0 |
| 2001-01-18 13:00:00 | MSFT | Stock | 27.8438 | 27.9375 | 27.8125 | 27.8125 | 4680200.0 |
| 2001-01-18 13:30:00 | MSFT | Stock | 27.8438 | 27.875 | 27.625 | 27.875 | 5540000.0 |
| 2001-01-18 14:00:00 | MSFT | Stock | 27.875 | 28.0938 | 27.7812 | 27.9375 | 8539800.0 |
| 2001-01-18 14:30:00 | MSFT | Stock | 27.9062 | 28.0 | 27.7188 | 27.8438 | 4698600.0 |
| 2001-01-18 15:00:00 | MSFT | Stock | 27.8125 | 28.0312 | 27.8125 | 27.8438 | 5911800.0 |
| 2001-01-18 15:30:00 | MSFT | Stock | 27.875 | 27.9688 | 27.7188 | 27.7812 | 8612400.0 |
| 2001-01-18 16:00:00 | MSFT | Stock | 27.7969 | 28.75 | 27.3438 | 28.625 | 4916200.0 |
| 2001-01-18 16:30:00 | MSFT | Stock | 28.625 | 29.125 | 27.7344 | 29.0 | 5694600.0 |
| 2001-01-18 17:00:00 | MSFT | Stock | 29.0625 | 29.5938 | 27.75 | 29.3438 | 2856400.0 |
| 2001-01-18 17:30:00 | MSFT | Stock | 29.3438 | 29.4375 | 29.2188 | 29.2812 | 474400.0 |
| 2001-01-18 18:00:00 | MSFT | Stock | 29.3125 | 29.625 | 29.3125 | 29.5312 | 557400.0 |
| 2001-01-18 18:30:00 | MSFT | Stock | 29.5938 | 29.5938 | 29.5938 | 29.5938 | 600.0 |
| 2001-01-18 09:00:00 | NVDA | Stock | 0.1878 | 0.1878 | 0.1875 | 0.1875 | 168000.0 |
| 2001-01-18 09:30:00 | NVDA | Stock | 0.187 | 0.1932 | 0.1833 | 0.1854 | 50520000.0 |
| 2001-01-18 10:00:00 | NVDA | Stock | 0.1854 | 0.1891 | 0.1828 | 0.188 | 52704000.0 |
| 2001-01-18 10:30:00 | NVDA | Stock | 0.1885 | 0.1938 | 0.1844 | 0.1927 | 52032000.0 |
| 2001-01-18 11:00:00 | NVDA | Stock | 0.1893 | 0.1977 | 0.1893 | 0.1969 | 85656000.0 |
| 2001-01-18 11:30:00 | NVDA | Stock | 0.1969 | 0.199 | 0.1969 | 0.1977 | 31776000.0 |
| 2001-01-18 12:00:00 | NVDA | Stock | 0.1974 | 0.2021 | 0.1974 | 0.201 | 37200000.0 |
> showing 50 of 27,813 rows — these rows as CSV