PREVIEW / stock_1hour / 2003-02-24
file: by_date/stock_1hour/2003/2003-02-24.parquet size: 411 KB rows: 20,254 symbols: 1,547
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-24 08:00:00 | AAPL | Stock | 0.2679 | 0.2679 | 0.2679 | 0.2679 | 1047200.0 |
| 2003-02-24 09:00:00 | AAPL | Stock | 0.2652 | 0.2666 | 0.2646 | 0.2646 | 12951400.0 |
| 2003-02-24 10:00:00 | AAPL | Stock | 0.2648 | 0.2677 | 0.2643 | 0.2673 | 25839296.0 |
| 2003-02-24 11:00:00 | AAPL | Stock | 0.2673 | 0.2684 | 0.267 | 0.2673 | 14656264.0 |
| 2003-02-24 12:00:00 | AAPL | Stock | 0.2671 | 0.2675 | 0.2636 | 0.2648 | 20333768.0 |
| 2003-02-24 13:00:00 | AAPL | Stock | 0.265 | 0.2657 | 0.2645 | 0.265 | 24120544.0 |
| 2003-02-24 14:00:00 | AAPL | Stock | 0.265 | 0.2652 | 0.2632 | 0.2646 | 28713216.0 |
| 2003-02-24 15:00:00 | AAPL | Stock | 0.2646 | 0.2661 | 0.2632 | 0.2634 | 35599312.0 |
| 2003-02-24 16:00:00 | AAPL | Stock | 0.2634 | 0.2641 | 0.2625 | 0.2625 | 2321200.0 |
| 2003-02-24 17:00:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2634 | 0.2634 | 50400.0 |
| 2003-02-24 08:00:00 | MSFT | Stock | 24.6 | 24.61 | 24.45 | 24.47 | 23600.0 |
| 2003-02-24 09:00:00 | MSFT | Stock | 24.46 | 24.62 | 24.25 | 24.29 | 6166824.0 |
| 2003-02-24 10:00:00 | MSFT | Stock | 24.29 | 24.48 | 24.22 | 24.37 | 7178288.0 |
| 2003-02-24 11:00:00 | MSFT | Stock | 24.36 | 24.37 | 24.16 | 24.21 | 5163864.0 |
| 2003-02-24 12:00:00 | MSFT | Stock | 24.2189 | 24.23 | 24.0 | 24.025 | 5716026.0 |
| 2003-02-24 13:00:00 | MSFT | Stock | 24.02 | 24.16 | 24.01 | 24.11 | 2893893.0 |
| 2003-02-24 14:00:00 | MSFT | Stock | 24.12 | 24.12 | 23.9 | 23.94 | 8788532.0 |
| 2003-02-24 15:00:00 | MSFT | Stock | 23.94 | 24.3 | 23.84 | 24.07 | 19876415.0 |
| 2003-02-24 16:00:00 | MSFT | Stock | 24.07 | 24.09 | 23.9847 | 24.02 | 766058.0 |
| 2003-02-24 17:00:00 | MSFT | Stock | 24.04 | 24.08 | 24.02 | 24.03 | 58080.0 |
| 2003-02-24 18:00:00 | MSFT | Stock | 24.05 | 24.06 | 24.03 | 24.06 | 9274.0 |
| 2003-02-24 08:00:00 | NVDA | Stock | 0.1072 | 0.1072 | 0.1063 | 0.1063 | 402000.0 |
| 2003-02-24 09:00:00 | NVDA | Stock | 0.1067 | 0.1078 | 0.1057 | 0.1069 | 109242960.0 |
| 2003-02-24 10:00:00 | NVDA | Stock | 0.1068 | 0.1124 | 0.1067 | 0.1116 | 334514880.0 |
| 2003-02-24 11:00:00 | NVDA | Stock | 0.1115 | 0.1116 | 0.1091 | 0.1102 | 172688280.0 |
| 2003-02-24 12:00:00 | NVDA | Stock | 0.1103 | 0.1104 | 0.1093 | 0.1098 | 126921840.0 |
| 2003-02-24 13:00:00 | NVDA | Stock | 0.1097 | 0.1104 | 0.1096 | 0.1099 | 71303880.0 |
| 2003-02-24 14:00:00 | NVDA | Stock | 0.11 | 0.11 | 0.1084 | 0.1092 | 85745880.0 |
| 2003-02-24 15:00:00 | NVDA | Stock | 0.1092 | 0.1096 | 0.1083 | 0.1086 | 137775600.0 |
| 2003-02-24 16:00:00 | NVDA | Stock | 0.1085 | 0.1092 | 0.1085 | 0.1092 | 7674960.0 |
| 2003-02-24 17:00:00 | NVDA | Stock | 0.109 | 0.1092 | 0.1083 | 0.1092 | 816000.0 |
| 2003-02-24 18:00:00 | NVDA | Stock | 0.1091 | 0.1092 | 0.1091 | 0.1092 | 774480.0 |
| 2003-02-24 08:00:00 | AMZN | Stock | 1.085 | 1.0865 | 1.0805 | 1.0805 | 34000.0 |
| 2003-02-24 09:00:00 | AMZN | Stock | 1.0855 | 1.0945 | 1.082 | 1.0895 | 21900820.0 |
| 2003-02-24 10:00:00 | AMZN | Stock | 1.0895 | 1.1085 | 1.087 | 1.1064 | 26560700.0 |
| 2003-02-24 11:00:00 | AMZN | Stock | 1.1055 | 1.109 | 1.096 | 1.097 | 16921240.0 |
| 2003-02-24 12:00:00 | AMZN | Stock | 1.0965 | 1.097 | 1.0905 | 1.0935 | 9902780.0 |
| 2003-02-24 13:00:00 | AMZN | Stock | 1.0935 | 1.0956 | 1.092 | 1.0925 | 6937420.0 |
| 2003-02-24 14:00:00 | AMZN | Stock | 1.0925 | 1.0975 | 1.0835 | 1.0945 | 17864920.0 |
| 2003-02-24 15:00:00 | AMZN | Stock | 1.0945 | 1.0975 | 1.0865 | 1.089 | 22736080.0 |
| 2003-02-24 16:00:00 | AMZN | Stock | 1.09 | 1.0925 | 1.085 | 1.087 | 930420.0 |
| 2003-02-24 17:00:00 | AMZN | Stock | 1.091 | 1.091 | 1.087 | 1.0875 | 57000.0 |
| 2003-02-24 09:00:00 | CL | Stock | 25.5 | 25.5 | 25.35 | 25.4 | 202200.0 |
| 2003-02-24 10:00:00 | CL | Stock | 25.395 | 25.51 | 25.26 | 25.44 | 318800.0 |
| 2003-02-24 11:00:00 | CL | Stock | 25.44 | 25.44 | 25.375 | 25.38 | 198400.0 |
| 2003-02-24 12:00:00 | CL | Stock | 25.385 | 25.435 | 25.22 | 25.33 | 265400.0 |
| 2003-02-24 13:00:00 | CL | Stock | 25.335 | 25.37 | 25.27 | 25.35 | 153200.0 |
| 2003-02-24 14:00:00 | CL | Stock | 25.335 | 25.415 | 25.3 | 25.36 | 236000.0 |
| 2003-02-24 15:00:00 | CL | Stock | 25.375 | 25.43 | 25.16 | 25.2 | 387600.0 |
| 2003-02-24 16:00:00 | CL | Stock | 25.185 | 25.185 | 25.185 | 25.185 | 95600.0 |
> showing 50 of 20,254 rows — these rows as CSV