PREVIEW / stock_1hour / 2004-10-11
file: by_date/stock_1hour/2004/2004-10-11.parquet size: 482 KB rows: 22,863 symbols: 1,817
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-11 08:00:00 | AAPL | Stock | 0.6921 | 0.6929 | 0.6911 | 0.692 | 202720.0 |
| 2004-10-11 09:00:00 | AAPL | Stock | 0.6929 | 0.6955 | 0.6821 | 0.6839 | 55397440.0 |
| 2004-10-11 10:00:00 | AAPL | Stock | 0.6839 | 0.6888 | 0.6827 | 0.685 | 66500224.0 |
| 2004-10-11 11:00:00 | AAPL | Stock | 0.6848 | 0.6902 | 0.6843 | 0.6902 | 38059168.0 |
| 2004-10-11 12:00:00 | AAPL | Stock | 0.6902 | 0.6907 | 0.6871 | 0.6891 | 21415128.0 |
| 2004-10-11 13:00:00 | AAPL | Stock | 0.6891 | 0.6893 | 0.6871 | 0.6889 | 22171744.0 |
| 2004-10-11 14:00:00 | AAPL | Stock | 0.6891 | 0.692 | 0.6879 | 0.6893 | 36437576.0 |
| 2004-10-11 15:00:00 | AAPL | Stock | 0.6893 | 0.6911 | 0.6877 | 0.6898 | 51536296.0 |
| 2004-10-11 16:00:00 | AAPL | Stock | 0.6893 | 0.6898 | 0.6871 | 0.6891 | 2663136.0 |
| 2004-10-11 17:00:00 | AAPL | Stock | 0.6884 | 0.6884 | 0.6884 | 0.6884 | 33600.0 |
| 2004-10-11 18:00:00 | AAPL | Stock | 0.6913 | 0.6913 | 0.6913 | 0.6913 | 5600.0 |
| 2004-10-11 08:00:00 | MSFT | Stock | 27.99 | 28.215 | 27.99 | 28.1 | 47923.0 |
| 2004-10-11 09:00:00 | MSFT | Stock | 28.13 | 28.22 | 28.0 | 28.15 | 6242525.0 |
| 2004-10-11 10:00:00 | MSFT | Stock | 28.15 | 28.18 | 28.11 | 28.14 | 7290165.0 |
| 2004-10-11 11:00:00 | MSFT | Stock | 28.14 | 28.16 | 28.1 | 28.14 | 4688437.0 |
| 2004-10-11 12:00:00 | MSFT | Stock | 28.14 | 28.17 | 28.11 | 28.13 | 2309319.0 |
| 2004-10-11 13:00:00 | MSFT | Stock | 28.12 | 28.15 | 28.09 | 28.1 | 2328453.0 |
| 2004-10-11 14:00:00 | MSFT | Stock | 28.1 | 28.12 | 28.04 | 28.06 | 5125946.0 |
| 2004-10-11 15:00:00 | MSFT | Stock | 28.05 | 28.09 | 27.93 | 28.06 | 14005788.0 |
| 2004-10-11 16:00:00 | MSFT | Stock | 28.06 | 28.06 | 28.02 | 28.05 | 774928.0 |
| 2004-10-11 17:00:00 | MSFT | Stock | 28.05 | 28.05 | 28.03 | 28.03 | 3470.0 |
| 2004-10-11 18:00:00 | MSFT | Stock | 28.03 | 28.03 | 28.0 | 28.0 | 4200.0 |
| 2004-10-11 09:00:00 | NVDA | Stock | 0.121 | 0.1235 | 0.1202 | 0.1216 | 46851240.0 |
| 2004-10-11 10:00:00 | NVDA | Stock | 0.1215 | 0.1217 | 0.1192 | 0.1197 | 66005520.0 |
| 2004-10-11 11:00:00 | NVDA | Stock | 0.1197 | 0.1201 | 0.1189 | 0.1197 | 49299600.0 |
| 2004-10-11 12:00:00 | NVDA | Stock | 0.1197 | 0.1202 | 0.1194 | 0.1199 | 72736080.0 |
| 2004-10-11 13:00:00 | NVDA | Stock | 0.1198 | 0.1205 | 0.1196 | 0.1203 | 23464200.0 |
| 2004-10-11 14:00:00 | NVDA | Stock | 0.1204 | 0.1212 | 0.1203 | 0.1207 | 27744960.0 |
| 2004-10-11 15:00:00 | NVDA | Stock | 0.1207 | 0.1222 | 0.1204 | 0.1211 | 72041040.0 |
| 2004-10-11 16:00:00 | NVDA | Stock | 0.1212 | 0.1213 | 0.1204 | 0.1211 | 5504160.0 |
| 2004-10-11 17:00:00 | NVDA | Stock | 0.12 | 0.12 | 0.12 | 0.12 | 48000.0 |
| 2004-10-11 18:00:00 | NVDA | Stock | 0.1201 | 0.1201 | 0.1201 | 0.1201 | 156000.0 |
| 2004-10-11 08:00:00 | AMZN | Stock | 2.0 | 2.0 | 1.9875 | 1.99 | 67200.0 |
| 2004-10-11 09:00:00 | AMZN | Stock | 1.9945 | 2.0375 | 1.9875 | 1.996 | 27176620.0 |
| 2004-10-11 10:00:00 | AMZN | Stock | 1.9965 | 1.997 | 1.9705 | 1.987 | 34380600.0 |
| 2004-10-11 11:00:00 | AMZN | Stock | 1.986 | 1.999 | 1.9815 | 1.983 | 13850140.0 |
| 2004-10-11 12:00:00 | AMZN | Stock | 1.985 | 1.9955 | 1.984 | 1.9925 | 9434700.0 |
| 2004-10-11 13:00:00 | AMZN | Stock | 1.9925 | 2.0 | 1.9885 | 1.9975 | 10689880.0 |
| 2004-10-11 14:00:00 | AMZN | Stock | 1.998 | 2.0025 | 1.986 | 1.995 | 21723340.0 |
| 2004-10-11 15:00:00 | AMZN | Stock | 1.994 | 2.008 | 1.9924 | 2.006 | 36440100.0 |
| 2004-10-11 16:00:00 | AMZN | Stock | 2.006 | 2.0075 | 2.0015 | 2.0075 | 619020.0 |
| 2004-10-11 17:00:00 | AMZN | Stock | 2.005 | 2.005 | 2.005 | 2.005 | 2000.0 |
| 2004-10-11 09:00:00 | CL | Stock | 22.06 | 22.145 | 22.0 | 22.065 | 540600.0 |
| 2004-10-11 10:00:00 | CL | Stock | 22.065 | 22.075 | 21.855 | 21.89 | 1205200.0 |
| 2004-10-11 11:00:00 | CL | Stock | 21.89 | 21.985 | 21.89 | 21.925 | 533800.0 |
| 2004-10-11 12:00:00 | CL | Stock | 21.93 | 21.99 | 21.9 | 21.975 | 499600.0 |
| 2004-10-11 13:00:00 | CL | Stock | 21.975 | 21.985 | 21.945 | 21.95 | 287800.0 |
| 2004-10-11 14:00:00 | CL | Stock | 21.955 | 21.98 | 21.875 | 21.935 | 625200.0 |
| 2004-10-11 15:00:00 | CL | Stock | 21.94 | 21.98 | 21.93 | 21.975 | 918200.0 |
| 2004-10-11 16:00:00 | CL | Stock | 21.995 | 22.075 | 21.995 | 22.075 | 46600.0 |
> showing 50 of 22,863 rows — these rows as CSV