PREVIEW / stock_1hour / 2004-10-08
file: by_date/stock_1hour/2004/2004-10-08.parquet size: 521 KB rows: 24,605 symbols: 1,844
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-08 08:00:00 | AAPL | Stock | 0.708 | 0.7082 | 0.7054 | 0.7054 | 210224.0 |
| 2004-10-08 09:00:00 | AAPL | Stock | 0.7071 | 0.7102 | 0.7054 | 0.7079 | 52884384.0 |
| 2004-10-08 10:00:00 | AAPL | Stock | 0.7079 | 0.708 | 0.6952 | 0.6959 | 70463848.0 |
| 2004-10-08 11:00:00 | AAPL | Stock | 0.6961 | 0.7 | 0.6955 | 0.6991 | 37306920.0 |
| 2004-10-08 12:00:00 | AAPL | Stock | 0.6991 | 0.7034 | 0.698 | 0.7027 | 31126536.0 |
| 2004-10-08 13:00:00 | AAPL | Stock | 0.7027 | 0.7057 | 0.7 | 0.7005 | 37036104.0 |
| 2004-10-08 14:00:00 | AAPL | Stock | 0.7009 | 0.7009 | 0.6936 | 0.6948 | 59379824.0 |
| 2004-10-08 15:00:00 | AAPL | Stock | 0.695 | 0.6991 | 0.6936 | 0.6973 | 55310584.0 |
| 2004-10-08 16:00:00 | AAPL | Stock | 0.6973 | 0.6979 | 0.6963 | 0.6975 | 867440.0 |
| 2004-10-08 17:00:00 | AAPL | Stock | 0.6955 | 0.6964 | 0.6955 | 0.6964 | 100800.0 |
| 2004-10-08 08:00:00 | MSFT | Stock | 28.23 | 28.23 | 28.05 | 28.08 | 80519.0 |
| 2004-10-08 09:00:00 | MSFT | Stock | 28.1 | 28.29 | 28.06 | 28.26 | 7658426.0 |
| 2004-10-08 10:00:00 | MSFT | Stock | 28.26 | 28.33 | 28.16 | 28.2 | 8960023.0 |
| 2004-10-08 11:00:00 | MSFT | Stock | 28.2 | 28.28 | 28.17 | 28.21 | 6410272.0 |
| 2004-10-08 12:00:00 | MSFT | Stock | 28.21 | 28.25 | 28.13 | 28.21 | 5218958.0 |
| 2004-10-08 13:00:00 | MSFT | Stock | 28.2 | 28.22 | 28.09 | 28.12 | 2856534.0 |
| 2004-10-08 14:00:00 | MSFT | Stock | 28.12 | 28.14 | 27.97 | 28.07 | 8011088.0 |
| 2004-10-08 15:00:00 | MSFT | Stock | 28.07 | 28.11 | 27.97 | 28.0 | 7774419.0 |
| 2004-10-08 16:00:00 | MSFT | Stock | 28.0 | 28.1004 | 27.96 | 27.99 | 520241.0 |
| 2004-10-08 17:00:00 | MSFT | Stock | 27.99 | 28.1532 | 27.98 | 28.0 | 7800.0 |
| 2004-10-08 18:00:00 | MSFT | Stock | 27.98 | 27.98 | 27.98 | 27.98 | 933.0 |
| 2004-10-08 08:00:00 | NVDA | Stock | 0.1278 | 0.1278 | 0.1267 | 0.1267 | 238800.0 |
| 2004-10-08 09:00:00 | NVDA | Stock | 0.1267 | 0.1272 | 0.125 | 0.1264 | 66291360.0 |
| 2004-10-08 10:00:00 | NVDA | Stock | 0.1263 | 0.1263 | 0.1219 | 0.1227 | 188303760.0 |
| 2004-10-08 11:00:00 | NVDA | Stock | 0.1226 | 0.1232 | 0.1218 | 0.1222 | 129452520.0 |
| 2004-10-08 12:00:00 | NVDA | Stock | 0.1222 | 0.1224 | 0.1214 | 0.122 | 71178240.0 |
| 2004-10-08 13:00:00 | NVDA | Stock | 0.1219 | 0.1222 | 0.1212 | 0.1217 | 42722640.0 |
| 2004-10-08 14:00:00 | NVDA | Stock | 0.1217 | 0.1219 | 0.1202 | 0.1209 | 76002480.0 |
| 2004-10-08 15:00:00 | NVDA | Stock | 0.1208 | 0.1213 | 0.1198 | 0.1208 | 98728560.0 |
| 2004-10-08 16:00:00 | NVDA | Stock | 0.1208 | 0.1218 | 0.1208 | 0.121 | 8227560.0 |
| 2004-10-08 08:00:00 | AMZN | Stock | 2.0585 | 2.0585 | 2.0445 | 2.045 | 155000.0 |
| 2004-10-08 09:00:00 | AMZN | Stock | 2.0435 | 2.0595 | 2.02 | 2.057 | 16757280.0 |
| 2004-10-08 10:00:00 | AMZN | Stock | 2.057 | 2.057 | 2.003 | 2.004 | 23034960.0 |
| 2004-10-08 11:00:00 | AMZN | Stock | 2.0035 | 2.017 | 1.9815 | 1.993 | 29613780.0 |
| 2004-10-08 12:00:00 | AMZN | Stock | 1.993 | 2.006 | 1.993 | 2.005 | 10733100.0 |
| 2004-10-08 13:00:00 | AMZN | Stock | 2.005 | 2.0075 | 2.0 | 2.002 | 13106260.0 |
| 2004-10-08 14:00:00 | AMZN | Stock | 2.002 | 2.01 | 1.992 | 1.9945 | 29114520.0 |
| 2004-10-08 15:00:00 | AMZN | Stock | 1.9945 | 2.0 | 1.9875 | 1.9985 | 38838360.0 |
| 2004-10-08 16:00:00 | AMZN | Stock | 1.9995 | 2.007 | 1.9975 | 2.0 | 2315780.0 |
| 2004-10-08 17:00:00 | AMZN | Stock | 1.9995 | 2.0065 | 1.9995 | 2.0 | 542000.0 |
| 2004-10-08 18:00:00 | AMZN | Stock | 2.0 | 2.0 | 2.0 | 2.0 | 200000.0 |
| 2004-10-08 09:00:00 | CL | Stock | 22.24 | 22.335 | 22.185 | 22.32 | 812200.0 |
| 2004-10-08 10:00:00 | CL | Stock | 22.33 | 22.405 | 22.26 | 22.29 | 1161400.0 |
| 2004-10-08 11:00:00 | CL | Stock | 22.29 | 22.31 | 22.19 | 22.2 | 1276600.0 |
| 2004-10-08 12:00:00 | CL | Stock | 22.2 | 22.225 | 22.19 | 22.22 | 937200.0 |
| 2004-10-08 13:00:00 | CL | Stock | 22.22 | 22.22 | 22.055 | 22.095 | 1218000.0 |
| 2004-10-08 14:00:00 | CL | Stock | 22.1 | 22.11 | 22.0 | 22.015 | 1568400.0 |
| 2004-10-08 15:00:00 | CL | Stock | 22.02 | 22.11 | 22.0 | 22.075 | 2781600.0 |
| 2004-10-08 16:00:00 | CL | Stock | 22.075 | 22.075 | 22.07 | 22.075 | 29000.0 |
> showing 49 of 24,605 rows — these rows as CSV