amer_0751|SHOP.TO|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
amer_0751|SHOP.TO|1|Shopify Inc Total Current Assets (Quarterly) (CAD)|Shopify Inc Cash and Short Term Investments (Quarterly) (CAD)|Shopify Inc Inventories (Quarterly) (CAD)|Shopify Inc Net PP&E (Quarterly) (CAD)|Shopify Inc Goodwill and Intangibles (Quarterly) (CAD)|Shopify Inc Total Liabilities (Quarterly) (CAD)|Shopify Inc Total Current Liabilities (Quarterly) (CAD)|Shopify Inc Total Long Term Liabilities (Quarterly) (CAD)|Shopify Inc Total Deposits (Quarterly) (CAD)|Shopify Inc Book Value (Quarterly) (CAD)|Shopify Inc Retained Earnings (Quarterly) (CAD)|Shopify Inc Treasury Stock (Quarterly) (CAD)|Shopify Inc EV to Revenues|Shopify Inc EV to Earnings|Shopify Inc EV to Free Cash Flow|Shopify Inc EV to Assets (Quarterly)|Shopify Inc PS Ratio|Shopify Inc PE Ratio|Shopify Inc Price to Book Value|Shopify Inc PEG Ratio|Shopify Inc Debt to Equity Ratio|Shopify Inc Dividend Yield|Shopify Inc Shareholder Yield (TTM)|Shopify Inc Percent of Shares Outstanding Short|Shopify Inc Total Receivables (Quarterly) (CAD)|Shopify Inc Total Payables (Quarterly) (CAD)|Shopify Inc Total Capital Stock (Quarterly) (CAD)|Shopify Inc Return on Invested Capital|Shopify Inc Quality Ratio Score|Shopify Inc Momentum Score|Shopify Inc Beta (1Y)|Shopify Inc Sustainable Growth Rate (TTM)|Shopify Inc Institutional Investor Ownership Percentage|Shopify Inc Average Diluted Shares Outstanding (Quarterly)|Shopify Inc Total Employees (Annual)|Shopify Inc EPS Diluted (Quarterly) (CAD)|Shopify Inc Shares Outstanding|Shopify Inc Repurchase of Capital Stock (Quarterly) (CAD)|Shopify Inc Ordinary Shares Number (Quarterly)|Shopify Inc Payout Ratio|Shopify Inc Quick Ratio (Quarterly)|Shopify Inc Normalized Diluted EPS (Quarterly) (CAD)|Shopify Inc Stock Buybacks (Quarterly) (CAD)|Shopify Inc Effective Tax Rate (TTM)|Shopify Inc Return on Equity|Shopify Inc Net Income (TTM) (CAD)|Shopify Inc Revenue (TTM) (CAD)|Shopify Inc Dividend Per Share (Quarterly) (CAD)|Shopify Inc Revenue (Quarterly) (CAD)|Shopify Inc Gross Profit (Quarterly) (CAD)|Shopify Inc SG&A Expense (Quarterly) (CAD)|Shopify Inc Pre-Tax Income (Quarterly) (CAD)|Shopify Inc Net Income (Quarterly) (CAD)|Shopify Inc Net Interest Income (Quarterly) (CAD)|Shopify Inc Price (CAD)|Shopify Inc Total Return Price (CAD)|Shopify Inc Enterprise Value (CAD)|Shopify Inc 30-Day Average Daily Volume|Shopify Inc 1 Year Price Returns (Daily)||
amer_0751|SHOP.TO|2|mil_figure_money_CAD_metric|mil_figure_money_CAD_metric|mil_figure_money_CAD_metric|mil_figure_money_CAD_metric|mil_figure_money_CAD_metric|mil_figure_money_CAD_metric|mil_figure_money_CAD_metric|mil_figure_money_CAD_metric|mil_figure_money_CAD_metric|mil_figure_money_CAD_metric|mil_figure_money_CAD_metric|mil_figure_money_CAD_metric|figure_CAD_metric|figure_CAD_metric|figure_CAD_metric|figure_CAD_metric|figure_CAD_metric|figure_CAD_metric|figure_CAD_metric|figure_CAD_metric|figure_CAD_metric|percent_CAD_metric|percent_CAD_metric|percent_CAD_metric|mil_figure_money_CAD_metric|mil_figure_money_CAD_metric|mil_figure_money_CAD_metric|percent_CAD_metric|figure_CAD_metric|figure_CAD_metric|figure_CAD_beta|percent_CAD_metric|percent_CAD_metric|mil_figure_CAD_metric|figure_whole_CAD_metric|figure_money_CAD_per_share_metric|mil_figure_CAD_metric|mil_figure_money_CAD_metric|mil_figure_CAD_metric|percent_CAD_metric|figure_CAD_metric|figure_money_CAD_per_share_metric|mil_figure_money_CAD_metric|percent_CAD_metric|percent_CAD_metric|mil_figure_money_CAD_metric|mil_figure_money_CAD_metric|figure_money_CAD_per_share_metric|mil_figure_money_CAD_metric|mil_figure_money_CAD_metric|mil_figure_money_CAD_metric|mil_figure_money_CAD_metric|mil_figure_money_CAD_metric|mil_figure_money_CAD_metric|figure_money_CAD_price|figure_money_CAD_price|mil_figure_money_CAD_metric|figure_CAD_metric|percent_CAD_metric||
amer_0751|SHOP.TO|4|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|monthly|quarterly|daily|quarterly|monthly|quarterly|monthly|daily|quarterly|daily|quarterly|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|monthly|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|monthly|monthly|monthly|monthly|daily||
amer_0751|SHOP.TO|5|91.2727272727|91.2727272727||91.2727272727|91.2727272727|91.2727272727|91.2727272727|91.2727272727||91.2727272727|91.2727272727||7.0035335689|91.35|6.97887323944|91.35|7.0035335689||7.01083032491|6.98648648649|91.2727272727|1.45307917889|91.35|15.21875|91.2727272727|91.2727272727|91.2727272727|91.35|91.35|31.06|30.4423076923|91.35||91.32|434|91.32|31.2063492063||91.2727272727|91.2727272727|91.2727272727|91.32|91.3333333333|91|91.35|91.2727272727|91.2727272727||91.32|91.32|91.32|91.32|91.32|91.32|7.0035335689|7.0035335689|7.0035335689|7.0036101083|6.98268398268||
amer_0751|SHOP.TO|6|22|22||22|22|22|22|22||22|22||283|20|284|20|283||277|222|22|1364|20|128|22|22|22|20|20|50|52|20||25|4|25|63||22|22|22|25|24|2|20|22|22||25|25|25|25|25|25|283|283|283|277|231||
amer_0751|SHOP.TO|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||
amer_0751|SHOP.TO|201403||||||||||||||||||||||||||||||||||66.5039||-0.1055||||||-0.0988|||||||20.7327|12.8166|12.6909|-7.0156|-7.0156|0.011|||||||
amer_0751|SHOP.TO|201406||||||||||||||||||||||||||||||||||66.5039||-0.1128||||||-0.1152|||||||25.8275|15.6132|16.0408|-7.5039|-7.5039|0.0142|||||||
amer_0751|SHOP.TO|201409||||||||||||||||||||||||||||||||||66.5039||-0.0699||||||-0.067|||||||29.7687|17.6777|15.0063|-4.6461|-4.6461|0.0163|||||||
amer_0751|SHOP.TO|201412|79.3583|69.2366||25.2149|5.8964|31.8679|22.9473|8.9206||-22.4251|-33.7282||||||||||||||8.3868|13.8967|105.7325|||||||66.5039||-0.082|||66.7374||3.3827|-0.0782||||-24.6202|116.3249||39.9959|22.2966|19.882|-5.4545|-5.4545|0.0216|||||||
amer_0751|SHOP.TO|201503|86.1493|74.9765||29.928|7.2669|41.2782|30.9495|10.3287||-28.2627|-42.5747||16.2454||-101.1735||15.9542||||||||6.7663|20.2114|115.782|||||||66.7374|632|-0.0841|66.7374||66.7374||2.6412|-0.0841||||-23.2153|141.8505||46.2583|26.7111|21.9587|-5.6107|-5.6107||34|34|2304.4238||||
amer_0751|SHOP.TO|201506|254.5383|246.7846||31.7745|7.7003|46.3324|34.9705|11.3619||247.6807|-45.7875||20.6209|-149.8924|-128.4229|10.0758|20.3182||12.957||||-5.2198|0.0126|4.0872|22.0932|282.9466|-14.5197|7|||-30.098||53.0405||-0.0738|75.7246||75.7246||7.1738|-0.0738|-167.5145||-30.098|-19.7637|171.2575||55.2345|31.0462|24.4821|-4.0523|-4.0523||43.3|43.3|2925.0816|23526.6||49.5|37.57
amer_0751|SHOP.TO|201509|262.3092|250.8494||39.056|8.7398|51.4391|38.2576|13.1815||264.7649|-55.7519||18.2178|-155.7074|-274.0387|10.4447|16.4064||13.8345||||-5.0167|0.0157|5.1475|22.4272|306.2176|-12.6045|7|||-18.3738||75.9018||-0.0785|76.1574||76.1574||6.6914|-0.0785|-10.7529||-18.3738|-21.2106|210.5527||69.0639|37.6066|30.0599|-6.0931|-6.0931||44.46|44.46|3119.9311|36160.2||41.61|36.36
amer_0751|SHOP.TO|201512|280.8594|263.808||45.8442|11.3737|67.1335|51.6552|15.4784||270.9437|-66.3831||9.7898|-107.0005|-383.4352|7.6533|9.2219||10.0371||||-6.1073|0.044|8.4467|31.2661|321.0702|-12.807|7|||-16.5013||78.1755|1048|-0.1069|80.0899||80.0899||5.2706|-0.1069|4.1364||-16.5013|-24.1811|264.2949||93.7382|50.3522|40.9721|-8.425|-8.425||35.6|35.6|2587.3925|38713.7||31.61|29.79
amer_0751|SHOP.TO|201603|263.6339|245.8599||44.8445|9.8038|70.459|55.1856|15.2735||247.8232|-73.685||10.0577|-88.5236|-258.6466|8.5759|9.4214||10.8527|-5.0824|||-5.8523|0.1505|8.4971|35.1277|302.8881|-13.8484|7||0.9686|-15.3718||80.4885||-0.1511|81.0299||81.0299||4.6091|-0.161|||-15.3718|-30.8342|317.9192||99.8826|55.0562|49.6199|-12.2639|-12.2639|0.2788|36.37|36.37|2658.1942|68377.5|14.7673|39.59|38.47
amer_0751|SHOP.TO|201606|253.348|232.3595||50.6313|20.8126|80.6557|64.3831|16.2726||244.1362|-84.3601||8.6978|-80.184|-169.6529|9.2962|8.4042||12.1501|-1.7012|||-0.2035|0.065|11.7599|41.7235|304.7903|-14.7627|7|7|1.872|-14.7627||81.3492||-0.1288|81.7832||81.7832||3.7917|-0.1288|||-14.7627|-37.6552|374.3249||111.6403|61.231|50.8293|-10.8732|-10.8732||37.16|37.16|2765.2112|86549.3|-6.1822|42.93|54.02
amer_0751|SHOP.TO|201609|562.1135|526.4855||56.2922|21.2666|98.4098|81.3495|17.0604||541.2625|-97.7798||12.0534|-103.091|-246.9917|7.0032|12.2395||19.4328|-2.4212|||-5.7629|0.163|22.0742|55.6806|611.3493|-13.8483|7|7|3.015|-13.8483||84.9128||-0.1434|88.9362||88.9362||6.7432|-0.1434|-292.6381||-13.8483|-43.4542|435.1065||129.8455|70.0903|57.086|-11.8921|-11.8921||58.01|58.01|4511.8839|100189.2667|25.0608|58.08|57.33
amer_0751|SHOP.TO|201612|569.9862|528.8995||61.6205|29.5723|107.9353|89.6725|18.2628||553.2437|-112.1499||10.7924|-98.7998|-292.4535|7.0023|10.9626||9.6484|-1.6641|||-5.7646|0.1121|28.9712|49.4336|631.4409|-12.6145|7|7|3.6902|-12.6145||89.1747|1900|-0.1334|89.4055||89.4055||6.2212|-0.1334|-4.7385||-12.6145|-46.8604|515.3383||173.9699|90.9125|70.6751|-11.8312|-11.8312||58.72|58.72|4695.8482|95732.4333|67.1839|67.04|83.81
amer_0751|SHOP.TO|201703|579.0318|527.5537||59.7443|29.6328|120.6245|102.4429|18.1815||547.7844|-129.0679||15.8021|-147.4635|-477.1165|11.6046|15.8075||15.6754|-2.7994|||-3.5897|0.1776|35.3285|69.7423|638.4148|-12.3229|7|8|-0.6379|-12.3229||90.2429||-0.1986|91.3258||91.3258||5.4946|-0.1986|||-12.3229|-52.6002|584.1045||168.6489|95.6466|79.5825|-18.0037|-18.0037||97|97|8143.434|218264.1333|155.7341|101.05|124.72
amer_0751|SHOP.TO|201706|1291.7724|1211.4521||57.4728|50.3606|129.6519|109.4536|20.1983||1269.9539|-144.0061||18.6836|-163.0794|-853.3409|7.0611|17.2557||20.8855|-4.0791|||-9.4715|0.1088|59.0358|74.2111|1366.1589|-9.5997|7|10|-0.4257|-9.5997||94.2905||-0.2018|98.5273||98.5273||11.6076|-0.2018|-753.4106||-9.5997|-60.6007|676.4765||204.0123|116.8206|94.2111|-18.8737|-18.8737||116.63|116.63|10913.1845|777404.1333|222.0783|117|136.82
amer_0751|SHOP.TO|201709|1262.1924|1152.2966||60.4466|47.105|141.1346|118.6547|22.4799||1228.6094|-149.5055||19.5437|-219.1921|-502.6775|9.6763|19.4134||11.3644|-4.7481|||-4.9066|0.3319|84.6477|81.1419|1323.4885|-7.3014|7|10|-1.173|-7.3014||98.778||-0.1128|99.2723||99.2723||10.4247|-0.1128|51.2875||-7.3014|-60.468|761.5792||214.9482|125.4002|95.721|-11.7594|-11.7594||146.48|146.48|13220.8268|391013.0333|145.8055|131.99|133.4
amer_0751|SHOP.TO|201712|1289.276|1179.115||63.3025|47.1714|141.3672|119.1058|22.2615||1258.3827|-154.8674||15.7193|-219.628|-359.6903|8.2274|16.1647||10.6818|-9.3113|||-5.7215|0.4859|86.7833|64.3219|1354.3886|-5.3969|7|9|-2.2979|-5.3969||99.8777||-0.0382|99.8777||99.8777||10.6284|-0.0382|-24.2519||-5.3969|-52.4357|870.99||283.3807|154.0754|110.5459|-3.7989|-3.7989||132.2|132.2|11971.5015|360054.8333|136.3669|157.04|177.5
amer_0751|SHOP.TO|201803|2180.9459|2039.6646||66.6801|53.4497|171.234|146.6153|24.6188||2129.8417|-179.5719||17.6363|-273.205|-740.3889|6.4729|17.2679||13.144||||-9.1152|0.3036|118.6247|102.0495|2253.0078|-4.2364|7|9|-2.6767|-4.2364||102.2566||-0.2021|105.6284||105.6284||14.7208|-0.2021|-817.2255||-4.2364|-54.5183|973.0806||270.7395|156.4287|121.8403|-20.0863|-20.0863||157|157|15361.0391|467065.0667|62.2907|154.04|188.01
amer_0751|SHOP.TO|201806|2262.265|2086.5912||72.6478|63.0285|202.6137|175.4723|27.1413||2195.3275|-216.138||18.9282|-275.0752|-488.7944|7.6339|19.658||9.6056||||-3.9607|0.3902|149.1091|126.8907|2347.8989|-4.117|7|9|-2.0819|-4.117||105.9781||-0.2967|106.3701||106.3701||12.741|-0.289|-17.4838||-4.117|-66.5477|1085.1084||316.0401|176.6931|146.3177|-30.9031|-30.9031|9.6039|193.61|193.61|18418.6782|249161.8667|69.2839|226.55|187.27
amer_0751|SHOP.TO|201809|2243.3174|2038.2776||72.0063|63.2241|219.0591|189.7821|29.277||2159.4887|-240.5328||18.823|-242.9191|-519.4722|8.6907|19.7519||10.2543|-8.0154|||-3.831|0.5268|174.7619|139.2741|2316.9678|-4.7424|7|9|-2.6265|-4.7424||106.6472||-0.2876|106.969||106.969||11.661|-0.2889|-11.0482||-4.7424|-85.0952|1223.1963||353.036|195.7278|156.1696|-30.3068|-30.3068|10.5598|210.7|210.7|20424.9972|231760.5|50.4355|181.87|199
amer_0751|SHOP.TO|201812|2900.2355|2683.0845||83.9279|87.3048|223.424|188.9208|34.5032||2848.0442|-255.7626||14.2101|-217.9886|-499.0546|5.9118|15.2806||8.9929|-7.9444|||-6.4784|0.5206|181.4723|95.9248|3018.548|-3.9324|8|10|1.2698|-3.9324||107.7572|4000|-0.0132|110.3927||110.3927||15.1627|0.003|-504.4092||-3.9324|-83.2977|1394.4022||454.5866|245.5528|169.4504|-2.0015|-2.0015|12.2484|180.26|180.26|17381.7451|410535.7|36.354|221.18|249.28
amer_0751|SHOP.TO|201903|2901.5871|2665.4146||214.8346|90.53|366.8196|230.9218|135.8978||2840.1322|-271.6555||19.8876|-294.6624|-664.02|8.7585|20.7273||10.679|-7.5967|||-1.7329|0.9626|196.5306|166.8709|3023.4158|-3.9154|8|10|1.8921|-3.9154||110.9213||-0.2925|111.4825||111.4825||12.3936|-0.2873|||-3.9154|-95.3232|1549.7831||426.1204|239.7192|185.783|-32.1117|-32.1117|16.0592|273.54|273.54|27731.281|506203.0333|74.2293|295.37|374.06
amer_0751|SHOP.TO|201906|2895.3658|2636.316||238.8976|96.4906|400.8349|253.1796|147.6553||2829.9192|-304.0641||26.8668|-405.2395|-5032.986|12.8928|27.4584||15.599|-7.3401|||-1.1638|0.6412|211.3368|185.9391|3028.9709|-3.9924|8|10|1.7133|-3.9924||112.0134||-0.3478|112.5306||112.5306||11.2476|-0.3331|||-3.9924|-102.7873|1718.0212||484.2782|273.9474|212.5395|-38.3672|-38.3672|16.2871|394.66|394.66|41637.6962|337518.5333|103.8428|438.79|522.06
amer_0751|SHOP.TO|201909|3852.4862|3530.0154||250.0475|96.7928|488.2074|343.7672|144.4402||3732.3481|-403.6609||26.372|-261.1307|3368.9024|10.4313|26.4564||16.9418|-9.2593|||-2.9712|0.4106|281.1988|272.5709|4026.8215|-5.85|8|10|1.66|-5.85||113.087||-0.8452|115.3433||115.3433||11.0866|-0.8415|-908.5784||-5.85|-168.5977|1880.7408||515.7556|286.1647|213.8906|-32.2829|-96.1172|15.3768|415.72|415.72|45307.6739|318593.9333|97.3042|413|454
amer_0751|SHOP.TO|201912|3584.7795|3206.6307||321.5154|625.7947|618.7394|413.2139|205.5255||3938.7295|-397.3348||31.0753|-343.678|-1456.9607|12.4862|31.5454||16.6047|-4.1685|||-1.5187|0.5485|314.3699|285.0515|4252.9023|-5.1139|8|10|0.4475|-5.1139||116.0602|5000|0.0132|116.429||116.429||8.521|0.0194|-4.3423|-30.1359|-5.1139|-165.5784|2092.9748||666.8205|348.341|252.41|-24.4731|1.0177|16.2177|534.76|534.76|58444.4975|220569.4333|196.6604|616.33|623.22
amer_0751|SHOP.TO|202003|3867.7906|3346.9842||355.3437|667.631|609.7763|409.1363|200.6399||4311.5314|-475.9123||31.319|-374.4861|6486.6933|13.3645|31.86||17.4565|-5.22|||-1.3208|0.821|437.2768|306.1068|4726.3378|-4.9746|8|10|0.7588|-4.9746||116.8065||-0.3622|117.2247||117.2247||9.2494|-0.3845||0.0866|-4.9746|-175.6302|2297.3828||630.5284|344.7105|286.8053|-80.6592|-42.1635|14.042|590|590|65549.9633|484197.0667|119.8457|883.83|1057.37
amer_0751|SHOP.TO|202006|5994.1467|5463.9442||302.7928|632.4631|641.1774|437.7022|203.4751||6321.5568|-409.2268||64.1823|-1710.2606|-992.0406|21.4616|62.9445||34.9756|-11.1819|||-1.8965|0.3561|439.8477|330.5689|6637.0393|-2.0671|7|10|1.7397|-2.0671||122.75||0.4019|120.0955||120.0955||13.4881|0.4174|-2024.7114|33.4862|-2.0671|-87.3736|2803.1038||989.9992|519.7565|334.7247|6.0536|49.8893|8.2488|1289.77|1289.77|149431.6288|277240.5333|227.7021|1308.95|1365.11
amer_0751|SHOP.TO|202009|||||||||||||57.5309||2140.0198||57.1854||26.3747|||||0.3079||||||10|1.7447||||||121.8779||||||||||||||||||1368|1368|161265.023|244039.2333|237.8612|1348.76|