PREVIEW / stock_1hour / 2003-01-10
file: by_date/stock_1hour/2003/2003-01-10.parquet size: 418 KB rows: 19,818 symbols: 1,529
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-01-10 08:00:00 | AAPL | Stock | 0.2616 | 0.2616 | 0.2616 | 0.2616 | 28000.0 |
| 2003-01-10 09:00:00 | AAPL | Stock | 0.2575 | 0.2618 | 0.2571 | 0.2607 | 25229848.0 |
| 2003-01-10 10:00:00 | AAPL | Stock | 0.2607 | 0.2646 | 0.2598 | 0.2641 | 30518376.0 |
| 2003-01-10 11:00:00 | AAPL | Stock | 0.2639 | 0.2646 | 0.2607 | 0.2632 | 21314328.0 |
| 2003-01-10 12:00:00 | AAPL | Stock | 0.2629 | 0.263 | 0.26 | 0.2607 | 17740968.0 |
| 2003-01-10 13:00:00 | AAPL | Stock | 0.2609 | 0.2623 | 0.2604 | 0.2621 | 15222704.0 |
| 2003-01-10 14:00:00 | AAPL | Stock | 0.2621 | 0.2636 | 0.2613 | 0.2629 | 15975064.0 |
| 2003-01-10 15:00:00 | AAPL | Stock | 0.2629 | 0.2634 | 0.2598 | 0.2629 | 24219048.0 |
| 2003-01-10 16:00:00 | AAPL | Stock | 0.2632 | 0.2638 | 0.2621 | 0.2638 | 4238696.0 |
| 2003-01-10 08:00:00 | MSFT | Stock | 28.06 | 28.1 | 27.585 | 27.6745 | 766986.0 |
| 2003-01-10 09:00:00 | MSFT | Stock | 27.655 | 28.05 | 27.45 | 27.85 | 10691582.0 |
| 2003-01-10 10:00:00 | MSFT | Stock | 27.85 | 28.11 | 27.74 | 28.075 | 15077986.0 |
| 2003-01-10 11:00:00 | MSFT | Stock | 28.07 | 28.15 | 27.85 | 27.96 | 10004614.0 |
| 2003-01-10 12:00:00 | MSFT | Stock | 27.965 | 27.97 | 27.59 | 27.72 | 5183748.0 |
| 2003-01-10 13:00:00 | MSFT | Stock | 27.7 | 27.925 | 27.685 | 27.83 | 4632936.0 |
| 2003-01-10 14:00:00 | MSFT | Stock | 27.8395 | 27.99 | 27.733 | 27.919 | 5485406.0 |
| 2003-01-10 15:00:00 | MSFT | Stock | 27.92 | 27.98 | 27.705 | 27.955 | 9492192.0 |
| 2003-01-10 16:00:00 | MSFT | Stock | 27.96 | 27.975 | 27.77 | 27.9155 | 1520780.0 |
| 2003-01-10 17:00:00 | MSFT | Stock | 27.96 | 27.96 | 27.9 | 27.96 | 22600.0 |
| 2003-01-10 18:00:00 | MSFT | Stock | 27.9 | 27.93 | 27.9 | 27.93 | 2400.0 |
| 2003-01-10 08:00:00 | NVDA | Stock | 0.1024 | 0.1035 | 0.0994 | 0.0994 | 10128120.0 |
| 2003-01-10 09:00:00 | NVDA | Stock | 0.0998 | 0.1025 | 0.0986 | 0.1024 | 173208600.0 |
| 2003-01-10 10:00:00 | NVDA | Stock | 0.1023 | 0.1045 | 0.1018 | 0.1041 | 205503120.0 |
| 2003-01-10 11:00:00 | NVDA | Stock | 0.104 | 0.1046 | 0.1021 | 0.1028 | 126855720.0 |
| 2003-01-10 12:00:00 | NVDA | Stock | 0.1028 | 0.104 | 0.1017 | 0.1024 | 89380920.0 |
| 2003-01-10 13:00:00 | NVDA | Stock | 0.1024 | 0.1029 | 0.1012 | 0.1021 | 63427200.0 |
| 2003-01-10 14:00:00 | NVDA | Stock | 0.1021 | 0.1035 | 0.1021 | 0.1032 | 57013680.0 |
| 2003-01-10 15:00:00 | NVDA | Stock | 0.1032 | 0.1037 | 0.1026 | 0.1032 | 130052760.0 |
| 2003-01-10 16:00:00 | NVDA | Stock | 0.1031 | 0.1042 | 0.103 | 0.1037 | 5916240.0 |
| 2003-01-10 17:00:00 | NVDA | Stock | 0.1037 | 0.1039 | 0.1037 | 0.1037 | 1224000.0 |
| 2003-01-10 18:00:00 | NVDA | Stock | 0.1037 | 0.1037 | 0.1035 | 0.1037 | 204000.0 |
| 2003-01-10 08:00:00 | AMZN | Stock | 1.073 | 1.08 | 1.053 | 1.053 | 197200.0 |
| 2003-01-10 09:00:00 | AMZN | Stock | 1.0545 | 1.0755 | 1.0455 | 1.07 | 23455100.0 |
| 2003-01-10 10:00:00 | AMZN | Stock | 1.071 | 1.0834 | 1.068 | 1.077 | 28219680.0 |
| 2003-01-10 11:00:00 | AMZN | Stock | 1.077 | 1.0795 | 1.0648 | 1.0695 | 16184680.0 |
| 2003-01-10 12:00:00 | AMZN | Stock | 1.069 | 1.07 | 1.0405 | 1.0525 | 19173380.0 |
| 2003-01-10 13:00:00 | AMZN | Stock | 1.0525 | 1.0585 | 1.0445 | 1.0465 | 20462980.0 |
| 2003-01-10 14:00:00 | AMZN | Stock | 1.0464 | 1.0675 | 1.046 | 1.0645 | 12933000.0 |
| 2003-01-10 15:00:00 | AMZN | Stock | 1.0645 | 1.07 | 1.0575 | 1.0665 | 15545040.0 |
| 2003-01-10 16:00:00 | AMZN | Stock | 1.0665 | 1.07 | 1.0635 | 1.0655 | 984000.0 |
| 2003-01-10 17:00:00 | AMZN | Stock | 1.0635 | 1.066 | 1.0635 | 1.066 | 348000.0 |
| 2003-01-10 09:00:00 | CL | Stock | 26.5 | 26.545 | 26.45 | 26.525 | 387400.0 |
| 2003-01-10 10:00:00 | CL | Stock | 26.54 | 26.55 | 26.42 | 26.47 | 406800.0 |
| 2003-01-10 11:00:00 | CL | Stock | 26.47 | 26.47 | 26.35 | 26.43 | 314600.0 |
| 2003-01-10 12:00:00 | CL | Stock | 26.415 | 26.445 | 26.35 | 26.4 | 257600.0 |
| 2003-01-10 13:00:00 | CL | Stock | 26.415 | 26.495 | 26.385 | 26.485 | 334600.0 |
| 2003-01-10 14:00:00 | CL | Stock | 26.49 | 26.5 | 26.37 | 26.5 | 275600.0 |
| 2003-01-10 15:00:00 | CL | Stock | 26.5 | 26.5 | 26.33 | 26.41 | 426600.0 |
| 2003-01-10 16:00:00 | CL | Stock | 26.415 | 26.465 | 26.415 | 26.465 | 173200.0 |
| 2003-01-10 17:00:00 | CL | Stock | 26.465 | 26.465 | 26.465 | 26.465 | 200.0 |
> showing 50 of 19,818 rows — these rows as CSV