with rankedmt4 as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors ), last_feed_entry as ( select * from rankedmt4 where r = ? ), ok_entries as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where status = ? ), earliest_entry_after_ok as ( select m.datafeedname, min(m.eventtimestamp) as eventtimestamp from mt4datafeederrors m left outer join ( select datafeedname, eventtimestamp from ok_entries where r = ?) oo on m.datafeedname = oo.datafeedname where m.eventtimestamp > coalesce(oo.eventtimestamp, ?::timestamp without time zone) group by m.datafeedname ), notified_entries as ( select *, row_number() over (partition by datafeedname order by eventtimestamp desc) r from mt4datafeederrors where notified is not null and notified <> ? ), broker as ( select *, row_number() over (partition by feedname order by brokerid) r from ( select distinct b.brokerid, b.name as brokername, dss.classname as feedname from downloadersymbolsettings dss inner join brokersymbollist bsl on dss.symbolid = bsl.symbolid inner join broker b on bsl.brokerid = b.brokerid where dss.enabled = ?) a ) select last.id, last.datafeedname, last.eventtimestamp, last.status, last.errordescription, last.serveraddress, last.username, note.notified, note.eventtimestamp, broker.brokername from last_feed_entry last inner join earliest_entry_after_ok after_ok on last.datafeedname = after_ok.datafeedname inner join broker on last.datafeedname = broker.feedname left outer join ok_entries ok on ok.datafeedname = last.datafeedname left outer join notified_entries note on note.datafeedname = last.datafeedname and note.r = ? where (ok.r is null or ok.r = ?) and last.datafeedname not in ( select distinct datafeedname from last_feed_entry where status = ?) and extract(epoch from (last.eventtimestamp - after_ok.eventtimestamp)) > ? * ? and last.eventtimestamp > current_timestamp - interval ? and (note.eventtimestamp is null or note.eventtimestamp < current_timestamp - interval ?) and last.eventtimestamp > current_timestamp - interval ? and broker.r = ?;

update solr_relevance_old set new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total from ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total from whatshot_probability where type = ?) sub where result_uid = sub.resultuid;

with max_ra as ( select resultuid from relevance_keylevels_results order by resultuid desc limit ?) update solr_relevance_old set newrelevant = sub.relevant, newage = sub.age from ( select so.uuid, case when ra.relevant is not null then ra.relevant when so.result_uid < max_ra.resultuid then ? else ? end as relevant, case when ra.age is not null then ra.age when so.result_uid < max_ra.resultuid then ? else ? end as age, so.result_uid from max_ra, solr_relevance_old so inner join keylevels_results k on so.result_uid = k.resultuid and so.uuid ilike ? inner join downloadersymbolsettings dss on k.symbolid = dss.symbolid left outer join relevance_keylevels_results ra on so.result_uid = ra.resultuid and so.uuid ilike ?) sub where solr_relevance_old.result_uid = sub.result_uid and solr_relevance_old.uuid ilike ?; update solr_relevance_old set newrelevant = ? where result_uid in ( select result_uid from solr_relevance_old s left outer join keylevels_results a on a.resultuid = s.result_uid where s.uuid ilike ? and a.resultuid is null); update solr_relevance_old set new_hod_correct = sub.hod_correct, new_hod_percent = sub.hod_percent, new_hod_total = sub.hod_total, new_pattern_correct = sub.pattern_correct, new_pattern_percent = sub.pattern_percent, new_pattern_total = sub.pattern_total, new_percent = sub.percent, new_symbol_correct = sub.symbol_correct, new_symbol_percent = sub.symbol_percent, new_symbol_total = sub.symbol_total from ( select distinct resultuid, hod_correct, hod_percent, hod_total, hod, pattern_correct, pattern_percent, pattern_total, percent, symbol_correct, symbol_percent, symbol_total from whatshot_probability where type in (...)) sub where result_uid = sub.resultuid;

select updateresultsmaterializedview ();

select updateageforrelevantresults ();

select count(distinct brokerid) from broker_symbol_ticker_view where brokerid not in ( select distinct brokerid from broker_symbol_ticker_view b inner join powerstats_symboldata pa on b.symbolid = pa.symbolid inner join powerstats_hourly t on pa.hourlysymbolid = t.symbolid where t.enddate = ( select max(enddate) from powerstats_hourly)) and enabled = ? and latestpricedatetime > current_timestamp - interval ? and timegranularity = ?;

select key, value from datasources ds inner join datasourceparams dsp on ds.id = dsp.datasourceid where ds.name = ?;

with rar_max as ( select resultuid from relevance_bigmovement_results order by resultuid desc limit ? ) select bmr.symbolid, patternstarttime, patternendtime, timegranularity, ? as direction, case when bmr.old_resultuid = ? then bmr.old_resultuid else bmr.resultuid end as uid, s.exchange, s.symbol, s.longname, s.shortname, dtt.timezone, bmr.patternmovement, bmr.statisticalmovement, bmr.fromprice, bmr.toprice, bmr.percentile, bmr.patternlengthbars, case when rbr.age is not null then rbr.age when bmr.resultuid <= rm.resultuid then ? else ? end as age, case when rbr.relevant is not null then rbr.relevant when bmr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from bigmovement_results bmr inner join downloadersymbolsettings dss on bmr.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname inner join symbols s on bmr.symbolid = s.symbolid inner join rar_max rm on ? = ? left outer join relevance_bigmovement_results rbr on rbr.resultuid = bmr.resultuid left join currencypips cps on cps.symbol = s.symbol where (bmr.old_resultuid = ? or bmr.resultuid = ?) and dtt.dayofweek = ?;

insert into t60 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict (pricedatetime, symbolid) do update set open = ?, high = ?, low = ?, close = ?, volume = ?, bsf = ?, sastdatetimewritten = ?, sastdatetimereceived = ?;

select count(*) from datafeeds_latestrun where feedname ilike ? and ((latestrxtime > current_timestamp - interval ? and latestdbwritetime > current_timestamp - interval ?) or (latestdbwritetime > current_timestamp - interval ? and lateststartuptime > current_timestamp - interval ?));

select updaterelevantforrelevantresults ();

set datestyle = iso;

set client_encoding to ?;

select "public"."executions"."id" AS "id", "public"."executions"."processid" AS "processid", "public"."executions"."executiondate" AS "executiondate", "public"."executions"."errorcount" AS "errorcount", "public"."executions"."warningcount" AS "warningcount", "public"."executions"."isrunning" AS "isrunning", "public"."executions"."response" AS "response", "public"."executions"."live" AS "live", "public"."executions"."has_results" AS "has_results", "LT?"."id" AS "LA?" from "public"."executions" left outer join "public"."processes" "LT?" on "LT?"."id" = "public"."executions"."processid" where (processid = ?) order by "public"."executions"."id" desc limit ? offset ?;

select cast(count(*) / cast(setting as numeric) * ? as int) from pg_stat_activity, pg_settings where name = ? group by setting;

select count(*) from "public"."executions" left outer join "public"."processes" "LT?" on "LT?"."id" = "public"."executions"."processid" where (processid = ?);

commit;

with rar_max as ( select resultuid from relevance_keylevels_results order by resultuid desc limit ? ), kr as ( select a.*, rr.age, rr.relevant from keylevels_results a left outer join relevance_keylevels_results rr on a.resultuid = rr.resultuid where case when false = ? then true else a.resultuid > ( select min(resultuid) from relevance_keylevels_results) end ), all_results as ( select kr.resultuid as resultuid, kr.direction as direction, s.exchange as exchange, s.symbolid as symbolid, coalesce(bim.code, s.symbol) as symbol_code, s.longname as symbol_name, s.timegranularity as interval, p.patternname as pattern_name, kr.breakout as breakout, kr.atbaridentified as identified, dtt.timezone as timezone, kr.patternlengthbars as length, g.basegroupname, newlevels.filtered, case when kr.age is not null then kr.age when kr.resultuid <= rm.resultuid then ? else ? end as age, case when kr.relevant is not null then kr.relevant when kr.resultuid <= rm.resultuid then ? else ? end as relevant, cps.pip from kr inner join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = kr.symbolid inner join symbols s on bsl.symbolid = s.symbolid and s.nonliquid = ? inner join symbolgroup sg on s.symbolid = sg.symbolid inner join groups g on sg.groupid = g.groupid inner join brokergroups bg on g.groupid = bg.groupid and bsl.brokerid = bg.brokerid inner join hrspatterns p on kr.patternid = p.patternid inner join downloadersymbolsettings dss on s.symbolid = dss.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join rar_max rm on ? = ? left outer join autochartist_symbolupdates au on dss.symbolid = au.symbolid left outer join relevance_keylevels_results rar on rar.resultuid = kr.resultuid left join lateral calc_kl_signal_filter (kr.resultuid) newlevels on true left join currencypips cps on cps.symbol = s.symbol left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = bsl.brokerid and bim.type = ? where kr.gmttimefound > now() - interval ? and dss.enabled = ? and s.deleted = ? and (kr.simulation = ? or kr.simulation is null) and (? = ? or s.timegranularity in (...)) and (? = ? or s.exchange in (...)) and (? = ? or coalesce(bim.code, s.symbol) in (...)) and (? = ? or p.patternname in (...)) and (? = ? or kr.patternclassid in (...)) and (? = ? or kr.patternlengthbars <= ?) and kr.patternstarttime::timestamp without time zone >= coalesce(au.earliestpricedatetime, ?::timestamp without time zone) -- to make sure patternstarttime is in our t-tables ), results as ( select distinct on (symbolid) * from all_results where (false = ? or relevant = ?) and (? = ? or age <= ?) order by symbolid, resultuid ) select * from results order by identified desc, length desc limit ?;

select count(*), sum(size), extract(epoch from now() - min(modification)) from pg_ls_waldir ();

