PREVIEW / stock_1hour / 2000-10-12
file: by_date/stock_1hour/2000/2000-10-12.parquet size: 309 KB rows: 15,735 symbols: 1,241
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 |
|---|---|---|---|---|---|---|---|
| 2000-10-12 08:00:00 | AAPL | Stock | 0.3571 | 0.3683 | 0.3504 | 0.3571 | 3337600.0 |
| 2000-10-12 09:00:00 | AAPL | Stock | 0.3571 | 0.3661 | 0.3566 | 0.3571 | 150925600.0 |
| 2000-10-12 10:00:00 | AAPL | Stock | 0.3571 | 0.3705 | 0.3538 | 0.3683 | 196280000.0 |
| 2000-10-12 11:00:00 | AAPL | Stock | 0.3683 | 0.3717 | 0.3516 | 0.3549 | 253915200.0 |
| 2000-10-12 12:00:00 | AAPL | Stock | 0.3549 | 0.356 | 0.3482 | 0.3516 | 104036800.0 |
| 2000-10-12 13:00:00 | AAPL | Stock | 0.3516 | 0.3583 | 0.3504 | 0.3577 | 70364000.0 |
| 2000-10-12 14:00:00 | AAPL | Stock | 0.3583 | 0.3583 | 0.3527 | 0.356 | 74116000.0 |
| 2000-10-12 15:00:00 | AAPL | Stock | 0.356 | 0.3583 | 0.3538 | 0.3571 | 228564000.0 |
| 2000-10-12 16:00:00 | AAPL | Stock | 0.356 | 0.3583 | 0.3549 | 0.3571 | 23032800.0 |
| 2000-10-12 17:00:00 | AAPL | Stock | 0.3571 | 0.3705 | 0.3571 | 0.3594 | 1321600.0 |
| 2000-10-12 18:00:00 | AAPL | Stock | 0.3605 | 0.3616 | 0.3583 | 0.3583 | 95200.0 |
| 2000-10-12 08:00:00 | MSFT | Stock | 28.125 | 28.4375 | 27.8906 | 28.1562 | 214000.0 |
| 2000-10-12 09:00:00 | MSFT | Stock | 28.1719 | 28.4375 | 27.6562 | 27.6875 | 9736400.0 |
| 2000-10-12 10:00:00 | MSFT | Stock | 27.6875 | 28.3438 | 27.6562 | 28.0938 | 14938200.0 |
| 2000-10-12 11:00:00 | MSFT | Stock | 28.0938 | 28.2812 | 27.75 | 27.75 | 9472800.0 |
| 2000-10-12 12:00:00 | MSFT | Stock | 27.75 | 27.8125 | 26.9375 | 27.0625 | 17777400.0 |
| 2000-10-12 13:00:00 | MSFT | Stock | 27.0938 | 27.4375 | 27.0 | 27.0625 | 10249800.0 |
| 2000-10-12 14:00:00 | MSFT | Stock | 27.0938 | 27.2812 | 26.9062 | 27.2344 | 8746200.0 |
| 2000-10-12 15:00:00 | MSFT | Stock | 27.25 | 27.4375 | 26.9062 | 27.2188 | 12128600.0 |
| 2000-10-12 16:00:00 | MSFT | Stock | 27.1875 | 28.0 | 27.0156 | 27.2188 | 2606800.0 |
| 2000-10-12 17:00:00 | MSFT | Stock | 27.6094 | 27.6094 | 27.1875 | 27.1875 | 246600.0 |
| 2000-10-12 18:00:00 | MSFT | Stock | 27.1875 | 27.1875 | 27.0 | 27.1562 | 1800.0 |
| 2000-10-12 09:00:00 | NVDA | Stock | 0.2776 | 0.288 | 0.2773 | 0.2823 | 45240000.0 |
| 2000-10-12 10:00:00 | NVDA | Stock | 0.2823 | 0.2885 | 0.2732 | 0.288 | 48288000.0 |
| 2000-10-12 11:00:00 | NVDA | Stock | 0.2883 | 0.2938 | 0.2792 | 0.2823 | 76440000.0 |
| 2000-10-12 12:00:00 | NVDA | Stock | 0.2826 | 0.2852 | 0.2766 | 0.2784 | 37392000.0 |
| 2000-10-12 13:00:00 | NVDA | Stock | 0.2786 | 0.2792 | 0.2625 | 0.2688 | 65664000.0 |
| 2000-10-12 14:00:00 | NVDA | Stock | 0.2688 | 0.2703 | 0.2583 | 0.2622 | 38136000.0 |
| 2000-10-12 15:00:00 | NVDA | Stock | 0.2622 | 0.2688 | 0.2583 | 0.2609 | 61440000.0 |
| 2000-10-12 16:00:00 | NVDA | Stock | 0.2609 | 0.2651 | 0.2604 | 0.2625 | 4320000.0 |
| 2000-10-12 17:00:00 | NVDA | Stock | 0.263 | 0.2875 | 0.263 | 0.287 | 960000.0 |
| 2000-10-12 08:00:00 | AMZN | Stock | 1.3938 | 1.425 | 1.375 | 1.4062 | 264000.0 |
| 2000-10-12 09:00:00 | AMZN | Stock | 1.4 | 1.4375 | 1.375 | 1.375 | 14836000.0 |
| 2000-10-12 10:00:00 | AMZN | Stock | 1.375 | 1.3938 | 1.3406 | 1.3891 | 24380000.0 |
| 2000-10-12 11:00:00 | AMZN | Stock | 1.3906 | 1.4062 | 1.3031 | 1.3125 | 13344000.0 |
| 2000-10-12 12:00:00 | AMZN | Stock | 1.3125 | 1.3156 | 1.25 | 1.2969 | 32008000.0 |
| 2000-10-12 13:00:00 | AMZN | Stock | 1.3 | 1.3375 | 1.2906 | 1.3125 | 16358000.0 |
| 2000-10-12 14:00:00 | AMZN | Stock | 1.3156 | 1.3219 | 1.2688 | 1.2812 | 16238000.0 |
| 2000-10-12 15:00:00 | AMZN | Stock | 1.2812 | 1.3031 | 1.2313 | 1.2531 | 31068000.0 |
| 2000-10-12 16:00:00 | AMZN | Stock | 1.2531 | 1.3656 | 1.25 | 1.2625 | 1630000.0 |
| 2000-10-12 17:00:00 | AMZN | Stock | 1.2562 | 1.4219 | 1.225 | 1.25 | 192000.0 |
| 2000-10-12 18:00:00 | AMZN | Stock | 1.225 | 1.225 | 1.225 | 1.225 | 12000.0 |
| 2000-10-12 09:00:00 | CL | Stock | 25.025 | 25.06 | 24.8 | 24.805 | 476600.0 |
| 2000-10-12 10:00:00 | CL | Stock | 24.7 | 24.7 | 23.875 | 24.29 | 2047600.0 |
| 2000-10-12 11:00:00 | CL | Stock | 24.335 | 24.49 | 24.245 | 24.475 | 526200.0 |
| 2000-10-12 12:00:00 | CL | Stock | 24.48 | 24.65 | 24.4 | 24.4 | 502400.0 |
| 2000-10-12 13:00:00 | CL | Stock | 24.375 | 24.575 | 24.275 | 24.305 | 768400.0 |
| 2000-10-12 14:00:00 | CL | Stock | 24.345 | 24.4 | 24.0 | 24.375 | 1432400.0 |
| 2000-10-12 15:00:00 | CL | Stock | 24.375 | 24.425 | 24.325 | 24.41 | 1801600.0 |
| 2000-10-12 16:00:00 | CL | Stock | 24.35 | 24.4 | 24.325 | 24.325 | 109000.0 |
> showing 50 of 15,735 rows — these rows as CSV