PREVIEW / stock_daily / 2005-01-06
file: by_date/stock_daily/2005/2005-01-06.parquet size: 133 KB rows: 3,956 symbols: 2,473
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2005-01-06 | AAPL | Stock | 1.1548 | 1.1591 | 1.1309 | 1.1527 | 705555200.0 |
| 2005-01-06 | MSFT | Stock | 26.85 | 27.06 | 26.64 | 26.75 | 76890500.0 |
| 2005-01-06 | NVDA | Stock | 0.1923 | 0.1946 | 0.1858 | 0.1872 | 563568000.0 |
| 2005-01-06 | AMZN | Stock | 2.0905 | 2.1125 | 2.045 | 2.0525 | 174018000.0 |
| 2005-01-06 | CL | Stock | 24.75 | 25.255 | 24.625 | 24.865 | 5987200.0 |
| 2005-01-06 | A | Stock | 16.7382 | 16.7668 | 16.2303 | 16.2589 | 3158641.0 |
| 2005-01-06 | AABA-DELISTED | Stock | 36.3199996948242 | 36.5 | 35.2099990844727 | 35.4300003051758 | 20835300.0 |
| 2005-01-06 | AACC-DELISTED | Stock | 21.55 | 21.6 | 21.19 | 21.39 | 32842.0 |
| 2005-01-06 | AAI-DELISTED | Stock | 9.57 | 9.69 | 9.4 | 9.58 | 1535200.0 |
| 2005-01-06 | AAIC-DELISTED | Stock | 366.8 | 375.4 | 366.4 | 373.0 | 1056400.0 |
| 2005-01-06 | AAME | Stock | 3.04 | 3.2 | 3.02 | 3.02 | 7200.0 |
| 2005-01-06 | AAON | Stock | 1.9174 | 2.0069 | 1.9174 | 1.9266 | 150356.0 |
| 2005-01-06 | AAP | Stock | 29.1333 | 29.1333 | 28.8333 | 28.8667 | 902550.0 |
| 2005-01-06 | AAV-DELISTED | Stock | 17.41 | 17.45 | 17.19 | 17.41 | 38700.0 |
| 2005-01-06 | AAXN-DELISTED | Stock | 28.4200000762939 | 28.7000007629395 | 27.5200004577637 | 27.6200008392334 | 7569700.0 |
| 2005-01-06 | ABAX-DELISTED | Stock | 13.46 | 13.46 | 12.99 | 13.06 | 128406.0 |
| 2005-01-06 | ABB-DELISTED | Stock | 5.71 | 5.73 | 5.64 | 5.7 | 153700.0 |
| 2005-01-06 | ABBC-DELISTED | Stock | 13.1 | 13.16 | 13.0 | 13.01 | 111144.0 |
| 2005-01-06 | ABC-DELISTED | Stock | 14.5 | 14.59 | 14.4 | 14.49 | 3440800.0 |
| 2005-01-06 | ABCB | Stock | 16.1053 | 16.1539 | 15.8297 | 16.1539 | 15792.0 |
| 2005-01-06 | ABCO-DELISTED | Stock | 18.472 | 18.497 | 18.248 | 18.378 | 200384.0 |
| 2005-01-06 | ABCW-DELISTED | Stock | 27.82 | 28.56 | 27.82 | 28.11 | 60550.0 |
| 2005-01-06 | ABE-DELISTED | Stock | 9.54 | 9.69 | 9.54 | 9.61 | 11700.0 |
| 2005-01-06 | ABFS-DELISTED | Stock | 42.89 | 43.83 | 42.39 | 43.04 | 151879.0 |
| 2005-01-06 | ABG | Stock | 14.15 | 14.31 | 14.06 | 14.18 | 78100.0 |
| 2005-01-06 | ABK-DELISTED | Stock | 81.9 | 82.5 | 81.87 | 82.1 | 343000.0 |
| 2005-01-06 | ABM | Stock | 18.42 | 19.07 | 18.31 | 18.82 | 149200.0 |
| 2005-01-06 | ABMD-DELISTED | Stock | 14.49 | 14.79 | 14.266 | 14.43 | 192105.0 |
| 2005-01-06 | ABP-DELISTED | Stock | 2.3 | 2.34 | 2.3 | 2.31 | 72800.0 |
| 2005-01-06 | ABR | Stock | 23.85 | 23.98 | 23.75 | 23.79 | 26500.0 |
| 2005-01-06 | ABT | Stock | 22.018 | 22.5026 | 22.0132 | 22.4067 | 11950188.0 |
| 2005-01-06 | ABTL-DELISTED | Stock | 29.0 | 29.25 | 28.0 | 28.0 | 127000.0 |
| 2005-01-06 | ABV-DELISTED | Stock | 27.77 | 27.77 | 27.16 | 27.19 | 434300.0 |
| 2005-01-06 | ABVA-DELISTED | Stock | 15.5 | 15.83 | 15.5 | 15.73 | 7450.0 |
| 2005-01-06 | ABX-DELISTED | Stock | 22.45 | 22.63 | 21.72 | 21.89 | 2947100.0 |
| 2005-01-06 | ACAD | Stock | 6.35 | 6.39 | 6.16 | 6.34 | 7700.0 |
| 2005-01-06 | ACAP-DELISTED | Stock | 35.12 | 35.46 | 34.53 | 34.9 | 38661.0 |
| 2005-01-06 | ACAS-DELISTED | Stock | 32.5 | 33.4 | 32.5 | 33.22 | 796798.0 |
| 2005-01-06 | ACAT-DELISTED | Stock | 25.27 | 25.34 | 24.43 | 24.43 | 63327.0 |
| 2005-01-06 | ACC-DELISTED | Stock | 21.21 | 21.21 | 20.75 | 21.04 | 63000.0 |
| 2005-01-06 | ACCL-DELISTED | Stock | 6.52 | 6.59 | 6.26 | 6.28 | 200871.0 |
| 2005-01-06 | ACE-DELISTED | Stock | 42.18 | 43.11 | 41.38 | 42.65 | 2594000.0 |
| 2005-01-06 | ACF-DELISTED | Stock | 23.69 | 24.0 | 23.59 | 23.72 | 947300.0 |
| 2005-01-06 | ACFC-DELISTED | Stock | 68.62 | 69.08 | 66.58 | 66.58 | 12428.0 |
| 2005-01-06 | ACG-DELISTED | Stock | 8.18 | 8.19 | 8.16 | 8.19 | 288600.0 |
| 2005-01-06 | ACGL | Stock | 4.1489 | 4.1833 | 4.1389 | 4.1478 | 2870100.0 |
| 2005-01-06 | ACGN-DELISTED | Stock | 544.0 | 566.6712 | 510.0 | 521.3288 | 525900.0 |
| 2005-01-06 | ACH | Stock | 18.34 | 18.64 | 18.34 | 18.3667 | 261150.0 |
| 2005-01-06 | ACH-DELISTED | Stock | 13.275 | 13.325 | 13.162 | 13.237 | 300919.0 |
| 2005-01-06 | ACLS | Stock | 28.28 | 28.84 | 27.36 | 27.76 | 165475.0 |
> showing 50 of 3,956 rows — these rows as CSV