History
The name of the Wealthsimple Engineering Org that the Securities Data team was a part of from September 2022 to January 2023
What is DIY Pro?
The 2 columns in the SM3 Database concatenated to form the symbol for a Canadian Mutual Fund
What is manufacturer_id and fund_code?
None, Price return and All
What are the 3 types of adjustment methods available for historical pricing?
These are the 5 listing impact attributes handled by SM3’s corporate actions processor
What are ISIN, CUSIP, Symbol, MIC and listing status changes?
2 hours, according to the FDA
How long can food be left out in the open?
The person who has created the highest number of commits to the security-master-3 repository
Who is Kyrylo?
These are all the eligible exchanges when determining Wealthsimple trade eligibility
What is NYSE, NASDAQ, BATS, CSE, NEOE, TSE and TSX-V?
When looking at a security's 1 Day graph, the first data point is shown at this time of day.
What is 9.50 am?
This is the stock dividend ratio that resulted in TSLA closing price of $400 to be adjusted to $100 as of August 25th, 2023.
What is 3 for 1 stock dividend ratio?
This service, owned by the securities data team, downloads PDFs from FundData API and uploads them to S3.
What is fund-fact-sheets?
The 4th product manager of the Securities Data domain
Who is Lily Liao?
708
What is the source ID of the ICE Options feed?
This is ratio used to calculate the underlying spot price for BCDA’s option chain where the deliverables for a single contract is:
What is 0.066667?
A field updated in SM3 by oracle-interface each morning using a text-based report containing a list of isins as the source of truth.
What is CDS eligible field?
The custodian firm used by the WS UK business. This firm handled the custody and investments of client money, while Wealthsimple owned the account opening process.
What was SEI?
Assets excluded from the tax-sheltered benefits of a TFSA are identified in SM3 based on a monthly operations process.
What are Non-qualified investments?
The differences are
What are the 2 differences between ICE & Xignite’s extended hour data?
All fields of an option contract that will result in a new option contract to be created during corporate actions processing
What are strike price, symbol, expiry date, underlying security ID?
The name of a database table that uses cusip, country of issue, and currency fields to create the uniqueness constraint for it's entries
What is xxbrk_sec_master?
The first name given to the service responsible for managing assets, asset metadata, quotes, and exchange rates at Wealthsimple
What is asset-service?
An SM3 security flag that is always evaluated to be false for securities with an ineligibility reason of DENIED_ASSET_CATEGORY except if the security has an asset category of DEPOSITORY_RECEIPT
What is Ws Trade Searchable flag?
This is the total RAM allocated to containers deployed via the ice-stream-ingestor-options service (~Within 5% range).
How much RAM is 346GB?
These are the fields that get copied over from the old security to the new security with a CUSIP/ISIN change processed in SM3.
What is ws trade eligibility overwrite, CDS eligible, and security groups?
All the names of Kids and Pets of the current Sec Data Eng Members
Who are Yihan, Ellie, Arnold, Vihaan and Charlie?