PREVIEW / stock_1hour / 2003-03-28
file: by_date/stock_1hour/2003/2003-03-28.parquet size: 409 KB rows: 20,032 symbols: 1,538
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-03-28 09:00:00 | AAPL | Stock | 0.2579 | 0.2596 | 0.2568 | 0.258 | 17291904.0 |
| 2003-03-28 10:00:00 | AAPL | Stock | 0.258 | 0.2611 | 0.257 | 0.2606 | 11075008.0 |
| 2003-03-28 11:00:00 | AAPL | Stock | 0.2605 | 0.2609 | 0.2588 | 0.2588 | 7877520.0 |
| 2003-03-28 12:00:00 | AAPL | Stock | 0.2588 | 0.26 | 0.258 | 0.2598 | 25905600.0 |
| 2003-03-28 13:00:00 | AAPL | Stock | 0.2598 | 0.2602 | 0.2591 | 0.2591 | 8380064.0 |
| 2003-03-28 14:00:00 | AAPL | Stock | 0.2591 | 0.2596 | 0.2573 | 0.2584 | 16961000.0 |
| 2003-03-28 15:00:00 | AAPL | Stock | 0.2584 | 0.2602 | 0.2575 | 0.2596 | 31072272.0 |
| 2003-03-28 16:00:00 | AAPL | Stock | 0.2598 | 0.2607 | 0.2589 | 0.2604 | 2629200.0 |
| 2003-03-28 17:00:00 | AAPL | Stock | 0.2602 | 0.2602 | 0.2602 | 0.2602 | 1265600.0 |
| 2003-03-28 08:00:00 | MSFT | Stock | 25.04 | 25.04 | 24.75 | 24.76 | 387797.0 |
| 2003-03-28 09:00:00 | MSFT | Stock | 24.76 | 25.03 | 24.6 | 24.833 | 6080351.0 |
| 2003-03-28 10:00:00 | MSFT | Stock | 24.84 | 25.059 | 24.74 | 25.01 | 6721145.0 |
| 2003-03-28 11:00:00 | MSFT | Stock | 25.01 | 25.09 | 24.87 | 24.9 | 4355081.0 |
| 2003-03-28 12:00:00 | MSFT | Stock | 24.91 | 24.95 | 24.75 | 24.82 | 3339000.0 |
| 2003-03-28 13:00:00 | MSFT | Stock | 24.818 | 24.842 | 24.75 | 24.8 | 2583302.0 |
| 2003-03-28 14:00:00 | MSFT | Stock | 24.79 | 24.88 | 24.6 | 24.719 | 4797488.0 |
| 2003-03-28 15:00:00 | MSFT | Stock | 24.72 | 24.79 | 24.64 | 24.691 | 5814343.0 |
| 2003-03-28 16:00:00 | MSFT | Stock | 24.69 | 24.75 | 24.621 | 24.67 | 1153969.0 |
| 2003-03-28 17:00:00 | MSFT | Stock | 24.67 | 24.7342 | 24.61 | 24.61 | 37664.0 |
| 2003-03-28 18:00:00 | MSFT | Stock | 24.6 | 24.65 | 24.6 | 24.62 | 2300.0 |
| 2003-03-28 08:00:00 | NVDA | Stock | 0.1167 | 0.1167 | 0.1158 | 0.1165 | 2191200.0 |
| 2003-03-28 09:00:00 | NVDA | Stock | 0.1162 | 0.1171 | 0.1144 | 0.1151 | 199230720.0 |
| 2003-03-28 10:00:00 | NVDA | Stock | 0.1151 | 0.1155 | 0.1135 | 0.1151 | 189339240.0 |
| 2003-03-28 11:00:00 | NVDA | Stock | 0.115 | 0.1157 | 0.1145 | 0.1147 | 96465120.0 |
| 2003-03-28 12:00:00 | NVDA | Stock | 0.1147 | 0.1148 | 0.1121 | 0.1125 | 152691960.0 |
| 2003-03-28 13:00:00 | NVDA | Stock | 0.1125 | 0.1131 | 0.1122 | 0.1129 | 65176560.0 |
| 2003-03-28 14:00:00 | NVDA | Stock | 0.1128 | 0.1132 | 0.1101 | 0.1107 | 206770080.0 |
| 2003-03-28 15:00:00 | NVDA | Stock | 0.1107 | 0.1115 | 0.1101 | 0.1113 | 253945200.0 |
| 2003-03-28 16:00:00 | NVDA | Stock | 0.1113 | 0.1122 | 0.1108 | 0.1117 | 15825480.0 |
| 2003-03-28 17:00:00 | NVDA | Stock | 0.1119 | 0.1119 | 0.1108 | 0.1117 | 1708800.0 |
| 2003-03-28 18:00:00 | NVDA | Stock | 0.1117 | 0.1119 | 0.1117 | 0.1119 | 168000.0 |
| 2003-03-28 08:00:00 | AMZN | Stock | 1.3845 | 1.388 | 1.374 | 1.3825 | 496000.0 |
| 2003-03-28 09:00:00 | AMZN | Stock | 1.3875 | 1.3975 | 1.3755 | 1.3825 | 17727640.0 |
| 2003-03-28 10:00:00 | AMZN | Stock | 1.3825 | 1.385 | 1.374 | 1.3825 | 20484620.0 |
| 2003-03-28 11:00:00 | AMZN | Stock | 1.3825 | 1.3875 | 1.375 | 1.376 | 13838600.0 |
| 2003-03-28 12:00:00 | AMZN | Stock | 1.3765 | 1.3814 | 1.361 | 1.366 | 19611880.0 |
| 2003-03-28 13:00:00 | AMZN | Stock | 1.366 | 1.3725 | 1.3625 | 1.367 | 11998960.0 |
| 2003-03-28 14:00:00 | AMZN | Stock | 1.3675 | 1.3715 | 1.362 | 1.365 | 9846060.0 |
| 2003-03-28 15:00:00 | AMZN | Stock | 1.364 | 1.3675 | 1.355 | 1.36 | 21702860.0 |
| 2003-03-28 16:00:00 | AMZN | Stock | 1.3587 | 1.3875 | 1.354 | 1.3575 | 1293040.0 |
| 2003-03-28 17:00:00 | AMZN | Stock | 1.3575 | 1.3634 | 1.354 | 1.3595 | 637000.0 |
| 2003-03-28 18:00:00 | AMZN | Stock | 1.3575 | 1.3575 | 1.3575 | 1.3575 | 7000.0 |
| 2003-03-28 09:00:00 | CL | Stock | 27.04 | 27.065 | 26.88 | 26.88 | 225200.0 |
| 2003-03-28 10:00:00 | CL | Stock | 26.875 | 27.11 | 26.825 | 27.11 | 348000.0 |
| 2003-03-28 11:00:00 | CL | Stock | 27.09 | 27.27 | 27.035 | 27.215 | 275000.0 |
| 2003-03-28 12:00:00 | CL | Stock | 27.2 | 27.245 | 27.08 | 27.08 | 302400.0 |
| 2003-03-28 13:00:00 | CL | Stock | 27.085 | 27.215 | 27.05 | 27.15 | 143000.0 |
| 2003-03-28 14:00:00 | CL | Stock | 27.155 | 27.225 | 27.03 | 27.125 | 287200.0 |
| 2003-03-28 15:00:00 | CL | Stock | 27.155 | 27.265 | 27.15 | 27.195 | 448200.0 |
| 2003-03-28 16:00:00 | CL | Stock | 27.195 | 27.25 | 27.175 | 27.25 | 37600.0 |
> showing 50 of 20,032 rows — these rows as CSV