PREVIEW / stock_daily / 2006-02-17
file: by_date/stock_daily/2006/2006-02-17.parquet size: 146 KB rows: 4,355 symbols: 2,753
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-17 | AAPL | Stock | 2.5107 | 2.5318 | 2.4861 | 2.5104 | 575999200.0 |
| 2006-02-17 | MSFT | Stock | 26.67 | 26.81 | 26.56 | 26.7 | 41513200.0 |
| 2006-02-17 | NVDA | Stock | 0.4222 | 0.4227 | 0.3933 | 0.3956 | 2356956000.0 |
| 2006-02-17 | AMZN | Stock | 1.9465 | 1.969 | 1.9455 | 1.9595 | 91636000.0 |
| 2006-02-17 | CL | Stock | 27.385 | 27.45 | 27.25 | 27.4 | 3213800.0 |
| 2006-02-17 | A | Stock | 24.7496 | 25.1359 | 24.6996 | 25.0286 | 4504915.0 |
| 2006-02-17 | AABA-DELISTED | Stock | 32.8800010681152 | 33.1399993896484 | 32.7099990844727 | 32.7599983215332 | 12620200.0 |
| 2006-02-17 | AACC-DELISTED | Stock | 17.78 | 17.78 | 17.3199 | 17.48 | 160441.0 |
| 2006-02-17 | AACQ-DELISTED | Stock | 5.42 | 5.42 | 5.36 | 5.36 | 8000.0 |
| 2006-02-17 | AACQW-DELISTED | Stock | 0.75 | 0.75 | 0.69 | 0.69 | 40600.0 |
| 2006-02-17 | AAI-DELISTED | Stock | 18.0 | 18.0 | 17.49 | 17.91 | 1915200.0 |
| 2006-02-17 | AAIC-DELISTED | Stock | 215.8 | 216.0 | 211.6 | 215.8 | 485200.0 |
| 2006-02-17 | AAME | Stock | 2.76 | 2.76 | 2.6 | 2.74 | 2100.0 |
| 2006-02-17 | AAON | Stock | 2.7193 | 2.7562 | 2.7128 | 2.7299 | 707737.0 |
| 2006-02-17 | AAP | Stock | 45.5 | 45.5 | 41.53 | 41.7 | 1354200.0 |
| 2006-02-17 | AATI-DELISTED | Stock | 14.76 | 14.95 | 14.51 | 14.55 | 185066.0 |
| 2006-02-17 | AAU-DELISTED | Stock | 2.74 | 2.9 | 2.74 | 2.79 | 93884.0 |
| 2006-02-17 | AAUAF-DELISTED | Stock | 2.69 | 2.84 | 2.69 | 2.74 | 95600.0 |
| 2006-02-17 | AAV-DELISTED | Stock | 19.22 | 19.64 | 19.0 | 19.51 | 609300.0 |
| 2006-02-17 | AAWW-DELISTED | Stock | 47.0 | 47.75 | 47.0 | 47.75 | 1900.0 |
| 2006-02-17 | AAXN-DELISTED | Stock | 10.3199996948242 | 10.3500003814697 | 10.0900001525879 | 10.1800003051758 | 2352700.0 |
| 2006-02-17 | ABAX-DELISTED | Stock | 21.98 | 22.07 | 21.01 | 21.24 | 243434.0 |
| 2006-02-17 | ABB-DELISTED | Stock | 11.26 | 11.36 | 11.24 | 11.32 | 2982800.0 |
| 2006-02-17 | ABBC-DELISTED | Stock | 13.38 | 13.38 | 13.31 | 13.32 | 34100.0 |
| 2006-02-17 | ABC-DELISTED | Stock | 22.12 | 22.12 | 21.85 | 22.01 | 1667800.0 |
| 2006-02-17 | ABCB | Stock | 20.7951 | 21.1161 | 20.6784 | 20.8145 | 20048.0 |
| 2006-02-17 | ABCO-DELISTED | Stock | 27.4 | 27.4 | 26.69 | 26.71 | 189534.0 |
| 2006-02-17 | ABCW-DELISTED | Stock | 32.04 | 32.04 | 31.34 | 31.4 | 38730.0 |
| 2006-02-17 | ABD-DELISTED | Stock | 23.88 | 24.11 | 23.45 | 23.78 | 286900.0 |
| 2006-02-17 | ABE-DELISTED | Stock | 12.9399 | 12.95 | 12.86 | 12.93 | 13300.0 |
| 2006-02-17 | ABFS-DELISTED | Stock | 42.96 | 42.96 | 42.06 | 42.5 | 143267.0 |
| 2006-02-17 | ABG | Stock | 18.03 | 20.03 | 18.03 | 19.7 | 248500.0 |
| 2006-02-17 | ABK-DELISTED | Stock | 75.96 | 76.05 | 75.05 | 75.41 | 690400.0 |
| 2006-02-17 | ABM | Stock | 18.99 | 19.03 | 18.83 | 18.89 | 111600.0 |
| 2006-02-17 | ABMD-DELISTED | Stock | 10.88 | 11.2 | 10.6 | 11.14 | 118714.0 |
| 2006-02-17 | ABP-DELISTED | Stock | 6.22 | 6.46 | 6.16 | 6.24 | 389100.0 |
| 2006-02-17 | ABR | Stock | 27.08 | 27.1 | 26.78 | 26.94 | 87000.0 |
| 2006-02-17 | ABT | Stock | 21.1832 | 21.3511 | 21.0152 | 21.2743 | 9496665.0 |
| 2006-02-17 | ABTL-DELISTED | Stock | 24.6 | 24.6 | 23.8 | 23.95 | 76887.0 |
| 2006-02-17 | ABV-DELISTED | Stock | 43.5 | 43.9 | 43.31 | 43.5 | 1292600.0 |
| 2006-02-17 | ABVA-DELISTED | Stock | 17.892 | 17.986 | 17.836 | 17.958 | 1278.0 |
| 2006-02-17 | ABX-DELISTED | Stock | 28.82 | 29.21 | 28.54 | 28.64 | 3253800.0 |
| 2006-02-17 | ACAD | Stock | 14.92 | 15.09 | 14.09 | 15.09 | 346500.0 |
| 2006-02-17 | ACAP-DELISTED | Stock | 49.75 | 49.75 | 48.65 | 49.01 | 52995.0 |
| 2006-02-17 | ACAS-DELISTED | Stock | 36.37 | 37.02 | 36.32 | 36.91 | 960865.0 |
| 2006-02-17 | ACAT-DELISTED | Stock | 24.99 | 24.99 | 24.3 | 24.42 | 51616.0 |
| 2006-02-17 | ACC-DELISTED | Stock | 25.45 | 25.5 | 24.93 | 24.93 | 44800.0 |
| 2006-02-17 | ACCL-DELISTED | Stock | 6.4 | 6.41 | 6.17 | 6.27 | 48106.0 |
| 2006-02-17 | ACCO | Stock | 23.88 | 24.11 | 23.45 | 23.78 | 286900.0 |
| 2006-02-17 | ACCP-DELISTED | Stock | 1.225 | 1.25 | 1.0 | 1.0 | 189880.0 |
> showing 50 of 4,355 rows — these rows as CSV