PREVIEW / stock_1hour / 2003-01-13
file: by_date/stock_1hour/2003/2003-01-13.parquet size: 426 KB rows: 19,936 symbols: 1,531
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-13 08:00:00 | AAPL | Stock | 0.2625 | 0.2625 | 0.2625 | 0.2625 | 5600.0 |
| 2003-01-13 09:00:00 | AAPL | Stock | 0.2654 | 0.2661 | 0.2609 | 0.262 | 21990976.0 |
| 2003-01-13 10:00:00 | AAPL | Stock | 0.262 | 0.2627 | 0.2564 | 0.2591 | 45543456.0 |
| 2003-01-13 11:00:00 | AAPL | Stock | 0.2591 | 0.2607 | 0.2584 | 0.26 | 29112104.0 |
| 2003-01-13 12:00:00 | AAPL | Stock | 0.26 | 0.2634 | 0.2598 | 0.2618 | 16891392.0 |
| 2003-01-13 13:00:00 | AAPL | Stock | 0.262 | 0.262 | 0.2593 | 0.2616 | 11096512.0 |
| 2003-01-13 14:00:00 | AAPL | Stock | 0.2618 | 0.2623 | 0.2598 | 0.2602 | 12167456.0 |
| 2003-01-13 15:00:00 | AAPL | Stock | 0.2602 | 0.2634 | 0.2593 | 0.2634 | 23435776.0 |
| 2003-01-13 16:00:00 | AAPL | Stock | 0.2634 | 0.2634 | 0.2604 | 0.2613 | 5630520.0 |
| 2003-01-13 17:00:00 | AAPL | Stock | 0.2613 | 0.2613 | 0.2613 | 0.2613 | 11200.0 |
| 2003-01-13 08:00:00 | MSFT | Stock | 28.225 | 28.345 | 27.8932 | 28.3 | 479588.0 |
| 2003-01-13 09:00:00 | MSFT | Stock | 28.2805 | 28.375 | 28.15 | 28.25 | 10325614.0 |
| 2003-01-13 10:00:00 | MSFT | Stock | 28.2475 | 28.295 | 27.889 | 28.015 | 12705402.0 |
| 2003-01-13 11:00:00 | MSFT | Stock | 28.015 | 28.18 | 27.945 | 28.15 | 7218398.0 |
| 2003-01-13 12:00:00 | MSFT | Stock | 28.145 | 28.245 | 28.12 | 28.215 | 5276260.0 |
| 2003-01-13 13:00:00 | MSFT | Stock | 28.215 | 28.24 | 28.12 | 28.195 | 4662092.0 |
| 2003-01-13 14:00:00 | MSFT | Stock | 28.2 | 28.276 | 28.113 | 28.155 | 5665578.0 |
| 2003-01-13 15:00:00 | MSFT | Stock | 28.155 | 28.25 | 28.055 | 28.2 | 8562328.0 |
| 2003-01-13 16:00:00 | MSFT | Stock | 28.1905 | 28.225 | 28.1145 | 28.206 | 1752852.0 |
| 2003-01-13 17:00:00 | MSFT | Stock | 28.1655 | 28.2 | 28.1655 | 28.19 | 14400.0 |
| 2003-01-13 18:00:00 | MSFT | Stock | 28.195 | 28.195 | 28.19 | 28.19 | 8000.0 |
| 2003-01-13 08:00:00 | NVDA | Stock | 0.106 | 0.1079 | 0.106 | 0.1079 | 2850000.0 |
| 2003-01-13 09:00:00 | NVDA | Stock | 0.1077 | 0.1083 | 0.1047 | 0.1055 | 170606640.0 |
| 2003-01-13 10:00:00 | NVDA | Stock | 0.1057 | 0.1071 | 0.1017 | 0.1035 | 243624000.0 |
| 2003-01-13 11:00:00 | NVDA | Stock | 0.1036 | 0.1041 | 0.1025 | 0.1034 | 93479880.0 |
| 2003-01-13 12:00:00 | NVDA | Stock | 0.1034 | 0.1041 | 0.1032 | 0.1035 | 52368840.0 |
| 2003-01-13 13:00:00 | NVDA | Stock | 0.1035 | 0.1037 | 0.1024 | 0.1032 | 61748400.0 |
| 2003-01-13 14:00:00 | NVDA | Stock | 0.1033 | 0.1038 | 0.1021 | 0.1024 | 72063360.0 |
| 2003-01-13 15:00:00 | NVDA | Stock | 0.1023 | 0.1033 | 0.1021 | 0.1022 | 88924680.0 |
| 2003-01-13 16:00:00 | NVDA | Stock | 0.1022 | 0.1026 | 0.1019 | 0.1019 | 8964360.0 |
| 2003-01-13 17:00:00 | NVDA | Stock | 0.1024 | 0.1024 | 0.1022 | 0.1022 | 845640.0 |
| 2003-01-13 18:00:00 | NVDA | Stock | 0.1025 | 0.1029 | 0.1023 | 0.1025 | 806640.0 |
| 2003-01-13 08:00:00 | AMZN | Stock | 1.072 | 1.0805 | 1.072 | 1.075 | 112440.0 |
| 2003-01-13 09:00:00 | AMZN | Stock | 1.075 | 1.0875 | 1.0625 | 1.084 | 22547740.0 |
| 2003-01-13 10:00:00 | AMZN | Stock | 1.084 | 1.093 | 1.0775 | 1.083 | 25475940.0 |
| 2003-01-13 11:00:00 | AMZN | Stock | 1.082 | 1.0918 | 1.0785 | 1.0885 | 13970660.0 |
| 2003-01-13 12:00:00 | AMZN | Stock | 1.0884 | 1.097 | 1.0855 | 1.0936 | 11085460.0 |
| 2003-01-13 13:00:00 | AMZN | Stock | 1.094 | 1.0995 | 1.0855 | 1.097 | 17395560.0 |
| 2003-01-13 14:00:00 | AMZN | Stock | 1.0975 | 1.1045 | 1.097 | 1.0995 | 16594340.0 |
| 2003-01-13 15:00:00 | AMZN | Stock | 1.099 | 1.105 | 1.0945 | 1.102 | 20237840.0 |
| 2003-01-13 16:00:00 | AMZN | Stock | 1.102 | 1.109 | 1.1005 | 1.109 | 2695260.0 |
| 2003-01-13 17:00:00 | AMZN | Stock | 1.1075 | 1.1075 | 1.102 | 1.1045 | 112000.0 |
| 2003-01-13 09:00:00 | CL | Stock | 26.475 | 26.55 | 26.375 | 26.465 | 255600.0 |
| 2003-01-13 10:00:00 | CL | Stock | 26.445 | 26.54 | 26.235 | 26.3 | 312800.0 |
| 2003-01-13 11:00:00 | CL | Stock | 26.305 | 26.345 | 26.255 | 26.34 | 276800.0 |
| 2003-01-13 12:00:00 | CL | Stock | 26.35 | 26.375 | 26.32 | 26.355 | 166400.0 |
| 2003-01-13 13:00:00 | CL | Stock | 26.355 | 26.445 | 26.315 | 26.435 | 246200.0 |
| 2003-01-13 14:00:00 | CL | Stock | 26.44 | 26.52 | 26.42 | 26.46 | 568800.0 |
| 2003-01-13 15:00:00 | CL | Stock | 26.45 | 26.505 | 26.42 | 26.42 | 509800.0 |
| 2003-01-13 16:00:00 | CL | Stock | 26.425 | 26.425 | 26.425 | 26.425 | 153600.0 |
> showing 50 of 19,936 rows — these rows as CSV