PREVIEW / stock_1hour / 2004-11-29
file: by_date/stock_1hour/2004/2004-11-29.parquet size: 535 KB rows: 25,462 symbols: 1,883
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-11-29 08:00:00 | AAPL | Stock | 1.2248 | 1.2293 | 1.2134 | 1.2175 | 33276992.0 |
| 2004-11-29 09:00:00 | AAPL | Stock | 1.218 | 1.2423 | 1.1786 | 1.2241 | 482273064.0 |
| 2004-11-29 10:00:00 | AAPL | Stock | 1.2239 | 1.2298 | 1.2161 | 1.2209 | 283901184.0 |
| 2004-11-29 11:00:00 | AAPL | Stock | 1.2207 | 1.2216 | 1.2038 | 1.2071 | 242416048.0 |
| 2004-11-29 12:00:00 | AAPL | Stock | 1.2071 | 1.2196 | 1.205 | 1.2175 | 121715104.0 |
| 2004-11-29 13:00:00 | AAPL | Stock | 1.2177 | 1.2275 | 1.2168 | 1.225 | 142789976.0 |
| 2004-11-29 14:00:00 | AAPL | Stock | 1.2248 | 1.2275 | 1.2191 | 1.2238 | 139954808.0 |
| 2004-11-29 15:00:00 | AAPL | Stock | 1.2234 | 1.2295 | 1.2216 | 1.2223 | 211817088.0 |
| 2004-11-29 16:00:00 | AAPL | Stock | 1.2223 | 1.2248 | 1.2216 | 1.2248 | 10863832.0 |
| 2004-11-29 17:00:00 | AAPL | Stock | 1.2254 | 1.2284 | 1.2221 | 1.2275 | 2932496.0 |
| 2004-11-29 18:00:00 | AAPL | Stock | 1.2275 | 1.2298 | 1.2275 | 1.2286 | 1154888.0 |
| 2004-11-29 08:00:00 | MSFT | Stock | 26.7 | 26.78 | 26.7 | 26.75 | 45708.0 |
| 2004-11-29 09:00:00 | MSFT | Stock | 26.73 | 26.82 | 26.61 | 26.8 | 7778862.0 |
| 2004-11-29 10:00:00 | MSFT | Stock | 26.8 | 26.95 | 26.74 | 26.87 | 12843661.0 |
| 2004-11-29 11:00:00 | MSFT | Stock | 26.87 | 26.9 | 26.75 | 26.79 | 8826593.0 |
| 2004-11-29 12:00:00 | MSFT | Stock | 26.79 | 26.82 | 26.759 | 26.76 | 4316888.0 |
| 2004-11-29 13:00:00 | MSFT | Stock | 26.76 | 26.851 | 26.76 | 26.81 | 4987236.0 |
| 2004-11-29 14:00:00 | MSFT | Stock | 26.81 | 26.91 | 26.77 | 26.83 | 9566787.0 |
| 2004-11-29 15:00:00 | MSFT | Stock | 26.82 | 26.94 | 26.75 | 26.77 | 12635241.0 |
| 2004-11-29 16:00:00 | MSFT | Stock | 26.77 | 26.78 | 26.73 | 26.74 | 1540495.0 |
| 2004-11-29 17:00:00 | MSFT | Stock | 26.75 | 26.77 | 26.74 | 26.75 | 96647.0 |
| 2004-11-29 18:00:00 | MSFT | Stock | 26.75 | 26.75 | 26.75 | 26.75 | 797.0 |
| 2004-11-29 08:00:00 | NVDA | Stock | 0.1667 | 0.1679 | 0.1667 | 0.1672 | 2373000.0 |
| 2004-11-29 09:00:00 | NVDA | Stock | 0.1671 | 0.1679 | 0.1655 | 0.166 | 71951520.0 |
| 2004-11-29 10:00:00 | NVDA | Stock | 0.166 | 0.1663 | 0.1635 | 0.1636 | 131712240.0 |
| 2004-11-29 11:00:00 | NVDA | Stock | 0.1637 | 0.1637 | 0.1617 | 0.1625 | 114610440.0 |
| 2004-11-29 12:00:00 | NVDA | Stock | 0.1625 | 0.1627 | 0.1611 | 0.1611 | 50703240.0 |
| 2004-11-29 13:00:00 | NVDA | Stock | 0.1612 | 0.1627 | 0.1611 | 0.1625 | 85992000.0 |
| 2004-11-29 14:00:00 | NVDA | Stock | 0.1625 | 0.1632 | 0.1619 | 0.1627 | 106239600.0 |
| 2004-11-29 15:00:00 | NVDA | Stock | 0.1627 | 0.1635 | 0.1616 | 0.1622 | 118355520.0 |
| 2004-11-29 16:00:00 | NVDA | Stock | 0.1622 | 0.1625 | 0.1618 | 0.1622 | 4272360.0 |
| 2004-11-29 17:00:00 | NVDA | Stock | 0.1622 | 0.1627 | 0.1618 | 0.162 | 5068920.0 |
| 2004-11-29 18:00:00 | NVDA | Stock | 0.162 | 0.162 | 0.1604 | 0.1604 | 1022400.0 |
| 2004-11-29 08:00:00 | AMZN | Stock | 1.9545 | 1.988 | 1.9545 | 1.9855 | 514800.0 |
| 2004-11-29 09:00:00 | AMZN | Stock | 1.981 | 1.9825 | 1.909 | 1.9165 | 37707060.0 |
| 2004-11-29 10:00:00 | AMZN | Stock | 1.916 | 1.92 | 1.8855 | 1.916 | 48912820.0 |
| 2004-11-29 11:00:00 | AMZN | Stock | 1.9155 | 1.925 | 1.9 | 1.9125 | 23790500.0 |
| 2004-11-29 12:00:00 | AMZN | Stock | 1.912 | 1.918 | 1.905 | 1.906 | 12629740.0 |
| 2004-11-29 13:00:00 | AMZN | Stock | 1.906 | 1.928 | 1.905 | 1.9225 | 14633160.0 |
| 2004-11-29 14:00:00 | AMZN | Stock | 1.9225 | 1.937 | 1.9165 | 1.928 | 16672580.0 |
| 2004-11-29 15:00:00 | AMZN | Stock | 1.928 | 1.95 | 1.9235 | 1.947 | 34733660.0 |
| 2004-11-29 16:00:00 | AMZN | Stock | 1.9465 | 1.952 | 1.945 | 1.947 | 1389320.0 |
| 2004-11-29 17:00:00 | AMZN | Stock | 1.947 | 1.947 | 1.946 | 1.947 | 489240.0 |
| 2004-11-29 18:00:00 | AMZN | Stock | 1.948 | 1.95 | 1.948 | 1.95 | 90000.0 |
| 2004-11-29 09:00:00 | CL | Stock | 23.0 | 23.08 | 23.0 | 23.035 | 557600.0 |
| 2004-11-29 10:00:00 | CL | Stock | 23.04 | 23.05 | 23.0 | 23.005 | 638400.0 |
| 2004-11-29 11:00:00 | CL | Stock | 23.0 | 23.045 | 22.95 | 23.035 | 644200.0 |
| 2004-11-29 12:00:00 | CL | Stock | 23.03 | 23.055 | 23.015 | 23.045 | 347400.0 |
| 2004-11-29 13:00:00 | CL | Stock | 23.045 | 23.1 | 23.035 | 23.08 | 398400.0 |
| 2004-11-29 14:00:00 | CL | Stock | 23.08 | 23.205 | 23.055 | 23.175 | 457200.0 |
> showing 50 of 25,462 rows — these rows as CSV