PREVIEW / stock_1hour / 2002-11-21
file: by_date/stock_1hour/2002/2002-11-21.parquet size: 426 KB rows: 19,918 symbols: 1,511
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-21 08:00:00 | AAPL | Stock | 0.2773 | 0.282 | 0.2768 | 0.282 | 3572800.0 |
| 2002-11-21 09:00:00 | AAPL | Stock | 0.2821 | 0.2851 | 0.2813 | 0.2846 | 46676728.0 |
| 2002-11-21 10:00:00 | AAPL | Stock | 0.2846 | 0.2927 | 0.2829 | 0.2916 | 64428840.0 |
| 2002-11-21 11:00:00 | AAPL | Stock | 0.2914 | 0.2936 | 0.2884 | 0.2895 | 39072040.0 |
| 2002-11-21 12:00:00 | AAPL | Stock | 0.2891 | 0.2909 | 0.2886 | 0.2893 | 61716592.0 |
| 2002-11-21 13:00:00 | AAPL | Stock | 0.2893 | 0.292 | 0.2884 | 0.2895 | 37414272.0 |
| 2002-11-21 14:00:00 | AAPL | Stock | 0.2896 | 0.292 | 0.2882 | 0.2913 | 46418848.0 |
| 2002-11-21 15:00:00 | AAPL | Stock | 0.2913 | 0.2921 | 0.2875 | 0.2921 | 52007536.0 |
| 2002-11-21 16:00:00 | AAPL | Stock | 0.2918 | 0.2934 | 0.2882 | 0.292 | 8814400.0 |
| 2002-11-21 17:00:00 | AAPL | Stock | 0.292 | 0.292 | 0.2902 | 0.2902 | 1366400.0 |
| 2002-11-21 18:00:00 | AAPL | Stock | 0.2875 | 0.2875 | 0.2875 | 0.2875 | 5600.0 |
| 2002-11-21 08:00:00 | MSFT | Stock | 28.57 | 28.575 | 28.315 | 28.565 | 210768.0 |
| 2002-11-21 09:00:00 | MSFT | Stock | 28.6 | 28.72 | 28.4 | 28.6205 | 12881540.0 |
| 2002-11-21 10:00:00 | MSFT | Stock | 28.625 | 28.8 | 28.39 | 28.7355 | 17541228.0 |
| 2002-11-21 11:00:00 | MSFT | Stock | 28.735 | 28.88 | 28.67 | 28.735 | 11626416.0 |
| 2002-11-21 12:00:00 | MSFT | Stock | 28.7295 | 28.855 | 28.675 | 28.765 | 9657250.0 |
| 2002-11-21 13:00:00 | MSFT | Stock | 28.765 | 28.87 | 28.725 | 28.79 | 6258328.0 |
| 2002-11-21 14:00:00 | MSFT | Stock | 28.79 | 28.942 | 28.725 | 28.925 | 7477562.0 |
| 2002-11-21 15:00:00 | MSFT | Stock | 28.925 | 28.935 | 28.685 | 28.915 | 12442256.0 |
| 2002-11-21 16:00:00 | MSFT | Stock | 28.92 | 28.935 | 28.805 | 28.84 | 1471130.0 |
| 2002-11-21 17:00:00 | MSFT | Stock | 28.825 | 28.92 | 28.725 | 28.8 | 233800.0 |
| 2002-11-21 18:00:00 | MSFT | Stock | 28.775 | 28.8 | 28.75 | 28.79 | 9400.0 |
| 2002-11-21 08:00:00 | NVDA | Stock | 0.1272 | 0.1292 | 0.1241 | 0.128 | 83686800.0 |
| 2002-11-21 09:00:00 | NVDA | Stock | 0.1286 | 0.1321 | 0.1285 | 0.1308 | 239531880.0 |
| 2002-11-21 10:00:00 | NVDA | Stock | 0.131 | 0.1374 | 0.1308 | 0.1364 | 346032720.0 |
| 2002-11-21 11:00:00 | NVDA | Stock | 0.1364 | 0.1407 | 0.1346 | 0.1361 | 347714520.0 |
| 2002-11-21 12:00:00 | NVDA | Stock | 0.1361 | 0.1379 | 0.1351 | 0.137 | 225464400.0 |
| 2002-11-21 13:00:00 | NVDA | Stock | 0.137 | 0.1379 | 0.1354 | 0.1355 | 122240040.0 |
| 2002-11-21 14:00:00 | NVDA | Stock | 0.1355 | 0.1358 | 0.1321 | 0.1354 | 253931880.0 |
| 2002-11-21 15:00:00 | NVDA | Stock | 0.1353 | 0.1355 | 0.1328 | 0.1347 | 271511160.0 |
| 2002-11-21 16:00:00 | NVDA | Stock | 0.1344 | 0.135 | 0.1332 | 0.1336 | 19756320.0 |
| 2002-11-21 17:00:00 | NVDA | Stock | 0.1334 | 0.1345 | 0.1312 | 0.1317 | 5270400.0 |
| 2002-11-21 18:00:00 | NVDA | Stock | 0.1317 | 0.1327 | 0.1313 | 0.1327 | 1141200.0 |
| 2002-11-21 08:00:00 | AMZN | Stock | 1.1675 | 1.18 | 1.1525 | 1.17 | 2094600.0 |
| 2002-11-21 09:00:00 | AMZN | Stock | 1.17 | 1.1925 | 1.1605 | 1.185 | 44105040.0 |
| 2002-11-21 10:00:00 | AMZN | Stock | 1.1855 | 1.187 | 1.177 | 1.18 | 39821900.0 |
| 2002-11-21 11:00:00 | AMZN | Stock | 1.1808 | 1.1842 | 1.175 | 1.178 | 23026940.0 |
| 2002-11-21 12:00:00 | AMZN | Stock | 1.1775 | 1.1805 | 1.171 | 1.1724 | 17029680.0 |
| 2002-11-21 13:00:00 | AMZN | Stock | 1.1725 | 1.1765 | 1.165 | 1.176 | 20454660.0 |
| 2002-11-21 14:00:00 | AMZN | Stock | 1.176 | 1.181 | 1.17 | 1.178 | 20391620.0 |
| 2002-11-21 15:00:00 | AMZN | Stock | 1.1775 | 1.178 | 1.1645 | 1.1695 | 31628240.0 |
| 2002-11-21 16:00:00 | AMZN | Stock | 1.17 | 1.1735 | 1.1675 | 1.17 | 1163800.0 |
| 2002-11-21 17:00:00 | AMZN | Stock | 1.1675 | 1.17 | 1.165 | 1.1655 | 1532000.0 |
| 2002-11-21 18:00:00 | AMZN | Stock | 1.1655 | 1.1655 | 1.1635 | 1.1645 | 14000.0 |
| 2002-11-21 09:00:00 | CL | Stock | 26.57 | 26.57 | 26.18 | 26.23 | 475000.0 |
| 2002-11-21 10:00:00 | CL | Stock | 26.235 | 26.29 | 25.8 | 25.96 | 996800.0 |
| 2002-11-21 11:00:00 | CL | Stock | 25.955 | 25.96 | 25.73 | 25.89 | 1450800.0 |
| 2002-11-21 12:00:00 | CL | Stock | 25.9 | 25.975 | 25.675 | 25.675 | 546000.0 |
| 2002-11-21 13:00:00 | CL | Stock | 25.675 | 25.75 | 25.55 | 25.62 | 817000.0 |
| 2002-11-21 14:00:00 | CL | Stock | 25.62 | 25.67 | 25.495 | 25.555 | 845200.0 |
> showing 50 of 19,918 rows — these rows as CSV