new_0222_0325|NAPA|0|total_current_assets|cash_on_hand|inventories_net|net_ppe|goodwill_and_intangible|liabilities|total_current_liabilities|total_long_term_liab|total_deposits|book_value_of_equity|retained_earnings|treasury_stock|ev_revenues|ev_earnings|ev_free_cash_flow|ev_assets|ps_ratio|pe_ratio|price_to_book_value|peg_ratio|debt_equity_ratio|dividend_yield|shareholder_yield_ttm|percent_of_shares_outstanding|receivables|payables|capital_stock|return_on_invested_capital|quality_ratio_fractile|momentum_fractile|market_beta_12_month|sustainable_growth_rate|institutional_investor_ownership_percentage|average_shares_outs_diluted|total_employee_number|eps|shares_outstanding|repurchase_of_capital_stock|ordinary_shares_number|payout_ratio|quick_ratio|normalized_eps|stock_buyback|effective_tax_rate|return_on_equity|net_income_ttm|revenues_ttm|dividend_per_share|revenues|gross_profit|sga_expense|pre_tax_income|net_income|interest_income|price|total_return_price|enterprise_value|average_volume_30|one_year_return|price_next_month|price_second_month
new_0222_0325|NAPA|1|The Duckhorn Portfolio Inc Total Current Assets (Quarterly) (USD)|The Duckhorn Portfolio Inc Cash and Short Term Investments (Quarterly) (USD)|The Duckhorn Portfolio Inc Inventories (Quarterly) (USD)|The Duckhorn Portfolio Inc Net PP&E (Quarterly) (USD)|The Duckhorn Portfolio Inc Goodwill and Intangibles (Quarterly) (USD)|The Duckhorn Portfolio Inc Total Liabilities (Quarterly) (USD)|The Duckhorn Portfolio Inc Total Current Liabilities (Quarterly) (USD)|The Duckhorn Portfolio Inc Total Long Term Liabilities (Quarterly) (USD)|The Duckhorn Portfolio Inc Total Deposits (Quarterly) (USD)|The Duckhorn Portfolio Inc Book Value (Quarterly) (USD)|The Duckhorn Portfolio Inc Retained Earnings (Quarterly) (USD)|The Duckhorn Portfolio Inc Treasury Stock (Quarterly) (USD)|The Duckhorn Portfolio Inc EV to Revenues|The Duckhorn Portfolio Inc EV to Earnings|The Duckhorn Portfolio Inc EV to Free Cash Flow|The Duckhorn Portfolio Inc EV to Assets (Quarterly)|The Duckhorn Portfolio Inc PS Ratio|The Duckhorn Portfolio Inc PE Ratio|The Duckhorn Portfolio Inc Price to Book Value|The Duckhorn Portfolio Inc PEG Ratio|The Duckhorn Portfolio Inc Debt to Equity Ratio|The Duckhorn Portfolio Inc Dividend Yield|The Duckhorn Portfolio Inc Shareholder Yield (TTM)|The Duckhorn Portfolio Inc Percent of Shares Outstanding Short|The Duckhorn Portfolio Inc Total Receivables (Quarterly) (USD)|The Duckhorn Portfolio Inc Total Payables (Quarterly) (USD)|The Duckhorn Portfolio Inc Total Capital Stock (Quarterly) (USD)|The Duckhorn Portfolio Inc Return on Invested Capital|The Duckhorn Portfolio Inc Quality Ratio Score|The Duckhorn Portfolio Inc Momentum Score|The Duckhorn Portfolio Inc Beta (1Y)|The Duckhorn Portfolio Inc Sustainable Growth Rate (TTM)|The Duckhorn Portfolio Inc Institutional Investor Ownership Percentage|The Duckhorn Portfolio Inc Average Diluted Shares Outstanding (Quarterly)|The Duckhorn Portfolio Inc Total Employees (Annual)|The Duckhorn Portfolio Inc EPS Diluted (Quarterly) (USD)|The Duckhorn Portfolio Inc Shares Outstanding|The Duckhorn Portfolio Inc Repurchase of Capital Stock (Quarterly) (USD)|The Duckhorn Portfolio Inc Ordinary Shares Number (Quarterly)|The Duckhorn Portfolio Inc Payout Ratio|The Duckhorn Portfolio Inc Quick Ratio (Quarterly)|The Duckhorn Portfolio Inc Normalized Diluted EPS (Quarterly) (USD)|The Duckhorn Portfolio Inc Stock Buybacks (Quarterly) (USD)|The Duckhorn Portfolio Inc Effective Tax Rate (TTM)|The Duckhorn Portfolio Inc Return on Equity|The Duckhorn Portfolio Inc Net Income (TTM) (USD)|The Duckhorn Portfolio Inc Revenue (TTM) (USD)|The Duckhorn Portfolio Inc Dividend Per Share (Quarterly) (USD)|The Duckhorn Portfolio Inc Revenue (Quarterly) (USD)|The Duckhorn Portfolio Inc Gross Profit (Quarterly) (USD)|The Duckhorn Portfolio Inc SG&A Expense (Quarterly) (USD)|The Duckhorn Portfolio Inc Pre-Tax Income (Quarterly) (USD)|The Duckhorn Portfolio Inc Net Income (Quarterly) (USD)|The Duckhorn Portfolio Inc Net Interest Income (Quarterly) (USD)|The Duckhorn Portfolio Inc Price (USD)|The Duckhorn Portfolio Inc Total Return Price (USD)|The Duckhorn Portfolio Inc Enterprise Value (USD)|The Duckhorn Portfolio Inc 30-Day Average Daily Volume|The Duckhorn Portfolio Inc 1 Year Price Returns (Daily)||
new_0222_0325|NAPA|2|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|percent_USD_metric|percent_USD_metric|percent_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|percent_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_beta|percent_USD_metric|percent_USD_metric|mil_figure_USD_metric|figure_whole_USD_metric|figure_money_USD_per_share_metric|mil_figure_USD_metric|mil_figure_money_USD_metric|mil_figure_USD_metric|percent_USD_metric|figure_USD_metric|figure_money_USD_per_share_metric|mil_figure_money_USD_metric|percent_USD_metric|percent_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|figure_money_USD_per_share_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|figure_money_USD_price|figure_money_USD_price|mil_figure_money_USD_metric|figure_USD_metric|percent_USD_metric||
new_0222_0325|NAPA|4|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|quarterly|daily|quarterly|daily|daily|daily|daily|quarterly|daily|quarterly|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|monthly|quarterly|quarterly|quarterly|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|daily|daily|daily|quarterly||
new_0222_0325|NAPA|5|114.25|114.25|114.25|114.25|114.25|114.25|114.25|114.25|0|114.25|114.25|0|1.42978723404|92|1.42553191489|92|1.42796610169|1.42796610169|1.42796610169|1.43421052632|91.4|1.44206008584|92|15.3|114.25|114.25|114.25|92|92|0|0|92|30.6|91.2857142857|181|91.2857142857|33.125|0|114.25|91.25|91.4|91.2857142857|92|91.25|92|91.25|91.25|0|91.2857142857|91.2857142857|91.2857142857|91.2857142857|91.2857142857|91.2857142857|1.44017094017|1.44017094017|1.42978723404|1.44117647059|0||
new_0222_0325|NAPA|6|4|4|4|4|4|4|4|4|0|4|4|0|235|2|141|2|236|236|236|76|5|233|2|20|4|4|4|2|2|0|0|2|10|7|1|7|8|0|4|4|5|7|1|4|2|4|4|0|7|7|7|7|7|7|234|234|235|204|0||
new_0222_0325|NAPA|7|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|quarterly|daily|quarterly|daily|daily|daily|daily|quarterly|daily|quarterly|daily|quarterly|quarterly|quarterly|quarterly|quarterly|monthly|monthly|quarterly|monthly|quarterly|yearly|quarterly|daily|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|market_daily|market_daily|daily|market_daily|market_daily||
new_0222_0325|NAPA|201912||||||||||||||||||||||||||||||||||110.5859||0.1326||||||0.105|||||||76.993|38.313|18.104|19.917|14.665|-4.854|||||||
new_0222_0325|NAPA|202003||||||||||||||||||||||||||||||||||110.5859||0.1051||||||0.1049|||||||68.72|36.342|13.156|15.806|11.619|-4.221|||||||
new_0222_0325|NAPA|202006|280.713|6.252|245.311|242.751|633.439|503.987|51.807|452.18||654.047|117.658||||||||||0.5794||||26.464|3.733|1.017|||||||110.5859||-0.0246|||115.0468||0.6315|0.0535|||||||52.231|25.923|16.205|-4.881|-2.723|-4.019|||||||
new_0222_0325|NAPA|202009||||||||||||||||||||||||||||||||||110.5859||0.1585||||0||0.1689||24.633||41.084|289.582||91.638|44.275|16.805|23.658|17.523|-3.58|||||||
new_0222_0325|NAPA|202012|321.018|9.274|271.674|242.591|629.597|500.359|59.547|440.812||694.149|157.184||||||||||0.5282||||29.736|8.296|1.017|||||||110.5859|413|0.199|||115.0468|0|0.6551|0.1474||24.9605||48.422|296.246||83.657|41.757|17.471|29.935|22.003|-3.612|||||||
new_0222_0325|NAPA|202103|326.361|5.027|268.825|240.975|627.677|403.494|63.976|339.518||792.957|66.206||7.7248|52.39||2.0056|6.2638|38.3192|2.7811||0.3344|0|-2.4781|1.0711|43.955|14.417|1.15|4.3593|3|||-7.5905|23.7571|108.404||0.08|115.0468||114.3814|218.2215|0.7656|0.0776|-187.5|27.6812|6.4206|45.825|317.951||90.425|46.929|31.142|14.645|9.022|-3.755|16.78|16.78|2288.4443|644501.3||18.71|18.18
new_0222_0325|NAPA|202106|314.401|4.244|267.737|240.939|625.756|380.879|56.781|324.098||801.687|73.634||8.7559|49.5066|54.7849|2.3423|7.6348|53.4357|3.1821||0.3085|0|-1.9568|1.6242|33.253|3.556|1.15|5.3271|4|||-5.9839|28.4443|115.4604|474|0.06|114.3814||115.0468|178.648|0.6604|0.0606|0|27.2909|7.6084|55.976|336.613||70.893|34.387|24.398|8.74|7.428|-2.671|22.06|22.06|2783.9477|550565.7||21.97|21.49
new_0222_0325|NAPA|202109|392.782|5.247|319.224|244.397|623.835|438.084|129.837|308.247||824.419|94.907||8.547|41.0575|56.8773|1.9414|7.5657|46.0141|3.2848|0.9324|0.2812|0|1.3222|1.5727|59.618|56.701|1.15|5.6526|3|||-5.3453|29.9685|115.396||0.18|115.0468||115.0468|167.4313|0.4996|0.1803||27.1296|7.927|59.726|349.156||104.181|52.41|23.158|28.69|21.273|-1.606|22.89|22.89|2877.0253|320716.1667||19.34|19.21
new_0222_0325|NAPA|202112|||||||||||||8.3412||40.1161||7.5177|44.9711|3.2571|1.1328||0||1.3718|||||||||34.168||||||||||||||||||||||23.34|23.34|2912.3863|588122.6333||19.96|19.24