PREVIEW / stock_daily / 2006-07-03
file: by_date/stock_daily/2006/2006-07-03.parquet size: 143 KB rows: 4,311 symbols: 2,694
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 |
|---|---|---|---|---|---|---|---|
| 2006-07-03 | AAPL | Stock | 2.0543 | 2.0779 | 2.0479 | 2.0696 | 194770800.0 |
| 2006-07-03 | MSFT | Stock | 23.53 | 23.72 | 23.45 | 23.7 | 25711400.0 |
| 2006-07-03 | NVDA | Stock | 0.363 | 0.3633 | 0.3575 | 0.36 | 174696000.0 |
| 2006-07-03 | AMZN | Stock | 1.926 | 1.931 | 1.9115 | 1.9305 | 28726000.0 |
| 2006-07-03 | CL | Stock | 29.635 | 29.985 | 29.635 | 29.94 | 1909000.0 |
| 2006-07-03 | A | Stock | 22.7039 | 22.8898 | 22.5179 | 22.7897 | 1393387.0 |
| 2006-07-03 | AABA-DELISTED | Stock | 32.9000015258789 | 33.439998626709 | 32.9000015258789 | 33.2999992370605 | 8067100.0 |
| 2006-07-03 | AACC-DELISTED | Stock | 19.68 | 19.99 | 19.59 | 19.98 | 32264.0 |
| 2006-07-03 | AAI-DELISTED | Stock | 14.85 | 15.1 | 14.68 | 14.95 | 547200.0 |
| 2006-07-03 | AAIC-DELISTED | Stock | 221.2 | 227.8 | 220.2 | 227.8 | 1311500.0 |
| 2006-07-03 | AAME | Stock | 3.05 | 3.05 | 3.05 | 3.05 | 400.0 |
| 2006-07-03 | AAON | Stock | 3.4226 | 3.5253 | 3.3857 | 3.4831 | 117703.0 |
| 2006-07-03 | AAP | Stock | 29.15 | 29.51 | 28.97 | 29.47 | 2213800.0 |
| 2006-07-03 | AATI-DELISTED | Stock | 10.29 | 10.48 | 10.28 | 10.34 | 61276.0 |
| 2006-07-03 | AAU-DELISTED | Stock | 2.2 | 2.39 | 2.2 | 2.35 | 30200.0 |
| 2006-07-03 | AAUAF-DELISTED | Stock | 2.2 | 2.39 | 2.2 | 2.35 | 30200.0 |
| 2006-07-03 | AAV-DELISTED | Stock | 17.7 | 17.85 | 17.46 | 17.69 | 186500.0 |
| 2006-07-03 | AAWW-DELISTED | Stock | 48.98 | 50.0 | 48.98 | 49.95 | 78761.0 |
| 2006-07-03 | AAXN-DELISTED | Stock | 7.90999984741211 | 8.32999992370605 | 7.90999984741211 | 8.32999992370605 | 741900.0 |
| 2006-07-03 | AB | Stock | 61.07 | 61.42 | 60.95 | 61.2 | 60300.0 |
| 2006-07-03 | ABAX-DELISTED | Stock | 22.5 | 22.99 | 22.5 | 22.65 | 108600.0 |
| 2006-07-03 | ABB-DELISTED | Stock | 12.96 | 13.06 | 12.95 | 13.03 | 1064100.0 |
| 2006-07-03 | ABBC-DELISTED | Stock | 14.93 | 15.12 | 14.62 | 14.77 | 7355.0 |
| 2006-07-03 | ABC-DELISTED | Stock | 20.97 | 20.98 | 20.74 | 20.88 | 1824000.0 |
| 2006-07-03 | ABCB | Stock | 21.9039 | 22.3708 | 21.9039 | 22.1762 | 15011.0 |
| 2006-07-03 | ABCO-DELISTED | Stock | 24.24 | 24.24 | 23.56 | 23.91 | 91374.0 |
| 2006-07-03 | ABCW-DELISTED | Stock | 29.84 | 30.44 | 29.73 | 30.19 | 53810.0 |
| 2006-07-03 | ABD-DELISTED | Stock | 21.92 | 22.31 | 21.77 | 22.23 | 289750.0 |
| 2006-07-03 | ABE-DELISTED | Stock | 11.91 | 12.3824 | 11.91 | 12.27 | 19200.0 |
| 2006-07-03 | ABFS-DELISTED | Stock | 50.21 | 50.67 | 50.0 | 50.56 | 223726.0 |
| 2006-07-03 | ABG | Stock | 20.94 | 20.94 | 20.41 | 20.5 | 100800.0 |
| 2006-07-03 | ABK-DELISTED | Stock | 81.5 | 82.32 | 81.1 | 82.16 | 346100.0 |
| 2006-07-03 | ABM | Stock | 17.1 | 17.27 | 16.87 | 17.19 | 82100.0 |
| 2006-07-03 | ABMD-DELISTED | Stock | 13.12 | 13.12 | 12.65 | 12.8 | 39560.0 |
| 2006-07-03 | ABP-DELISTED | Stock | 4.28 | 4.6 | 4.27 | 4.56 | 147400.0 |
| 2006-07-03 | ABR | Stock | 25.04 | 25.14 | 24.8 | 25.14 | 39300.0 |
| 2006-07-03 | ABT | Stock | 20.9625 | 20.9865 | 20.8425 | 20.9097 | 4451855.0 |
| 2006-07-03 | ABTL-DELISTED | Stock | 16.095 | 16.739 | 14.807 | 15.55 | 45829.0 |
| 2006-07-03 | ABV-DELISTED | Stock | 42.0 | 44.1 | 41.87 | 43.6 | 565700.0 |
| 2006-07-03 | ABVA-DELISTED | Stock | 16.483 | 16.483 | 16.483 | 16.483 | 150.0 |
| 2006-07-03 | ABX-DELISTED | Stock | 30.2 | 30.56 | 29.91 | 30.5 | 1851648.0 |
| 2006-07-03 | ACAD | Stock | 8.46 | 8.76 | 8.43 | 8.6 | 47800.0 |
| 2006-07-03 | ACAP-DELISTED | Stock | 51.96 | 51.96 | 50.79 | 50.79 | 29862.0 |
| 2006-07-03 | ACAS-DELISTED | Stock | 33.65 | 33.86 | 33.35 | 33.86 | 417038.0 |
| 2006-07-03 | ACAT-DELISTED | Stock | 19.4 | 19.4 | 19.01 | 19.06 | 61618.0 |
| 2006-07-03 | ACC-DELISTED | Stock | 25.05 | 25.32 | 24.9 | 25.25 | 27800.0 |
| 2006-07-03 | ACCL-DELISTED | Stock | 7.13 | 7.13 | 6.91 | 6.95 | 18904.0 |
| 2006-07-03 | ACCO | Stock | 21.9 | 22.29 | 21.75 | 22.25 | 299600.0 |
| 2006-07-03 | ACE-DELISTED | Stock | 50.72 | 50.89 | 50.29 | 50.61 | 399900.0 |
| 2006-07-03 | ACF-DELISTED | Stock | 28.08 | 28.08 | 27.6 | 27.97 | 300600.0 |
> showing 50 of 4,311 rows — these rows as CSV