PREVIEW / stock_1hour / 2002-12-19
file: by_date/stock_1hour/2002/2002-12-19.parquet size: 419 KB rows: 20,017 symbols: 1,530
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 |
|---|---|---|---|---|---|---|---|
| 2002-12-19 08:00:00 | AAPL | Stock | 0.2598 | 0.2598 | 0.2598 | 0.2598 | 397600.0 |
| 2002-12-19 09:00:00 | AAPL | Stock | 0.2605 | 0.2664 | 0.2593 | 0.265 | 26231800.0 |
| 2002-12-19 10:00:00 | AAPL | Stock | 0.265 | 0.2663 | 0.2545 | 0.2546 | 55001688.0 |
| 2002-12-19 11:00:00 | AAPL | Stock | 0.2546 | 0.258 | 0.2525 | 0.2577 | 64430128.0 |
| 2002-12-19 12:00:00 | AAPL | Stock | 0.2577 | 0.2586 | 0.2543 | 0.2571 | 21456736.0 |
| 2002-12-19 13:00:00 | AAPL | Stock | 0.2571 | 0.2571 | 0.2523 | 0.2536 | 33972064.0 |
| 2002-12-19 14:00:00 | AAPL | Stock | 0.2536 | 0.2548 | 0.2518 | 0.253 | 56991424.0 |
| 2002-12-19 15:00:00 | AAPL | Stock | 0.2529 | 0.2548 | 0.252 | 0.2533 | 47881008.0 |
| 2002-12-19 16:00:00 | AAPL | Stock | 0.2532 | 0.2539 | 0.2521 | 0.2521 | 13319600.0 |
| 2002-12-19 08:00:00 | MSFT | Stock | 26.72 | 26.785 | 26.5995 | 26.6445 | 102448.0 |
| 2002-12-19 09:00:00 | MSFT | Stock | 26.645 | 27.3 | 26.625 | 27.285 | 11687434.0 |
| 2002-12-19 10:00:00 | MSFT | Stock | 27.28 | 27.375 | 26.86 | 26.88 | 15302600.0 |
| 2002-12-19 11:00:00 | MSFT | Stock | 26.87 | 27.04 | 26.65 | 26.875 | 15074966.0 |
| 2002-12-19 12:00:00 | MSFT | Stock | 26.88 | 27.01 | 26.66 | 26.8055 | 6880514.0 |
| 2002-12-19 13:00:00 | MSFT | Stock | 26.81 | 26.825 | 26.535 | 26.605 | 5151022.0 |
| 2002-12-19 14:00:00 | MSFT | Stock | 26.6095 | 26.7 | 26.5 | 26.5845 | 7438110.0 |
| 2002-12-19 15:00:00 | MSFT | Stock | 26.575 | 26.735 | 26.455 | 26.555 | 10492942.0 |
| 2002-12-19 16:00:00 | MSFT | Stock | 26.56 | 26.62 | 26.44 | 26.54 | 2160822.0 |
| 2002-12-19 17:00:00 | MSFT | Stock | 26.54 | 26.575 | 26.525 | 26.575 | 34748.0 |
| 2002-12-19 18:00:00 | MSFT | Stock | 26.595 | 26.6 | 26.5155 | 26.5155 | 670400.0 |
| 2002-12-19 08:00:00 | NVDA | Stock | 0.1092 | 0.1092 | 0.1057 | 0.1058 | 3579600.0 |
| 2002-12-19 09:00:00 | NVDA | Stock | 0.1051 | 0.1114 | 0.105 | 0.1103 | 193425360.0 |
| 2002-12-19 10:00:00 | NVDA | Stock | 0.1103 | 0.111 | 0.1052 | 0.1056 | 216392760.0 |
| 2002-12-19 11:00:00 | NVDA | Stock | 0.1055 | 0.1083 | 0.1047 | 0.1075 | 162195960.0 |
| 2002-12-19 12:00:00 | NVDA | Stock | 0.1075 | 0.1081 | 0.1052 | 0.1061 | 80622720.0 |
| 2002-12-19 13:00:00 | NVDA | Stock | 0.1061 | 0.1064 | 0.1043 | 0.1058 | 102266760.0 |
| 2002-12-19 14:00:00 | NVDA | Stock | 0.1058 | 0.1075 | 0.1052 | 0.1064 | 75001320.0 |
| 2002-12-19 15:00:00 | NVDA | Stock | 0.1065 | 0.1072 | 0.1047 | 0.1054 | 150262560.0 |
| 2002-12-19 16:00:00 | NVDA | Stock | 0.1054 | 0.1079 | 0.1048 | 0.105 | 22625400.0 |
| 2002-12-19 17:00:00 | NVDA | Stock | 0.1051 | 0.1055 | 0.1051 | 0.1055 | 429240.0 |
| 2002-12-19 18:00:00 | NVDA | Stock | 0.1055 | 0.1055 | 0.1054 | 0.1054 | 1140000.0 |
| 2002-12-19 08:00:00 | AMZN | Stock | 1.095 | 1.095 | 1.07 | 1.08 | 761700.0 |
| 2002-12-19 09:00:00 | AMZN | Stock | 1.08 | 1.11 | 1.0725 | 1.103 | 15142780.0 |
| 2002-12-19 10:00:00 | AMZN | Stock | 1.103 | 1.1075 | 1.0875 | 1.0875 | 21709640.0 |
| 2002-12-19 11:00:00 | AMZN | Stock | 1.0878 | 1.1032 | 1.0845 | 1.097 | 16209700.0 |
| 2002-12-19 12:00:00 | AMZN | Stock | 1.0975 | 1.1 | 1.087 | 1.091 | 9576860.0 |
| 2002-12-19 13:00:00 | AMZN | Stock | 1.0896 | 1.095 | 1.082 | 1.0895 | 5701340.0 |
| 2002-12-19 14:00:00 | AMZN | Stock | 1.0895 | 1.095 | 1.0815 | 1.086 | 10596320.0 |
| 2002-12-19 15:00:00 | AMZN | Stock | 1.0855 | 1.0915 | 1.0765 | 1.0825 | 19091340.0 |
| 2002-12-19 16:00:00 | AMZN | Stock | 1.0825 | 1.0855 | 1.0815 | 1.0845 | 1370000.0 |
| 2002-12-19 17:00:00 | AMZN | Stock | 1.0845 | 1.0966 | 1.078 | 1.0966 | 1928000.0 |
| 2002-12-19 18:00:00 | AMZN | Stock | 1.084 | 1.084 | 1.084 | 1.084 | 70000.0 |
| 2002-12-19 09:00:00 | CL | Stock | 26.2 | 26.23 | 25.975 | 25.985 | 398800.0 |
| 2002-12-19 10:00:00 | CL | Stock | 25.995 | 26.175 | 25.955 | 26.07 | 570400.0 |
| 2002-12-19 11:00:00 | CL | Stock | 26.065 | 26.27 | 26.045 | 26.255 | 513800.0 |
| 2002-12-19 12:00:00 | CL | Stock | 26.265 | 26.295 | 26.165 | 26.205 | 332800.0 |
| 2002-12-19 13:00:00 | CL | Stock | 26.205 | 26.215 | 26.075 | 26.075 | 284000.0 |
| 2002-12-19 14:00:00 | CL | Stock | 26.075 | 26.095 | 26.005 | 26.005 | 308400.0 |
| 2002-12-19 15:00:00 | CL | Stock | 26.0 | 26.065 | 25.905 | 25.935 | 781200.0 |
| 2002-12-19 16:00:00 | CL | Stock | 25.95 | 25.95 | 25.95 | 25.95 | 89600.0 |
> showing 50 of 20,017 rows — these rows as CSV