PREVIEW / stock_1hour / 2003-05-08
file: by_date/stock_1hour/2003/2003-05-08.parquet size: 415 KB rows: 20,165 symbols: 1,568
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-05-08 08:00:00 | AAPL | Stock | 0.3188 | 0.3188 | 0.3123 | 0.3155 | 4256000.0 |
| 2003-05-08 09:00:00 | AAPL | Stock | 0.3157 | 0.3168 | 0.3089 | 0.3129 | 102579176.0 |
| 2003-05-08 10:00:00 | AAPL | Stock | 0.3129 | 0.3177 | 0.3123 | 0.3166 | 100764720.0 |
| 2003-05-08 11:00:00 | AAPL | Stock | 0.3168 | 0.3178 | 0.3143 | 0.3152 | 40506760.0 |
| 2003-05-08 12:00:00 | AAPL | Stock | 0.3154 | 0.3166 | 0.3132 | 0.3163 | 68516728.0 |
| 2003-05-08 13:00:00 | AAPL | Stock | 0.3163 | 0.3175 | 0.3139 | 0.315 | 48887832.0 |
| 2003-05-08 14:00:00 | AAPL | Stock | 0.3148 | 0.3175 | 0.3143 | 0.3171 | 47312440.0 |
| 2003-05-08 15:00:00 | AAPL | Stock | 0.3171 | 0.3225 | 0.317 | 0.322 | 146851376.0 |
| 2003-05-08 16:00:00 | AAPL | Stock | 0.3218 | 0.3227 | 0.3214 | 0.3216 | 4478992.0 |
| 2003-05-08 17:00:00 | AAPL | Stock | 0.3213 | 0.3229 | 0.3213 | 0.3223 | 22400.0 |
| 2003-05-08 18:00:00 | AAPL | Stock | 0.3214 | 0.3214 | 0.3214 | 0.3214 | 11200.0 |
| 2003-05-08 08:00:00 | MSFT | Stock | 25.83 | 26.0 | 25.76 | 25.82 | 81603.0 |
| 2003-05-08 09:00:00 | MSFT | Stock | 25.799 | 25.99 | 25.71 | 25.78 | 6131133.0 |
| 2003-05-08 10:00:00 | MSFT | Stock | 25.77 | 26.09 | 25.741 | 26.04 | 9419001.0 |
| 2003-05-08 11:00:00 | MSFT | Stock | 26.04 | 26.148 | 25.96 | 25.98 | 5652812.0 |
| 2003-05-08 12:00:00 | MSFT | Stock | 25.981 | 25.994 | 25.73 | 25.8 | 4929273.0 |
| 2003-05-08 13:00:00 | MSFT | Stock | 25.81 | 26.0 | 25.746 | 25.76 | 3474499.0 |
| 2003-05-08 14:00:00 | MSFT | Stock | 25.76 | 25.84 | 25.729 | 25.8 | 2794216.0 |
| 2003-05-08 15:00:00 | MSFT | Stock | 25.81 | 25.94 | 25.72 | 25.75 | 6410785.0 |
| 2003-05-08 16:00:00 | MSFT | Stock | 25.75 | 25.79 | 25.6762 | 25.72 | 656835.0 |
| 2003-05-08 17:00:00 | MSFT | Stock | 25.72 | 25.8 | 25.72 | 25.8 | 55031.0 |
| 2003-05-08 18:00:00 | MSFT | Stock | 25.8 | 25.8 | 25.776 | 25.8 | 5400.0 |
| 2003-05-08 08:00:00 | NVDA | Stock | 0.1329 | 0.1329 | 0.1318 | 0.1326 | 1360800.0 |
| 2003-05-08 09:00:00 | NVDA | Stock | 0.1323 | 0.1337 | 0.1304 | 0.1326 | 167613600.0 |
| 2003-05-08 10:00:00 | NVDA | Stock | 0.1326 | 0.1367 | 0.1321 | 0.1358 | 196843800.0 |
| 2003-05-08 11:00:00 | NVDA | Stock | 0.1359 | 0.1392 | 0.1357 | 0.1374 | 197739000.0 |
| 2003-05-08 12:00:00 | NVDA | Stock | 0.1374 | 0.1375 | 0.1345 | 0.1347 | 149909400.0 |
| 2003-05-08 13:00:00 | NVDA | Stock | 0.1347 | 0.137 | 0.1336 | 0.1367 | 171553920.0 |
| 2003-05-08 14:00:00 | NVDA | Stock | 0.1367 | 0.1373 | 0.1342 | 0.135 | 145981920.0 |
| 2003-05-08 15:00:00 | NVDA | Stock | 0.135 | 0.136 | 0.1332 | 0.1337 | 301914000.0 |
| 2003-05-08 16:00:00 | NVDA | Stock | 0.1337 | 0.1362 | 0.1267 | 0.1294 | 186557400.0 |
| 2003-05-08 17:00:00 | NVDA | Stock | 0.1289 | 0.15 | 0.1287 | 0.1479 | 256630440.0 |
| 2003-05-08 18:00:00 | NVDA | Stock | 0.1479 | 0.1515 | 0.1479 | 0.1504 | 65534160.0 |
| 2003-05-08 08:00:00 | AMZN | Stock | 1.5126 | 1.5215 | 1.5126 | 1.52 | 120800.0 |
| 2003-05-08 09:00:00 | AMZN | Stock | 1.52 | 1.5345 | 1.511 | 1.523 | 25412440.0 |
| 2003-05-08 10:00:00 | AMZN | Stock | 1.523 | 1.5345 | 1.5195 | 1.5265 | 27565540.0 |
| 2003-05-08 11:00:00 | AMZN | Stock | 1.527 | 1.5382 | 1.525 | 1.526 | 19257600.0 |
| 2003-05-08 12:00:00 | AMZN | Stock | 1.5265 | 1.531 | 1.5226 | 1.5295 | 19992960.0 |
| 2003-05-08 13:00:00 | AMZN | Stock | 1.5305 | 1.5355 | 1.529 | 1.53 | 12799880.0 |
| 2003-05-08 14:00:00 | AMZN | Stock | 1.5305 | 1.5315 | 1.5185 | 1.5205 | 17049760.0 |
| 2003-05-08 15:00:00 | AMZN | Stock | 1.5205 | 1.5285 | 1.52 | 1.522 | 17513320.0 |
| 2003-05-08 16:00:00 | AMZN | Stock | 1.5225 | 1.5235 | 1.519 | 1.5205 | 1304000.0 |
| 2003-05-08 17:00:00 | AMZN | Stock | 1.5225 | 1.526 | 1.522 | 1.5255 | 130000.0 |
| 2003-05-08 18:00:00 | AMZN | Stock | 1.5275 | 1.5285 | 1.5275 | 1.5285 | 60000.0 |
| 2003-05-08 09:00:00 | CL | Stock | 28.5 | 28.645 | 28.5 | 28.585 | 600600.0 |
| 2003-05-08 10:00:00 | CL | Stock | 28.605 | 28.675 | 28.575 | 28.625 | 575800.0 |
| 2003-05-08 11:00:00 | CL | Stock | 28.615 | 28.625 | 28.545 | 28.555 | 479400.0 |
| 2003-05-08 12:00:00 | CL | Stock | 28.545 | 28.545 | 28.425 | 28.455 | 274200.0 |
| 2003-05-08 13:00:00 | CL | Stock | 28.44 | 28.515 | 28.4 | 28.4 | 232200.0 |
| 2003-05-08 14:00:00 | CL | Stock | 28.395 | 28.53 | 28.385 | 28.495 | 316400.0 |
> showing 50 of 20,165 rows — these rows as CSV