insert into executionlogs(executionid, status, message, details, detailtype) values(?, ?, ?, ?'s biggest movers": "\u0628\u0632\u0631\u06af\u200c\u062a\u0631\u06cc\u0646 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u0627\u0645\u0631\u0648\u0632", "TodaysEconomicEvents": "\u0631\u0648\u06cc\u062f\u0627\u062f\u0647\u0627\u06cc \u0627\u0642\u062a\u0635\u0627\u062f\u06cc \u0627\u0645\u0631\u0648\u0632", "Trading Terms ?": "\u0634\u0631\u0627\u06cc\u0637 \u062a\u062c\u0627\u0631\u062a ?", "Tuesday": "\u0633\u0647\u200c\u0634\u0646\u0628\u0647", "TuesdayShort": "\u0633\u0647\u200c\u0634\u0646\u0628\u0647", "Upcoming earnings announcements for this week:": "\u06af\u0632\u0627\u0631\u0634\u200c\u0647\u0627\u06cc \u062f\u0631\u0622\u0645\u062f \u0622\u062a\u06cc \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u0647\u0641\u062a\u0647:", "upcomingearnings_title": "\u06af\u0632\u0627\u0631\u0634\u200c\u0647\u0627\u06cc \u062f\u0631\u0622\u0645\u062f \u0628\u06cc\u0646 {fromdate} \u0648 {todate}.", "upcomingearnings_title_noearnings": "\u0647\u06cc\u0686 \u06af\u0632\u0627\u0631\u0634 \u062f\u0631\u0622\u0645\u062f\u06cc \u0628\u06cc\u0646 {fromdate} \u0648 {todate} \u0628\u0631\u0646\u0627\u0645\u0647\u200c \u0631\u06cc\u0632\u06cc \u0646\u0634\u062f\u0647 \u0627\u0633\u062a.", "upcomingeconomicevents_title": "\u0631\u0648\u06cc\u062f\u0627\u062f\u0647\u0627\u06cc \u0627\u0642\u062a\u0635\u0627\u062f\u06cc \u0628\u0627 \u062a\u0623\u062b\u06cc\u0631 \u0628\u0627\u0644\u0627 \u0628\u06cc\u0646 {fromdate} \u0648 {todate}.", "UpcomingHighImpactEconomicEvent": "\u0631\u0648\u06cc\u062f\u0627\u062f \u0627\u0642\u062a\u0635\u0627\u062f\u06cc \u0628\u0627 \u062a\u0627\u062b\u06cc\u0631 \u0628\u0627\u0644\u0627", "USD/CAD": "USD/CAD", "USD/CAD Futures": "USD/CAD Futures", "USD/CHF": "USD/CHF", "USD/CHF Futures": "USD/CHF Futures", "USD/JPY": "USD/JPY", "USD/JPY Futures": "USD/JPY Futures", "US Dollar Index Futures": "US Dollar Index Futures", "UTC": "UTC", "VolatilityIncrease": "\u0627\u0641\u0632\u0627\u06cc\u0634 \u0646\u0648\u0633\u0627\u0646", "VolatilityWarning": "\u0647\u0634\u062f\u0627\u0631 \u0646\u0648\u0633\u0627\u0646", "volatilitywarning_longtext": "\u00ab{eventname}\u00bb {country_name} \u0645\u0648\u062c\u0628 \u0627\u0641\u0632\u0627\u06cc\u0634 \u0642\u0627\u0628\u0644\u200c \u062a\u0648\u062c\u0647 \u0646\u0648\u0633\u0627\u0646\u0627\u062a \u062e\u0648\u0627\u0647\u062f \u0634\u062f.", "volatilitywarning_shorttext": "\u00ab{eventname}\u00bb {country_name} \u0645\u0648\u062c\u0628 \u0627\u0641\u0632\u0627\u06cc\u0634 \u0642\u0627\u0628\u0644\u200c\u062a\u0648\u062c\u0647 \u0646\u0648\u0633\u0627\u0646\u0627\u062a \u062e\u0648\u0627\u0647\u062f \u0634\u062f.", "volatilitywarning_title": "\u0646\u0648\u0633\u0627\u0646 \u0622\u062a\u06cc \u0628\u0647 \u062f\u0644\u06cc\u0644 \u00ab{eventname}\u00bb\u062f\u0631 {country_name} \u0637\u06cc {hours_ahead} \u0633\u0627\u0639\u062a \u0622\u06cc\u0646\u062f\u0647.", "Wednesday": "\u0686\u0647\u0627\u0631 \u0634\u0646\u0628\u0647", "WednesdayShort": "\u0686\u0647\u0627\u0631 \u0634\u0646\u0628\u0647", "Wheat": "\u06af\u0646\u062f\u0645", "Wheat Futures": "Wheat Futures", "WTI Crude Oil Futures": "WTI Crude Oil Futures", "Zeromarkets ?_AUD/USD": "AUDUSD", "Zeromarkets ?_Brent Crude Oil Futures": "XBRUSD", "Zeromarkets ?_Crude oil": "XTIUSD", "Zeromarkets ?_DAX": "GER?", "Zeromarkets ?_EUR/USD": "EURUSD", "Zeromarkets ?_FTSE ?": "UK?", "Zeromarkets ?_GBP/USD": "GBPUSD", "Zeromarkets ?_Gold": "XAUUSD", "Zeromarkets ?_Hang Seng": "HK?", "Zeromarkets ?_Nasdaq ?": "US?", "Zeromarkets ?_Natural gas": "XNGUSD", "Zeromarkets ?_Nikkei ?": "JP?", "Zeromarkets ?_Nikkei ? Dollar Futures": "JP?", "Zeromarkets ?_NZD/USD": "NZDUSD", "Zeromarkets ?_Platinum Futures": "XPTUSD", "Zeromarkets ?_Silver": "XAGUSD", "Zeromarkets ?_USD/CAD": "USDCAD", "Zeromarkets ?_USD/CHF": "USDCHF", "Zeromarkets ?_USD/JPY": "USDJPY", "Zeromarkets ?_US Dollar Index Futures": "USDX", "Zeromarkets ?_WTI Crude Oil Futures": "WTI" }, "data": { "earningscompany": "JPM", "earningscompany_name": "JPMorgan Chase & Co", "earningscompany_sector": "Financial Services", "earningscompany_industry": "Banks-Diversified", "next_releasetime": "?-01-13 ?:?:?", "earningsimpactid": ?, "sample_size": ?, "impact_on_self": { "forecastperiod_trading_days": ?, "id": "delta_gt_up", "probability": "?%", "delta_gt": ?, "delta_gt_up": ?, "trend_direction": ?, "delta_sign": ">", "mean_mov": "?.?", "mean_mov_percent": " ?%", "icon": "https://acarrows.s3.eu-west-1.amazonaws.com/arrows/up.svg", "description": "\u062f\u0631 \u06af\u0630\u0634\u062a\u0647\u060c \u0647\u0631\u06af\u0627\u0647 \u062f\u0631\u0622\u0645\u062f\u0647\u0627 \u0628\u0627\u0644\u0627\u062a\u0631 \u0627\u0632 \u067e\u06cc\u0634\u200c\u0628\u06cc\u0646\u06cc\u200c\u0647\u0627 \u0628\u0648\u062f\u0647\u200c\u0627\u0646\u062f\u060c \u062f\u0631 \u200e100%\u200e \u0645\u0648\u0627\u0642\u0639\u060c \u0633\u0647\u0627\u0645 \u0628\u0647\u200c\u0637\u0648\u0631 \u0645\u06cc\u0627\u0646\u06af\u06cc\u0646 \u0628\u0647 \u0627\u0646\u062f\u0627\u0632\u0647 \u200e ?%\u200e \u0627\u0641\u0632\u0627\u06cc\u0634 \u06cc\u0627\u0641\u062a\u0647 \u0627\u0633\u062a.", "ifeps": "\u0627\u06af\u0631 \u062f\u0631\u0622\u0645\u062f JPM > \u0627\u0632 ?.? \u0628\u0627\u0634\u062f" }, "Code": "JPM", "Type": "Common Stock", "Name": "JPMorgan Chase & Co", "Exchange": "NYSE", "CurrencyCode": "USD", "CurrencyName": "US Dollar", "CurrencySymbol": "$", "CountryName": "USA", "CountryISO": "US", "OpenFigi": "BBG?DMBXR?", "ISIN": "US?H?", "LEI": "?I?DZWZKVSZI?NUHU?", "PrimaryTicker": "JPM.US", "CUSIP": "?A?", "CIK": "?", "EmployerIdNumber": "?-2624428", "FiscalYearEnd": "December", "IPODate": "?-10-06", "InternationalDomestic": "International/Domestic", "Sector": "Financial Services", "Industry": "Banks - Diversified", "GicSector": "Financials", "GicGroup": "Banks", "GicIndustry": "Banks", "GicSubIndustry": "Diversified Banks", "HomeCategory": "Domestic Primary", "IsDelisted": false, "Description": "JPMorgan Chase & Co. operates as a financial services company worldwide. It operates through three segments: Consumer & Community Banking, Commercial & Investment Bank, and Asset & Wealth Management. The company offers deposit, investment and lending products, cash management, and payments and services; mortgage origination and servicing activities; residential mortgages and home equity loans; and credit cards, auto loans, leases, and travel services to consumers and small businesses through bank branches, ATMs, and digital and telephone banking. It also provides investment banking products and services, including corporate strategy and structure advisory, and equity and debt market capital-raising services, as well as loan origination and syndication; payments; and cash and derivative instruments, risk management solutions, prime brokerage, and research, as well as offers securities services, including custody, fund services, liquidity, and trading services, and data solutions products. In addition, the company provides financial solutions, including lending, payments, investment banking, and asset management to small and midsized companies, local governments, nonprofit clients, and municipalities, as well as commercial real estate clients. Further, it offers multi-asset investment management solutions in equities, fixed income, alternatives, and money market funds to institutional clients and retail investors; and retirement products and services, brokerage, custody, estate planning, lending, deposits, and investment management products to high net worth clients. The company was founded in ? and is headquartered in New York, New York.", "Address": "? Park Avenue, New York, NY, United States, ?", "Phone": "(?) ?-6000", "WebURL": "https://www.jpmorganchase.com", "LogoURL": "https://eodhistoricaldata.com/img/logos/US/JPM.png", "FullTimeEmployees": ?, "UpdatedAt": "?-12-28", "MarketCapitalization": ?, "MarketCapitalizationMln": ?.?, "EBITDA": null, "PERatio": ?.?, "PEGRatio": ?.?, "WallStreetTargetPrice": ?.?, "BookValue": ?.?, "DividendShare": ?.?, "DividendYield": ?.?, "EarningsShare": ?.?, "EPSEstimateCurrentYear": ?.?, "EPSEstimateNextYear": ?.?, "EPSEstimateNextQuarter": ?.?, "EPSEstimateCurrentQuarter": ?.?, "MostRecentQuarter": "?-09-30", "ProfitMargin": ?.?, "OperatingMarginTTM": ?.?, "ReturnOnAssetsTTM": ?.?, "ReturnOnEquityTTM": ?.?, "RevenueTTM": ?, "RevenuePerShareTTM": ?.?, "QuarterlyRevenueGrowthYOY": ?.?, "GrossProfitTTM": ?, "DilutedEpsTTM": ?.?, "QuarterlyEarningsGrowthYOY": ?.?, "code": "JPM.US", "report_date": "?-01-13", "date": "?-12-31", "before_after_market": "BeforeMarket", "currency": "USD", "actual": null, "estimate": ?.?, "difference": ?, "percent": null, "DateToday": "\u062f\u0648\u0634\u0646\u0628\u0647, ? \u062f\u0633\u0627\u0645\u0628\u0631", "ProbabilityLabel": "\u0627\u062d\u062a\u0645\u0627\u0644", "impact": { "?": { "earningsimpactid": ?, "sample_size": ?, "impactcompany": "WFC", "impactcompany_name": "Wells Fargo & Company", "impactcompany_sector": "Financial Services", "impactcompany_industry": "Banks-Diversified", "opportunities": [ { "forecastperiod_trading_days": ?, "id": "delta_gt_up", "probability": "?%", "delta_gt": ?, "delta_gt_up": ?, "trend_direction": ?, "delta_sign": ">", "mean_mov": "?.?", "mean_mov_percent": "?%", "icon": "https://acarrows.s3.eu-west-1.amazonaws.com/arrows/up.svg" } ], "Code": "WFC", "Type": "Common Stock", "Name": "Wells Fargo & Company", "Exchange": "NYSE", "CurrencyCode": "USD", "CurrencyName": "US Dollar", "CurrencySymbol": "$", "CountryName": "USA", "CountryISO": "US", "OpenFigi": "BBG?BWQFY?", "ISIN": "US?", "LEI": "PBLD?EJDB?FWOLXP?B?", "PrimaryTicker": "WFC.US", "CUSIP": "?", "CIK": "?", "EmployerIdNumber": "?-0449260", "FiscalYearEnd": "December", "IPODate": "?-06-01", "InternationalDomestic": "Domestic", "Sector": "Financial Services", "Industry": "Banks - Diversified", "GicSector": "Financials", "GicGroup": "Banks", "GicIndustry": "Banks", "GicSubIndustry": "Diversified Banks", "HomeCategory": "Domestic Primary", "IsDelisted": false, "Description": "Wells Fargo & Company, a financial services company, provides diversified banking, investment, mortgage, and consumer and commercial finance products and services in the United States and internationally. It operates through four segments: Consumer Banking and Lending; Commercial Banking; Corporate and Investment Banking; and Wealth and Investment Management. The Consumer Banking and Lending segment offers diversified financial products and services for consumers and small businesses. Its financial products and services include checking and savings accounts, and credit and debit cards, as well as home, auto, personal, and small business lending services. The Commercial Banking segment provides financial solutions to private, family owned, and certain public companies. Its products and services include banking and credit products across various industry sectors and municipalities, secured lending and lease products, and treasury management services. The Corporate and Investment Banking segment offers a suite of capital markets, banking, and financial products and services, such as corporate banking, investment banking, treasury management, commercial real estate lending and servicing, equity, and fixed income solutions, as well as sales, trading, and research capabilities services to corporate, commercial real estate, government, and institutional clients. The Wealth and Investment Management segment provides personalized wealth management, brokerage, financial planning, lending, private banking, and trust and fiduciary products and services to affluent, high-net worth, and ultra-high-net worth clients. It also operates through financial advisors in brokerage and wealth offices, consumer bank branches, independent offices, and digitally through WellsTrade and Intuitive Investor. Wells Fargo & Company was founded in ? and is headquartered in San Francisco, California.", "Address": "? Market Street, San Francisco, CA, United States, ?", "Phone": "?-371-2921", "WebURL": "https://www.wellsfargo.com", "LogoURL": "https://eodhistoricaldata.com/img/logos/US/WFC.png", "FullTimeEmployees": ?, "UpdatedAt": "?-12-28", "MarketCapitalization": ?, "MarketCapitalizationMln": ?.?, "EBITDA": null, "PERatio": ?.?, "PEGRatio": ?.?, "WallStreetTargetPrice": ?.?, "BookValue": ?.?, "DividendShare": ?.?, "DividendYield": ?.?, "EarningsShare": ?.?, "EPSEstimateCurrentYear": ?.?, "EPSEstimateNextYear": ?.?, "EPSEstimateNextQuarter": ?.?, "EPSEstimateCurrentQuarter": ?.?, "MostRecentQuarter": "?-09-30", "ProfitMargin": ?.?, "OperatingMarginTTM": ?.?, "ReturnOnAssetsTTM": ?.?, "ReturnOnEquityTTM": ?.?, "RevenueTTM": ?, "RevenuePerShareTTM": ?.?, "QuarterlyRevenueGrowthYOY": ?.?, "GrossProfitTTM": ?, "DilutedEpsTTM": ?.?, "QuarterlyEarningsGrowthYOY": ?.? }, "?": { "earningsimpactid": ?, "sample_size": ?, "impactcompany": "C", "impactcompany_name": "Citigroup Inc", "impactcompany_sector": "Financial Services", "impactcompany_industry": "Banks-Diversified", "opportunities": [ { "forecastperiod_trading_days": ?, "id": "delta_gt_up", "probability": "?%", "delta_gt": ?, "delta_gt_up": ?, "trend_direction": ?, "delta_sign": ">", "mean_mov": "?.?", "mean_mov_percent": "?%", "icon": "https://acarrows.s3.eu-west-1.amazonaws.com/arrows/up.svg" } ], "Code": "C", "Type": "Common Stock", "Name": "Citigroup Inc", "Exchange": "NYSE", "CurrencyCode": "USD", "CurrencyName": "US Dollar", "CurrencySymbol": "$", "CountryName": "USA", "CountryISO": "US", "OpenFigi": "BBG?FY?S?", "ISIN": "US?", "LEI": "?SHGI?ZSSLCXXQSBB?", "PrimaryTicker": "C.US", "CUSIP": "?", "CIK": "?", "EmployerIdNumber": "?-1568099", "FiscalYearEnd": "December", "IPODate": "?-01-03", "InternationalDomestic": "International/Domestic", "Sector": "Financial Services", "Industry": "Banks - Diversified", "GicSector": "Financials", "GicGroup": "Banks", "GicIndustry": "Banks", "GicSubIndustry": "Diversified Banks", "HomeCategory": "Domestic Primary", "IsDelisted": false, "Description": "Citigroup Inc., a diversified financial service holding company, provides various financial product and services to consumers, corporations, governments, and institutions. It operates through five segments: Services, Markets, Banking, U.S. Personal Banking, and Wealth. The Services segment includes treasury and trade solutions, which provides cash management, trade, and working capital solutions to multinational corporations, financial institutions, and public sector organizations; and securities services, such as cross-border support for clients, local market expertise, post-trade technologies, data solutions, and various securities services solutions. The Markets segment offers sales and trading services for equities, foreign exchange, rates, spread products, and commodities to corporate, institutional, and public sector clients; and market-making services, including asset classes, risk management solutions, financing, and prime brokerage. The Banking segment includes investment banking services comprising equity and debt capital markets-related strategic financing solutions; advisory services related to mergers and acquisitions, divestitures, restructurings, and corporate defense activities; and corporate lending consists of corporate and commercial banking. The U.S. Personal Banking segment provides proprietary and co-branded card portfolios; and traditional banking services to retail and small business customers. The Wealth segment offers financial services to high-net-worth clients through banking, lending, mortgages, investment, custody, and trust product offerings; professional industries, including law firms, consulting groups, accounting, and asset management; and affluent and high net worth clients. The company operates in North America, the United Kingdom, Japan, North and South Asia, Australia, Europe, the Middle East, and Africa. Citigroup Inc. was founded in ? and is headquartered in New York, New York.", "Address": "? Greenwich Street, New York, NY, United States, ?", "Phone": "? ? ?", "WebURL": "https://www.citigroup.com", "LogoURL": "https://eodhistoricaldata.com/img/logos/US/c.png", "FullTimeEmployees": ?, "UpdatedAt": "?-12-28", "MarketCapitalization": ?, "MarketCapitalizationMln": ?.?, "EBITDA": null, "PERatio": ?.?, "PEGRatio": ?.?, "WallStreetTargetPrice": ?.?, "BookValue": ?.?, "DividendShare": ?.?, "DividendYield": ?.?, "EarningsShare": ?.?, "EPSEstimateCurrentYear": ?.?, "EPSEstimateNextYear": ?.?, "EPSEstimateNextQuarter": ?.?, "EPSEstimateCurrentQuarter": ?.?, "MostRecentQuarter": "?-09-30", "ProfitMargin": ?.?, "OperatingMarginTTM": ?.?, "ReturnOnAssetsTTM": ?.?, "ReturnOnEquityTTM": ?.?, "RevenueTTM": ?, "RevenuePerShareTTM": ?.?, "QuarterlyRevenueGrowthYOY": ?.?, "GrossProfitTTM": ?, "DilutedEpsTTM": ?.?, "QuarterlyEarningsGrowthYOY": ?.? }, "?": { "earningsimpactid": ?, "sample_size": ?, "impactcompany": "BAC", "impactcompany_name": "Bank of America Corp", "impactcompany_sector": "Financial Services", "impactcompany_industry": "Banks-Diversified", "opportunities": [ { "forecastperiod_trading_days": ?, "id": "delta_gt_up", "probability": "?%", "delta_gt": ?, "delta_gt_up": ?, "trend_direction": ?, "delta_sign": ">", "mean_mov": "?.?", "mean_mov_percent": " ?%", "icon": "https://acarrows.s3.eu-west-1.amazonaws.com/arrows/up.svg" } ], "Code": "BAC", "Type": "Common Stock", "Name": "Bank of America Corp", "Exchange": "NYSE", "CurrencyCode": "USD", "CurrencyName": "US Dollar", "CurrencySymbol": "$", "CountryName": "USA", "CountryISO": "US", "OpenFigi": "BBG?BCTLF?", "ISIN": "US?", "LEI": "?DJT?UXIJIZJI?WXO?", "PrimaryTicker": "BAC.US", "CUSIP": "?", "CIK": "?", "EmployerIdNumber": "?-0906609", "FiscalYearEnd": "December", "IPODate": "?-01-13", "InternationalDomestic": "International/Domestic", "Sector": "Financial Services", "Industry": "Banks - Diversified", "GicSector": "Financials", "GicGroup": "Banks", "GicIndustry": "Banks", "GicSubIndustry": "Diversified Banks", "HomeCategory": "Domestic Primary", "IsDelisted": false, "Description": "Bank of America Corporation, through its subsidiaries, provides various financial products and services for individual consumers, small and middle-market businesses, institutional investors, large corporations, and governments worldwide. The company operates through four segments: Consumer Banking, Global Wealth & Investment Management (GWIM), Global Banking, and Global Markets. The Consumer Banking segment offers traditional and money market savings accounts, certificates of deposit and IRAs, checking accounts, and investment accounts and products; credit and debit cards; residential mortgages and home equity loans; and direct and indirect loans, such as automotive, recreational vehicle, and consumer personal loans. The GWIM segment provides investment management, brokerage, banking, and trust and retirement products and services; wealth management solutions; and customized solutions, including specialty asset management services. The Global Banking segment offers lending products and services, including commercial loans, leases, commitment facilities, trade finance, and commercial real estate and asset-based lending; treasury solutions, such as treasury management, foreign exchange, short-term investing options, and merchant services; working capital management solutions; debt and equity underwriting and distribution, and merger-related and other advisory services; and fixed-income and equity research services. The Global Markets segment provides market-making, financing, securities clearing, settlement, and custody services; securities and derivative products; and risk management products using interest rate, equity, credit, currency and commodity derivatives, foreign exchange, fixed-income, and mortgage-related products. Bank of America Corporation was founded in ? and is based in Charlotte, North Carolina.", "Address": "Bank of America Corporate Center, Charlotte, NC, United States, ?", "Phone": "(?) ?-5681", "WebURL": "https://www.bankofamerica.com", "LogoURL": "https://eodhistoricaldata.com/img/logos/US/bac.png", "FullTimeEmployees": ?, "UpdatedAt": "?-12-28", "MarketCapitalization": ?, "MarketCapitalizationMln": ?.?, "EBITDA": null, "PERatio": ?.?, "PEGRatio": ?.?, "WallStreetTargetPrice": ?.?, "BookValue": ?.?, "DividendShare": ?.?, "DividendYield": ?.?, "EarningsShare": ?.?, "EPSEstimateCurrentYear": ?.?, "EPSEstimateNextYear": ?.?, "EPSEstimateNextQuarter": ?.?, "EPSEstimateCurrentQuarter": ?.?, "MostRecentQuarter": "?-09-30", "ProfitMargin": ?.?, "OperatingMarginTTM": ?.?, "ReturnOnAssetsTTM": ?.?, "ReturnOnEquityTTM": ?.?, "RevenueTTM": ?, "RevenuePerShareTTM": ?.?, "QuarterlyRevenueGrowthYOY": ?.?, "GrossProfitTTM": ?, "DilutedEpsTTM": ?.?, "QuarterlyEarningsGrowthYOY": ?.? }, "?": { "earningsimpactid": "%%OBJNAME?%%earningsimpactid.visible": false, "sample_size": "%%OBJNAME?%%sample_size.visible": false, "impactcompany": "%%OBJNAME?%%impactcompany.visible": false, "impactcompany_name": "%%OBJNAME?%%impactcompany_name.visible": false, "impactcompany_sector": "%%OBJNAME?%%impactcompany_sector.visible": false, "impactcompany_industry": "%%OBJNAME?%%impactcompany_industry.visible": false, "opportunities": "%%OBJNAME?%%opportunities.visible": false, "Code": "%%OBJNAME?%%Code.visible": false, "Type": "%%OBJNAME?%%Type.visible": false, "Name": "%%OBJNAME?%%Name.visible": false, "Exchange": "%%OBJNAME?%%Exchange.visible": false, "CurrencyCode": "%%OBJNAME?%%CurrencyCode.visible": false, "CurrencyName": "%%OBJNAME?%%CurrencyName.visible": false, "CurrencySymbol": "%%OBJNAME?%%CurrencySymbol.visible": false, "CountryName": "%%OBJNAME?%%CountryName.visible": false, "CountryISO": "%%OBJNAME?%%CountryISO.visible": false, "OpenFigi": "%%OBJNAME?%%OpenFigi.visible": false, "ISIN": "%%OBJNAME?%%ISIN.visible": false, "LEI": "%%OBJNAME?%%LEI.visible": false, "PrimaryTicker": "%%OBJNAME?%%PrimaryTicker.visible": false, "CUSIP": "%%OBJNAME?%%CUSIP.visible": false, "CIK": "%%OBJNAME?%%CIK.visible": false, "EmployerIdNumber": "%%OBJNAME?%%EmployerIdNumber.visible": false, "FiscalYearEnd": "%%OBJNAME?%%FiscalYearEnd.visible": false, "IPODate": "%%OBJNAME?%%IPODate.visible": false, "InternationalDomestic": "%%OBJNAME?%%InternationalDomestic.visible": false, "Sector": "%%OBJNAME?%%Sector.visible": false, "Industry": "%%OBJNAME?%%Industry.visible": false, "GicSector": "%%OBJNAME?%%GicSector.visible": false, "GicGroup": "%%OBJNAME?%%GicGroup.visible": false, "GicIndustry": "%%OBJNAME?%%GicIndustry.visible": false, "GicSubIndustry": "%%OBJNAME?%%GicSubIndustry.visible": false, "HomeCategory": "%%OBJNAME?%%HomeCategory.visible": false, "IsDelisted": "%%OBJNAME?%%IsDelisted.visible": false, "Description": "%%OBJNAME?%%Description.visible": false, "Address": "%%OBJNAME?%%Address.visible": false, "Phone": "%%OBJNAME?%%Phone.visible": false, "WebURL": "%%OBJNAME?%%WebURL.visible": false, "LogoURL": "%%OBJNAME?%%LogoURL.visible": false, "FullTimeEmployees": "%%OBJNAME?%%FullTimeEmployees.visible": false, "UpdatedAt": "%%OBJNAME?%%UpdatedAt.visible": false, "MarketCapitalization": "%%OBJNAME?%%MarketCapitalization.visible": false, "MarketCapitalizationMln": "%%OBJNAME?%%MarketCapitalizationMln.visible": false, "EBITDA": "%%OBJNAME?%%EBITDA.visible": false, "PERatio": "%%OBJNAME?%%PERatio.visible": false, "PEGRatio": "%%OBJNAME?%%PEGRatio.visible": false, "WallStreetTargetPrice": "%%OBJNAME?%%WallStreetTargetPrice.visible": false, "BookValue": "%%OBJNAME?%%BookValue.visible": false, "DividendShare": "%%OBJNAME?%%DividendShare.visible": false, "DividendYield": "%%OBJNAME?%%DividendYield.visible": false, "EarningsShare": "%%OBJNAME?%%EarningsShare.visible": false, "EPSEstimateCurrentYear": "%%OBJNAME?%%EPSEstimateCurrentYear.visible": false, "EPSEstimateNextYear": "%%OBJNAME?%%EPSEstimateNextYear.visible": false, "EPSEstimateNextQuarter": "%%OBJNAME?%%EPSEstimateNextQuarter.visible": false, "EPSEstimateCurrentQuarter": "%%OBJNAME?%%EPSEstimateCurrentQuarter.visible": false, "MostRecentQuarter": "%%OBJNAME?%%MostRecentQuarter.visible": false, "ProfitMargin": "%%OBJNAME?%%ProfitMargin.visible": false, "OperatingMarginTTM": "%%OBJNAME?%%OperatingMarginTTM.visible": false, "ReturnOnAssetsTTM": "%%OBJNAME?%%ReturnOnAssetsTTM.visible": false, "ReturnOnEquityTTM": "%%OBJNAME?%%ReturnOnEquityTTM.visible": false, "RevenueTTM": "%%OBJNAME?%%RevenueTTM.visible": false, "RevenuePerShareTTM": "%%OBJNAME?%%RevenuePerShareTTM.visible": false, "QuarterlyRevenueGrowthYOY": "%%OBJNAME?%%QuarterlyRevenueGrowthYOY.visible": false, "GrossProfitTTM": "%%OBJNAME?%%GrossProfitTTM.visible": false, "DilutedEpsTTM": "%%OBJNAME?%%DilutedEpsTTM.visible": false, "QuarterlyEarningsGrowthYOY": "%%OBJNAME?%%QuarterlyEarningsGrowthYOY.visible": false, "Shape.visible": false, "bgshape.visible": false }, "?": { "earningsimpactid": "%%OBJNAME?%%earningsimpactid.visible": false, "sample_size": "%%OBJNAME?%%sample_size.visible": false, "impactcompany": "%%OBJNAME?%%impactcompany.visible": false, "impactcompany_name": "%%OBJNAME?%%impactcompany_name.visible": false, "impactcompany_sector": "%%OBJNAME?%%impactcompany_sector.visible": false, "impactcompany_industry": "%%OBJNAME?%%impactcompany_industry.visible": false, "opportunities": "%%OBJNAME?%%opportunities.visible": false, "Code": "%%OBJNAME?%%Code.visible": false, "Type": "%%OBJNAME?%%Type.visible": false, "Name": "%%OBJNAME?%%Name.visible": false, "Exchange": "%%OBJNAME?%%Exchange.visible": false, "CurrencyCode": "%%OBJNAME?%%CurrencyCode.visible": false, "CurrencyName": "%%OBJNAME?%%CurrencyName.visible": false, "CurrencySymbol": "%%OBJNAME?%%CurrencySymbol.visible": false, "CountryName": "%%OBJNAME?%%CountryName.visible": false, "CountryISO": "%%OBJNAME?%%CountryISO.visible": false, "OpenFigi": "%%OBJNAME?%%OpenFigi.visible": false, "ISIN": "%%OBJNAME?%%ISIN.visible": false, "LEI": "%%OBJNAME?%%LEI.visible": false, "PrimaryTicker": "%%OBJNAME?%%PrimaryTicker.visible": false, "CUSIP": "%%OBJNAME?%%CUSIP.visible": false, "CIK": "%%OBJNAME?%%CIK.visible": false, "EmployerIdNumber": "%%OBJNAME?%%EmployerIdNumber.visible": false, "FiscalYearEnd": "%%OBJNAME?%%FiscalYearEnd.visible": false, "IPODate": "%%OBJNAME?%%IPODate.visible": false, "InternationalDomestic": "%%OBJNAME?%%InternationalDomestic.visible": false, "Sector": "%%OBJNAME?%%Sector.visible": false, "Industry": "%%OBJNAME?%%Industry.visible": false, "GicSector": "%%OBJNAME?%%GicSector.visible": false, "GicGroup": "%%OBJNAME?%%GicGroup.visible": false, "GicIndustry": "%%OBJNAME?%%GicIndustry.visible": false, "GicSubIndustry": "%%OBJNAME?%%GicSubIndustry.visible": false, "HomeCategory": "%%OBJNAME?%%HomeCategory.visible": false, "IsDelisted": "%%OBJNAME?%%IsDelisted.visible": false, "Description": "%%OBJNAME?%%Description.visible": false, "Address": "%%OBJNAME?%%Address.visible": false, "Phone": "%%OBJNAME?%%Phone.visible": false, "WebURL": "%%OBJNAME?%%WebURL.visible": false, "LogoURL": "%%OBJNAME?%%LogoURL.visible": false, "FullTimeEmployees": "%%OBJNAME?%%FullTimeEmployees.visible": false, "UpdatedAt": "%%OBJNAME?%%UpdatedAt.visible": false, "MarketCapitalization": "%%OBJNAME?%%MarketCapitalization.visible": false, "MarketCapitalizationMln": "%%OBJNAME?%%MarketCapitalizationMln.visible": false, "EBITDA": "%%OBJNAME?%%EBITDA.visible": false, "PERatio": "%%OBJNAME?%%PERatio.visible": false, "PEGRatio": "%%OBJNAME?%%PEGRatio.visible": false, "WallStreetTargetPrice": "%%OBJNAME?%%WallStreetTargetPrice.visible": false, "BookValue": "%%OBJNAME?%%BookValue.visible": false, "DividendShare": "%%OBJNAME?%%DividendShare.visible": false, "DividendYield": "%%OBJNAME?%%DividendYield.visible": false, "EarningsShare": "%%OBJNAME?%%EarningsShare.visible": false, "EPSEstimateCurrentYear": "%%OBJNAME?%%EPSEstimateCurrentYear.visible": false, "EPSEstimateNextYear": "%%OBJNAME?%%EPSEstimateNextYear.visible": false, "EPSEstimateNextQuarter": "%%OBJNAME?%%EPSEstimateNextQuarter.visible": false, "EPSEstimateCurrentQuarter": "%%OBJNAME?%%EPSEstimateCurrentQuarter.visible": false, "MostRecentQuarter": "%%OBJNAME?%%MostRecentQuarter.visible": false, "ProfitMargin": "%%OBJNAME?%%ProfitMargin.visible": false, "OperatingMarginTTM": "%%OBJNAME?%%OperatingMarginTTM.visible": false, "ReturnOnAssetsTTM": "%%OBJNAME?%%ReturnOnAssetsTTM.visible": false, "ReturnOnEquityTTM": "%%OBJNAME?%%ReturnOnEquityTTM.visible": false, "RevenueTTM": "%%OBJNAME?%%RevenueTTM.visible": false, "RevenuePerShareTTM": "%%OBJNAME?%%RevenuePerShareTTM.visible": false, "QuarterlyRevenueGrowthYOY": "%%OBJNAME?%%QuarterlyRevenueGrowthYOY.visible": false, "GrossProfitTTM": "%%OBJNAME?%%GrossProfitTTM.visible": false, "DilutedEpsTTM": "%%OBJNAME?%%DilutedEpsTTM.visible": false, "QuarterlyEarningsGrowthYOY": "%%OBJNAME?%%QuarterlyEarningsGrowthYOY.visible": false, "Shape.visible": false, "bgshape.visible": false }, "?": { "earningsimpactid": "%%OBJNAME?%%earningsimpactid.visible": false, "sample_size": "%%OBJNAME?%%sample_size.visible": false, "impactcompany": "%%OBJNAME?%%impactcompany.visible": false, "impactcompany_name": "%%OBJNAME?%%impactcompany_name.visible": false, "impactcompany_sector": "%%OBJNAME?%%impactcompany_sector.visible": false, "impactcompany_industry": "%%OBJNAME?%%impactcompany_industry.visible": false, "opportunities": "%%OBJNAME?%%opportunities.visible": false, "Code": "%%OBJNAME?%%Code.visible": false, "Type": "%%OBJNAME?%%Type.visible": false, "Name": "%%OBJNAME?%%Name.visible": false, "Exchange": "%%OBJNAME?%%Exchange.visible": false, "CurrencyCode": "%%OBJNAME?%%CurrencyCode.visible": false, "CurrencyName": "%%OBJNAME?%%CurrencyName.visible": false, "CurrencySymbol": "%%OBJNAME?%%CurrencySymbol.visible": false, "CountryName": "%%OBJNAME?%%CountryName.visible": false, "CountryISO": "%%OBJNAME?%%CountryISO.visible": false, "OpenFigi": "%%OBJNAME?%%OpenFigi.visible": false, "ISIN": "%%OBJNAME?%%ISIN.visible": false, "LEI": "%%OBJNAME?%%LEI.visible": false, "PrimaryTicker": "%%OBJNAME?%%PrimaryTicker.visible": false, "CUSIP": "%%OBJNAME?%%CUSIP.visible": false, "CIK": "%%OBJNAME?%%CIK.visible": false, "EmployerIdNumber": "%%OBJNAME?%%EmployerIdNumber.visible": false, "FiscalYearEnd": "%%OBJNAME?%%FiscalYearEnd.visible": false, "IPODate": "%%OBJNAME?%%IPODate.visible": false, "InternationalDomestic": "%%OBJNAME?%%InternationalDomestic.visible": false, "Sector": "%%OBJNAME?%%Sector.visible": false, "Industry": "%%OBJNAME?%%Industry.visible": false, "GicSector": "%%OBJNAME?%%GicSector.visible": false, "GicGroup": "%%OBJNAME?%%GicGroup.visible": false, "GicIndustry": "%%OBJNAME?%%GicIndustry.visible": false, "GicSubIndustry": "%%OBJNAME?%%GicSubIndustry.visible": false, "HomeCategory": "%%OBJNAME?%%HomeCategory.visible": false, "IsDelisted": "%%OBJNAME?%%IsDelisted.visible": false, "Description": "%%OBJNAME?%%Description.visible": false, "Address": "%%OBJNAME?%%Address.visible": false, "Phone": "%%OBJNAME?%%Phone.visible": false, "WebURL": "%%OBJNAME?%%WebURL.visible": false, "LogoURL": "%%OBJNAME?%%LogoURL.visible": false, "FullTimeEmployees": "%%OBJNAME?%%FullTimeEmployees.visible": false, "UpdatedAt": "%%OBJNAME?%%UpdatedAt.visible": false, "MarketCapitalization": "%%OBJNAME?%%MarketCapitalization.visible": false, "MarketCapitalizationMln": "%%OBJNAME?%%MarketCapitalizationMln.visible": false, "EBITDA": "%%OBJNAME?%%EBITDA.visible": false, "PERatio": "%%OBJNAME?%%PERatio.visible": false, "PEGRatio": "%%OBJNAME?%%PEGRatio.visible": false, "WallStreetTargetPrice": "%%OBJNAME?%%WallStreetTargetPrice.visible": false, "BookValue": "%%OBJNAME?%%BookValue.visible": false, "DividendShare": "%%OBJNAME?%%DividendShare.visible": false, "DividendYield": "%%OBJNAME?%%DividendYield.visible": false, "EarningsShare": "%%OBJNAME?%%EarningsShare.visible": false, "EPSEstimateCurrentYear": "%%OBJNAME?%%EPSEstimateCurrentYear.visible": false, "EPSEstimateNextYear": "%%OBJNAME?%%EPSEstimateNextYear.visible": false, "EPSEstimateNextQuarter": "%%OBJNAME?%%EPSEstimateNextQuarter.visible": false, "EPSEstimateCurrentQuarter": "%%OBJNAME?%%EPSEstimateCurrentQuarter.visible": false, "MostRecentQuarter": "%%OBJNAME?%%MostRecentQuarter.visible": false, "ProfitMargin": "%%OBJNAME?%%ProfitMargin.visible": false, "OperatingMarginTTM": "%%OBJNAME?%%OperatingMarginTTM.visible": false, "ReturnOnAssetsTTM": "%%OBJNAME?%%ReturnOnAssetsTTM.visible": false, "ReturnOnEquityTTM": "%%OBJNAME?%%ReturnOnEquityTTM.visible": false, "RevenueTTM": "%%OBJNAME?%%RevenueTTM.visible": false, "RevenuePerShareTTM": "%%OBJNAME?%%RevenuePerShareTTM.visible": false, "QuarterlyRevenueGrowthYOY": "%%OBJNAME?%%QuarterlyRevenueGrowthYOY.visible": false, "GrossProfitTTM": "%%OBJNAME?%%GrossProfitTTM.visible": false, "DilutedEpsTTM": "%%OBJNAME?%%DilutedEpsTTM.visible": false, "QuarterlyEarningsGrowthYOY": "%%OBJNAME?%%QuarterlyEarningsGrowthYOY.visible": false, "Shape.visible": false, "bgshape.visible": false }, "?": { "earningsimpactid": "%%OBJNAME?%%earningsimpactid.visible": false, "sample_size": "%%OBJNAME?%%sample_size.visible": false, "impactcompany": "%%OBJNAME?%%impactcompany.visible": false, "impactcompany_name": "%%OBJNAME?%%impactcompany_name.visible": false, "impactcompany_sector": "%%OBJNAME?%%impactcompany_sector.visible": false, "impactcompany_industry": "%%OBJNAME?%%impactcompany_industry.visible": false, "opportunities": "%%OBJNAME?%%opportunities.visible": false, "Code": "%%OBJNAME?%%Code.visible": false, "Type": "%%OBJNAME?%%Type.visible": false, "Name": "%%OBJNAME?%%Name.visible": false, "Exchange": "%%OBJNAME?%%Exchange.visible": false, "CurrencyCode": "%%OBJNAME?%%CurrencyCode.visible": false, "CurrencyName": "%%OBJNAME?%%CurrencyName.visible": false, "CurrencySymbol": "%%OBJNAME?%%CurrencySymbol.visible": false, "CountryName": "%%OBJNAME?%%CountryName.visible": false, "CountryISO": "%%OBJNAME?%%CountryISO.visible": false, "OpenFigi": "%%OBJNAME?%%OpenFigi.visible": false, "ISIN": "%%OBJNAME?%%ISIN.visible": false, "LEI": "%%OBJNAME?%%LEI.visible": false, "PrimaryTicker": "%%OBJNAME?%%PrimaryTicker.visible": false, "CUSIP": "%%OBJNAME?%%CUSIP.visible": false, "CIK": "%%OBJNAME?%%CIK.visible": false, "EmployerIdNumber": "%%OBJNAME?%%EmployerIdNumber.visible": false, "FiscalYearEnd": "%%OBJNAME?%%FiscalYearEnd.visible": false, "IPODate": "%%OBJNAME?%%IPODate.visible": false, "InternationalDomestic": "%%OBJNAME?%%InternationalDomestic.visible": false, "Sector": "%%OBJNAME?%%Sector.visible": false, "Industry": "%%OBJNAME?%%Industry.visible": false, "GicSector": "%%OBJNAME?%%GicSector.visible": false, "GicGroup": "%%OBJNAME?%%GicGroup.visible": false, "GicIndustry": "%%OBJNAME?%%GicIndustry.visible": false, "GicSubIndustry": "%%OBJNAME?%%GicSubIndustry.visible": false, "HomeCategory": "%%OBJNAME?%%HomeCategory.visible": false, "IsDelisted": "%%OBJNAME?%%IsDelisted.visible": false, "Description": "%%OBJNAME?%%Description.visible": false, "Address": "%%OBJNAME?%%Address.visible": false, "Phone": "%%OBJNAME?%%Phone.visible": false, "WebURL": "%%OBJNAME?%%WebURL.visible": false, "LogoURL": "%%OBJNAME?%%LogoURL.visible": false, "FullTimeEmployees": "%%OBJNAME?%%FullTimeEmployees.visible": false, "UpdatedAt": "%%OBJNAME?%%UpdatedAt.visible": false, "MarketCapitalization": "%%OBJNAME?%%MarketCapitalization.visible": false, "MarketCapitalizationMln": "%%OBJNAME?%%MarketCapitalizationMln.visible": false, "EBITDA": "%%OBJNAME?%%EBITDA.visible": false, "PERatio": "%%OBJNAME?%%PERatio.visible": false, "PEGRatio": "%%OBJNAME?%%PEGRatio.visible": false, "WallStreetTargetPrice": "%%OBJNAME?%%WallStreetTargetPrice.visible": false, "BookValue": "%%OBJNAME?%%BookValue.visible": false, "DividendShare": "%%OBJNAME?%%DividendShare.visible": false, "DividendYield": "%%OBJNAME?%%DividendYield.visible": false, "EarningsShare": "%%OBJNAME?%%EarningsShare.visible": false, "EPSEstimateCurrentYear": "%%OBJNAME?%%EPSEstimateCurrentYear.visible": false, "EPSEstimateNextYear": "%%OBJNAME?%%EPSEstimateNextYear.visible": false, "EPSEstimateNextQuarter": "%%OBJNAME?%%EPSEstimateNextQuarter.visible": false, "EPSEstimateCurrentQuarter": "%%OBJNAME?%%EPSEstimateCurrentQuarter.visible": false, "MostRecentQuarter": "%%OBJNAME?%%MostRecentQuarter.visible": false, "ProfitMargin": "%%OBJNAME?%%ProfitMargin.visible": false, "OperatingMarginTTM": "%%OBJNAME?%%OperatingMarginTTM.visible": false, "ReturnOnAssetsTTM": "%%OBJNAME?%%ReturnOnAssetsTTM.visible": false, "ReturnOnEquityTTM": "%%OBJNAME?%%ReturnOnEquityTTM.visible": false, "RevenueTTM": "%%OBJNAME?%%RevenueTTM.visible": false, "RevenuePerShareTTM": "%%OBJNAME?%%RevenuePerShareTTM.visible": false, "QuarterlyRevenueGrowthYOY": "%%OBJNAME?%%QuarterlyRevenueGrowthYOY.visible": false, "GrossProfitTTM": "%%OBJNAME?%%GrossProfitTTM.visible": false, "DilutedEpsTTM": "%%OBJNAME?%%DilutedEpsTTM.visible": false, "QuarterlyEarningsGrowthYOY": "%%OBJNAME?%%QuarterlyEarningsGrowthYOY.visible": false, "Shape.visible": false, "bgshape.visible": false }, "?": { "earningsimpactid": "%%OBJNAME?%%earningsimpactid.visible": false, "sample_size": "%%OBJNAME?%%sample_size.visible": false, "impactcompany": "%%OBJNAME?%%impactcompany.visible": false, "impactcompany_name": "%%OBJNAME?%%impactcompany_name.visible": false, "impactcompany_sector": "%%OBJNAME?%%impactcompany_sector.visible": false, "impactcompany_industry": "%%OBJNAME?%%impactcompany_industry.visible": false, "opportunities": "%%OBJNAME?%%opportunities.visible": false, "Code": "%%OBJNAME?%%Code.visible": false, "Type": "%%OBJNAME?%%Type.visible": false, "Name": "%%OBJNAME?%%Name.visible": false, "Exchange": "%%OBJNAME?%%Exchange.visible": false, "CurrencyCode": "%%OBJNAME?%%CurrencyCode.visible": false, "CurrencyName": "%%OBJNAME?%%CurrencyName.visible": false, "CurrencySymbol": "%%OBJNAME?%%CurrencySymbol.visible": false, "CountryName": "%%OBJNAME?%%CountryName.visible": false, "CountryISO": "%%OBJNAME?%%CountryISO.visible": false, "OpenFigi": "%%OBJNAME?%%OpenFigi.visible": false, "ISIN": "%%OBJNAME?%%ISIN.visible": false, "LEI": "%%OBJNAME?%%LEI.visible": false, "PrimaryTicker": "%%OBJNAME?%%PrimaryTicker.visible": false, "CUSIP": "%%OBJNAME?%%CUSIP.visible": false, "CIK": "%%OBJNAME?%%CIK.visible": false, "EmployerIdNumber": "%%OBJNAME?%%EmployerIdNumber.visible": false, "FiscalYearEnd": "%%OBJNAME?%%FiscalYearEnd.visible": false, "IPODate": "%%OBJNAME?%%IPODate.visible": false, "InternationalDomestic": "%%OBJNAME?%%InternationalDomestic.visible": false, "Sector": "%%OBJNAME?%%Sector.visible": false, "Industry": "%%OBJNAME?%%Industry.visible": false, "GicSector": "%%OBJNAME?%%GicSector.visible": false, "GicGroup": "%%OBJNAME?%%GicGroup.visible": false, "GicIndustry": "%%OBJNAME?%%GicIndustry.visible": false, "GicSubIndustry": "%%OBJNAME?%%GicSubIndustry.visible": false, "HomeCategory": "%%OBJNAME?%%HomeCategory.visible": false, "IsDelisted": "%%OBJNAME?%%IsDelisted.visible": false, "Description": "%%OBJNAME?%%Description.visible": false, "Address": "%%OBJNAME?%%Address.visible": false, "Phone": "%%OBJNAME?%%Phone.visible": false, "WebURL": "%%OBJNAME?%%WebURL.visible": false, "LogoURL": "%%OBJNAME?%%LogoURL.visible": false, "FullTimeEmployees": "%%OBJNAME?%%FullTimeEmployees.visible": false, "UpdatedAt": "%%OBJNAME?%%UpdatedAt.visible": false, "MarketCapitalization": "%%OBJNAME?%%MarketCapitalization.visible": false, "MarketCapitalizationMln": "%%OBJNAME?%%MarketCapitalizationMln.visible": false, "EBITDA": "%%OBJNAME?%%EBITDA.visible": false, "PERatio": "%%OBJNAME?%%PERatio.visible": false, "PEGRatio": "%%OBJNAME?%%PEGRatio.visible": false, "WallStreetTargetPrice": "%%OBJNAME?%%WallStreetTargetPrice.visible": false, "BookValue": "%%OBJNAME?%%BookValue.visible": false, "DividendShare": "%%OBJNAME?%%DividendShare.visible": false, "DividendYield": "%%OBJNAME?%%DividendYield.visible": false, "EarningsShare": "%%OBJNAME?%%EarningsShare.visible": false, "EPSEstimateCurrentYear": "%%OBJNAME?%%EPSEstimateCurrentYear.visible": false, "EPSEstimateNextYear": "%%OBJNAME?%%EPSEstimateNextYear.visible": false, "EPSEstimateNextQuarter": "%%OBJNAME?%%EPSEstimateNextQuarter.visible": false, "EPSEstimateCurrentQuarter": "%%OBJNAME?%%EPSEstimateCurrentQuarter.visible": false, "MostRecentQuarter": "%%OBJNAME?%%MostRecentQuarter.visible": false, "ProfitMargin": "%%OBJNAME?%%ProfitMargin.visible": false, "OperatingMarginTTM": "%%OBJNAME?%%OperatingMarginTTM.visible": false, "ReturnOnAssetsTTM": "%%OBJNAME?%%ReturnOnAssetsTTM.visible": false, "ReturnOnEquityTTM": "%%OBJNAME?%%ReturnOnEquityTTM.visible": false, "RevenueTTM": "%%OBJNAME?%%RevenueTTM.visible": false, "RevenuePerShareTTM": "%%OBJNAME?%%RevenuePerShareTTM.visible": false, "QuarterlyRevenueGrowthYOY": "%%OBJNAME?%%QuarterlyRevenueGrowthYOY.visible": false, "GrossProfitTTM": "%%OBJNAME?%%GrossProfitTTM.visible": false, "DilutedEpsTTM": "%%OBJNAME?%%DilutedEpsTTM.visible": false, "QuarterlyEarningsGrowthYOY": "%%OBJNAME?%%QuarterlyEarningsGrowthYOY.visible": false, "Shape.visible": false, "bgshape.visible": false }, "?": { "earningsimpactid": "%%OBJNAME?%%earningsimpactid.visible": false, "sample_size": "%%OBJNAME?%%sample_size.visible": false, "impactcompany": "%%OBJNAME?%%impactcompany.visible": false, "impactcompany_name": "%%OBJNAME?%%impactcompany_name.visible": false, "impactcompany_sector": "%%OBJNAME?%%impactcompany_sector.visible": false, "impactcompany_industry": "%%OBJNAME?%%impactcompany_industry.visible": false, "opportunities": "%%OBJNAME?%%opportunities.visible": false, "Code": "%%OBJNAME?%%Code.visible": false, "Type": "%%OBJNAME?%%Type.visible": false, "Name": "%%OBJNAME?%%Name.visible": false, "Exchange": "%%OBJNAME?%%Exchange.visible": false, "CurrencyCode": "%%OBJNAME?%%CurrencyCode.visible": false, "CurrencyName": "%%OBJNAME?%%CurrencyName.visible": false, "CurrencySymbol": "%%OBJNAME?%%CurrencySymbol.visible": false, "CountryName": "%%OBJNAME?%%CountryName.visible": false, "CountryISO": "%%OBJNAME?%%CountryISO.visible": false, "OpenFigi": "%%OBJNAME?%%OpenFigi.visible": false, "ISIN": "%%OBJNAME?%%ISIN.visible": false, "LEI": "%%OBJNAME?%%LEI.visible": false, "PrimaryTicker": "%%OBJNAME?%%PrimaryTicker.visible": false, "CUSIP": "%%OBJNAME?%%CUSIP.visible": false, "CIK": "%%OBJNAME?%%CIK.visible": false, "EmployerIdNumber": "%%OBJNAME?%%EmployerIdNumber.visible": false, "FiscalYearEnd": "%%OBJNAME?%%FiscalYearEnd.visible": false, "IPODate": "%%OBJNAME?%%IPODate.visible": false, "InternationalDomestic": "%%OBJNAME?%%InternationalDomestic.visible": false, "Sector": "%%OBJNAME?%%Sector.visible": false, "Industry": "%%OBJNAME?%%Industry.visible": false, "GicSector": "%%OBJNAME?%%GicSector.visible": false, "GicGroup": "%%OBJNAME?%%GicGroup.visible": false, "GicIndustry": "%%OBJNAME?%%GicIndustry.visible": false, "GicSubIndustry": "%%OBJNAME?%%GicSubIndustry.visible": false, "HomeCategory": "%%OBJNAME?%%HomeCategory.visible": false, "IsDelisted": "%%OBJNAME?%%IsDelisted.visible": false, "Description": "%%OBJNAME?%%Description.visible": false, "Address": "%%OBJNAME?%%Address.visible": false, "Phone": "%%OBJNAME?%%Phone.visible": false, "WebURL": "%%OBJNAME?%%WebURL.visible": false, "LogoURL": "%%OBJNAME?%%LogoURL.visible": false, "FullTimeEmployees": "%%OBJNAME?%%FullTimeEmployees.visible": false, "UpdatedAt": "%%OBJNAME?%%UpdatedAt.visible": false, "MarketCapitalization": "%%OBJNAME?%%MarketCapitalization.visible": false, "MarketCapitalizationMln": "%%OBJNAME?%%MarketCapitalizationMln.visible": false, "EBITDA": "%%OBJNAME?%%EBITDA.visible": false, "PERatio": "%%OBJNAME?%%PERatio.visible": false, "PEGRatio": "%%OBJNAME?%%PEGRatio.visible": false, "WallStreetTargetPrice": "%%OBJNAME?%%WallStreetTargetPrice.visible": false, "BookValue": "%%OBJNAME?%%BookValue.visible": false, "DividendShare": "%%OBJNAME?%%DividendShare.visible": false, "DividendYield": "%%OBJNAME?%%DividendYield.visible": false, "EarningsShare": "%%OBJNAME?%%EarningsShare.visible": false, "EPSEstimateCurrentYear": "%%OBJNAME?%%EPSEstimateCurrentYear.visible": false, "EPSEstimateNextYear": "%%OBJNAME?%%EPSEstimateNextYear.visible": false, "EPSEstimateNextQuarter": "%%OBJNAME?%%EPSEstimateNextQuarter.visible": false, "EPSEstimateCurrentQuarter": "%%OBJNAME?%%EPSEstimateCurrentQuarter.visible": false, "MostRecentQuarter": "%%OBJNAME?%%MostRecentQuarter.visible": false, "ProfitMargin": "%%OBJNAME?%%ProfitMargin.visible": false, "OperatingMarginTTM": "%%OBJNAME?%%OperatingMarginTTM.visible": false, "ReturnOnAssetsTTM": "%%OBJNAME?%%ReturnOnAssetsTTM.visible": false, "ReturnOnEquityTTM": "%%OBJNAME?%%ReturnOnEquityTTM.visible": false, "RevenueTTM": "%%OBJNAME?%%RevenueTTM.visible": false, "RevenuePerShareTTM": "%%OBJNAME?%%RevenuePerShareTTM.visible": false, "QuarterlyRevenueGrowthYOY": "%%OBJNAME?%%QuarterlyRevenueGrowthYOY.visible": false, "GrossProfitTTM": "%%OBJNAME?%%GrossProfitTTM.visible": false, "DilutedEpsTTM": "%%OBJNAME?%%DilutedEpsTTM.visible": false, "QuarterlyEarningsGrowthYOY": "%%OBJNAME?%%QuarterlyEarningsGrowthYOY.visible": false, "Shape.visible": false, "bgshape.visible": false }, "?": { "earningsimpactid": "%%OBJNAME?%%earningsimpactid.visible": false, "sample_size": "%%OBJNAME?%%sample_size.visible": false, "impactcompany": "%%OBJNAME?%%impactcompany.visible": false, "impactcompany_name": "%%OBJNAME?%%impactcompany_name.visible": false, "impactcompany_sector": "%%OBJNAME?%%impactcompany_sector.visible": false, "impactcompany_industry": "%%OBJNAME?%%impactcompany_industry.visible": false, "opportunities": "%%OBJNAME?%%opportunities.visible": false, "Code": "%%OBJNAME?%%Code.visible": false, "Type": "%%OBJNAME?%%Type.visible": false, "Name": "%%OBJNAME?%%Name.visible": false, "Exchange": "%%OBJNAME?%%Exchange.visible": false, "CurrencyCode": "%%OBJNAME?%%CurrencyCode.visible": false, "CurrencyName": "%%OBJNAME?%%CurrencyName.visible": false, "CurrencySymbol": "%%OBJNAME?%%CurrencySymbol.visible": false, "CountryName": "%%OBJNAME?%%CountryName.visible": false, "CountryISO": "%%OBJNAME?%%CountryISO.visible": false, "OpenFigi": "%%OBJNAME?%%OpenFigi.visible": false, "ISIN": "%%OBJNAME?%%ISIN.visible": false, "LEI": "%%OBJNAME?%%LEI.visible": false, "PrimaryTicker": "%%OBJNAME?%%PrimaryTicker.visible": false, "CUSIP": "%%OBJNAME?%%CUSIP.visible": false, "CIK": "%%OBJNAME?%%CIK.visible": false, "EmployerIdNumber": "%%OBJNAME?%%EmployerIdNumber.visible": false, "FiscalYearEnd": "%%OBJNAME?%%FiscalYearEnd.visible": false, "IPODate": "%%OBJNAME?%%IPODate.visible": false, "InternationalDomestic": "%%OBJNAME?%%InternationalDomestic.visible": false, "Sector": "%%OBJNAME?%%Sector.visible": false, "Industry": "%%OBJNAME?%%Industry.visible": false, "GicSector": "%%OBJNAME?%%GicSector.visible": false, "GicGroup": "%%OBJNAME?%%GicGroup.visible": false, "GicIndustry": "%%OBJNAME?%%GicIndustry.visible": false, "GicSubIndustry": "%%OBJNAME?%%GicSubIndustry.visible": false, "HomeCategory": "%%OBJNAME?%%HomeCategory.visible": false, "IsDelisted": "%%OBJNAME?%%IsDelisted.visible": false, "Description": "%%OBJNAME?%%Description.visible": false, "Address": "%%OBJNAME?%%Address.visible": false, "Phone": "%%OBJNAME?%%Phone.visible": false, "WebURL": "%%OBJNAME?%%WebURL.visible": false, "LogoURL": "%%OBJNAME?%%LogoURL.visible": false, "FullTimeEmployees": "%%OBJNAME?%%FullTimeEmployees.visible": false, "UpdatedAt": "%%OBJNAME?%%UpdatedAt.visible": false, "MarketCapitalization": "%%OBJNAME?%%MarketCapitalization.visible": false, "MarketCapitalizationMln": "%%OBJNAME?%%MarketCapitalizationMln.visible": false, "EBITDA": "%%OBJNAME?%%EBITDA.visible": false, "PERatio": "%%OBJNAME?%%PERatio.visible": false, "PEGRatio": "%%OBJNAME?%%PEGRatio.visible": false, "WallStreetTargetPrice": "%%OBJNAME?%%WallStreetTargetPrice.visible": false, "BookValue": "%%OBJNAME?%%BookValue.visible": false, "DividendShare": "%%OBJNAME?%%DividendShare.visible": false, "DividendYield": "%%OBJNAME?%%DividendYield.visible": false, "EarningsShare": "%%OBJNAME?%%EarningsShare.visible": false, "EPSEstimateCurrentYear": "%%OBJNAME?%%EPSEstimateCurrentYear.visible": false, "EPSEstimateNextYear": "%%OBJNAME?%%EPSEstimateNextYear.visible": false, "EPSEstimateNextQuarter": "%%OBJNAME?%%EPSEstimateNextQuarter.visible": false, "EPSEstimateCurrentQuarter": "%%OBJNAME?%%EPSEstimateCurrentQuarter.visible": false, "MostRecentQuarter": "%%OBJNAME?%%MostRecentQuarter.visible": false, "ProfitMargin": "%%OBJNAME?%%ProfitMargin.visible": false, "OperatingMarginTTM": "%%OBJNAME?%%OperatingMarginTTM.visible": false, "ReturnOnAssetsTTM": "%%OBJNAME?%%ReturnOnAssetsTTM.visible": false, "ReturnOnEquityTTM": "%%OBJNAME?%%ReturnOnEquityTTM.visible": false, "RevenueTTM": "%%OBJNAME?%%RevenueTTM.visible": false, "RevenuePerShareTTM": "%%OBJNAME?%%RevenuePerShareTTM.visible": false, "QuarterlyRevenueGrowthYOY": "%%OBJNAME?%%QuarterlyRevenueGrowthYOY.visible": false, "GrossProfitTTM": "%%OBJNAME?%%GrossProfitTTM.visible": false, "DilutedEpsTTM": "%%OBJNAME?%%DilutedEpsTTM.visible": false, "QuarterlyEarningsGrowthYOY": "%%OBJNAME?%%QuarterlyEarningsGrowthYOY.visible": false, "Shape.visible": false, "bgshape.visible": false } } }, "text": { "title": "\u062a\u0623\u062b\u06cc\u0631 \u0627\u0646\u062a\u0634\u0627\u0631 \u06af\u0632\u0627\u0631\u0634 \u0633\u0648\u062f JPMorgan Chase & Co (JPM)", "short_text": "JPMorgan Chase & Co (JPM) \u0627\u0645\u0631\u0648\u0632 \u06af\u0632\u0627\u0631\u0634 \u0633\u0648\u062f \u062e\u0648\u062f \u0631\u0627 \u0645\u0646\u062a\u0634\u0631 \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u0628\u0631 \u0633\u0647\u0627\u0645 \u0632\u06cc\u0631 \u062a\u0623\u062b\u06cc\u0631 \u062e\u0648\u0627\u0647\u062f \u06af\u0630\u0627\u0634\u062a:\n- Wells Fargo & Company (WFC)\n- Citigroup Inc (C)\n- Bank of America Corp (BAC)\n", "long_text": "\u0634\u0631\u06a9\u062a jpmorgan chase & co (jpm) \u0627\u0645\u0631\u0648\u0632 \u06af\u0632\u0627\u0631\u0634 \u062f\u0631\u0622\u0645\u062f \u062e\u0648\u062f \u0631\u0627 \u0645\u0646\u062a\u0634\u0631 \u0645\u06cc\u200c\u06a9\u0646\u062f.\n\u0648\u0642\u062a\u06cc \u0633\u0648\u062f \u0647\u0631 \u0633\u0647\u0645 (eps) > \u0627\u0632 \u0645\u0642\u062f\u0627\u0631 \u067e\u06cc\u0634 \u200c\u0628\u06cc\u0646\u06cc\u200c \u0634\u062f\u0647 \[...];

select system_identifier from pg_control_system ();

select groupid, exchange, groupname, symbol, longname from prfsymboltree where brokerid = ? order by groupname, symbol;

insert into t15 (symbolid, pricedatetime, open, high, low, close, volume, bsf, sastdatetimereceived) values (?, ?::timestamp without time zone, ?, ?.?, ?.?, ?.?, ?, ?, ?::timestamp without time zone) on conflict (symbolid, pricedatetime) do nothing;

select "public"."processes"."id" AS "id", "public"."processes"."locale" AS "locale", "public"."processes"."region" AS "region", "public"."processes"."schedule" AS "schedule", "public"."processes"."enabled" AS "enabled", "public"."processes"."live" AS "live", "public"."processes"."lastmodified" AS "lastmodified", "public"."processes"."lastrun" AS "lastrun", "public"."processes"."contenttypeid" AS "contenttypeid", "public"."processes"."brokerid" AS "brokerid", "public"."processes"."uuid" AS "uuid", "LT?"."name" AS "LA?", "LT?"."name" AS "LA?" from "public"."processes" left outer join "public"."brokers" "LT?" on "LT?"."id" = "public"."processes"."brokerid" left outer join "public"."contenttypes" "LT?" on "LT?"."id" = "public"."processes"."contenttypeid" where (brokerid = ?) and (contenttypeid = ?) order by "public"."processes"."id" asc limit ? offset ?;

select updatedatafeedslatestrun (?);

insert into t15 (symbolid, pricedatetime, open, high, low, close, volume, bsf, sastdatetimereceived) values (?, ?::timestamp without time zone, ?.?, ?.?, ?.?, ?, ?, ?, ?::timestamp without time zone) on conflict (symbolid, pricedatetime) do nothing;

select ?;

select distinct on (coalesce(bim.code, s.symbol) , s.exchange, s.timegranularity, df.timezone) s.symbolid as id, coalesce(bim.code, s.symbol) as name, s.symbol as symbol, dss.downloadersymbol as ticker, s.exchange as exchange, s.timegranularity as interval, df.timezone as timezone from symbols s inner join downloadersymbolsettings dss on dss.symbolid = s.symbolid inner join datafeedstimetable df on df.classname ilike dss.classname left join brokersymbollist bsl on bsl.brokerid = ? and bsl.symbolid = s.symbolid left outer join brokerinstrumentmap bim on dss.datafeedinstrumentid = bim.datafeedinstrumentid and bim.brokerid = ? and bim.type = ? where s.symbolid = ?;

select s.symbolid as id, s.symbol as name, s.exchange as exchange, s.timegranularity as interval, dtt.timezone as timezone from symbols s inner join downloadersymbolsettings dss on dss.symbolid = s.symbolid inner join datafeedstimetable dtt on dss.classname = dtt.classname and dtt.dayofweek = ? inner join brokersymbollist bsl on bsl.symbolid = s.symbolid where bsl.brokerid = ? and (? = ? or s.timegranularity = ?) and (s.symbol = ? or dss.downloadersymbol = ?) and dss.enabled = ?;

insert into executionlogs (executionid, status, message, details, detailtype) values (null, ?, ?, null, null);

insert into t15 (pricedatetime, open, high, low, close, volume, symbolid, bsf, sastdatetimewritten, sastdatetimereceived) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) on conflict (pricedatetime, symbolid) do update set open = ?, high = ?, low = ?, close = ?, volume = ?, bsf = ?, sastdatetimewritten = ?, sastdatetimereceived = ?;

