PREVIEW / stock_1hour / 2003-04-08
file: by_date/stock_1hour/2003/2003-04-08.parquet size: 409 KB rows: 20,492 symbols: 1,548
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-08 08:00:00 | AAPL | Stock | 0.2591 | 0.2602 | 0.2589 | 0.2589 | 128800.0 |
| 2003-04-08 09:00:00 | AAPL | Stock | 0.2595 | 0.2602 | 0.2577 | 0.2582 | 12486208.0 |
| 2003-04-08 10:00:00 | AAPL | Stock | 0.258 | 0.26 | 0.2571 | 0.26 | 17522512.0 |
| 2003-04-08 11:00:00 | AAPL | Stock | 0.26 | 0.26 | 0.2577 | 0.2593 | 13591648.0 |
| 2003-04-08 12:00:00 | AAPL | Stock | 0.2589 | 0.26 | 0.258 | 0.2593 | 9384480.0 |
| 2003-04-08 13:00:00 | AAPL | Stock | 0.2595 | 0.2602 | 0.2589 | 0.2598 | 12471200.0 |
| 2003-04-08 14:00:00 | AAPL | Stock | 0.26 | 0.2616 | 0.258 | 0.2584 | 19613608.0 |
| 2003-04-08 15:00:00 | AAPL | Stock | 0.2584 | 0.2591 | 0.2571 | 0.2573 | 26531624.0 |
| 2003-04-08 16:00:00 | AAPL | Stock | 0.2573 | 0.2582 | 0.2571 | 0.2579 | 1998192.0 |
| 2003-04-08 17:00:00 | AAPL | Stock | 0.2579 | 0.258 | 0.2579 | 0.258 | 28000.0 |
| 2003-04-08 08:00:00 | MSFT | Stock | 25.4 | 25.61 | 25.26 | 25.33 | 108295.0 |
| 2003-04-08 09:00:00 | MSFT | Stock | 25.302 | 25.47 | 25.22 | 25.37 | 7602370.0 |
| 2003-04-08 10:00:00 | MSFT | Stock | 25.37 | 25.75 | 25.2 | 25.62 | 10921949.0 |
| 2003-04-08 11:00:00 | MSFT | Stock | 25.68 | 25.73 | 25.4 | 25.58 | 7517698.0 |
| 2003-04-08 12:00:00 | MSFT | Stock | 25.57 | 25.68 | 25.47 | 25.64 | 3632655.0 |
| 2003-04-08 13:00:00 | MSFT | Stock | 25.64 | 25.724 | 25.62 | 25.709 | 3914180.0 |
| 2003-04-08 14:00:00 | MSFT | Stock | 25.7 | 25.835 | 25.5 | 25.538 | 7448977.0 |
| 2003-04-08 15:00:00 | MSFT | Stock | 25.54 | 25.75 | 25.45 | 25.59 | 8112963.0 |
| 2003-04-08 16:00:00 | MSFT | Stock | 25.59 | 25.7 | 25.56 | 25.7 | 595566.0 |
| 2003-04-08 17:00:00 | MSFT | Stock | 25.72 | 25.72 | 25.58 | 25.65 | 44000.0 |
| 2003-04-08 18:00:00 | MSFT | Stock | 25.65 | 25.65 | 25.613 | 25.619 | 2200.0 |
| 2003-04-08 08:00:00 | NVDA | Stock | 0.1054 | 0.1129 | 0.1054 | 0.1125 | 329160.0 |
| 2003-04-08 09:00:00 | NVDA | Stock | 0.1121 | 0.1143 | 0.1112 | 0.1118 | 76879080.0 |
| 2003-04-08 10:00:00 | NVDA | Stock | 0.1119 | 0.1129 | 0.1112 | 0.1127 | 68964240.0 |
| 2003-04-08 11:00:00 | NVDA | Stock | 0.1127 | 0.1128 | 0.112 | 0.1122 | 52883160.0 |
| 2003-04-08 12:00:00 | NVDA | Stock | 0.1122 | 0.1124 | 0.1112 | 0.1117 | 47984640.0 |
| 2003-04-08 13:00:00 | NVDA | Stock | 0.1119 | 0.1127 | 0.1112 | 0.1127 | 36615240.0 |
| 2003-04-08 14:00:00 | NVDA | Stock | 0.1127 | 0.1137 | 0.112 | 0.1122 | 55533840.0 |
| 2003-04-08 15:00:00 | NVDA | Stock | 0.1122 | 0.1124 | 0.1109 | 0.1116 | 56996160.0 |
| 2003-04-08 16:00:00 | NVDA | Stock | 0.1117 | 0.1121 | 0.1113 | 0.1119 | 32917920.0 |
| 2003-04-08 17:00:00 | NVDA | Stock | 0.1118 | 0.1121 | 0.1117 | 0.1117 | 228000.0 |
| 2003-04-08 18:00:00 | NVDA | Stock | 0.1121 | 0.1121 | 0.1121 | 0.1121 | 24000.0 |
| 2003-04-08 08:00:00 | AMZN | Stock | 1.35 | 1.359 | 1.34 | 1.341 | 199300.0 |
| 2003-04-08 09:00:00 | AMZN | Stock | 1.34 | 1.343 | 1.3232 | 1.3235 | 15388840.0 |
| 2003-04-08 10:00:00 | AMZN | Stock | 1.3235 | 1.337 | 1.3235 | 1.3359 | 23037580.0 |
| 2003-04-08 11:00:00 | AMZN | Stock | 1.3355 | 1.337 | 1.325 | 1.331 | 12837100.0 |
| 2003-04-08 12:00:00 | AMZN | Stock | 1.3305 | 1.3315 | 1.3225 | 1.3298 | 9324180.0 |
| 2003-04-08 13:00:00 | AMZN | Stock | 1.3305 | 1.331 | 1.327 | 1.328 | 4193120.0 |
| 2003-04-08 14:00:00 | AMZN | Stock | 1.3285 | 1.333 | 1.3255 | 1.3285 | 8824460.0 |
| 2003-04-08 15:00:00 | AMZN | Stock | 1.329 | 1.3315 | 1.3225 | 1.327 | 17073520.0 |
| 2003-04-08 16:00:00 | AMZN | Stock | 1.3275 | 1.3285 | 1.324 | 1.3285 | 1872200.0 |
| 2003-04-08 17:00:00 | AMZN | Stock | 1.326 | 1.326 | 1.326 | 1.326 | 42000.0 |
| 2003-04-08 09:00:00 | CL | Stock | 27.4 | 27.65 | 27.375 | 27.5 | 210800.0 |
| 2003-04-08 10:00:00 | CL | Stock | 27.5 | 27.6 | 27.425 | 27.575 | 382000.0 |
| 2003-04-08 11:00:00 | CL | Stock | 27.58 | 27.625 | 27.395 | 27.59 | 312000.0 |
| 2003-04-08 12:00:00 | CL | Stock | 27.58 | 27.69 | 27.545 | 27.61 | 200600.0 |
| 2003-04-08 13:00:00 | CL | Stock | 27.605 | 27.685 | 27.56 | 27.595 | 237200.0 |
| 2003-04-08 14:00:00 | CL | Stock | 27.595 | 27.75 | 27.5 | 27.505 | 269200.0 |
| 2003-04-08 15:00:00 | CL | Stock | 27.505 | 27.63 | 27.48 | 27.585 | 359800.0 |
| 2003-04-08 16:00:00 | CL | Stock | 27.585 | 27.585 | 27.58 | 27.585 | 104400.0 |
> showing 50 of 20,492 rows — these rows as CSV