PREVIEW / stock_1hour / 2002-06-11
file: by_date/stock_1hour/2002/2002-06-11.parquet size: 410 KB rows: 19,271 symbols: 1,427
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 |
|---|---|---|---|---|---|---|---|
| 2002-06-11 08:00:00 | AAPL | Stock | 0.3804 | 0.3855 | 0.3804 | 0.3855 | 268800.0 |
| 2002-06-11 09:00:00 | AAPL | Stock | 0.3847 | 0.3875 | 0.3821 | 0.3834 | 22943200.0 |
| 2002-06-11 10:00:00 | AAPL | Stock | 0.383 | 0.3873 | 0.3802 | 0.3839 | 46272800.0 |
| 2002-06-11 11:00:00 | AAPL | Stock | 0.3838 | 0.3863 | 0.3827 | 0.3855 | 21420000.0 |
| 2002-06-11 12:00:00 | AAPL | Stock | 0.3857 | 0.3863 | 0.3827 | 0.383 | 31444000.0 |
| 2002-06-11 13:00:00 | AAPL | Stock | 0.383 | 0.3836 | 0.3805 | 0.3821 | 28845600.0 |
| 2002-06-11 14:00:00 | AAPL | Stock | 0.382 | 0.3827 | 0.3752 | 0.3764 | 37553600.0 |
| 2002-06-11 15:00:00 | AAPL | Stock | 0.3764 | 0.3764 | 0.3645 | 0.3645 | 128402400.0 |
| 2002-06-11 16:00:00 | AAPL | Stock | 0.3654 | 0.3836 | 0.3625 | 0.3661 | 19835200.0 |
| 2002-06-11 17:00:00 | AAPL | Stock | 0.3654 | 0.3661 | 0.3616 | 0.3643 | 1825600.0 |
| 2002-06-11 18:00:00 | AAPL | Stock | 0.3616 | 0.3616 | 0.3616 | 0.3616 | 22400.0 |
| 2002-06-11 08:00:00 | MSFT | Stock | 26.59 | 26.7 | 26.36 | 26.625 | 139400.0 |
| 2002-06-11 09:00:00 | MSFT | Stock | 26.625 | 26.915 | 26.5375 | 26.74 | 10780200.0 |
| 2002-06-11 10:00:00 | MSFT | Stock | 26.745 | 27.0895 | 26.65 | 26.99 | 13283800.0 |
| 2002-06-11 11:00:00 | MSFT | Stock | 26.99 | 27.09 | 26.9 | 26.935 | 6031200.0 |
| 2002-06-11 12:00:00 | MSFT | Stock | 26.94 | 26.975 | 26.71 | 26.745 | 6636000.0 |
| 2002-06-11 13:00:00 | MSFT | Stock | 26.74 | 26.87 | 26.625 | 26.75 | 9125000.0 |
| 2002-06-11 14:00:00 | MSFT | Stock | 26.75 | 26.806 | 26.565 | 26.66 | 8798000.0 |
| 2002-06-11 15:00:00 | MSFT | Stock | 26.655 | 26.69 | 26.21 | 26.28 | 15518600.0 |
| 2002-06-11 16:00:00 | MSFT | Stock | 26.285 | 26.739 | 26.235 | 26.28 | 2138200.0 |
| 2002-06-11 17:00:00 | MSFT | Stock | 26.3 | 26.3 | 26.215 | 26.215 | 271800.0 |
| 2002-06-11 18:00:00 | MSFT | Stock | 26.22 | 26.275 | 26.21 | 26.22 | 6800.0 |
| 2002-06-11 08:00:00 | NVDA | Stock | 0.2669 | 0.2727 | 0.2669 | 0.2717 | 7008000.0 |
| 2002-06-11 09:00:00 | NVDA | Stock | 0.2717 | 0.2725 | 0.2657 | 0.2667 | 118392000.0 |
| 2002-06-11 10:00:00 | NVDA | Stock | 0.2667 | 0.2676 | 0.2636 | 0.2662 | 140268000.0 |
| 2002-06-11 11:00:00 | NVDA | Stock | 0.2662 | 0.2683 | 0.265 | 0.2679 | 101052000.0 |
| 2002-06-11 12:00:00 | NVDA | Stock | 0.2678 | 0.2687 | 0.2638 | 0.2642 | 85380000.0 |
| 2002-06-11 13:00:00 | NVDA | Stock | 0.2642 | 0.2672 | 0.2637 | 0.2671 | 62616000.0 |
| 2002-06-11 14:00:00 | NVDA | Stock | 0.2667 | 0.2669 | 0.2597 | 0.2605 | 106236000.0 |
| 2002-06-11 15:00:00 | NVDA | Stock | 0.2605 | 0.2613 | 0.2542 | 0.255 | 204012000.0 |
| 2002-06-11 16:00:00 | NVDA | Stock | 0.255 | 0.2669 | 0.2546 | 0.255 | 20484000.0 |
| 2002-06-11 17:00:00 | NVDA | Stock | 0.255 | 0.255 | 0.255 | 0.255 | 1308000.0 |
| 2002-06-11 18:00:00 | NVDA | Stock | 0.255 | 0.2557 | 0.2537 | 0.2557 | 984000.0 |
| 2002-06-11 08:00:00 | AMZN | Stock | 0.861 | 0.876 | 0.85 | 0.8662 | 1566000.0 |
| 2002-06-11 09:00:00 | AMZN | Stock | 0.8748 | 0.8895 | 0.8644 | 0.8776 | 23980000.0 |
| 2002-06-11 10:00:00 | AMZN | Stock | 0.8775 | 0.881 | 0.87 | 0.8725 | 23632000.0 |
| 2002-06-11 11:00:00 | AMZN | Stock | 0.873 | 0.8785 | 0.8725 | 0.8755 | 9110000.0 |
| 2002-06-11 12:00:00 | AMZN | Stock | 0.876 | 0.877 | 0.8705 | 0.8735 | 7690000.0 |
| 2002-06-11 13:00:00 | AMZN | Stock | 0.872 | 0.8785 | 0.8715 | 0.873 | 10898000.0 |
| 2002-06-11 14:00:00 | AMZN | Stock | 0.8725 | 0.8757 | 0.8665 | 0.8675 | 12384000.0 |
| 2002-06-11 15:00:00 | AMZN | Stock | 0.8675 | 0.8685 | 0.8565 | 0.8565 | 17310000.0 |
| 2002-06-11 16:00:00 | AMZN | Stock | 0.857 | 0.873 | 0.8525 | 0.8525 | 1916000.0 |
| 2002-06-11 17:00:00 | AMZN | Stock | 0.8535 | 0.857 | 0.8535 | 0.8535 | 382000.0 |
| 2002-06-11 09:00:00 | CL | Stock | 27.2 | 27.225 | 27.0 | 27.025 | 406600.0 |
| 2002-06-11 10:00:00 | CL | Stock | 27.025 | 27.045 | 26.88 | 26.915 | 604600.0 |
| 2002-06-11 11:00:00 | CL | Stock | 26.915 | 26.93 | 26.85 | 26.89 | 464600.0 |
| 2002-06-11 12:00:00 | CL | Stock | 26.89 | 26.925 | 26.64 | 26.735 | 441800.0 |
| 2002-06-11 13:00:00 | CL | Stock | 26.735 | 26.825 | 26.655 | 26.79 | 337800.0 |
| 2002-06-11 14:00:00 | CL | Stock | 26.8 | 26.815 | 26.725 | 26.755 | 298200.0 |
| 2002-06-11 15:00:00 | CL | Stock | 26.73 | 26.76 | 26.575 | 26.575 | 620400.0 |
> showing 50 of 19,271 rows — these rows as CSV