PREVIEW / stock_1hour / 2003-04-16
file: by_date/stock_1hour/2003/2003-04-16.parquet size: 411 KB rows: 20,204 symbols: 1,556
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-16 08:00:00 | AAPL | Stock | 0.2241 | 0.2393 | 0.2218 | 0.2321 | 27555360.0 |
| 2003-04-16 09:00:00 | AAPL | Stock | 0.2321 | 0.2343 | 0.2266 | 0.232 | 154591640.0 |
| 2003-04-16 10:00:00 | AAPL | Stock | 0.2321 | 0.2357 | 0.2313 | 0.2327 | 170111368.0 |
| 2003-04-16 11:00:00 | AAPL | Stock | 0.2327 | 0.2341 | 0.2314 | 0.2327 | 97044864.0 |
| 2003-04-16 12:00:00 | AAPL | Stock | 0.2329 | 0.2339 | 0.2321 | 0.2329 | 38901128.0 |
| 2003-04-16 13:00:00 | AAPL | Stock | 0.233 | 0.2336 | 0.232 | 0.2323 | 42609784.0 |
| 2003-04-16 14:00:00 | AAPL | Stock | 0.2321 | 0.2441 | 0.2314 | 0.2377 | 263839072.0 |
| 2003-04-16 15:00:00 | AAPL | Stock | 0.2375 | 0.2379 | 0.2348 | 0.2363 | 114869664.0 |
| 2003-04-16 16:00:00 | AAPL | Stock | 0.2363 | 0.2388 | 0.2318 | 0.2359 | 25790408.0 |
| 2003-04-16 17:00:00 | AAPL | Stock | 0.2356 | 0.2371 | 0.2336 | 0.2339 | 3406312.0 |
| 2003-04-16 18:00:00 | AAPL | Stock | 0.2339 | 0.2339 | 0.2334 | 0.2334 | 180712.0 |
| 2003-04-16 08:00:00 | MSFT | Stock | 25.8 | 25.99 | 24.62 | 25.65 | 2290300.0 |
| 2003-04-16 09:00:00 | MSFT | Stock | 25.651 | 25.75 | 25.3 | 25.55 | 17657020.0 |
| 2003-04-16 10:00:00 | MSFT | Stock | 25.55 | 25.64 | 25.192 | 25.29 | 17990378.0 |
| 2003-04-16 11:00:00 | MSFT | Stock | 25.29 | 25.4489 | 25.16 | 25.31 | 11385958.0 |
| 2003-04-16 12:00:00 | MSFT | Stock | 25.3 | 25.4 | 25.26 | 25.343 | 4796666.0 |
| 2003-04-16 13:00:00 | MSFT | Stock | 25.35 | 25.35 | 25.25 | 25.319 | 4733359.0 |
| 2003-04-16 14:00:00 | MSFT | Stock | 25.32 | 25.32 | 25.05 | 25.167 | 7691804.0 |
| 2003-04-16 15:00:00 | MSFT | Stock | 25.165 | 25.2 | 24.841 | 24.91 | 12500854.0 |
| 2003-04-16 16:00:00 | MSFT | Stock | 24.92 | 24.98 | 24.77 | 24.9 | 570007.0 |
| 2003-04-16 17:00:00 | MSFT | Stock | 24.85 | 24.94 | 24.85 | 24.88 | 30365.0 |
| 2003-04-16 18:00:00 | MSFT | Stock | 24.86 | 24.889 | 24.84 | 24.85 | 10621.0 |
| 2003-04-16 08:00:00 | NVDA | Stock | 0.116 | 0.1162 | 0.1147 | 0.1147 | 2634720.0 |
| 2003-04-16 09:00:00 | NVDA | Stock | 0.1147 | 0.115 | 0.1122 | 0.1131 | 100753800.0 |
| 2003-04-16 10:00:00 | NVDA | Stock | 0.1131 | 0.1142 | 0.1126 | 0.1127 | 159049800.0 |
| 2003-04-16 11:00:00 | NVDA | Stock | 0.1127 | 0.113 | 0.1119 | 0.1121 | 66343920.0 |
| 2003-04-16 12:00:00 | NVDA | Stock | 0.1121 | 0.1132 | 0.1119 | 0.1131 | 52954920.0 |
| 2003-04-16 13:00:00 | NVDA | Stock | 0.1131 | 0.1131 | 0.1117 | 0.1122 | 58102320.0 |
| 2003-04-16 14:00:00 | NVDA | Stock | 0.1122 | 0.1122 | 0.1108 | 0.1117 | 86005800.0 |
| 2003-04-16 15:00:00 | NVDA | Stock | 0.1117 | 0.1126 | 0.1112 | 0.1117 | 78376440.0 |
| 2003-04-16 16:00:00 | NVDA | Stock | 0.1117 | 0.1118 | 0.1108 | 0.1108 | 9003720.0 |
| 2003-04-16 17:00:00 | NVDA | Stock | 0.1107 | 0.1117 | 0.1107 | 0.1117 | 534000.0 |
| 2003-04-16 18:00:00 | NVDA | Stock | 0.1117 | 0.1117 | 0.1117 | 0.1117 | 168000.0 |
| 2003-04-16 08:00:00 | AMZN | Stock | 1.275 | 1.2835 | 1.257 | 1.2615 | 260360.0 |
| 2003-04-16 09:00:00 | AMZN | Stock | 1.2615 | 1.275 | 1.2536 | 1.2615 | 15328940.0 |
| 2003-04-16 10:00:00 | AMZN | Stock | 1.2615 | 1.262 | 1.214 | 1.224 | 64606540.0 |
| 2003-04-16 11:00:00 | AMZN | Stock | 1.224 | 1.227 | 1.2065 | 1.2145 | 37520300.0 |
| 2003-04-16 12:00:00 | AMZN | Stock | 1.215 | 1.227 | 1.212 | 1.223 | 9931620.0 |
| 2003-04-16 13:00:00 | AMZN | Stock | 1.2235 | 1.225 | 1.215 | 1.217 | 7741100.0 |
| 2003-04-16 14:00:00 | AMZN | Stock | 1.218 | 1.22 | 1.209 | 1.218 | 17977500.0 |
| 2003-04-16 15:00:00 | AMZN | Stock | 1.2185 | 1.224 | 1.213 | 1.219 | 14160580.0 |
| 2003-04-16 16:00:00 | AMZN | Stock | 1.2195 | 1.2275 | 1.218 | 1.2275 | 1650800.0 |
| 2003-04-16 17:00:00 | AMZN | Stock | 1.2185 | 1.219 | 1.2185 | 1.219 | 16000.0 |
| 2003-04-16 18:00:00 | AMZN | Stock | 1.2185 | 1.2185 | 1.2185 | 1.2185 | 128000.0 |
| 2003-04-16 09:00:00 | CL | Stock | 28.5 | 28.6 | 28.38 | 28.46 | 528000.0 |
| 2003-04-16 10:00:00 | CL | Stock | 28.46 | 28.52 | 28.245 | 28.345 | 727000.0 |
| 2003-04-16 11:00:00 | CL | Stock | 28.34 | 28.385 | 28.25 | 28.28 | 359600.0 |
| 2003-04-16 12:00:00 | CL | Stock | 28.26 | 28.375 | 28.25 | 28.285 | 326800.0 |
| 2003-04-16 13:00:00 | CL | Stock | 28.285 | 28.305 | 28.21 | 28.295 | 287600.0 |
| 2003-04-16 14:00:00 | CL | Stock | 28.3 | 28.31 | 28.14 | 28.19 | 345600.0 |
> showing 50 of 20,204 rows — these rows as CSV