PREVIEW / stock_daily / 2006-02-02
file: by_date/stock_daily/2006/2006-02-02.parquet size: 146 KB rows: 4,345 symbols: 2,747
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-02-02 | AAPL | Stock | 2.6821 | 2.6914 | 2.5732 | 2.575 | 707322000.0 |
| 2006-02-02 | MSFT | Stock | 27.97 | 27.99 | 27.55 | 27.68 | 55073400.0 |
| 2006-02-02 | NVDA | Stock | 0.3783 | 0.3786 | 0.3629 | 0.3635 | 473736000.0 |
| 2006-02-02 | AMZN | Stock | 2.192 | 2.202 | 1.99 | 2.137 | 474186000.0 |
| 2006-02-02 | CL | Stock | 27.65 | 27.65 | 27.39 | 27.42 | 4866200.0 |
| 2006-02-02 | A | Stock | 24.6781 | 24.8927 | 24.3205 | 24.5136 | 2170675.0 |
| 2006-02-02 | AABA-DELISTED | Stock | 35.0099983215332 | 35.0999984741211 | 34.0999984741211 | 34.25 | 18323500.0 |
| 2006-02-02 | AACC-DELISTED | Stock | 20.29 | 20.49 | 17.51 | 18.28 | 2104050.0 |
| 2006-02-02 | AACQ-DELISTED | Stock | 5.34 | 5.36 | 5.34 | 5.36 | 5500.0 |
| 2006-02-02 | AACQW-DELISTED | Stock | 0.68 | 0.68 | 0.68 | 0.68 | 2500.0 |
| 2006-02-02 | AAI-DELISTED | Stock | 17.1 | 17.19 | 16.52 | 16.97 | 2246800.0 |
| 2006-02-02 | AAIC-DELISTED | Stock | 235.4 | 237.6 | 230.6 | 234.0 | 729800.0 |
| 2006-02-02 | AAME | Stock | 2.6 | 2.76 | 2.6 | 2.76 | 6100.0 |
| 2006-02-02 | AAON | Stock | 2.5547 | 2.5758 | 2.5218 | 2.5653 | 72141.0 |
| 2006-02-02 | AAP | Stock | 43.2 | 43.4 | 42.28 | 42.36 | 630200.0 |
| 2006-02-02 | AATI-DELISTED | Stock | 15.25 | 15.75 | 14.75 | 15.1 | 292203.0 |
| 2006-02-02 | AAU-DELISTED | Stock | 3.01 | 3.08 | 2.9 | 2.95 | 123300.0 |
| 2006-02-02 | AAUAF-DELISTED | Stock | 3.01 | 3.08 | 2.9 | 2.95 | 123300.0 |
| 2006-02-02 | AAV-DELISTED | Stock | 21.08 | 21.08 | 20.52 | 20.63 | 442500.0 |
| 2006-02-02 | AAWW-DELISTED | Stock | 48.0 | 48.75 | 48.0 | 48.25 | 67500.0 |
| 2006-02-02 | AAXN-DELISTED | Stock | 9.68000030517578 | 9.73999977111816 | 9.11999988555908 | 9.22000026702881 | 1620200.0 |
| 2006-02-02 | ABAX-DELISTED | Stock | 19.9 | 19.972 | 19.16 | 19.75 | 195551.0 |
| 2006-02-02 | ABB-DELISTED | Stock | 11.0 | 11.0199 | 10.84 | 10.86 | 1156600.0 |
| 2006-02-02 | ABBC-DELISTED | Stock | 13.4 | 13.5 | 13.4 | 13.45 | 2000.0 |
| 2006-02-02 | ABC-DELISTED | Stock | 21.99 | 21.99 | 21.73 | 21.88 | 3123000.0 |
| 2006-02-02 | ABCB | Stock | 19.8322 | 20.0656 | 19.4723 | 19.6765 | 11926.0 |
| 2006-02-02 | ABCO-DELISTED | Stock | 25.46 | 25.46 | 24.65 | 25.25 | 245308.0 |
| 2006-02-02 | ABCW-DELISTED | Stock | 30.99 | 31.12 | 30.3 | 30.41 | 81140.0 |
| 2006-02-02 | ABD-DELISTED | Stock | 24.5 | 24.56 | 24.09 | 24.44 | 193500.0 |
| 2006-02-02 | ABE-DELISTED | Stock | 12.82 | 12.82 | 12.501 | 12.5201 | 20100.0 |
| 2006-02-02 | ABFS-DELISTED | Stock | 42.77 | 43.12 | 42.61 | 42.94 | 462079.0 |
| 2006-02-02 | ABG | Stock | 17.81 | 18.07 | 17.75 | 17.88 | 68300.0 |
| 2006-02-02 | ABK-DELISTED | Stock | 76.65 | 77.64 | 76.3 | 76.71 | 591900.0 |
| 2006-02-02 | ABM | Stock | 19.03 | 19.1 | 18.78 | 18.84 | 138200.0 |
| 2006-02-02 | ABMD-DELISTED | Stock | 11.15 | 11.2 | 10.73 | 11.2 | 278568.0 |
| 2006-02-02 | ABP-DELISTED | Stock | 6.8 | 6.8 | 6.51 | 6.6 | 474900.0 |
| 2006-02-02 | ABR | Stock | 26.1 | 26.2 | 25.0 | 25.33 | 160500.0 |
| 2006-02-02 | ABT | Stock | 20.5354 | 20.6266 | 20.3483 | 20.3531 | 11625052.0 |
| 2006-02-02 | ABTL-DELISTED | Stock | 24.08 | 24.72 | 23.93 | 24.67 | 153261.0 |
| 2006-02-02 | ABV-DELISTED | Stock | 40.85 | 40.85 | 39.48 | 39.69 | 751500.0 |
| 2006-02-02 | ABVA-DELISTED | Stock | 17.0 | 17.08 | 16.95 | 17.05 | 23040.0 |
| 2006-02-02 | ABVT-DELISTED | Stock | 32.0 | 32.0 | 30.0 | 30.0 | 4500.0 |
| 2006-02-02 | ABX-DELISTED | Stock | 31.1 | 31.25 | 29.96 | 30.42 | 6111100.0 |
| 2006-02-02 | ACAD | Stock | 15.17 | 16.25 | 14.99 | 15.4 | 2916400.0 |
| 2006-02-02 | ACAP-DELISTED | Stock | 49.04 | 49.38 | 47.64 | 47.68 | 71012.0 |
| 2006-02-02 | ACAS-DELISTED | Stock | 35.4 | 35.47 | 35.1 | 35.27 | 960384.0 |
| 2006-02-02 | ACAT-DELISTED | Stock | 22.96 | 23.32 | 22.8 | 22.97 | 84157.0 |
| 2006-02-02 | ACC-DELISTED | Stock | 25.35 | 25.35 | 24.9 | 24.95 | 65900.0 |
| 2006-02-02 | ACCL-DELISTED | Stock | 6.71 | 6.78 | 6.61 | 6.62 | 115622.0 |
| 2006-02-02 | ACCO | Stock | 24.5 | 24.55 | 24.09 | 24.44 | 194200.0 |
> showing 50 of 4,345 rows — these rows as CSV