PREVIEW / stock_1hour / 2003-10-02
file: by_date/stock_1hour/2003/2003-10-02.parquet size: 466 KB rows: 22,188 symbols: 1,626
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-10-02 08:00:00 | AAPL | Stock | 0.3682 | 0.3682 | 0.3682 | 0.3682 | 54376.0 |
| 2003-10-02 09:00:00 | AAPL | Stock | 0.3688 | 0.3714 | 0.3643 | 0.3673 | 18604544.0 |
| 2003-10-02 10:00:00 | AAPL | Stock | 0.3673 | 0.3691 | 0.3654 | 0.3657 | 32785032.0 |
| 2003-10-02 11:00:00 | AAPL | Stock | 0.3655 | 0.367 | 0.3625 | 0.3637 | 28711368.0 |
| 2003-10-02 12:00:00 | AAPL | Stock | 0.3636 | 0.3652 | 0.3623 | 0.3639 | 14288512.0 |
| 2003-10-02 13:00:00 | AAPL | Stock | 0.3639 | 0.3648 | 0.3621 | 0.3645 | 15720320.0 |
| 2003-10-02 14:00:00 | AAPL | Stock | 0.3646 | 0.3666 | 0.3639 | 0.3661 | 16839032.0 |
| 2003-10-02 15:00:00 | AAPL | Stock | 0.3661 | 0.3684 | 0.3639 | 0.3673 | 45275216.0 |
| 2003-10-02 16:00:00 | AAPL | Stock | 0.3673 | 0.373 | 0.3643 | 0.367 | 6871200.0 |
| 2003-10-02 17:00:00 | AAPL | Stock | 0.3673 | 0.3673 | 0.3673 | 0.3673 | 722400.0 |
| 2003-10-02 18:00:00 | AAPL | Stock | 0.3671 | 0.3671 | 0.3671 | 0.3671 | 28000.0 |
| 2003-10-02 08:00:00 | MSFT | Stock | 28.49 | 28.57 | 28.1 | 28.5 | 19300.0 |
| 2003-10-02 09:00:00 | MSFT | Stock | 28.47 | 28.56 | 28.28 | 28.542 | 4309977.0 |
| 2003-10-02 10:00:00 | MSFT | Stock | 28.542 | 28.75 | 28.45 | 28.481 | 7786836.0 |
| 2003-10-02 11:00:00 | MSFT | Stock | 28.48 | 28.59 | 28.26 | 28.27 | 4228187.0 |
| 2003-10-02 12:00:00 | MSFT | Stock | 28.29 | 28.39 | 28.19 | 28.32 | 3455423.0 |
| 2003-10-02 13:00:00 | MSFT | Stock | 28.32 | 28.46 | 28.28 | 28.4 | 3045699.0 |
| 2003-10-02 14:00:00 | MSFT | Stock | 28.41 | 28.5 | 28.32 | 28.439 | 3083322.0 |
| 2003-10-02 15:00:00 | MSFT | Stock | 28.44 | 28.56 | 28.4 | 28.49 | 6649902.0 |
| 2003-10-02 16:00:00 | MSFT | Stock | 28.5 | 28.55 | 28.4 | 28.49 | 389055.0 |
| 2003-10-02 17:00:00 | MSFT | Stock | 28.5 | 28.57 | 28.49 | 28.5 | 71200.0 |
| 2003-10-02 18:00:00 | MSFT | Stock | 28.5 | 28.56 | 28.48 | 28.48 | 4900.0 |
| 2003-10-02 08:00:00 | NVDA | Stock | 0.1343 | 0.1346 | 0.1333 | 0.1337 | 914400.0 |
| 2003-10-02 09:00:00 | NVDA | Stock | 0.1337 | 0.1342 | 0.1328 | 0.1337 | 108227280.0 |
| 2003-10-02 10:00:00 | NVDA | Stock | 0.1337 | 0.1349 | 0.1332 | 0.1347 | 138551160.0 |
| 2003-10-02 11:00:00 | NVDA | Stock | 0.1347 | 0.1382 | 0.1347 | 0.1367 | 166310520.0 |
| 2003-10-02 12:00:00 | NVDA | Stock | 0.1367 | 0.1371 | 0.135 | 0.1352 | 69873240.0 |
| 2003-10-02 13:00:00 | NVDA | Stock | 0.1352 | 0.1365 | 0.1352 | 0.1358 | 38317800.0 |
| 2003-10-02 14:00:00 | NVDA | Stock | 0.1358 | 0.1375 | 0.135 | 0.1357 | 67052880.0 |
| 2003-10-02 15:00:00 | NVDA | Stock | 0.1356 | 0.1364 | 0.1338 | 0.1352 | 109119120.0 |
| 2003-10-02 16:00:00 | NVDA | Stock | 0.1347 | 0.1378 | 0.1338 | 0.1354 | 21575520.0 |
| 2003-10-02 17:00:00 | NVDA | Stock | 0.1358 | 0.1358 | 0.1358 | 0.1358 | 9216000.0 |
| 2003-10-02 08:00:00 | AMZN | Stock | 2.4545 | 2.4575 | 2.446 | 2.45 | 45080.0 |
| 2003-10-02 09:00:00 | AMZN | Stock | 2.449 | 2.4723 | 2.434 | 2.4511 | 22772200.0 |
| 2003-10-02 10:00:00 | AMZN | Stock | 2.451 | 2.4935 | 2.4455 | 2.4815 | 34113920.0 |
| 2003-10-02 11:00:00 | AMZN | Stock | 2.4815 | 2.4995 | 2.465 | 2.4665 | 26159780.0 |
| 2003-10-02 12:00:00 | AMZN | Stock | 2.466 | 2.474 | 2.459 | 2.474 | 13339580.0 |
| 2003-10-02 13:00:00 | AMZN | Stock | 2.4733 | 2.48 | 2.47 | 2.476 | 7935880.0 |
| 2003-10-02 14:00:00 | AMZN | Stock | 2.4775 | 2.5085 | 2.475 | 2.495 | 18498480.0 |
| 2003-10-02 15:00:00 | AMZN | Stock | 2.496 | 2.51 | 2.4945 | 2.504 | 21447160.0 |
| 2003-10-02 16:00:00 | AMZN | Stock | 2.5045 | 2.5055 | 2.5 | 2.504 | 728580.0 |
| 2003-10-02 17:00:00 | AMZN | Stock | 2.5035 | 2.5049 | 2.5035 | 2.5045 | 252600.0 |
| 2003-10-02 18:00:00 | AMZN | Stock | 2.5025 | 2.5045 | 2.5025 | 2.5045 | 138000.0 |
| 2003-10-02 09:00:00 | CL | Stock | 28.485 | 28.6 | 28.385 | 28.575 | 247200.0 |
| 2003-10-02 10:00:00 | CL | Stock | 28.585 | 28.77 | 28.52 | 28.58 | 574200.0 |
| 2003-10-02 11:00:00 | CL | Stock | 28.58 | 28.7 | 28.555 | 28.625 | 358000.0 |
| 2003-10-02 12:00:00 | CL | Stock | 28.625 | 28.745 | 28.615 | 28.675 | 285000.0 |
| 2003-10-02 13:00:00 | CL | Stock | 28.69 | 28.69 | 28.54 | 28.62 | 670400.0 |
| 2003-10-02 14:00:00 | CL | Stock | 28.625 | 28.69 | 28.585 | 28.605 | 569800.0 |
| 2003-10-02 15:00:00 | CL | Stock | 28.6 | 28.635 | 28.575 | 28.61 | 937200.0 |
> showing 50 of 22,188 rows — these rows as CSV