PREVIEW / stock_1hour / 2003-03-03
file: by_date/stock_1hour/2003/2003-03-03.parquet size: 406 KB rows: 19,878 symbols: 1,557
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-03-03 08:00:00 | AAPL | Stock | 0.2679 | 0.2679 | 0.2679 | 0.2679 | 11200.0 |
| 2003-03-03 09:00:00 | AAPL | Stock | 0.2688 | 0.2707 | 0.2661 | 0.2698 | 23581432.0 |
| 2003-03-03 10:00:00 | AAPL | Stock | 0.2698 | 0.2702 | 0.2629 | 0.2632 | 51238152.0 |
| 2003-03-03 11:00:00 | AAPL | Stock | 0.2634 | 0.2643 | 0.2629 | 0.2639 | 27807192.0 |
| 2003-03-03 12:00:00 | AAPL | Stock | 0.2639 | 0.2648 | 0.2636 | 0.2636 | 12739664.0 |
| 2003-03-03 13:00:00 | AAPL | Stock | 0.2638 | 0.2638 | 0.2602 | 0.262 | 31769080.0 |
| 2003-03-03 14:00:00 | AAPL | Stock | 0.262 | 0.2621 | 0.2604 | 0.2616 | 15253952.0 |
| 2003-03-03 15:00:00 | AAPL | Stock | 0.2616 | 0.2621 | 0.2598 | 0.2616 | 27468392.0 |
| 2003-03-03 16:00:00 | AAPL | Stock | 0.2618 | 0.262 | 0.2613 | 0.2616 | 3220000.0 |
| 2003-03-03 17:00:00 | AAPL | Stock | 0.2616 | 0.2616 | 0.2616 | 0.2616 | 1041600.0 |
| 2003-03-03 08:00:00 | MSFT | Stock | 23.99 | 24.1 | 23.07 | 24.05 | 362347.0 |
| 2003-03-03 09:00:00 | MSFT | Stock | 24.05 | 24.12 | 23.92 | 24.039 | 7507859.0 |
| 2003-03-03 10:00:00 | MSFT | Stock | 24.04 | 24.11 | 23.62 | 23.74 | 9573739.0 |
| 2003-03-03 11:00:00 | MSFT | Stock | 23.73 | 23.78 | 23.64 | 23.7 | 5408670.0 |
| 2003-03-03 12:00:00 | MSFT | Stock | 23.7 | 23.851 | 23.67 | 23.72 | 3542805.0 |
| 2003-03-03 13:00:00 | MSFT | Stock | 23.72 | 23.72 | 23.534 | 23.601 | 5130616.0 |
| 2003-03-03 14:00:00 | MSFT | Stock | 23.601 | 23.63 | 23.44 | 23.49 | 5665913.0 |
| 2003-03-03 15:00:00 | MSFT | Stock | 23.49 | 23.606 | 23.42 | 23.543 | 8179966.0 |
| 2003-03-03 16:00:00 | MSFT | Stock | 23.53 | 23.7 | 23.5056 | 23.53 | 837738.0 |
| 2003-03-03 17:00:00 | MSFT | Stock | 23.55 | 23.6 | 23.54 | 23.56 | 170085.0 |
| 2003-03-03 18:00:00 | MSFT | Stock | 23.55 | 23.58 | 23.541 | 23.551 | 7200.0 |
| 2003-03-03 08:00:00 | NVDA | Stock | 0.1064 | 0.1071 | 0.1064 | 0.1068 | 1597200.0 |
| 2003-03-03 09:00:00 | NVDA | Stock | 0.1067 | 0.1102 | 0.1062 | 0.1071 | 121661760.0 |
| 2003-03-03 10:00:00 | NVDA | Stock | 0.1071 | 0.1075 | 0.1047 | 0.105 | 123065160.0 |
| 2003-03-03 11:00:00 | NVDA | Stock | 0.1051 | 0.106 | 0.1047 | 0.1052 | 70497240.0 |
| 2003-03-03 12:00:00 | NVDA | Stock | 0.1052 | 0.1056 | 0.105 | 0.1051 | 34724520.0 |
| 2003-03-03 13:00:00 | NVDA | Stock | 0.1052 | 0.1052 | 0.1027 | 0.1037 | 95357640.0 |
| 2003-03-03 14:00:00 | NVDA | Stock | 0.1037 | 0.1038 | 0.1021 | 0.1034 | 94087560.0 |
| 2003-03-03 15:00:00 | NVDA | Stock | 0.1034 | 0.1035 | 0.1021 | 0.1034 | 106943400.0 |
| 2003-03-03 16:00:00 | NVDA | Stock | 0.1035 | 0.1037 | 0.103 | 0.1034 | 9071760.0 |
| 2003-03-03 17:00:00 | NVDA | Stock | 0.1035 | 0.1035 | 0.1034 | 0.1034 | 1884000.0 |
| 2003-03-03 18:00:00 | NVDA | Stock | 0.1033 | 0.1034 | 0.1033 | 0.1034 | 96000.0 |
| 2003-03-03 08:00:00 | AMZN | Stock | 1.1005 | 1.108 | 1.1005 | 1.1005 | 573000.0 |
| 2003-03-03 09:00:00 | AMZN | Stock | 1.1074 | 1.1305 | 1.1015 | 1.1215 | 20604600.0 |
| 2003-03-03 10:00:00 | AMZN | Stock | 1.1219 | 1.124 | 1.102 | 1.1045 | 14550340.0 |
| 2003-03-03 11:00:00 | AMZN | Stock | 1.104 | 1.11 | 1.104 | 1.1075 | 7706680.0 |
| 2003-03-03 12:00:00 | AMZN | Stock | 1.1072 | 1.1145 | 1.1051 | 1.1105 | 6416800.0 |
| 2003-03-03 13:00:00 | AMZN | Stock | 1.11 | 1.11 | 1.091 | 1.096 | 12765240.0 |
| 2003-03-03 14:00:00 | AMZN | Stock | 1.0955 | 1.0955 | 1.091 | 1.094 | 7404160.0 |
| 2003-03-03 15:00:00 | AMZN | Stock | 1.0936 | 1.094 | 1.087 | 1.0905 | 11205180.0 |
| 2003-03-03 16:00:00 | AMZN | Stock | 1.0915 | 1.092 | 1.0875 | 1.0895 | 553840.0 |
| 2003-03-03 17:00:00 | AMZN | Stock | 1.0895 | 1.0905 | 1.0895 | 1.0895 | 180000.0 |
| 2003-03-03 18:00:00 | AMZN | Stock | 1.089 | 1.0895 | 1.089 | 1.0895 | 46000.0 |
| 2003-03-03 09:00:00 | CL | Stock | 25.3 | 25.335 | 25.245 | 25.26 | 252400.0 |
| 2003-03-03 10:00:00 | CL | Stock | 25.26 | 25.275 | 25.02 | 25.03 | 319600.0 |
| 2003-03-03 11:00:00 | CL | Stock | 25.05 | 25.05 | 24.94 | 25.005 | 265400.0 |
| 2003-03-03 12:00:00 | CL | Stock | 25.005 | 25.135 | 25.005 | 25.05 | 204800.0 |
| 2003-03-03 13:00:00 | CL | Stock | 25.05 | 25.135 | 25.03 | 25.105 | 186400.0 |
| 2003-03-03 14:00:00 | CL | Stock | 25.09 | 25.09 | 24.985 | 25.005 | 255600.0 |
| 2003-03-03 15:00:00 | CL | Stock | 25.0 | 25.025 | 24.94 | 24.995 | 379800.0 |
> showing 50 of 19,878 rows — these rows as CSV