PREVIEW / stock_1hour / 2002-12-03
file: by_date/stock_1hour/2002/2002-12-03.parquet size: 416 KB rows: 19,830 symbols: 1,516
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-03 08:00:00 | AAPL | Stock | 0.2688 | 0.2714 | 0.2688 | 0.2714 | 16800.0 |
| 2002-12-03 09:00:00 | AAPL | Stock | 0.2713 | 0.2739 | 0.2696 | 0.2723 | 23078328.0 |
| 2002-12-03 10:00:00 | AAPL | Stock | 0.272 | 0.2723 | 0.2696 | 0.2714 | 18417784.0 |
| 2002-12-03 11:00:00 | AAPL | Stock | 0.2714 | 0.2714 | 0.2704 | 0.2711 | 13602456.0 |
| 2002-12-03 12:00:00 | AAPL | Stock | 0.2709 | 0.2723 | 0.2698 | 0.2711 | 19183024.0 |
| 2002-12-03 13:00:00 | AAPL | Stock | 0.2711 | 0.2732 | 0.2708 | 0.2723 | 19917296.0 |
| 2002-12-03 14:00:00 | AAPL | Stock | 0.2725 | 0.2732 | 0.2709 | 0.273 | 18528888.0 |
| 2002-12-03 15:00:00 | AAPL | Stock | 0.273 | 0.2734 | 0.2707 | 0.2711 | 56937496.0 |
| 2002-12-03 16:00:00 | AAPL | Stock | 0.2711 | 0.2729 | 0.2705 | 0.2713 | 6706336.0 |
| 2002-12-03 17:00:00 | AAPL | Stock | 0.2707 | 0.2707 | 0.2705 | 0.2707 | 2408000.0 |
| 2002-12-03 18:00:00 | AAPL | Stock | 0.2714 | 0.2714 | 0.2714 | 0.2714 | 5600.0 |
| 2002-12-03 08:00:00 | MSFT | Stock | 28.8 | 28.845 | 28.655 | 28.665 | 50600.0 |
| 2002-12-03 09:00:00 | MSFT | Stock | 28.64 | 28.85 | 28.41 | 28.54 | 7335532.0 |
| 2002-12-03 10:00:00 | MSFT | Stock | 28.4 | 28.46 | 28.21 | 28.34 | 5679458.0 |
| 2002-12-03 11:00:00 | MSFT | Stock | 28.3445 | 28.465 | 28.22 | 28.28 | 6280456.0 |
| 2002-12-03 12:00:00 | MSFT | Stock | 28.275 | 28.425 | 28.21 | 28.3345 | 5120346.0 |
| 2002-12-03 13:00:00 | MSFT | Stock | 28.3255 | 28.57 | 28.315 | 28.445 | 6786604.0 |
| 2002-12-03 14:00:00 | MSFT | Stock | 28.445 | 28.6 | 28.3345 | 28.52 | 6694984.0 |
| 2002-12-03 15:00:00 | MSFT | Stock | 28.52 | 28.67 | 28.305 | 28.345 | 8863460.0 |
| 2002-12-03 16:00:00 | MSFT | Stock | 28.38 | 28.435 | 28.329 | 28.34 | 1372020.0 |
| 2002-12-03 17:00:00 | MSFT | Stock | 28.345 | 28.355 | 28.255 | 28.355 | 639960.0 |
| 2002-12-03 18:00:00 | MSFT | Stock | 28.3 | 28.31 | 28.275 | 28.275 | 6400.0 |
| 2002-12-03 08:00:00 | NVDA | Stock | 0.1437 | 0.145 | 0.1393 | 0.1401 | 5721000.0 |
| 2002-12-03 09:00:00 | NVDA | Stock | 0.1404 | 0.1442 | 0.1354 | 0.1368 | 132405600.0 |
| 2002-12-03 10:00:00 | NVDA | Stock | 0.135 | 0.1356 | 0.1327 | 0.1339 | 167713800.0 |
| 2002-12-03 11:00:00 | NVDA | Stock | 0.1339 | 0.1344 | 0.1329 | 0.1329 | 123264600.0 |
| 2002-12-03 12:00:00 | NVDA | Stock | 0.1329 | 0.1347 | 0.1321 | 0.1334 | 103665720.0 |
| 2002-12-03 13:00:00 | NVDA | Stock | 0.1333 | 0.1352 | 0.133 | 0.1332 | 88604520.0 |
| 2002-12-03 14:00:00 | NVDA | Stock | 0.1333 | 0.1348 | 0.1329 | 0.1337 | 71227200.0 |
| 2002-12-03 15:00:00 | NVDA | Stock | 0.1337 | 0.1345 | 0.1321 | 0.1322 | 135009240.0 |
| 2002-12-03 16:00:00 | NVDA | Stock | 0.1323 | 0.1327 | 0.1314 | 0.1317 | 11959800.0 |
| 2002-12-03 17:00:00 | NVDA | Stock | 0.1317 | 0.1323 | 0.1292 | 0.1312 | 3945960.0 |
| 2002-12-03 18:00:00 | NVDA | Stock | 0.1299 | 0.1312 | 0.1299 | 0.1308 | 264000.0 |
| 2002-12-03 08:00:00 | AMZN | Stock | 1.2075 | 1.2075 | 1.185 | 1.19 | 586000.0 |
| 2002-12-03 09:00:00 | AMZN | Stock | 1.19 | 1.2075 | 1.169 | 1.177 | 13980880.0 |
| 2002-12-03 10:00:00 | AMZN | Stock | 1.1844 | 1.1908 | 1.178 | 1.1875 | 10871880.0 |
| 2002-12-03 11:00:00 | AMZN | Stock | 1.188 | 1.1895 | 1.1765 | 1.1785 | 12292200.0 |
| 2002-12-03 12:00:00 | AMZN | Stock | 1.1785 | 1.1835 | 1.175 | 1.179 | 9705880.0 |
| 2002-12-03 13:00:00 | AMZN | Stock | 1.179 | 1.199 | 1.1785 | 1.1895 | 13061820.0 |
| 2002-12-03 14:00:00 | AMZN | Stock | 1.189 | 1.1985 | 1.188 | 1.19 | 11555240.0 |
| 2002-12-03 15:00:00 | AMZN | Stock | 1.19 | 1.1935 | 1.1795 | 1.187 | 18857960.0 |
| 2002-12-03 16:00:00 | AMZN | Stock | 1.1875 | 1.192 | 1.18 | 1.1865 | 2876200.0 |
| 2002-12-03 17:00:00 | AMZN | Stock | 1.185 | 1.187 | 1.1805 | 1.187 | 940000.0 |
| 2002-12-03 18:00:00 | AMZN | Stock | 1.1815 | 1.1815 | 1.1815 | 1.1815 | 2000.0 |
| 2002-12-03 09:00:00 | CL | Stock | 25.825 | 26.105 | 25.805 | 26.08 | 397600.0 |
| 2002-12-03 10:00:00 | CL | Stock | 26.07 | 26.095 | 26.0 | 26.02 | 388400.0 |
| 2002-12-03 11:00:00 | CL | Stock | 26.02 | 26.075 | 25.825 | 25.885 | 233200.0 |
| 2002-12-03 12:00:00 | CL | Stock | 25.88 | 25.97 | 25.84 | 25.925 | 242600.0 |
| 2002-12-03 13:00:00 | CL | Stock | 25.925 | 25.98 | 25.85 | 25.865 | 311600.0 |
| 2002-12-03 14:00:00 | CL | Stock | 25.865 | 25.97 | 25.845 | 25.87 | 566600.0 |
> showing 50 of 19,830 rows — these rows as CSV