PREVIEW / stock_1hour / 2003-09-30
file: by_date/stock_1hour/2003/2003-09-30.parquet size: 482 KB rows: 22,441 symbols: 1,629
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-09-30 09:00:00 | AAPL | Stock | 0.3804 | 0.3804 | 0.3727 | 0.3736 | 22524712.0 |
| 2003-09-30 10:00:00 | AAPL | Stock | 0.3732 | 0.3737 | 0.3678 | 0.368 | 43779008.0 |
| 2003-09-30 11:00:00 | AAPL | Stock | 0.368 | 0.3702 | 0.365 | 0.3673 | 25808888.0 |
| 2003-09-30 12:00:00 | AAPL | Stock | 0.3673 | 0.3698 | 0.3655 | 0.3686 | 15517376.0 |
| 2003-09-30 13:00:00 | AAPL | Stock | 0.3688 | 0.372 | 0.3682 | 0.372 | 21244832.0 |
| 2003-09-30 14:00:00 | AAPL | Stock | 0.3721 | 0.3786 | 0.3716 | 0.3741 | 39346888.0 |
| 2003-09-30 15:00:00 | AAPL | Stock | 0.3739 | 0.3757 | 0.3689 | 0.3698 | 49072632.0 |
| 2003-09-30 16:00:00 | AAPL | Stock | 0.3689 | 0.3814 | 0.3682 | 0.3684 | 12488560.0 |
| 2003-09-30 17:00:00 | AAPL | Stock | 0.3685 | 0.3685 | 0.3684 | 0.3684 | 476000.0 |
| 2003-09-30 18:00:00 | AAPL | Stock | 0.3684 | 0.3684 | 0.3684 | 0.3684 | 257600.0 |
| 2003-09-30 08:00:00 | MSFT | Stock | 28.75 | 28.827 | 28.65 | 28.68 | 115750.0 |
| 2003-09-30 09:00:00 | MSFT | Stock | 28.69 | 28.88 | 28.12 | 28.13 | 5234670.0 |
| 2003-09-30 10:00:00 | MSFT | Stock | 28.13 | 28.22 | 27.8 | 27.97 | 11063344.0 |
| 2003-09-30 11:00:00 | MSFT | Stock | 27.97 | 28.13 | 27.91 | 28.04 | 5724847.0 |
| 2003-09-30 12:00:00 | MSFT | Stock | 28.04 | 28.12 | 27.93 | 28.0 | 4995711.0 |
| 2003-09-30 13:00:00 | MSFT | Stock | 28.0 | 28.25 | 27.97 | 28.13 | 4941650.0 |
| 2003-09-30 14:00:00 | MSFT | Stock | 28.13 | 28.25 | 27.99 | 28.11 | 5029314.0 |
| 2003-09-30 15:00:00 | MSFT | Stock | 28.11 | 28.11 | 27.75 | 27.84 | 10467594.0 |
| 2003-09-30 16:00:00 | MSFT | Stock | 27.83 | 27.86 | 27.65 | 27.8 | 3784873.0 |
| 2003-09-30 17:00:00 | MSFT | Stock | 27.8 | 28.0746 | 27.78 | 27.79 | 207515.0 |
| 2003-09-30 18:00:00 | MSFT | Stock | 27.8 | 27.8 | 27.78 | 27.8 | 33720.0 |
| 2003-09-30 08:00:00 | NVDA | Stock | 0.133 | 0.1332 | 0.1321 | 0.1321 | 1614000.0 |
| 2003-09-30 09:00:00 | NVDA | Stock | 0.1321 | 0.1375 | 0.1311 | 0.1362 | 178647600.0 |
| 2003-09-30 10:00:00 | NVDA | Stock | 0.1364 | 0.1371 | 0.1342 | 0.1356 | 213815880.0 |
| 2003-09-30 11:00:00 | NVDA | Stock | 0.1356 | 0.1359 | 0.1347 | 0.1355 | 95087520.0 |
| 2003-09-30 12:00:00 | NVDA | Stock | 0.1354 | 0.1362 | 0.1336 | 0.1353 | 102911400.0 |
| 2003-09-30 13:00:00 | NVDA | Stock | 0.1353 | 0.1367 | 0.135 | 0.1354 | 69548880.0 |
| 2003-09-30 14:00:00 | NVDA | Stock | 0.1354 | 0.1363 | 0.1344 | 0.1352 | 61073400.0 |
| 2003-09-30 15:00:00 | NVDA | Stock | 0.1352 | 0.1352 | 0.1312 | 0.1329 | 157579680.0 |
| 2003-09-30 16:00:00 | NVDA | Stock | 0.1324 | 0.1342 | 0.1312 | 0.1321 | 13626840.0 |
| 2003-09-30 17:00:00 | NVDA | Stock | 0.1322 | 0.1327 | 0.1322 | 0.1324 | 1356000.0 |
| 2003-09-30 18:00:00 | NVDA | Stock | 0.1324 | 0.1324 | 0.1322 | 0.1322 | 96000.0 |
| 2003-09-30 08:00:00 | AMZN | Stock | 2.4875 | 2.4875 | 2.48 | 2.4802 | 34000.0 |
| 2003-09-30 09:00:00 | AMZN | Stock | 2.48 | 2.4905 | 2.4375 | 2.4375 | 23898000.0 |
| 2003-09-30 10:00:00 | AMZN | Stock | 2.4375 | 2.4525 | 2.4205 | 2.4325 | 39980160.0 |
| 2003-09-30 11:00:00 | AMZN | Stock | 2.4325 | 2.4565 | 2.431 | 2.455 | 19601620.0 |
| 2003-09-30 12:00:00 | AMZN | Stock | 2.449 | 2.4555 | 2.4415 | 2.446 | 14518600.0 |
| 2003-09-30 13:00:00 | AMZN | Stock | 2.4465 | 2.4595 | 2.4425 | 2.45 | 13931060.0 |
| 2003-09-30 14:00:00 | AMZN | Stock | 2.4495 | 2.457 | 2.4385 | 2.447 | 16682880.0 |
| 2003-09-30 15:00:00 | AMZN | Stock | 2.4475 | 2.4475 | 2.418 | 2.4195 | 26730860.0 |
| 2003-09-30 16:00:00 | AMZN | Stock | 2.42 | 2.4462 | 2.417 | 2.4185 | 4058000.0 |
| 2003-09-30 17:00:00 | AMZN | Stock | 2.4184 | 2.4218 | 2.418 | 2.4218 | 270000.0 |
| 2003-09-30 18:00:00 | AMZN | Stock | 2.4362 | 2.4362 | 2.4185 | 2.4185 | 178000.0 |
| 2003-09-30 09:00:00 | CL | Stock | 27.8 | 27.91 | 27.75 | 27.825 | 264400.0 |
| 2003-09-30 10:00:00 | CL | Stock | 27.825 | 28.005 | 27.764 | 27.955 | 591600.0 |
| 2003-09-30 11:00:00 | CL | Stock | 27.955 | 28.05 | 27.905 | 28.05 | 438600.0 |
| 2003-09-30 12:00:00 | CL | Stock | 28.045 | 28.175 | 28.0 | 28.11 | 466800.0 |
| 2003-09-30 13:00:00 | CL | Stock | 28.11 | 28.3 | 28.055 | 28.18 | 418600.0 |
| 2003-09-30 14:00:00 | CL | Stock | 28.2 | 28.24 | 28.045 | 28.125 | 463200.0 |
| 2003-09-30 15:00:00 | CL | Stock | 28.125 | 28.15 | 27.94 | 27.98 | 520400.0 |
> showing 50 of 22,441 rows — these rows as CSV