PREVIEW / stock_1hour / 2003-04-09
file: by_date/stock_1hour/2003/2003-04-09.parquet size: 408 KB rows: 20,054 symbols: 1,553
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-09 08:00:00 | AAPL | Stock | 0.258 | 0.258 | 0.258 | 0.258 | 44800.0 |
| 2003-04-09 09:00:00 | AAPL | Stock | 0.258 | 0.2768 | 0.2563 | 0.2577 | 16250640.0 |
| 2003-04-09 10:00:00 | AAPL | Stock | 0.2577 | 0.2609 | 0.2571 | 0.2591 | 19879272.0 |
| 2003-04-09 11:00:00 | AAPL | Stock | 0.2591 | 0.26 | 0.2566 | 0.2575 | 11688712.0 |
| 2003-04-09 12:00:00 | AAPL | Stock | 0.2577 | 0.2577 | 0.2545 | 0.2555 | 17586184.0 |
| 2003-04-09 13:00:00 | AAPL | Stock | 0.2554 | 0.2555 | 0.2545 | 0.2546 | 9685424.0 |
| 2003-04-09 14:00:00 | AAPL | Stock | 0.2546 | 0.2555 | 0.2542 | 0.2545 | 17261888.0 |
| 2003-04-09 15:00:00 | AAPL | Stock | 0.2545 | 0.2557 | 0.2525 | 0.2527 | 32318776.0 |
| 2003-04-09 16:00:00 | AAPL | Stock | 0.2532 | 0.2541 | 0.2527 | 0.2534 | 6619200.0 |
| 2003-04-09 17:00:00 | AAPL | Stock | 0.2534 | 0.2534 | 0.2534 | 0.2534 | 1220800.0 |
| 2003-04-09 08:00:00 | MSFT | Stock | 25.5 | 25.58 | 24.86 | 25.399 | 316124.0 |
| 2003-04-09 09:00:00 | MSFT | Stock | 25.401 | 25.777 | 25.24 | 25.4 | 10169408.0 |
| 2003-04-09 10:00:00 | MSFT | Stock | 25.4 | 25.67 | 25.32 | 25.337 | 15020250.0 |
| 2003-04-09 11:00:00 | MSFT | Stock | 25.32 | 25.52 | 25.19 | 25.2 | 7190109.0 |
| 2003-04-09 12:00:00 | MSFT | Stock | 25.203 | 25.21 | 24.93 | 25.0 | 9377670.0 |
| 2003-04-09 13:00:00 | MSFT | Stock | 25.02 | 25.1067 | 24.9 | 24.9 | 4549278.0 |
| 2003-04-09 14:00:00 | MSFT | Stock | 24.9 | 25.07 | 24.88 | 24.881 | 6577759.0 |
| 2003-04-09 15:00:00 | MSFT | Stock | 24.88 | 25.07 | 24.54 | 24.579 | 16177550.0 |
| 2003-04-09 16:00:00 | MSFT | Stock | 24.579 | 24.7 | 24.56 | 24.61 | 1394185.0 |
| 2003-04-09 17:00:00 | MSFT | Stock | 24.6 | 24.673 | 24.57 | 24.673 | 213142.0 |
| 2003-04-09 18:00:00 | MSFT | Stock | 24.674 | 25.1581 | 24.65 | 24.69 | 21281.0 |
| 2003-04-09 08:00:00 | NVDA | Stock | 0.1116 | 0.1116 | 0.1116 | 0.1116 | 5376000.0 |
| 2003-04-09 09:00:00 | NVDA | Stock | 0.1115 | 0.1136 | 0.1115 | 0.1135 | 82834560.0 |
| 2003-04-09 10:00:00 | NVDA | Stock | 0.1135 | 0.1151 | 0.1133 | 0.1136 | 165224280.0 |
| 2003-04-09 11:00:00 | NVDA | Stock | 0.1136 | 0.114 | 0.1128 | 0.1133 | 84024840.0 |
| 2003-04-09 12:00:00 | NVDA | Stock | 0.1133 | 0.1133 | 0.1122 | 0.1125 | 121028520.0 |
| 2003-04-09 13:00:00 | NVDA | Stock | 0.1125 | 0.1132 | 0.1124 | 0.1125 | 50494200.0 |
| 2003-04-09 14:00:00 | NVDA | Stock | 0.1125 | 0.1129 | 0.1122 | 0.1122 | 42182400.0 |
| 2003-04-09 15:00:00 | NVDA | Stock | 0.1123 | 0.1124 | 0.111 | 0.1112 | 76319640.0 |
| 2003-04-09 16:00:00 | NVDA | Stock | 0.1112 | 0.1117 | 0.1109 | 0.1117 | 4346280.0 |
| 2003-04-09 17:00:00 | NVDA | Stock | 0.1111 | 0.1117 | 0.1111 | 0.1114 | 1060800.0 |
| 2003-04-09 18:00:00 | NVDA | Stock | 0.1117 | 0.1117 | 0.1114 | 0.1117 | 444000.0 |
| 2003-04-09 08:00:00 | AMZN | Stock | 1.305 | 1.325 | 1.302 | 1.325 | 1045320.0 |
| 2003-04-09 09:00:00 | AMZN | Stock | 1.3075 | 1.3312 | 1.285 | 1.289 | 34459500.0 |
| 2003-04-09 10:00:00 | AMZN | Stock | 1.2893 | 1.3 | 1.276 | 1.288 | 47847060.0 |
| 2003-04-09 11:00:00 | AMZN | Stock | 1.2885 | 1.294 | 1.275 | 1.275 | 18800780.0 |
| 2003-04-09 12:00:00 | AMZN | Stock | 1.275 | 1.2785 | 1.263 | 1.272 | 27867540.0 |
| 2003-04-09 13:00:00 | AMZN | Stock | 1.2715 | 1.2735 | 1.2595 | 1.2595 | 10679420.0 |
| 2003-04-09 14:00:00 | AMZN | Stock | 1.2595 | 1.274 | 1.254 | 1.269 | 20920840.0 |
| 2003-04-09 15:00:00 | AMZN | Stock | 1.269 | 1.273 | 1.242 | 1.253 | 51561200.0 |
| 2003-04-09 16:00:00 | AMZN | Stock | 1.2518 | 1.3 | 1.2518 | 1.2635 | 3419820.0 |
| 2003-04-09 17:00:00 | AMZN | Stock | 1.265 | 1.2715 | 1.253 | 1.2715 | 472540.0 |
| 2003-04-09 18:00:00 | AMZN | Stock | 1.269 | 1.271 | 1.2675 | 1.271 | 58000.0 |
| 2003-04-09 09:00:00 | CL | Stock | 27.75 | 27.925 | 27.695 | 27.925 | 327800.0 |
| 2003-04-09 10:00:00 | CL | Stock | 27.925 | 28.1 | 27.845 | 27.85 | 455000.0 |
| 2003-04-09 11:00:00 | CL | Stock | 27.83 | 27.9 | 27.82 | 27.85 | 431000.0 |
| 2003-04-09 12:00:00 | CL | Stock | 27.84 | 27.86 | 27.63 | 27.67 | 454000.0 |
| 2003-04-09 13:00:00 | CL | Stock | 27.67 | 27.75 | 27.67 | 27.73 | 384400.0 |
| 2003-04-09 14:00:00 | CL | Stock | 27.73 | 27.875 | 27.73 | 27.815 | 452400.0 |
| 2003-04-09 15:00:00 | CL | Stock | 27.815 | 27.94 | 27.745 | 27.745 | 747000.0 |
> showing 50 of 20,054 rows — these rows as CSV