PREVIEW / stock_1hour / 2003-02-21
file: by_date/stock_1hour/2003/2003-02-21.parquet size: 415 KB rows: 20,429 symbols: 1,539
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-21 09:00:00 | AAPL | Stock | 0.263 | 0.2646 | 0.2616 | 0.2639 | 17938704.0 |
| 2003-02-21 10:00:00 | AAPL | Stock | 0.2641 | 0.2668 | 0.262 | 0.2632 | 26239808.0 |
| 2003-02-21 11:00:00 | AAPL | Stock | 0.2632 | 0.2675 | 0.2629 | 0.2666 | 21359352.0 |
| 2003-02-21 12:00:00 | AAPL | Stock | 0.2666 | 0.267 | 0.2655 | 0.2655 | 8653512.0 |
| 2003-02-21 13:00:00 | AAPL | Stock | 0.2655 | 0.2679 | 0.2655 | 0.2675 | 13122424.0 |
| 2003-02-21 14:00:00 | AAPL | Stock | 0.2676 | 0.2689 | 0.2668 | 0.2677 | 21428512.0 |
| 2003-02-21 15:00:00 | AAPL | Stock | 0.2679 | 0.2682 | 0.2668 | 0.2679 | 23753296.0 |
| 2003-02-21 16:00:00 | AAPL | Stock | 0.2679 | 0.268 | 0.2671 | 0.2679 | 3732400.0 |
| 2003-02-21 17:00:00 | AAPL | Stock | 0.2675 | 0.2682 | 0.2625 | 0.2625 | 67200.0 |
| 2003-02-21 18:00:00 | AAPL | Stock | 0.2679 | 0.2679 | 0.2679 | 0.2679 | 112000.0 |
| 2003-02-21 08:00:00 | MSFT | Stock | 24.13 | 24.261 | 24.13 | 24.25 | 56900.0 |
| 2003-02-21 09:00:00 | MSFT | Stock | 24.25 | 24.36 | 24.08 | 24.206 | 6230785.0 |
| 2003-02-21 10:00:00 | MSFT | Stock | 24.209 | 24.32 | 23.7 | 24.1 | 11110151.0 |
| 2003-02-21 11:00:00 | MSFT | Stock | 24.1 | 24.549 | 24.09 | 24.5 | 8482613.0 |
| 2003-02-21 12:00:00 | MSFT | Stock | 24.502 | 24.58 | 24.409 | 24.44 | 4258410.0 |
| 2003-02-21 13:00:00 | MSFT | Stock | 24.44 | 24.68 | 24.439 | 24.608 | 3855723.0 |
| 2003-02-21 14:00:00 | MSFT | Stock | 24.61 | 24.8 | 24.59 | 24.63 | 5135772.0 |
| 2003-02-21 15:00:00 | MSFT | Stock | 24.63 | 24.72 | 24.44 | 24.66 | 8952631.0 |
| 2003-02-21 16:00:00 | MSFT | Stock | 24.66 | 24.69 | 24.56 | 24.65 | 1361064.0 |
| 2003-02-21 17:00:00 | MSFT | Stock | 24.65 | 24.76 | 23.77 | 24.55 | 111567.0 |
| 2003-02-21 18:00:00 | MSFT | Stock | 24.61 | 24.61 | 24.531 | 24.531 | 71176.0 |
| 2003-02-21 08:00:00 | NVDA | Stock | 0.1071 | 0.1071 | 0.1065 | 0.107 | 522000.0 |
| 2003-02-21 09:00:00 | NVDA | Stock | 0.1065 | 0.1074 | 0.1059 | 0.1059 | 100657800.0 |
| 2003-02-21 10:00:00 | NVDA | Stock | 0.1058 | 0.1062 | 0.1033 | 0.1045 | 218532120.0 |
| 2003-02-21 11:00:00 | NVDA | Stock | 0.1045 | 0.1061 | 0.1044 | 0.1056 | 113620200.0 |
| 2003-02-21 12:00:00 | NVDA | Stock | 0.1056 | 0.1062 | 0.1054 | 0.1056 | 66281640.0 |
| 2003-02-21 13:00:00 | NVDA | Stock | 0.1057 | 0.1066 | 0.1056 | 0.1062 | 62529840.0 |
| 2003-02-21 14:00:00 | NVDA | Stock | 0.1062 | 0.1073 | 0.1061 | 0.1063 | 62472120.0 |
| 2003-02-21 15:00:00 | NVDA | Stock | 0.1063 | 0.1073 | 0.106 | 0.1071 | 189489360.0 |
| 2003-02-21 16:00:00 | NVDA | Stock | 0.1071 | 0.1076 | 0.1068 | 0.1068 | 16881960.0 |
| 2003-02-21 17:00:00 | NVDA | Stock | 0.1071 | 0.1074 | 0.1048 | 0.1074 | 4219440.0 |
| 2003-02-21 18:00:00 | NVDA | Stock | 0.1073 | 0.1075 | 0.1067 | 0.1072 | 819960.0 |
| 2003-02-21 08:00:00 | AMZN | Stock | 1.066 | 1.066 | 1.066 | 1.066 | 6000.0 |
| 2003-02-21 09:00:00 | AMZN | Stock | 1.0665 | 1.068 | 1.052 | 1.0635 | 15291140.0 |
| 2003-02-21 10:00:00 | AMZN | Stock | 1.0635 | 1.0675 | 1.059 | 1.064 | 21475020.0 |
| 2003-02-21 11:00:00 | AMZN | Stock | 1.0638 | 1.071 | 1.0625 | 1.0685 | 18391420.0 |
| 2003-02-21 12:00:00 | AMZN | Stock | 1.0685 | 1.0705 | 1.0655 | 1.068 | 10842500.0 |
| 2003-02-21 13:00:00 | AMZN | Stock | 1.068 | 1.074 | 1.067 | 1.0725 | 8700180.0 |
| 2003-02-21 14:00:00 | AMZN | Stock | 1.073 | 1.0915 | 1.0725 | 1.0855 | 19587740.0 |
| 2003-02-21 15:00:00 | AMZN | Stock | 1.0858 | 1.0887 | 1.0825 | 1.0865 | 17327540.0 |
| 2003-02-21 16:00:00 | AMZN | Stock | 1.086 | 1.0895 | 1.0845 | 1.0895 | 1167360.0 |
| 2003-02-21 17:00:00 | AMZN | Stock | 1.068 | 1.087 | 1.06 | 1.0865 | 116000.0 |
| 2003-02-21 18:00:00 | AMZN | Stock | 1.092 | 1.092 | 1.089 | 1.089 | 634000.0 |
| 2003-02-21 09:00:00 | CL | Stock | 25.25 | 25.365 | 25.145 | 25.345 | 490000.0 |
| 2003-02-21 10:00:00 | CL | Stock | 25.34 | 25.405 | 25.14 | 25.325 | 475200.0 |
| 2003-02-21 11:00:00 | CL | Stock | 25.32 | 25.575 | 25.3 | 25.57 | 313200.0 |
| 2003-02-21 12:00:00 | CL | Stock | 25.58 | 25.655 | 25.545 | 25.57 | 175200.0 |
| 2003-02-21 13:00:00 | CL | Stock | 25.57 | 25.675 | 25.57 | 25.575 | 148400.0 |
| 2003-02-21 14:00:00 | CL | Stock | 25.565 | 25.6 | 25.485 | 25.49 | 254000.0 |
| 2003-02-21 15:00:00 | CL | Stock | 25.49 | 25.5 | 25.455 | 25.495 | 389800.0 |
> showing 50 of 20,429 rows — these rows as CSV