PREVIEW / stock_1hour / 2001-03-21
file: by_date/stock_1hour/2001/2001-03-21.parquet size: 351 KB rows: 16,360 symbols: 1,279
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-03-21 08:00:00 | AAPL | Stock | 0.3521 | 0.3527 | 0.3504 | 0.3527 | 392000.0 |
| 2001-03-21 09:00:00 | AAPL | Stock | 0.3527 | 0.3549 | 0.346 | 0.3493 | 43237600.0 |
| 2001-03-21 10:00:00 | AAPL | Stock | 0.3493 | 0.3728 | 0.3493 | 0.3683 | 124241600.0 |
| 2001-03-21 11:00:00 | AAPL | Stock | 0.3683 | 0.3705 | 0.3627 | 0.3627 | 39642400.0 |
| 2001-03-21 12:00:00 | AAPL | Stock | 0.3627 | 0.3638 | 0.3549 | 0.356 | 34378400.0 |
| 2001-03-21 13:00:00 | AAPL | Stock | 0.356 | 0.3594 | 0.3527 | 0.3583 | 21212800.0 |
| 2001-03-21 14:00:00 | AAPL | Stock | 0.3583 | 0.3661 | 0.3549 | 0.3638 | 48020000.0 |
| 2001-03-21 15:00:00 | AAPL | Stock | 0.3638 | 0.3661 | 0.3571 | 0.3583 | 48473600.0 |
| 2001-03-21 16:00:00 | AAPL | Stock | 0.3583 | 0.3611 | 0.3571 | 0.3594 | 5684000.0 |
| 2001-03-21 17:00:00 | AAPL | Stock | 0.3571 | 0.3571 | 0.3571 | 0.3571 | 11200.0 |
| 2001-03-21 18:00:00 | AAPL | Stock | 0.3571 | 0.3594 | 0.3571 | 0.3594 | 56000.0 |
| 2001-03-21 08:00:00 | MSFT | Stock | 26.125 | 26.4375 | 25.9062 | 26.125 | 511200.0 |
| 2001-03-21 09:00:00 | MSFT | Stock | 26.1875 | 26.375 | 25.8125 | 26.0 | 15642800.0 |
| 2001-03-21 10:00:00 | MSFT | Stock | 26.0 | 26.625 | 25.7344 | 26.0625 | 20522200.0 |
| 2001-03-21 11:00:00 | MSFT | Stock | 26.0625 | 26.125 | 25.2812 | 25.4375 | 19256000.0 |
| 2001-03-21 12:00:00 | MSFT | Stock | 25.4062 | 25.625 | 25.125 | 25.5312 | 10592200.0 |
| 2001-03-21 13:00:00 | MSFT | Stock | 25.5312 | 25.5938 | 24.9688 | 25.125 | 15319600.0 |
| 2001-03-21 14:00:00 | MSFT | Stock | 25.1562 | 25.8125 | 25.0625 | 25.3281 | 14991000.0 |
| 2001-03-21 15:00:00 | MSFT | Stock | 25.2812 | 25.4688 | 24.875 | 25.0312 | 18831800.0 |
| 2001-03-21 16:00:00 | MSFT | Stock | 25.0 | 25.6094 | 24.8281 | 24.9375 | 3298000.0 |
| 2001-03-21 17:00:00 | MSFT | Stock | 24.9375 | 26.625 | 24.9375 | 25.2812 | 109000.0 |
| 2001-03-21 18:00:00 | MSFT | Stock | 25.25 | 25.25 | 25.125 | 25.2188 | 5400.0 |
| 2001-03-21 08:00:00 | NVDA | Stock | 0.2384 | 0.2417 | 0.2354 | 0.2375 | 3192000.0 |
| 2001-03-21 09:00:00 | NVDA | Stock | 0.2385 | 0.25 | 0.2354 | 0.2469 | 255024000.0 |
| 2001-03-21 10:00:00 | NVDA | Stock | 0.2464 | 0.263 | 0.2461 | 0.2604 | 455616000.0 |
| 2001-03-21 11:00:00 | NVDA | Stock | 0.2604 | 0.2609 | 0.251 | 0.2534 | 241968000.0 |
| 2001-03-21 12:00:00 | NVDA | Stock | 0.2531 | 0.2563 | 0.2474 | 0.2549 | 144744000.0 |
| 2001-03-21 13:00:00 | NVDA | Stock | 0.2552 | 0.2563 | 0.2471 | 0.2497 | 157464000.0 |
| 2001-03-21 14:00:00 | NVDA | Stock | 0.2497 | 0.2615 | 0.2479 | 0.2547 | 274296000.0 |
| 2001-03-21 15:00:00 | NVDA | Stock | 0.2544 | 0.257 | 0.2482 | 0.256 | 280584000.0 |
| 2001-03-21 16:00:00 | NVDA | Stock | 0.256 | 0.2563 | 0.2547 | 0.2552 | 6984000.0 |
| 2001-03-21 17:00:00 | NVDA | Stock | 0.2557 | 0.2557 | 0.2557 | 0.2557 | 1608000.0 |
| 2001-03-21 18:00:00 | NVDA | Stock | 0.2557 | 0.2573 | 0.2557 | 0.2573 | 696000.0 |
| 2001-03-21 08:00:00 | AMZN | Stock | 0.5094 | 0.5125 | 0.5094 | 0.5094 | 36000.0 |
| 2001-03-21 09:00:00 | AMZN | Stock | 0.5125 | 0.5219 | 0.5 | 0.5 | 12410000.0 |
| 2001-03-21 10:00:00 | AMZN | Stock | 0.5 | 0.5219 | 0.5 | 0.5156 | 27976000.0 |
| 2001-03-21 11:00:00 | AMZN | Stock | 0.5188 | 0.5219 | 0.5094 | 0.5125 | 10062000.0 |
| 2001-03-21 12:00:00 | AMZN | Stock | 0.5094 | 0.5125 | 0.5062 | 0.5094 | 12134000.0 |
| 2001-03-21 13:00:00 | AMZN | Stock | 0.5078 | 0.5125 | 0.5031 | 0.5062 | 9890000.0 |
| 2001-03-21 14:00:00 | AMZN | Stock | 0.5062 | 0.5219 | 0.5062 | 0.5094 | 10638000.0 |
| 2001-03-21 15:00:00 | AMZN | Stock | 0.5125 | 0.5125 | 0.5 | 0.5031 | 22034000.0 |
| 2001-03-21 16:00:00 | AMZN | Stock | 0.5 | 0.5031 | 0.4969 | 0.5 | 1612000.0 |
| 2001-03-21 17:00:00 | AMZN | Stock | 0.5062 | 0.5062 | 0.5031 | 0.5031 | 104000.0 |
| 2001-03-21 18:00:00 | AMZN | Stock | 0.5062 | 0.5062 | 0.5 | 0.5 | 14000.0 |
| 2001-03-21 09:00:00 | CL | Stock | 26.75 | 26.755 | 26.25 | 26.25 | 591600.0 |
| 2001-03-21 10:00:00 | CL | Stock | 26.23 | 26.8 | 26.23 | 26.35 | 778200.0 |
| 2001-03-21 11:00:00 | CL | Stock | 26.355 | 26.4 | 26.2 | 26.235 | 740400.0 |
| 2001-03-21 12:00:00 | CL | Stock | 26.19 | 26.29 | 26.05 | 26.225 | 423400.0 |
| 2001-03-21 13:00:00 | CL | Stock | 26.2 | 26.205 | 26.05 | 26.12 | 493400.0 |
| 2001-03-21 14:00:00 | CL | Stock | 26.1 | 26.125 | 25.83 | 25.875 | 578600.0 |
> showing 50 of 16,360 rows — these rows as CSV