insert into keylevels_results (bandwidth, breakout, patternid, gmttimefound, approachingtimestamp, approachingregion, qtytp, patternlengthbars, patternprice, x0, x1, x2, x3, x4, x5, x6, x7, x8, x9, breakoutbars, breakoutprice, patternendtime, atbaridentified, atpriceidentified, errormargin, direction, symbolid, predictionpricefrom, predictionpriceto, predictiontimefrom, predictiontimebars, uniquepointsvalue, furthestprice, relevancestartdistance, patternclassid, patternstarttime, stoplosslevel, simulation, writtendatetime) values (?.?, ?, ?, ?::timestamp without time zone, ?, ?.?, ?, ?, ?.?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?.?, ?::timestamp without time zone, ?, ?.?, ?.?, ?, ?, ?.?, ?.?, ?::timestamp without time zone, ?, ?, ?.?, ?.?, ?, ?, ?.?, ?, current_timestamp::timestamp without time zone) on conflict do nothing;

insert into autochartist_results (resultid, symbolid, bandwidth, pattern, qtytp, gmttimefound, direction, initialtrend, breakout, volumeincrease, noise, symmetry, predictionpricefrom, predictionpriceto, predictiontimefrom, predictiontimeto, patternstarttime, patternendtime, patternstartprice, patternendprice, resx0, resx1, supportx0, supportx1, resy0, resy1, supporty0, supporty1, supportgradient, resgradient, riskreward, patternquality, trendchange, maxmovementafterbreakout, latestbaratbreakouttime, latestbaratbreakoutprice, patternlengthbars, temporarypattern, relevancestartdistance, simulation, writtendatetime) values (?, ?, ?.?, ?, ?, ?::timestamp without time zone, ?, ?.?, ?.?, ?.?, ?.?, ?.?, ?.?, ?.?, ?::timestamp without time zone, ?::timestamp without time zone, ?::timestamp without time zone, ?::timestamp without time zone, ?.?, ?.?, ?::timestamp without time zone, ?::timestamp without time zone, ?::timestamp without time zone, ?::timestamp without time zone, ?.?, ?.?, ?.?, ?.?, ?.?, ?.?, ?.?, ?.?, ?, ?.?, ?::timestamp without time zone, ?.?, ?, ?, ?.?, ?, current_timestamp::timestamp without time zone) on conflict do nothing;