PREVIEW / stock_1hour / 2003-02-04
file: by_date/stock_1hour/2003/2003-02-04.parquet size: 406 KB rows: 19,689 symbols: 1,540
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 |
|---|---|---|---|---|---|---|---|
| 2003-02-04 08:00:00 | AAPL | Stock | 0.2613 | 0.2613 | 0.2613 | 0.2613 | 5600.0 |
| 2003-02-04 09:00:00 | AAPL | Stock | 0.2618 | 0.2618 | 0.2555 | 0.2598 | 51984016.0 |
| 2003-02-04 10:00:00 | AAPL | Stock | 0.2598 | 0.2606 | 0.257 | 0.258 | 62633480.0 |
| 2003-02-04 11:00:00 | AAPL | Stock | 0.258 | 0.2582 | 0.2561 | 0.257 | 47749688.0 |
| 2003-02-04 12:00:00 | AAPL | Stock | 0.2568 | 0.2588 | 0.2564 | 0.2575 | 22491280.0 |
| 2003-02-04 13:00:00 | AAPL | Stock | 0.2575 | 0.2605 | 0.2573 | 0.2593 | 22163064.0 |
| 2003-02-04 14:00:00 | AAPL | Stock | 0.2593 | 0.2602 | 0.2575 | 0.2586 | 22024016.0 |
| 2003-02-04 15:00:00 | AAPL | Stock | 0.2582 | 0.2616 | 0.2571 | 0.2612 | 43206072.0 |
| 2003-02-04 16:00:00 | AAPL | Stock | 0.2607 | 0.2621 | 0.2607 | 0.2607 | 11314800.0 |
| 2003-02-04 17:00:00 | AAPL | Stock | 0.2607 | 0.2607 | 0.2604 | 0.2607 | 319200.0 |
| 2003-02-04 08:00:00 | MSFT | Stock | 24.05 | 24.285 | 23.93 | 23.99 | 168376.0 |
| 2003-02-04 09:00:00 | MSFT | Stock | 24.0 | 24.28 | 23.825 | 23.91 | 10366162.0 |
| 2003-02-04 10:00:00 | MSFT | Stock | 23.91 | 23.94 | 23.61 | 23.6205 | 17355464.0 |
| 2003-02-04 11:00:00 | MSFT | Stock | 23.63 | 23.632 | 23.44 | 23.605 | 12502580.0 |
| 2003-02-04 12:00:00 | MSFT | Stock | 23.605 | 23.61 | 23.5255 | 23.5395 | 4691506.0 |
| 2003-02-04 13:00:00 | MSFT | Stock | 23.5395 | 23.75 | 23.53 | 23.625 | 7450900.0 |
| 2003-02-04 14:00:00 | MSFT | Stock | 23.635 | 23.705 | 23.48 | 23.51 | 7039510.0 |
| 2003-02-04 15:00:00 | MSFT | Stock | 23.505 | 23.663 | 23.44 | 23.66 | 11840438.0 |
| 2003-02-04 16:00:00 | MSFT | Stock | 23.663 | 23.825 | 23.54 | 23.625 | 2837778.0 |
| 2003-02-04 17:00:00 | MSFT | Stock | 23.625 | 23.7 | 23.5 | 23.675 | 764480.0 |
| 2003-02-04 18:00:00 | MSFT | Stock | 23.6605 | 23.6995 | 23.66 | 23.695 | 4522.0 |
| 2003-02-04 08:00:00 | NVDA | Stock | 0.0867 | 0.0867 | 0.085 | 0.0865 | 762000.0 |
| 2003-02-04 09:00:00 | NVDA | Stock | 0.0867 | 0.0876 | 0.0853 | 0.0862 | 81511920.0 |
| 2003-02-04 10:00:00 | NVDA | Stock | 0.0861 | 0.0862 | 0.0833 | 0.0837 | 129683760.0 |
| 2003-02-04 11:00:00 | NVDA | Stock | 0.0836 | 0.0842 | 0.0826 | 0.0832 | 125397240.0 |
| 2003-02-04 12:00:00 | NVDA | Stock | 0.0832 | 0.0842 | 0.0831 | 0.0834 | 44841120.0 |
| 2003-02-04 13:00:00 | NVDA | Stock | 0.0833 | 0.0842 | 0.0833 | 0.0836 | 45258840.0 |
| 2003-02-04 14:00:00 | NVDA | Stock | 0.0836 | 0.0842 | 0.0829 | 0.0832 | 56655360.0 |
| 2003-02-04 15:00:00 | NVDA | Stock | 0.0831 | 0.0842 | 0.0829 | 0.0837 | 88416360.0 |
| 2003-02-04 16:00:00 | NVDA | Stock | 0.0839 | 0.084 | 0.0833 | 0.0839 | 5020680.0 |
| 2003-02-04 17:00:00 | NVDA | Stock | 0.083 | 0.0839 | 0.083 | 0.0839 | 1356000.0 |
| 2003-02-04 18:00:00 | NVDA | Stock | 0.0837 | 0.0837 | 0.0834 | 0.0834 | 228000.0 |
| 2003-02-04 08:00:00 | AMZN | Stock | 1.093 | 1.11 | 1.0805 | 1.1055 | 182000.0 |
| 2003-02-04 09:00:00 | AMZN | Stock | 1.09 | 1.105 | 1.09 | 1.0985 | 14400920.0 |
| 2003-02-04 10:00:00 | AMZN | Stock | 1.098 | 1.1005 | 1.089 | 1.0905 | 19090860.0 |
| 2003-02-04 11:00:00 | AMZN | Stock | 1.091 | 1.0915 | 1.0785 | 1.0885 | 14633780.0 |
| 2003-02-04 12:00:00 | AMZN | Stock | 1.0885 | 1.0965 | 1.0875 | 1.0905 | 10546040.0 |
| 2003-02-04 13:00:00 | AMZN | Stock | 1.0905 | 1.0945 | 1.0875 | 1.092 | 4944360.0 |
| 2003-02-04 14:00:00 | AMZN | Stock | 1.092 | 1.0948 | 1.0885 | 1.089 | 5973460.0 |
| 2003-02-04 15:00:00 | AMZN | Stock | 1.0895 | 1.1055 | 1.0875 | 1.1045 | 14632980.0 |
| 2003-02-04 16:00:00 | AMZN | Stock | 1.101 | 1.12 | 1.096 | 1.1075 | 3149980.0 |
| 2003-02-04 17:00:00 | AMZN | Stock | 1.1046 | 1.1075 | 1.1025 | 1.1025 | 130000.0 |
| 2003-02-04 18:00:00 | AMZN | Stock | 1.106 | 1.106 | 1.104 | 1.104 | 6000.0 |
| 2003-02-04 08:00:00 | CL | Stock | 25.6 | 25.6 | 25.6 | 25.6 | 200.0 |
| 2003-02-04 09:00:00 | CL | Stock | 25.575 | 25.95 | 25.55 | 25.56 | 1244600.0 |
| 2003-02-04 10:00:00 | CL | Stock | 25.575 | 25.625 | 25.3 | 25.47 | 1375000.0 |
| 2003-02-04 11:00:00 | CL | Stock | 25.465 | 25.655 | 25.35 | 25.64 | 726600.0 |
| 2003-02-04 12:00:00 | CL | Stock | 25.635 | 25.635 | 25.44 | 25.455 | 537800.0 |
| 2003-02-04 13:00:00 | CL | Stock | 25.455 | 25.745 | 25.44 | 25.715 | 868000.0 |
| 2003-02-04 14:00:00 | CL | Stock | 25.7 | 25.845 | 25.7 | 25.78 | 741200.0 |
> showing 50 of 19,689 rows — these rows as CSV