PREVIEW / stock_1hour / 2003-04-11
file: by_date/stock_1hour/2003/2003-04-11.parquet size: 400 KB rows: 20,385 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-04-11 08:00:00 | AAPL | Stock | 0.2563 | 0.2591 | 0.2521 | 0.2582 | 817600.0 |
| 2003-04-11 09:00:00 | AAPL | Stock | 0.2582 | 0.2588 | 0.2446 | 0.2459 | 87901072.0 |
| 2003-04-11 10:00:00 | AAPL | Stock | 0.2459 | 0.2463 | 0.2382 | 0.2393 | 166132624.0 |
| 2003-04-11 11:00:00 | AAPL | Stock | 0.2395 | 0.2438 | 0.2334 | 0.2364 | 142463496.0 |
| 2003-04-11 12:00:00 | AAPL | Stock | 0.2363 | 0.2375 | 0.2352 | 0.2368 | 125164648.0 |
| 2003-04-11 13:00:00 | AAPL | Stock | 0.2368 | 0.2409 | 0.2334 | 0.2336 | 204410080.0 |
| 2003-04-11 14:00:00 | AAPL | Stock | 0.2336 | 0.237 | 0.2309 | 0.2332 | 202806520.0 |
| 2003-04-11 15:00:00 | AAPL | Stock | 0.2332 | 0.2373 | 0.232 | 0.237 | 284851560.0 |
| 2003-04-11 16:00:00 | AAPL | Stock | 0.237 | 0.2529 | 0.2343 | 0.2389 | 26488392.0 |
| 2003-04-11 17:00:00 | AAPL | Stock | 0.2366 | 0.2375 | 0.2355 | 0.2366 | 2055200.0 |
| 2003-04-11 18:00:00 | AAPL | Stock | 0.2366 | 0.2373 | 0.2366 | 0.2373 | 162400.0 |
| 2003-04-11 08:00:00 | MSFT | Stock | 24.65 | 24.958 | 24.5 | 24.879 | 211905.0 |
| 2003-04-11 09:00:00 | MSFT | Stock | 24.85 | 25.18 | 24.3 | 24.9 | 10290385.0 |
| 2003-04-11 10:00:00 | MSFT | Stock | 24.9 | 24.921 | 24.16 | 24.282 | 14853681.0 |
| 2003-04-11 11:00:00 | MSFT | Stock | 24.28 | 24.34 | 24.05 | 24.13 | 8980975.0 |
| 2003-04-11 12:00:00 | MSFT | Stock | 24.12 | 24.2 | 24.01 | 24.06 | 7485523.0 |
| 2003-04-11 13:00:00 | MSFT | Stock | 24.06 | 24.15 | 23.95 | 24.019 | 6777471.0 |
| 2003-04-11 14:00:00 | MSFT | Stock | 24.019 | 24.23 | 24.01 | 24.03 | 5961767.0 |
| 2003-04-11 15:00:00 | MSFT | Stock | 24.03 | 24.22 | 23.96 | 24.21 | 11007040.0 |
| 2003-04-11 16:00:00 | MSFT | Stock | 24.2 | 24.22 | 24.05 | 24.15 | 460513.0 |
| 2003-04-11 17:00:00 | MSFT | Stock | 24.1888 | 24.2 | 24.11 | 24.131 | 79281.0 |
| 2003-04-11 18:00:00 | MSFT | Stock | 24.13 | 24.18 | 24.13 | 24.18 | 16810.0 |
| 2003-04-11 08:00:00 | NVDA | Stock | 0.1125 | 0.1131 | 0.1123 | 0.1129 | 1056000.0 |
| 2003-04-11 09:00:00 | NVDA | Stock | 0.1134 | 0.1138 | 0.1117 | 0.1125 | 55903200.0 |
| 2003-04-11 10:00:00 | NVDA | Stock | 0.1123 | 0.1123 | 0.1109 | 0.1113 | 56931960.0 |
| 2003-04-11 11:00:00 | NVDA | Stock | 0.1113 | 0.1116 | 0.111 | 0.1111 | 31473120.0 |
| 2003-04-11 12:00:00 | NVDA | Stock | 0.1112 | 0.1115 | 0.1111 | 0.1112 | 46913640.0 |
| 2003-04-11 13:00:00 | NVDA | Stock | 0.1113 | 0.1114 | 0.1093 | 0.1096 | 63949560.0 |
| 2003-04-11 14:00:00 | NVDA | Stock | 0.1095 | 0.1107 | 0.1095 | 0.1102 | 26916360.0 |
| 2003-04-11 15:00:00 | NVDA | Stock | 0.1102 | 0.1107 | 0.1097 | 0.1104 | 51628560.0 |
| 2003-04-11 16:00:00 | NVDA | Stock | 0.1104 | 0.1104 | 0.1098 | 0.1098 | 6502320.0 |
| 2003-04-11 17:00:00 | NVDA | Stock | 0.1103 | 0.1104 | 0.1098 | 0.1098 | 3438000.0 |
| 2003-04-11 18:00:00 | NVDA | Stock | 0.1102 | 0.1102 | 0.1102 | 0.1102 | 36000.0 |
| 2003-04-11 08:00:00 | AMZN | Stock | 1.283 | 1.295 | 1.283 | 1.2945 | 168500.0 |
| 2003-04-11 09:00:00 | AMZN | Stock | 1.295 | 1.312 | 1.2881 | 1.2995 | 23045680.0 |
| 2003-04-11 10:00:00 | AMZN | Stock | 1.2995 | 1.2995 | 1.2785 | 1.285 | 35470400.0 |
| 2003-04-11 11:00:00 | AMZN | Stock | 1.285 | 1.2975 | 1.283 | 1.2965 | 13726300.0 |
| 2003-04-11 12:00:00 | AMZN | Stock | 1.2965 | 1.3 | 1.289 | 1.2895 | 9933040.0 |
| 2003-04-11 13:00:00 | AMZN | Stock | 1.29 | 1.29 | 1.271 | 1.276 | 19619240.0 |
| 2003-04-11 14:00:00 | AMZN | Stock | 1.276 | 1.2895 | 1.2725 | 1.2835 | 9497760.0 |
| 2003-04-11 15:00:00 | AMZN | Stock | 1.2835 | 1.2905 | 1.2808 | 1.286 | 11047600.0 |
| 2003-04-11 16:00:00 | AMZN | Stock | 1.286 | 1.288 | 1.285 | 1.2855 | 1011140.0 |
| 2003-04-11 17:00:00 | AMZN | Stock | 1.2869 | 1.2879 | 1.286 | 1.2879 | 374000.0 |
| 2003-04-11 18:00:00 | AMZN | Stock | 1.2875 | 1.2875 | 1.2875 | 1.2875 | 8000.0 |
| 2003-04-11 09:00:00 | CL | Stock | 28.0 | 28.29 | 27.99 | 28.15 | 461800.0 |
| 2003-04-11 10:00:00 | CL | Stock | 28.155 | 28.175 | 27.845 | 27.87 | 437200.0 |
| 2003-04-11 11:00:00 | CL | Stock | 27.87 | 27.925 | 27.81 | 27.85 | 207800.0 |
| 2003-04-11 12:00:00 | CL | Stock | 27.855 | 27.95 | 27.815 | 27.88 | 124200.0 |
| 2003-04-11 13:00:00 | CL | Stock | 27.89 | 27.925 | 27.78 | 27.795 | 154800.0 |
| 2003-04-11 14:00:00 | CL | Stock | 27.795 | 27.88 | 27.78 | 27.79 | 133000.0 |
> showing 50 of 20,385 rows — these rows as CSV