PREVIEW / stock_1hour / 2003-08-18
file: by_date/stock_1hour/2003/2003-08-18.parquet size: 458 KB rows: 22,532 symbols: 1,610
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-08-18 08:00:00 | AAPL | Stock | 0.3527 | 0.3554 | 0.3527 | 0.3554 | 106400.0 |
| 2003-08-18 09:00:00 | AAPL | Stock | 0.3554 | 0.3563 | 0.3521 | 0.3541 | 22746472.0 |
| 2003-08-18 10:00:00 | AAPL | Stock | 0.3543 | 0.3564 | 0.3523 | 0.3545 | 29323896.0 |
| 2003-08-18 11:00:00 | AAPL | Stock | 0.3545 | 0.3613 | 0.3545 | 0.3596 | 30087904.0 |
| 2003-08-18 12:00:00 | AAPL | Stock | 0.3596 | 0.3609 | 0.3582 | 0.3588 | 27754776.0 |
| 2003-08-18 13:00:00 | AAPL | Stock | 0.3589 | 0.3589 | 0.3566 | 0.3584 | 10247832.0 |
| 2003-08-18 14:00:00 | AAPL | Stock | 0.3584 | 0.3625 | 0.3584 | 0.3618 | 12853568.0 |
| 2003-08-18 15:00:00 | AAPL | Stock | 0.3618 | 0.3645 | 0.3609 | 0.3634 | 39902800.0 |
| 2003-08-18 16:00:00 | AAPL | Stock | 0.363 | 0.3643 | 0.3629 | 0.3639 | 2111200.0 |
| 2003-08-18 17:00:00 | AAPL | Stock | 0.3639 | 0.3639 | 0.3634 | 0.3636 | 812000.0 |
| 2003-08-18 08:00:00 | MSFT | Stock | 25.545 | 25.64 | 25.5 | 25.55 | 32359.0 |
| 2003-08-18 09:00:00 | MSFT | Stock | 25.57 | 25.66 | 25.5 | 25.51 | 6782282.0 |
| 2003-08-18 10:00:00 | MSFT | Stock | 25.51 | 25.63 | 25.46 | 25.561 | 7549162.0 |
| 2003-08-18 11:00:00 | MSFT | Stock | 25.57 | 25.64 | 25.54 | 25.6305 | 5514224.0 |
| 2003-08-18 12:00:00 | MSFT | Stock | 25.63 | 25.69 | 25.59 | 25.63 | 3458974.0 |
| 2003-08-18 13:00:00 | MSFT | Stock | 25.63 | 25.68 | 25.6 | 25.68 | 4292585.0 |
| 2003-08-18 14:00:00 | MSFT | Stock | 25.66 | 25.79 | 25.64 | 25.76 | 5389955.0 |
| 2003-08-18 15:00:00 | MSFT | Stock | 25.76 | 25.8 | 25.64 | 25.72 | 8065409.0 |
| 2003-08-18 16:00:00 | MSFT | Stock | 25.71 | 25.76 | 25.7 | 25.73 | 572607.0 |
| 2003-08-18 17:00:00 | MSFT | Stock | 25.74 | 25.75 | 25.72 | 25.72 | 167290.0 |
| 2003-08-18 18:00:00 | MSFT | Stock | 25.73 | 25.75 | 25.73 | 25.75 | 2900.0 |
| 2003-08-18 08:00:00 | NVDA | Stock | 0.135 | 0.1364 | 0.1348 | 0.1358 | 2316000.0 |
| 2003-08-18 09:00:00 | NVDA | Stock | 0.1361 | 0.1375 | 0.1343 | 0.1353 | 91966440.0 |
| 2003-08-18 10:00:00 | NVDA | Stock | 0.1355 | 0.1369 | 0.1352 | 0.1369 | 136650480.0 |
| 2003-08-18 11:00:00 | NVDA | Stock | 0.137 | 0.1382 | 0.1369 | 0.138 | 90184440.0 |
| 2003-08-18 12:00:00 | NVDA | Stock | 0.1379 | 0.138 | 0.1371 | 0.1376 | 61285320.0 |
| 2003-08-18 13:00:00 | NVDA | Stock | 0.1376 | 0.1377 | 0.1372 | 0.1374 | 53906400.0 |
| 2003-08-18 14:00:00 | NVDA | Stock | 0.1374 | 0.1381 | 0.1372 | 0.1378 | 75545760.0 |
| 2003-08-18 15:00:00 | NVDA | Stock | 0.1379 | 0.1386 | 0.1373 | 0.1384 | 140351640.0 |
| 2003-08-18 16:00:00 | NVDA | Stock | 0.1385 | 0.1396 | 0.1384 | 0.139 | 11112000.0 |
| 2003-08-18 17:00:00 | NVDA | Stock | 0.1393 | 0.1398 | 0.1384 | 0.1384 | 1039200.0 |
| 2003-08-18 18:00:00 | NVDA | Stock | 0.1398 | 0.1407 | 0.1398 | 0.1406 | 1212000.0 |
| 2003-08-18 08:00:00 | AMZN | Stock | 2.01 | 2.0125 | 2.0075 | 2.0125 | 246000.0 |
| 2003-08-18 09:00:00 | AMZN | Stock | 2.0055 | 2.082 | 2.0055 | 2.0645 | 36201000.0 |
| 2003-08-18 10:00:00 | AMZN | Stock | 2.0645 | 2.076 | 2.0565 | 2.0745 | 24843160.0 |
| 2003-08-18 11:00:00 | AMZN | Stock | 2.0745 | 2.0795 | 2.066 | 2.075 | 16443680.0 |
| 2003-08-18 12:00:00 | AMZN | Stock | 2.075 | 2.0865 | 2.0745 | 2.0845 | 15672180.0 |
| 2003-08-18 13:00:00 | AMZN | Stock | 2.085 | 2.1025 | 2.0845 | 2.102 | 22043280.0 |
| 2003-08-18 14:00:00 | AMZN | Stock | 2.102 | 2.135 | 2.102 | 2.1325 | 35014760.0 |
| 2003-08-18 15:00:00 | AMZN | Stock | 2.1325 | 2.162 | 2.1275 | 2.151 | 45923120.0 |
| 2003-08-18 16:00:00 | AMZN | Stock | 2.15 | 2.1575 | 2.1425 | 2.1575 | 2169600.0 |
| 2003-08-18 17:00:00 | AMZN | Stock | 2.1575 | 2.1625 | 2.151 | 2.151 | 430600.0 |
| 2003-08-18 18:00:00 | AMZN | Stock | 2.161 | 2.1625 | 2.16 | 2.16 | 24000.0 |
| 2003-08-18 09:00:00 | CL | Stock | 27.425 | 27.475 | 27.335 | 27.335 | 341600.0 |
| 2003-08-18 10:00:00 | CL | Stock | 27.35 | 27.45 | 27.345 | 27.405 | 575800.0 |
| 2003-08-18 11:00:00 | CL | Stock | 27.4 | 27.435 | 27.335 | 27.385 | 373400.0 |
| 2003-08-18 12:00:00 | CL | Stock | 27.375 | 27.42 | 27.335 | 27.4 | 290400.0 |
| 2003-08-18 13:00:00 | CL | Stock | 27.4 | 27.405 | 27.375 | 27.405 | 170400.0 |
| 2003-08-18 14:00:00 | CL | Stock | 27.405 | 27.435 | 27.34 | 27.37 | 283000.0 |
| 2003-08-18 15:00:00 | CL | Stock | 27.375 | 27.375 | 27.27 | 27.3 | 711000.0 |
> showing 50 of 22,532 rows — these rows as CSV