PREVIEW / stock_1hour / 2003-02-19
file: by_date/stock_1hour/2003/2003-02-19.parquet size: 391 KB rows: 19,493 symbols: 1,539
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-02-19 08:00:00 | AAPL | Stock | 0.2727 | 0.2727 | 0.2727 | 0.2727 | 448000.0 |
| 2003-02-19 09:00:00 | AAPL | Stock | 0.2711 | 0.2711 | 0.2682 | 0.2686 | 19870592.0 |
| 2003-02-19 10:00:00 | AAPL | Stock | 0.2684 | 0.27 | 0.2671 | 0.2691 | 22800288.0 |
| 2003-02-19 11:00:00 | AAPL | Stock | 0.2689 | 0.2693 | 0.2654 | 0.2672 | 29557808.0 |
| 2003-02-19 12:00:00 | AAPL | Stock | 0.2672 | 0.2677 | 0.2654 | 0.2655 | 13367872.0 |
| 2003-02-19 13:00:00 | AAPL | Stock | 0.2655 | 0.2656 | 0.2621 | 0.2629 | 31679984.0 |
| 2003-02-19 14:00:00 | AAPL | Stock | 0.2629 | 0.265 | 0.2625 | 0.2632 | 44173864.0 |
| 2003-02-19 15:00:00 | AAPL | Stock | 0.2634 | 0.2654 | 0.2627 | 0.2652 | 50873032.0 |
| 2003-02-19 16:00:00 | AAPL | Stock | 0.2652 | 0.266 | 0.2643 | 0.2645 | 4138064.0 |
| 2003-02-19 17:00:00 | AAPL | Stock | 0.2652 | 0.2652 | 0.2652 | 0.2652 | 1607200.0 |
| 2003-02-19 08:00:00 | MSFT | Stock | 24.86 | 25.23 | 24.32 | 24.808 | 167022.0 |
| 2003-02-19 09:00:00 | MSFT | Stock | 24.81 | 24.99 | 24.58 | 24.67 | 6583092.0 |
| 2003-02-19 10:00:00 | MSFT | Stock | 24.67 | 24.81 | 24.5 | 24.57 | 7278378.0 |
| 2003-02-19 11:00:00 | MSFT | Stock | 24.57 | 24.64 | 24.5 | 24.601 | 4251691.0 |
| 2003-02-19 12:00:00 | MSFT | Stock | 24.6 | 24.661 | 24.58 | 24.59 | 2687339.0 |
| 2003-02-19 13:00:00 | MSFT | Stock | 24.59 | 24.6 | 24.28 | 24.37 | 5456269.0 |
| 2003-02-19 14:00:00 | MSFT | Stock | 24.36 | 24.46 | 24.18 | 24.2185 | 4862763.0 |
| 2003-02-19 15:00:00 | MSFT | Stock | 24.22 | 24.59 | 24.17 | 24.58 | 9425688.0 |
| 2003-02-19 16:00:00 | MSFT | Stock | 24.55 | 24.59 | 24.47 | 24.53 | 1142675.0 |
| 2003-02-19 17:00:00 | MSFT | Stock | 24.48 | 24.53 | 24.47 | 24.52 | 223400.0 |
| 2003-02-19 18:00:00 | MSFT | Stock | 24.5 | 24.53 | 24.49 | 24.53 | 8080.0 |
| 2003-02-19 08:00:00 | NVDA | Stock | 0.1057 | 0.1059 | 0.1038 | 0.104 | 2615040.0 |
| 2003-02-19 09:00:00 | NVDA | Stock | 0.104 | 0.1071 | 0.104 | 0.1059 | 232723440.0 |
| 2003-02-19 10:00:00 | NVDA | Stock | 0.1061 | 0.1068 | 0.1051 | 0.1057 | 197050680.0 |
| 2003-02-19 11:00:00 | NVDA | Stock | 0.1057 | 0.1062 | 0.1054 | 0.1057 | 95765760.0 |
| 2003-02-19 12:00:00 | NVDA | Stock | 0.1057 | 0.1067 | 0.1056 | 0.1067 | 98871720.0 |
| 2003-02-19 13:00:00 | NVDA | Stock | 0.1067 | 0.1068 | 0.1058 | 0.1058 | 103294680.0 |
| 2003-02-19 14:00:00 | NVDA | Stock | 0.1058 | 0.1061 | 0.1053 | 0.1055 | 76533720.0 |
| 2003-02-19 15:00:00 | NVDA | Stock | 0.1054 | 0.1077 | 0.1054 | 0.1072 | 225605520.0 |
| 2003-02-19 16:00:00 | NVDA | Stock | 0.1072 | 0.1072 | 0.107 | 0.1071 | 19687200.0 |
| 2003-02-19 17:00:00 | NVDA | Stock | 0.107 | 0.1071 | 0.1067 | 0.1068 | 2315760.0 |
| 2003-02-19 18:00:00 | NVDA | Stock | 0.1068 | 0.1072 | 0.1068 | 0.1072 | 286560.0 |
| 2003-02-19 08:00:00 | AMZN | Stock | 1.0675 | 1.069 | 1.0624 | 1.0625 | 48000.0 |
| 2003-02-19 09:00:00 | AMZN | Stock | 1.0625 | 1.069 | 1.056 | 1.061 | 11621620.0 |
| 2003-02-19 10:00:00 | AMZN | Stock | 1.061 | 1.0625 | 1.0525 | 1.055 | 18522420.0 |
| 2003-02-19 11:00:00 | AMZN | Stock | 1.055 | 1.056 | 1.052 | 1.0555 | 10343220.0 |
| 2003-02-19 12:00:00 | AMZN | Stock | 1.0551 | 1.058 | 1.053 | 1.053 | 7485740.0 |
| 2003-02-19 13:00:00 | AMZN | Stock | 1.053 | 1.0575 | 1.0525 | 1.054 | 11079460.0 |
| 2003-02-19 14:00:00 | AMZN | Stock | 1.054 | 1.0566 | 1.0514 | 1.054 | 10401380.0 |
| 2003-02-19 15:00:00 | AMZN | Stock | 1.054 | 1.0625 | 1.053 | 1.0592 | 20012620.0 |
| 2003-02-19 16:00:00 | AMZN | Stock | 1.0615 | 1.0615 | 1.0565 | 1.059 | 705560.0 |
| 2003-02-19 17:00:00 | AMZN | Stock | 1.0595 | 1.0595 | 1.0594 | 1.0594 | 506000.0 |
| 2003-02-19 18:00:00 | AMZN | Stock | 1.0585 | 1.0586 | 1.0585 | 1.0586 | 166000.0 |
| 2003-02-19 09:00:00 | CL | Stock | 25.375 | 25.525 | 25.3 | 25.405 | 200600.0 |
| 2003-02-19 10:00:00 | CL | Stock | 25.405 | 25.41 | 25.21 | 25.245 | 292400.0 |
| 2003-02-19 11:00:00 | CL | Stock | 25.24 | 25.335 | 25.225 | 25.325 | 257200.0 |
| 2003-02-19 12:00:00 | CL | Stock | 25.325 | 25.325 | 25.165 | 25.23 | 255200.0 |
| 2003-02-19 13:00:00 | CL | Stock | 25.225 | 25.225 | 25.105 | 25.13 | 149600.0 |
| 2003-02-19 14:00:00 | CL | Stock | 25.135 | 25.185 | 25.105 | 25.165 | 208000.0 |
| 2003-02-19 15:00:00 | CL | Stock | 25.17 | 25.325 | 25.14 | 25.25 | 445000.0 |
> showing 50 of 19,493 rows — these rows as CSV