PREVIEW / stock_1hour / 2002-10-11
file: by_date/stock_1hour/2002/2002-10-11.parquet size: 406 KB rows: 19,408 symbols: 1,502
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-10-11 09:00:00 | AAPL | Stock | 0.2536 | 0.2593 | 0.2518 | 0.2589 | 43627640.0 |
| 2002-10-11 10:00:00 | AAPL | Stock | 0.2589 | 0.2609 | 0.2563 | 0.2591 | 38708824.0 |
| 2002-10-11 11:00:00 | AAPL | Stock | 0.2593 | 0.2602 | 0.2588 | 0.2591 | 17619056.0 |
| 2002-10-11 12:00:00 | AAPL | Stock | 0.259 | 0.2629 | 0.2586 | 0.2625 | 31027640.0 |
| 2002-10-11 13:00:00 | AAPL | Stock | 0.2623 | 0.2639 | 0.26 | 0.2625 | 42182560.0 |
| 2002-10-11 14:00:00 | AAPL | Stock | 0.2627 | 0.263 | 0.26 | 0.2609 | 30047024.0 |
| 2002-10-11 15:00:00 | AAPL | Stock | 0.2611 | 0.2611 | 0.2579 | 0.2586 | 58502528.0 |
| 2002-10-11 16:00:00 | AAPL | Stock | 0.2586 | 0.26 | 0.2581 | 0.2593 | 15536976.0 |
| 2002-10-11 08:00:00 | MSFT | Stock | 23.485 | 23.6 | 23.1875 | 23.58 | 977336.0 |
| 2002-10-11 09:00:00 | MSFT | Stock | 23.6 | 24.02 | 23.45 | 23.98 | 20960406.0 |
| 2002-10-11 10:00:00 | MSFT | Stock | 23.985 | 24.035 | 23.785 | 23.9 | 16588224.0 |
| 2002-10-11 11:00:00 | MSFT | Stock | 23.9 | 24.0 | 23.78 | 23.95 | 9703526.0 |
| 2002-10-11 12:00:00 | MSFT | Stock | 23.95 | 24.085 | 23.92 | 24.04 | 9511706.0 |
| 2002-10-11 13:00:00 | MSFT | Stock | 24.04 | 24.44 | 24.025 | 24.34 | 11867280.0 |
| 2002-10-11 14:00:00 | MSFT | Stock | 24.335 | 24.375 | 24.075 | 24.2145 | 11480206.0 |
| 2002-10-11 15:00:00 | MSFT | Stock | 24.214 | 24.44 | 23.81 | 24.43 | 19466286.0 |
| 2002-10-11 16:00:00 | MSFT | Stock | 24.435 | 24.48 | 23.983 | 24.475 | 2393126.0 |
| 2002-10-11 17:00:00 | MSFT | Stock | 24.46 | 24.46 | 23.983 | 24.375 | 333356.0 |
| 2002-10-11 18:00:00 | MSFT | Stock | 24.375 | 24.4 | 24.375 | 24.4 | 2200.0 |
| 2002-10-11 08:00:00 | NVDA | Stock | 0.0663 | 0.0672 | 0.0663 | 0.0669 | 868200.0 |
| 2002-10-11 09:00:00 | NVDA | Stock | 0.0681 | 0.0687 | 0.0667 | 0.0677 | 198201960.0 |
| 2002-10-11 10:00:00 | NVDA | Stock | 0.0678 | 0.0707 | 0.0677 | 0.0705 | 173734560.0 |
| 2002-10-11 11:00:00 | NVDA | Stock | 0.0705 | 0.072 | 0.0697 | 0.0712 | 114283320.0 |
| 2002-10-11 12:00:00 | NVDA | Stock | 0.0712 | 0.0722 | 0.0711 | 0.072 | 69116160.0 |
| 2002-10-11 13:00:00 | NVDA | Stock | 0.072 | 0.0746 | 0.0719 | 0.0743 | 123527520.0 |
| 2002-10-11 14:00:00 | NVDA | Stock | 0.0742 | 0.0745 | 0.0725 | 0.0735 | 98949720.0 |
| 2002-10-11 15:00:00 | NVDA | Stock | 0.0735 | 0.0736 | 0.0717 | 0.0734 | 163175040.0 |
| 2002-10-11 16:00:00 | NVDA | Stock | 0.0733 | 0.0742 | 0.0723 | 0.0739 | 30625320.0 |
| 2002-10-11 17:00:00 | NVDA | Stock | 0.0723 | 0.0735 | 0.0723 | 0.0735 | 96000.0 |
| 2002-10-11 18:00:00 | NVDA | Stock | 0.0735 | 0.0735 | 0.0733 | 0.0733 | 528000.0 |
| 2002-10-11 08:00:00 | AMZN | Stock | 0.9 | 0.909 | 0.895 | 0.909 | 95720.0 |
| 2002-10-11 09:00:00 | AMZN | Stock | 0.9095 | 0.936 | 0.905 | 0.9355 | 35386700.0 |
| 2002-10-11 10:00:00 | AMZN | Stock | 0.936 | 0.937 | 0.9255 | 0.927 | 36630760.0 |
| 2002-10-11 11:00:00 | AMZN | Stock | 0.927 | 0.93 | 0.913 | 0.921 | 26490100.0 |
| 2002-10-11 12:00:00 | AMZN | Stock | 0.9195 | 0.93 | 0.919 | 0.925 | 15685020.0 |
| 2002-10-11 13:00:00 | AMZN | Stock | 0.9255 | 0.935 | 0.9225 | 0.9285 | 27252100.0 |
| 2002-10-11 14:00:00 | AMZN | Stock | 0.928 | 0.93 | 0.9165 | 0.9265 | 14201160.0 |
| 2002-10-11 15:00:00 | AMZN | Stock | 0.9266 | 0.927 | 0.91 | 0.9226 | 18893060.0 |
| 2002-10-11 16:00:00 | AMZN | Stock | 0.923 | 0.932 | 0.9206 | 0.9225 | 2511760.0 |
| 2002-10-11 17:00:00 | AMZN | Stock | 0.9225 | 0.923 | 0.9225 | 0.9225 | 12000.0 |
| 2002-10-11 18:00:00 | AMZN | Stock | 0.9225 | 0.9225 | 0.92 | 0.92 | 14000.0 |
| 2002-10-11 09:00:00 | CL | Stock | 27.775 | 27.8 | 27.55 | 27.7 | 412800.0 |
| 2002-10-11 10:00:00 | CL | Stock | 27.705 | 27.87 | 27.675 | 27.855 | 861800.0 |
| 2002-10-11 11:00:00 | CL | Stock | 27.855 | 27.965 | 27.84 | 27.94 | 415600.0 |
| 2002-10-11 12:00:00 | CL | Stock | 27.96 | 28.135 | 27.905 | 28.1 | 454200.0 |
| 2002-10-11 13:00:00 | CL | Stock | 28.075 | 28.415 | 28.075 | 28.325 | 758000.0 |
| 2002-10-11 14:00:00 | CL | Stock | 28.325 | 28.33 | 28.2 | 28.2 | 655600.0 |
| 2002-10-11 15:00:00 | CL | Stock | 28.205 | 28.275 | 28.11 | 28.17 | 699800.0 |
| 2002-10-11 16:00:00 | CL | Stock | 28.175 | 28.2 | 28.175 | 28.2 | 100600.0 |
> showing 49 of 19,408 rows — these rows as CSV