PREVIEW / stock_1hour / 2003-03-05
file: by_date/stock_1hour/2003/2003-03-05.parquet size: 421 KB rows: 20,095 symbols: 1,551
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-05 08:00:00 | AAPL | Stock | 0.2595 | 0.2595 | 0.2595 | 0.2595 | 1349600.0 |
| 2003-03-05 09:00:00 | AAPL | Stock | 0.2643 | 0.2643 | 0.2593 | 0.2618 | 14416640.0 |
| 2003-03-05 10:00:00 | AAPL | Stock | 0.2618 | 0.2625 | 0.2596 | 0.26 | 15376200.0 |
| 2003-03-05 11:00:00 | AAPL | Stock | 0.26 | 0.262 | 0.2596 | 0.2618 | 7832496.0 |
| 2003-03-05 12:00:00 | AAPL | Stock | 0.2616 | 0.2634 | 0.26 | 0.2627 | 15746808.0 |
| 2003-03-05 13:00:00 | AAPL | Stock | 0.2627 | 0.2643 | 0.262 | 0.2634 | 14213024.0 |
| 2003-03-05 14:00:00 | AAPL | Stock | 0.2632 | 0.2638 | 0.2593 | 0.2602 | 19522776.0 |
| 2003-03-05 15:00:00 | AAPL | Stock | 0.2605 | 0.2629 | 0.2602 | 0.2611 | 18223912.0 |
| 2003-03-05 16:00:00 | AAPL | Stock | 0.2609 | 0.2616 | 0.26 | 0.2611 | 1612800.0 |
| 2003-03-05 17:00:00 | AAPL | Stock | 0.2611 | 0.2611 | 0.2588 | 0.2588 | 828800.0 |
| 2003-03-05 08:00:00 | MSFT | Stock | 23.2 | 23.2 | 23.0 | 23.12 | 76433.0 |
| 2003-03-05 09:00:00 | MSFT | Stock | 23.12 | 23.38 | 23.06 | 23.326 | 6498818.0 |
| 2003-03-05 10:00:00 | MSFT | Stock | 23.32 | 23.41 | 23.133 | 23.15 | 8260012.0 |
| 2003-03-05 11:00:00 | MSFT | Stock | 23.16 | 23.28 | 23.108 | 23.24 | 5180041.0 |
| 2003-03-05 12:00:00 | MSFT | Stock | 23.241 | 23.47 | 23.2 | 23.38 | 4796586.0 |
| 2003-03-05 13:00:00 | MSFT | Stock | 23.388 | 23.5 | 23.31 | 23.39 | 4153355.0 |
| 2003-03-05 14:00:00 | MSFT | Stock | 23.4 | 23.45 | 23.09 | 23.22 | 7368597.0 |
| 2003-03-05 15:00:00 | MSFT | Stock | 23.22 | 23.51 | 23.16 | 23.43 | 10555991.0 |
| 2003-03-05 16:00:00 | MSFT | Stock | 23.43 | 23.51 | 23.3365 | 23.4 | 1422209.0 |
| 2003-03-05 17:00:00 | MSFT | Stock | 23.41 | 23.44 | 23.39 | 23.439 | 140020.0 |
| 2003-03-05 18:00:00 | MSFT | Stock | 23.44 | 23.45 | 23.4 | 23.4 | 11949.0 |
| 2003-03-05 08:00:00 | NVDA | Stock | 0.1026 | 0.1027 | 0.1 | 0.1026 | 10863000.0 |
| 2003-03-05 09:00:00 | NVDA | Stock | 0.1006 | 0.1042 | 0.1006 | 0.1033 | 105885360.0 |
| 2003-03-05 10:00:00 | NVDA | Stock | 0.1033 | 0.1034 | 0.1022 | 0.1022 | 63862440.0 |
| 2003-03-05 11:00:00 | NVDA | Stock | 0.1022 | 0.1031 | 0.1021 | 0.1029 | 40830240.0 |
| 2003-03-05 12:00:00 | NVDA | Stock | 0.1029 | 0.1042 | 0.1027 | 0.1039 | 37861680.0 |
| 2003-03-05 13:00:00 | NVDA | Stock | 0.1037 | 0.1043 | 0.1032 | 0.1038 | 64203600.0 |
| 2003-03-05 14:00:00 | NVDA | Stock | 0.1037 | 0.1041 | 0.1027 | 0.1035 | 47127960.0 |
| 2003-03-05 15:00:00 | NVDA | Stock | 0.1035 | 0.1049 | 0.1032 | 0.1042 | 87780000.0 |
| 2003-03-05 16:00:00 | NVDA | Stock | 0.1042 | 0.1047 | 0.104 | 0.1042 | 5752440.0 |
| 2003-03-05 17:00:00 | NVDA | Stock | 0.1047 | 0.105 | 0.1042 | 0.1047 | 972000.0 |
| 2003-03-05 18:00:00 | NVDA | Stock | 0.1047 | 0.1047 | 0.1042 | 0.1042 | 480000.0 |
| 2003-03-05 08:00:00 | AMZN | Stock | 1.1132 | 1.13 | 1.1081 | 1.1135 | 26000.0 |
| 2003-03-05 09:00:00 | AMZN | Stock | 1.113 | 1.1205 | 1.103 | 1.112 | 11144160.0 |
| 2003-03-05 10:00:00 | AMZN | Stock | 1.1118 | 1.1163 | 1.101 | 1.101 | 13657200.0 |
| 2003-03-05 11:00:00 | AMZN | Stock | 1.1015 | 1.111 | 1.1015 | 1.1095 | 10289240.0 |
| 2003-03-05 12:00:00 | AMZN | Stock | 1.11 | 1.1185 | 1.109 | 1.115 | 10204520.0 |
| 2003-03-05 13:00:00 | AMZN | Stock | 1.1155 | 1.125 | 1.1145 | 1.1201 | 12452860.0 |
| 2003-03-05 14:00:00 | AMZN | Stock | 1.1195 | 1.1225 | 1.1135 | 1.1165 | 8763000.0 |
| 2003-03-05 15:00:00 | AMZN | Stock | 1.1165 | 1.131 | 1.116 | 1.124 | 21698580.0 |
| 2003-03-05 16:00:00 | AMZN | Stock | 1.1215 | 1.128 | 1.1195 | 1.121 | 1238900.0 |
| 2003-03-05 17:00:00 | AMZN | Stock | 1.121 | 1.121 | 1.1195 | 1.1195 | 308000.0 |
| 2003-03-05 18:00:00 | AMZN | Stock | 1.1195 | 1.1265 | 1.1175 | 1.1265 | 22000.0 |
| 2003-03-05 09:00:00 | CL | Stock | 24.835 | 24.89 | 24.82 | 24.88 | 255000.0 |
| 2003-03-05 10:00:00 | CL | Stock | 24.875 | 24.895 | 24.725 | 24.725 | 592200.0 |
| 2003-03-05 11:00:00 | CL | Stock | 24.73 | 24.845 | 24.7 | 24.81 | 368600.0 |
| 2003-03-05 12:00:00 | CL | Stock | 24.805 | 24.965 | 24.75 | 24.965 | 241000.0 |
| 2003-03-05 13:00:00 | CL | Stock | 24.965 | 24.98 | 24.885 | 24.91 | 221800.0 |
| 2003-03-05 14:00:00 | CL | Stock | 24.925 | 24.95 | 24.79 | 24.89 | 269200.0 |
| 2003-03-05 15:00:00 | CL | Stock | 24.9 | 25.045 | 24.9 | 25.045 | 431600.0 |
> showing 50 of 20,095 rows — these rows as CSV