PREVIEW / stock_30min / 2001-02-15
file: by_date/stock_30min/2001/2001-02-15.parquet size: 535 KB rows: 27,349 symbols: 1,269
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-02-15 08:00:00 | AAPL | Stock | 0.3493 | 0.3549 | 0.3482 | 0.3516 | 991200.0 |
| 2001-02-15 08:30:00 | AAPL | Stock | 0.3516 | 0.3527 | 0.3482 | 0.3521 | 487200.0 |
| 2001-02-15 09:00:00 | AAPL | Stock | 0.3516 | 0.3527 | 0.3493 | 0.3527 | 442400.0 |
| 2001-02-15 09:30:00 | AAPL | Stock | 0.3516 | 0.3616 | 0.3516 | 0.3594 | 51699200.0 |
| 2001-02-15 10:00:00 | AAPL | Stock | 0.3594 | 0.3661 | 0.3583 | 0.3605 | 43232000.0 |
| 2001-02-15 10:30:00 | AAPL | Stock | 0.3616 | 0.3638 | 0.3605 | 0.3616 | 21554400.0 |
| 2001-02-15 11:00:00 | AAPL | Stock | 0.3616 | 0.3627 | 0.3571 | 0.3571 | 37760800.0 |
| 2001-02-15 11:30:00 | AAPL | Stock | 0.3577 | 0.3583 | 0.3527 | 0.3571 | 30514400.0 |
| 2001-02-15 12:00:00 | AAPL | Stock | 0.3571 | 0.3638 | 0.356 | 0.3627 | 14834400.0 |
| 2001-02-15 12:30:00 | AAPL | Stock | 0.3627 | 0.3661 | 0.3616 | 0.365 | 9312800.0 |
| 2001-02-15 13:00:00 | AAPL | Stock | 0.3661 | 0.3661 | 0.3616 | 0.3616 | 7582400.0 |
| 2001-02-15 13:30:00 | AAPL | Stock | 0.3627 | 0.365 | 0.3616 | 0.3638 | 11037600.0 |
| 2001-02-15 14:00:00 | AAPL | Stock | 0.3638 | 0.3672 | 0.3638 | 0.365 | 15853600.0 |
| 2001-02-15 14:30:00 | AAPL | Stock | 0.365 | 0.3661 | 0.3616 | 0.3627 | 10466400.0 |
| 2001-02-15 15:00:00 | AAPL | Stock | 0.3616 | 0.365 | 0.356 | 0.3571 | 14957600.0 |
| 2001-02-15 15:30:00 | AAPL | Stock | 0.3571 | 0.3594 | 0.3527 | 0.3583 | 25362400.0 |
| 2001-02-15 16:00:00 | AAPL | Stock | 0.3583 | 0.3583 | 0.3527 | 0.3583 | 5342400.0 |
| 2001-02-15 16:30:00 | AAPL | Stock | 0.3527 | 0.3583 | 0.3493 | 0.3527 | 308000.0 |
| 2001-02-15 17:00:00 | AAPL | Stock | 0.3571 | 0.3583 | 0.3527 | 0.3527 | 61600.0 |
| 2001-02-15 17:30:00 | AAPL | Stock | 0.3516 | 0.3516 | 0.3516 | 0.3516 | 16800.0 |
| 2001-02-15 18:00:00 | AAPL | Stock | 0.3516 | 0.3516 | 0.3516 | 0.3516 | 11200.0 |
| 2001-02-15 08:00:00 | MSFT | Stock | 29.3438 | 30.0 | 29.25 | 29.4375 | 80800.0 |
| 2001-02-15 08:30:00 | MSFT | Stock | 29.4375 | 29.75 | 29.4375 | 29.625 | 149600.0 |
| 2001-02-15 09:00:00 | MSFT | Stock | 29.5625 | 29.625 | 29.5 | 29.5625 | 178400.0 |
| 2001-02-15 09:30:00 | MSFT | Stock | 29.5 | 29.625 | 29.0938 | 29.4688 | 11633000.0 |
| 2001-02-15 10:00:00 | MSFT | Stock | 29.4688 | 29.8125 | 29.4688 | 29.75 | 7766400.0 |
| 2001-02-15 10:30:00 | MSFT | Stock | 29.7812 | 30.0938 | 29.75 | 29.9062 | 7612800.0 |
| 2001-02-15 11:00:00 | MSFT | Stock | 29.875 | 29.9688 | 29.6562 | 29.75 | 2831200.0 |
| 2001-02-15 11:30:00 | MSFT | Stock | 29.75 | 29.875 | 29.4688 | 29.8125 | 2265400.0 |
| 2001-02-15 12:00:00 | MSFT | Stock | 29.8125 | 29.9688 | 29.625 | 29.9531 | 2154000.0 |
| 2001-02-15 12:30:00 | MSFT | Stock | 29.9688 | 30.0938 | 29.9062 | 30.0 | 2883000.0 |
| 2001-02-15 13:00:00 | MSFT | Stock | 30.0 | 30.0938 | 29.6875 | 29.6875 | 2185200.0 |
| 2001-02-15 13:30:00 | MSFT | Stock | 29.6875 | 29.9688 | 29.6562 | 29.7812 | 2310800.0 |
| 2001-02-15 14:00:00 | MSFT | Stock | 29.7812 | 29.9688 | 29.75 | 29.9375 | 1798800.0 |
| 2001-02-15 14:30:00 | MSFT | Stock | 29.9062 | 29.9688 | 29.4688 | 29.5625 | 4002200.0 |
| 2001-02-15 15:00:00 | MSFT | Stock | 29.5625 | 29.6562 | 29.0938 | 29.1875 | 6948800.0 |
| 2001-02-15 15:30:00 | MSFT | Stock | 29.1875 | 29.4375 | 28.9375 | 29.4375 | 5867000.0 |
| 2001-02-15 16:00:00 | MSFT | Stock | 29.4375 | 29.8125 | 29.125 | 29.125 | 1805200.0 |
| 2001-02-15 16:30:00 | MSFT | Stock | 29.0625 | 29.4062 | 28.75 | 29.0625 | 223800.0 |
| 2001-02-15 17:00:00 | MSFT | Stock | 29.1562 | 29.1875 | 28.875 | 28.9062 | 54000.0 |
| 2001-02-15 17:30:00 | MSFT | Stock | 28.875 | 28.9062 | 28.5 | 28.5 | 53000.0 |
| 2001-02-15 18:00:00 | MSFT | Stock | 28.75 | 28.75 | 28.625 | 28.75 | 5000.0 |
| 2001-02-15 08:00:00 | NVDA | Stock | 0.2146 | 0.2161 | 0.2135 | 0.2161 | 648000.0 |
| 2001-02-15 08:30:00 | NVDA | Stock | 0.2164 | 0.2167 | 0.2141 | 0.2167 | 888000.0 |
| 2001-02-15 09:00:00 | NVDA | Stock | 0.2146 | 0.2262 | 0.2146 | 0.2258 | 5712000.0 |
| 2001-02-15 09:30:00 | NVDA | Stock | 0.226 | 0.2365 | 0.2245 | 0.2341 | 264288000.0 |
| 2001-02-15 10:00:00 | NVDA | Stock | 0.2341 | 0.2385 | 0.2323 | 0.2349 | 162984000.0 |
| 2001-02-15 10:30:00 | NVDA | Stock | 0.2352 | 0.2391 | 0.2345 | 0.2391 | 116424000.0 |
| 2001-02-15 11:00:00 | NVDA | Stock | 0.238 | 0.2391 | 0.2331 | 0.2341 | 65448000.0 |
| 2001-02-15 11:30:00 | NVDA | Stock | 0.2341 | 0.237 | 0.2333 | 0.2367 | 36216000.0 |
> showing 50 of 27,349 rows — these rows as CSV