PREVIEW / stock_1hour / 2003-01-08
file: by_date/stock_1hour/2003/2003-01-08.parquet size: 431 KB rows: 20,504 symbols: 1,533
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-08 08:00:00 | AAPL | Stock | 0.2661 | 0.2661 | 0.2623 | 0.2623 | 22400.0 |
| 2003-01-08 09:00:00 | AAPL | Stock | 0.2623 | 0.2627 | 0.2579 | 0.2591 | 38310440.0 |
| 2003-01-08 10:00:00 | AAPL | Stock | 0.2591 | 0.2609 | 0.2582 | 0.2588 | 29039584.0 |
| 2003-01-08 11:00:00 | AAPL | Stock | 0.2589 | 0.2607 | 0.2586 | 0.2589 | 21408184.0 |
| 2003-01-08 12:00:00 | AAPL | Stock | 0.2586 | 0.2604 | 0.2579 | 0.2589 | 32743144.0 |
| 2003-01-08 13:00:00 | AAPL | Stock | 0.2589 | 0.2604 | 0.2584 | 0.2593 | 15195432.0 |
| 2003-01-08 14:00:00 | AAPL | Stock | 0.2591 | 0.2607 | 0.2589 | 0.2596 | 28289016.0 |
| 2003-01-08 15:00:00 | AAPL | Stock | 0.2595 | 0.2602 | 0.2584 | 0.2598 | 27909952.0 |
| 2003-01-08 16:00:00 | AAPL | Stock | 0.2598 | 0.26 | 0.2589 | 0.2598 | 18754400.0 |
| 2003-01-08 17:00:00 | AAPL | Stock | 0.2598 | 0.2598 | 0.2598 | 0.2598 | 1405600.0 |
| 2003-01-08 08:00:00 | MSFT | Stock | 27.73 | 27.905 | 27.61 | 27.615 | 75100.0 |
| 2003-01-08 09:00:00 | MSFT | Stock | 27.605 | 27.875 | 27.505 | 27.5305 | 8769452.0 |
| 2003-01-08 10:00:00 | MSFT | Stock | 27.53 | 27.59 | 27.38 | 27.4555 | 11188276.0 |
| 2003-01-08 11:00:00 | MSFT | Stock | 27.455 | 27.55 | 27.34 | 27.345 | 7518000.0 |
| 2003-01-08 12:00:00 | MSFT | Stock | 27.34 | 27.375 | 27.165 | 27.2 | 7108186.0 |
| 2003-01-08 13:00:00 | MSFT | Stock | 27.2 | 27.31 | 27.095 | 27.22 | 4949432.0 |
| 2003-01-08 14:00:00 | MSFT | Stock | 27.2195 | 27.335 | 27.095 | 27.11 | 7162200.0 |
| 2003-01-08 15:00:00 | MSFT | Stock | 27.115 | 27.275 | 27.055 | 27.125 | 10652480.0 |
| 2003-01-08 16:00:00 | MSFT | Stock | 27.125 | 27.1995 | 27.1 | 27.125 | 1527386.0 |
| 2003-01-08 17:00:00 | MSFT | Stock | 27.14 | 27.235 | 27.12 | 27.2 | 252140.0 |
| 2003-01-08 18:00:00 | MSFT | Stock | 27.21 | 27.21 | 27.19 | 27.19 | 2000.0 |
| 2003-01-08 08:00:00 | NVDA | Stock | 0.11 | 0.1103 | 0.1079 | 0.1083 | 1200000.0 |
| 2003-01-08 09:00:00 | NVDA | Stock | 0.1083 | 0.1109 | 0.1075 | 0.108 | 228503640.0 |
| 2003-01-08 10:00:00 | NVDA | Stock | 0.1081 | 0.1088 | 0.1055 | 0.1058 | 212028720.0 |
| 2003-01-08 11:00:00 | NVDA | Stock | 0.1058 | 0.1065 | 0.1026 | 0.1027 | 247364760.0 |
| 2003-01-08 12:00:00 | NVDA | Stock | 0.1026 | 0.1035 | 0.1021 | 0.1031 | 169475280.0 |
| 2003-01-08 13:00:00 | NVDA | Stock | 0.1031 | 0.1039 | 0.1024 | 0.1036 | 120102480.0 |
| 2003-01-08 14:00:00 | NVDA | Stock | 0.1036 | 0.1037 | 0.1018 | 0.1022 | 137799120.0 |
| 2003-01-08 15:00:00 | NVDA | Stock | 0.1022 | 0.1025 | 0.0988 | 0.0996 | 555525480.0 |
| 2003-01-08 16:00:00 | NVDA | Stock | 0.0995 | 0.1002 | 0.0989 | 0.0989 | 24458640.0 |
| 2003-01-08 17:00:00 | NVDA | Stock | 0.0989 | 0.1003 | 0.0989 | 0.1 | 4992960.0 |
| 2003-01-08 18:00:00 | NVDA | Stock | 0.1 | 0.1002 | 0.0998 | 0.1002 | 1960800.0 |
| 2003-01-08 08:00:00 | AMZN | Stock | 1.0788 | 1.0788 | 1.0694 | 1.0695 | 38000.0 |
| 2003-01-08 09:00:00 | AMZN | Stock | 1.0675 | 1.08 | 1.066 | 1.0675 | 19327060.0 |
| 2003-01-08 10:00:00 | AMZN | Stock | 1.0665 | 1.079 | 1.0645 | 1.0685 | 21395420.0 |
| 2003-01-08 11:00:00 | AMZN | Stock | 1.0685 | 1.0715 | 1.0505 | 1.053 | 14306440.0 |
| 2003-01-08 12:00:00 | AMZN | Stock | 1.053 | 1.0595 | 1.045 | 1.0475 | 15570720.0 |
| 2003-01-08 13:00:00 | AMZN | Stock | 1.0474 | 1.0575 | 1.041 | 1.0472 | 17454220.0 |
| 2003-01-08 14:00:00 | AMZN | Stock | 1.0485 | 1.05 | 1.0435 | 1.0475 | 14308460.0 |
| 2003-01-08 15:00:00 | AMZN | Stock | 1.0475 | 1.055 | 1.045 | 1.0505 | 20513920.0 |
| 2003-01-08 16:00:00 | AMZN | Stock | 1.0505 | 1.058 | 1.049 | 1.0525 | 2247000.0 |
| 2003-01-08 17:00:00 | AMZN | Stock | 1.051 | 1.058 | 1.051 | 1.051 | 743500.0 |
| 2003-01-08 09:00:00 | CL | Stock | 26.825 | 26.96 | 26.805 | 26.88 | 211800.0 |
| 2003-01-08 10:00:00 | CL | Stock | 26.88 | 27.02 | 26.87 | 26.99 | 685000.0 |
| 2003-01-08 11:00:00 | CL | Stock | 26.985 | 27.07 | 26.935 | 26.935 | 499800.0 |
| 2003-01-08 12:00:00 | CL | Stock | 26.955 | 27.02 | 26.95 | 27.005 | 323600.0 |
| 2003-01-08 13:00:00 | CL | Stock | 27.0 | 27.0 | 26.81 | 26.815 | 686600.0 |
| 2003-01-08 14:00:00 | CL | Stock | 26.82 | 26.82 | 26.64 | 26.665 | 322600.0 |
| 2003-01-08 15:00:00 | CL | Stock | 26.665 | 26.665 | 26.6 | 26.625 | 588400.0 |
| 2003-01-08 16:00:00 | CL | Stock | 26.6 | 26.6 | 26.6 | 26.6 | 158200.0 |
> showing 50 of 20,504 rows — these rows as CSV