PREVIEW / stock_1hour / 2002-11-26
file: by_date/stock_1hour/2002/2002-11-26.parquet size: 436 KB rows: 20,870 symbols: 1,517
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-11-26 08:00:00 | AAPL | Stock | 0.2846 | 0.2846 | 0.2839 | 0.2839 | 186200.0 |
| 2002-11-26 09:00:00 | AAPL | Stock | 0.2846 | 0.2846 | 0.2811 | 0.2827 | 13362608.0 |
| 2002-11-26 10:00:00 | AAPL | Stock | 0.2827 | 0.2827 | 0.275 | 0.2768 | 45173016.0 |
| 2002-11-26 11:00:00 | AAPL | Stock | 0.2769 | 0.2789 | 0.2763 | 0.2777 | 16727816.0 |
| 2002-11-26 12:00:00 | AAPL | Stock | 0.2775 | 0.2798 | 0.2771 | 0.2786 | 21368144.0 |
| 2002-11-26 13:00:00 | AAPL | Stock | 0.2791 | 0.2793 | 0.2761 | 0.277 | 19370456.0 |
| 2002-11-26 14:00:00 | AAPL | Stock | 0.2768 | 0.2777 | 0.2757 | 0.2775 | 22445248.0 |
| 2002-11-26 15:00:00 | AAPL | Stock | 0.2773 | 0.2779 | 0.2727 | 0.2755 | 40342624.0 |
| 2002-11-26 16:00:00 | AAPL | Stock | 0.2755 | 0.2775 | 0.2745 | 0.2754 | 10348800.0 |
| 2002-11-26 17:00:00 | AAPL | Stock | 0.2755 | 0.2755 | 0.2732 | 0.2752 | 629104.0 |
| 2002-11-26 08:00:00 | MSFT | Stock | 29.095 | 29.125 | 28.9055 | 28.925 | 105580.0 |
| 2002-11-26 09:00:00 | MSFT | Stock | 28.925 | 29.125 | 28.76 | 29.125 | 8701930.0 |
| 2002-11-26 10:00:00 | MSFT | Stock | 29.125 | 29.125 | 28.805 | 28.835 | 13245942.0 |
| 2002-11-26 11:00:00 | MSFT | Stock | 28.8425 | 28.935 | 28.75 | 28.925 | 6038870.0 |
| 2002-11-26 12:00:00 | MSFT | Stock | 28.9295 | 28.973 | 28.77 | 28.825 | 3849264.0 |
| 2002-11-26 13:00:00 | MSFT | Stock | 28.82 | 28.825 | 28.55 | 28.6605 | 6519754.0 |
| 2002-11-26 14:00:00 | MSFT | Stock | 28.66 | 28.665 | 28.51 | 28.6 | 7145244.0 |
| 2002-11-26 15:00:00 | MSFT | Stock | 28.605 | 28.645 | 28.39 | 28.455 | 12127442.0 |
| 2002-11-26 16:00:00 | MSFT | Stock | 28.455 | 28.6 | 28.355 | 28.475 | 2985962.0 |
| 2002-11-26 17:00:00 | MSFT | Stock | 28.475 | 28.515 | 28.445 | 28.5 | 722200.0 |
| 2002-11-26 18:00:00 | MSFT | Stock | 28.5 | 28.505 | 28.455 | 28.455 | 7800.0 |
| 2002-11-26 08:00:00 | NVDA | Stock | 0.1358 | 0.1379 | 0.1358 | 0.1358 | 1842000.0 |
| 2002-11-26 09:00:00 | NVDA | Stock | 0.1354 | 0.1391 | 0.135 | 0.1381 | 175465320.0 |
| 2002-11-26 10:00:00 | NVDA | Stock | 0.1381 | 0.1383 | 0.1333 | 0.1347 | 220214280.0 |
| 2002-11-26 11:00:00 | NVDA | Stock | 0.1346 | 0.1357 | 0.1328 | 0.1353 | 175271280.0 |
| 2002-11-26 12:00:00 | NVDA | Stock | 0.1354 | 0.1366 | 0.1347 | 0.1348 | 97985520.0 |
| 2002-11-26 13:00:00 | NVDA | Stock | 0.1349 | 0.1355 | 0.1337 | 0.1343 | 83826120.0 |
| 2002-11-26 14:00:00 | NVDA | Stock | 0.1343 | 0.1349 | 0.1333 | 0.1343 | 68467080.0 |
| 2002-11-26 15:00:00 | NVDA | Stock | 0.1343 | 0.1352 | 0.1317 | 0.1321 | 157549320.0 |
| 2002-11-26 16:00:00 | NVDA | Stock | 0.1321 | 0.1332 | 0.1317 | 0.133 | 20126040.0 |
| 2002-11-26 17:00:00 | NVDA | Stock | 0.1321 | 0.1334 | 0.1321 | 0.1334 | 2616000.0 |
| 2002-11-26 18:00:00 | NVDA | Stock | 0.1337 | 0.1342 | 0.1334 | 0.1342 | 378000.0 |
| 2002-11-26 08:00:00 | AMZN | Stock | 1.2145 | 1.2145 | 1.195 | 1.2 | 102000.0 |
| 2002-11-26 09:00:00 | AMZN | Stock | 1.204 | 1.213 | 1.1465 | 1.198 | 23792220.0 |
| 2002-11-26 10:00:00 | AMZN | Stock | 1.1975 | 1.199 | 1.18 | 1.187 | 30158440.0 |
| 2002-11-26 11:00:00 | AMZN | Stock | 1.187 | 1.193 | 1.1825 | 1.1855 | 12210920.0 |
| 2002-11-26 12:00:00 | AMZN | Stock | 1.1855 | 1.1915 | 1.1825 | 1.1865 | 9667480.0 |
| 2002-11-26 13:00:00 | AMZN | Stock | 1.1865 | 1.1895 | 1.1735 | 1.1805 | 9864100.0 |
| 2002-11-26 14:00:00 | AMZN | Stock | 1.18 | 1.18 | 1.171 | 1.176 | 11692960.0 |
| 2002-11-26 15:00:00 | AMZN | Stock | 1.176 | 1.1835 | 1.169 | 1.1695 | 18267320.0 |
| 2002-11-26 16:00:00 | AMZN | Stock | 1.17 | 1.171 | 1.167 | 1.171 | 1277440.0 |
| 2002-11-26 17:00:00 | AMZN | Stock | 1.171 | 1.173 | 1.1698 | 1.17 | 472000.0 |
| 2002-11-26 18:00:00 | AMZN | Stock | 1.173 | 1.176 | 1.173 | 1.176 | 32000.0 |
| 2002-11-26 09:00:00 | CL | Stock | 25.5 | 25.55 | 25.35 | 25.475 | 464200.0 |
| 2002-11-26 10:00:00 | CL | Stock | 25.48 | 25.48 | 25.25 | 25.35 | 766200.0 |
| 2002-11-26 11:00:00 | CL | Stock | 25.355 | 25.52 | 25.325 | 25.44 | 500400.0 |
| 2002-11-26 12:00:00 | CL | Stock | 25.435 | 25.48 | 25.345 | 25.475 | 518200.0 |
| 2002-11-26 13:00:00 | CL | Stock | 25.47 | 25.745 | 25.465 | 25.68 | 554800.0 |
| 2002-11-26 14:00:00 | CL | Stock | 25.67 | 25.725 | 25.575 | 25.66 | 423400.0 |
| 2002-11-26 15:00:00 | CL | Stock | 25.655 | 25.655 | 25.54 | 25.57 | 813400.0 |
> showing 50 of 20,870 rows — these rows as CSV