PREVIEW / stock_1hour / 2003-04-04
file: by_date/stock_1hour/2003/2003-04-04.parquet size: 402 KB rows: 19,883 symbols: 1,554
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-04 08:00:00 | AAPL | Stock | 0.2625 | 0.2625 | 0.2625 | 0.2625 | 28000.0 |
| 2003-04-04 09:00:00 | AAPL | Stock | 0.2625 | 0.2625 | 0.2586 | 0.2596 | 13257496.0 |
| 2003-04-04 10:00:00 | AAPL | Stock | 0.2598 | 0.26 | 0.257 | 0.2584 | 16696400.0 |
| 2003-04-04 11:00:00 | AAPL | Stock | 0.2582 | 0.2613 | 0.2579 | 0.2609 | 16238040.0 |
| 2003-04-04 12:00:00 | AAPL | Stock | 0.2609 | 0.2609 | 0.258 | 0.2591 | 19871096.0 |
| 2003-04-04 13:00:00 | AAPL | Stock | 0.2589 | 0.2595 | 0.2577 | 0.258 | 16420656.0 |
| 2003-04-04 14:00:00 | AAPL | Stock | 0.258 | 0.26 | 0.2579 | 0.2588 | 18397176.0 |
| 2003-04-04 15:00:00 | AAPL | Stock | 0.2589 | 0.2604 | 0.2582 | 0.2593 | 18078928.0 |
| 2003-04-04 16:00:00 | AAPL | Stock | 0.26 | 0.26 | 0.2541 | 0.2541 | 8387344.0 |
| 2003-04-04 17:00:00 | AAPL | Stock | 0.2583 | 0.2589 | 0.2573 | 0.2589 | 4009600.0 |
| 2003-04-04 08:00:00 | MSFT | Stock | 25.45 | 25.96 | 25.295 | 25.85 | 432607.0 |
| 2003-04-04 09:00:00 | MSFT | Stock | 25.85 | 25.96 | 25.4 | 25.41 | 9798959.0 |
| 2003-04-04 10:00:00 | MSFT | Stock | 25.41 | 25.5 | 25.24 | 25.28 | 7849316.0 |
| 2003-04-04 11:00:00 | MSFT | Stock | 25.28 | 25.494 | 25.276 | 25.44 | 4949877.0 |
| 2003-04-04 12:00:00 | MSFT | Stock | 25.42 | 25.433 | 25.15 | 25.23 | 4009986.0 |
| 2003-04-04 13:00:00 | MSFT | Stock | 25.24 | 25.34 | 25.06 | 25.09 | 4615631.0 |
| 2003-04-04 14:00:00 | MSFT | Stock | 25.083 | 25.16 | 24.99 | 25.09 | 7523180.0 |
| 2003-04-04 15:00:00 | MSFT | Stock | 25.08 | 25.16 | 24.93 | 25.09 | 10785902.0 |
| 2003-04-04 16:00:00 | MSFT | Stock | 25.09 | 25.2809 | 24.99 | 25.08 | 1071497.0 |
| 2003-04-04 17:00:00 | MSFT | Stock | 25.07 | 25.09 | 25.06 | 25.08 | 53352.0 |
| 2003-04-04 18:00:00 | MSFT | Stock | 25.09 | 25.12 | 25.08 | 25.101 | 11900.0 |
| 2003-04-04 08:00:00 | NVDA | Stock | 0.1165 | 0.1167 | 0.1155 | 0.1164 | 1956000.0 |
| 2003-04-04 09:00:00 | NVDA | Stock | 0.1163 | 0.1167 | 0.114 | 0.1142 | 80868120.0 |
| 2003-04-04 10:00:00 | NVDA | Stock | 0.1142 | 0.1143 | 0.1117 | 0.1117 | 136374480.0 |
| 2003-04-04 11:00:00 | NVDA | Stock | 0.1117 | 0.1129 | 0.1116 | 0.1125 | 62216520.0 |
| 2003-04-04 12:00:00 | NVDA | Stock | 0.1124 | 0.1125 | 0.1114 | 0.1117 | 39770640.0 |
| 2003-04-04 13:00:00 | NVDA | Stock | 0.1117 | 0.1122 | 0.1111 | 0.1114 | 26620920.0 |
| 2003-04-04 14:00:00 | NVDA | Stock | 0.1112 | 0.1123 | 0.1111 | 0.1117 | 44122920.0 |
| 2003-04-04 15:00:00 | NVDA | Stock | 0.1117 | 0.1122 | 0.1113 | 0.1116 | 75857280.0 |
| 2003-04-04 16:00:00 | NVDA | Stock | 0.1113 | 0.1121 | 0.1107 | 0.1112 | 9384720.0 |
| 2003-04-04 17:00:00 | NVDA | Stock | 0.1116 | 0.1116 | 0.1116 | 0.1116 | 216000.0 |
| 2003-04-04 18:00:00 | NVDA | Stock | 0.1116 | 0.1117 | 0.1116 | 0.1117 | 198000.0 |
| 2003-04-04 08:00:00 | AMZN | Stock | 1.334 | 1.34 | 1.3325 | 1.3325 | 262000.0 |
| 2003-04-04 09:00:00 | AMZN | Stock | 1.336 | 1.3415 | 1.317 | 1.3185 | 26934940.0 |
| 2003-04-04 10:00:00 | AMZN | Stock | 1.319 | 1.321 | 1.3015 | 1.305 | 23574180.0 |
| 2003-04-04 11:00:00 | AMZN | Stock | 1.305 | 1.3095 | 1.302 | 1.307 | 15123000.0 |
| 2003-04-04 12:00:00 | AMZN | Stock | 1.307 | 1.3075 | 1.3 | 1.306 | 10334040.0 |
| 2003-04-04 13:00:00 | AMZN | Stock | 1.306 | 1.309 | 1.2975 | 1.3025 | 9977480.0 |
| 2003-04-04 14:00:00 | AMZN | Stock | 1.3025 | 1.312 | 1.3 | 1.31 | 10002120.0 |
| 2003-04-04 15:00:00 | AMZN | Stock | 1.3105 | 1.316 | 1.305 | 1.3145 | 12396480.0 |
| 2003-04-04 16:00:00 | AMZN | Stock | 1.3125 | 1.315 | 1.3075 | 1.311 | 2682300.0 |
| 2003-04-04 17:00:00 | AMZN | Stock | 1.308 | 1.311 | 1.308 | 1.311 | 116000.0 |
| 2003-04-04 18:00:00 | AMZN | Stock | 1.31 | 1.31 | 1.3085 | 1.3085 | 28000.0 |
| 2003-04-04 09:00:00 | CL | Stock | 27.6 | 27.62 | 27.49 | 27.55 | 431400.0 |
| 2003-04-04 10:00:00 | CL | Stock | 27.525 | 27.595 | 27.35 | 27.38 | 335400.0 |
| 2003-04-04 11:00:00 | CL | Stock | 27.36 | 27.525 | 27.36 | 27.495 | 389800.0 |
| 2003-04-04 12:00:00 | CL | Stock | 27.49 | 27.49 | 27.265 | 27.275 | 226400.0 |
| 2003-04-04 13:00:00 | CL | Stock | 27.275 | 27.35 | 27.16 | 27.17 | 340400.0 |
| 2003-04-04 14:00:00 | CL | Stock | 27.165 | 27.29 | 27.145 | 27.265 | 257200.0 |
| 2003-04-04 15:00:00 | CL | Stock | 27.255 | 27.285 | 27.22 | 27.28 | 471400.0 |
> showing 50 of 19,883 rows — these rows as CSV