PREVIEW / stock_1hour / 2003-04-10
file: by_date/stock_1hour/2003/2003-04-10.parquet size: 407 KB rows: 20,520 symbols: 1,552
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-10 09:00:00 | AAPL | Stock | 0.2536 | 0.2561 | 0.2536 | 0.255 | 13655264.0 |
| 2003-04-10 10:00:00 | AAPL | Stock | 0.2546 | 0.2554 | 0.2536 | 0.2543 | 17611832.0 |
| 2003-04-10 11:00:00 | AAPL | Stock | 0.2545 | 0.2548 | 0.2536 | 0.2546 | 12486712.0 |
| 2003-04-10 12:00:00 | AAPL | Stock | 0.2545 | 0.2557 | 0.2545 | 0.2557 | 14224616.0 |
| 2003-04-10 13:00:00 | AAPL | Stock | 0.2557 | 0.2568 | 0.255 | 0.2559 | 10563616.0 |
| 2003-04-10 14:00:00 | AAPL | Stock | 0.2559 | 0.257 | 0.2555 | 0.2564 | 11392360.0 |
| 2003-04-10 15:00:00 | AAPL | Stock | 0.2566 | 0.257 | 0.255 | 0.2566 | 18647440.0 |
| 2003-04-10 16:00:00 | AAPL | Stock | 0.2568 | 0.2571 | 0.2564 | 0.2566 | 1307600.0 |
| 2003-04-10 17:00:00 | AAPL | Stock | 0.2565 | 0.2565 | 0.2551 | 0.2551 | 2234400.0 |
| 2003-04-10 08:00:00 | MSFT | Stock | 24.7 | 24.8 | 24.522 | 24.7 | 145667.0 |
| 2003-04-10 09:00:00 | MSFT | Stock | 24.691 | 24.82 | 24.576 | 24.6 | 7664413.0 |
| 2003-04-10 10:00:00 | MSFT | Stock | 24.593 | 24.645 | 24.28 | 24.46 | 10798729.0 |
| 2003-04-10 11:00:00 | MSFT | Stock | 24.46 | 24.5 | 24.339 | 24.4 | 4907635.0 |
| 2003-04-10 12:00:00 | MSFT | Stock | 24.41 | 24.62 | 24.4 | 24.55 | 6142038.0 |
| 2003-04-10 13:00:00 | MSFT | Stock | 24.55 | 24.65 | 24.43 | 24.559 | 4275179.0 |
| 2003-04-10 14:00:00 | MSFT | Stock | 24.56 | 24.68 | 24.52 | 24.59 | 3916291.0 |
| 2003-04-10 15:00:00 | MSFT | Stock | 24.59 | 24.75 | 24.47 | 24.61 | 8680342.0 |
| 2003-04-10 16:00:00 | MSFT | Stock | 24.6 | 24.725 | 24.58 | 24.7 | 335717.0 |
| 2003-04-10 17:00:00 | MSFT | Stock | 24.68 | 24.72 | 24.5393 | 24.693 | 282900.0 |
| 2003-04-10 18:00:00 | MSFT | Stock | 24.719 | 24.75 | 24.719 | 24.75 | 8950.0 |
| 2003-04-10 08:00:00 | NVDA | Stock | 0.1121 | 0.115 | 0.1116 | 0.1124 | 1615680.0 |
| 2003-04-10 09:00:00 | NVDA | Stock | 0.1128 | 0.113 | 0.1112 | 0.1114 | 57937320.0 |
| 2003-04-10 10:00:00 | NVDA | Stock | 0.1115 | 0.1121 | 0.1106 | 0.1115 | 64790760.0 |
| 2003-04-10 11:00:00 | NVDA | Stock | 0.1115 | 0.1118 | 0.111 | 0.1116 | 28494480.0 |
| 2003-04-10 12:00:00 | NVDA | Stock | 0.1115 | 0.1123 | 0.1114 | 0.1117 | 53237880.0 |
| 2003-04-10 13:00:00 | NVDA | Stock | 0.1117 | 0.1121 | 0.1113 | 0.1115 | 28138440.0 |
| 2003-04-10 14:00:00 | NVDA | Stock | 0.1116 | 0.1123 | 0.1113 | 0.1117 | 29555760.0 |
| 2003-04-10 15:00:00 | NVDA | Stock | 0.1117 | 0.1121 | 0.111 | 0.1118 | 60765360.0 |
| 2003-04-10 16:00:00 | NVDA | Stock | 0.1117 | 0.1124 | 0.1116 | 0.1124 | 8774400.0 |
| 2003-04-10 17:00:00 | NVDA | Stock | 0.1119 | 0.112 | 0.1117 | 0.112 | 2196000.0 |
| 2003-04-10 18:00:00 | NVDA | Stock | 0.1122 | 0.1122 | 0.1121 | 0.1121 | 36000.0 |
| 2003-04-10 08:00:00 | AMZN | Stock | 1.265 | 1.2725 | 1.26 | 1.2641 | 247000.0 |
| 2003-04-10 09:00:00 | AMZN | Stock | 1.265 | 1.2745 | 1.239 | 1.2595 | 36518460.0 |
| 2003-04-10 10:00:00 | AMZN | Stock | 1.2599 | 1.2615 | 1.2431 | 1.253 | 25307520.0 |
| 2003-04-10 11:00:00 | AMZN | Stock | 1.253 | 1.263 | 1.251 | 1.263 | 19444000.0 |
| 2003-04-10 12:00:00 | AMZN | Stock | 1.2625 | 1.27 | 1.2615 | 1.268 | 23967000.0 |
| 2003-04-10 13:00:00 | AMZN | Stock | 1.2676 | 1.294 | 1.2655 | 1.2885 | 33132380.0 |
| 2003-04-10 14:00:00 | AMZN | Stock | 1.288 | 1.2935 | 1.283 | 1.2895 | 13811220.0 |
| 2003-04-10 15:00:00 | AMZN | Stock | 1.29 | 1.2925 | 1.2825 | 1.2845 | 20247200.0 |
| 2003-04-10 16:00:00 | AMZN | Stock | 1.2845 | 1.286 | 1.2835 | 1.286 | 476000.0 |
| 2003-04-10 17:00:00 | AMZN | Stock | 1.2835 | 1.285 | 1.2673 | 1.285 | 3792000.0 |
| 2003-04-10 18:00:00 | AMZN | Stock | 1.2825 | 1.2825 | 1.2825 | 1.2825 | 2000.0 |
| 2003-04-10 09:00:00 | CL | Stock | 27.775 | 27.785 | 27.63 | 27.63 | 599000.0 |
| 2003-04-10 10:00:00 | CL | Stock | 27.63 | 27.8 | 27.525 | 27.77 | 850200.0 |
| 2003-04-10 11:00:00 | CL | Stock | 27.75 | 27.93 | 27.74 | 27.93 | 321400.0 |
| 2003-04-10 12:00:00 | CL | Stock | 27.925 | 27.975 | 27.835 | 27.87 | 410000.0 |
| 2003-04-10 13:00:00 | CL | Stock | 27.89 | 27.95 | 27.83 | 27.86 | 270000.0 |
| 2003-04-10 14:00:00 | CL | Stock | 27.87 | 27.915 | 27.83 | 27.835 | 262200.0 |
| 2003-04-10 15:00:00 | CL | Stock | 27.835 | 27.895 | 27.755 | 27.835 | 653400.0 |
| 2003-04-10 16:00:00 | CL | Stock | 27.84 | 27.84 | 27.84 | 27.84 | 50600.0 |
> showing 50 of 20,520 rows — these rows as CSV