Tech Diary

Explaining using a real-world scenario One of the key points that data scientists should ask end-users is: How much importance do they give ...

 select userid, max(case when name = 'EMAIL' then val else 0 end) as email, max(case when name = 'PHONE' then val else 0 end...

Quadruple Witching refers to the 3rd Friday of every quarter i.e March, June, September and December. This is the trading day when: mar...

Create an ionic project > ionic start myproject  Give a package id in file >myproject/config.xml < widget id = ...

sel a, b, rank() over(order by c) from table1

Verify if date is in format dd-MMM-yyyy select  regexp_similar(a_date,'^(([0-9])|([0-2][0-9])|([3][0-1]))\-(JAN|FEB|MAR|APR|MAY|JUN|J...

WITH CTE1 AS (select current_date as today) select today from CTE1; Ref: http://dwgeek.com/teradata-with-clause-syntax-usage-and-examples...

Interesting read: https://9to5mac.com/2019/04/17/apple-qualcomm-and-intel/ Graphical diagram explaining players involved and their roles. ...

Composed of: Subject -> Predicate -> Object A subject : which is a URI (e.g., a "web address") that represents something...

Abstractions Resource: representing an RDF resource (whether named with a URI or anonymous) Literal: for data values (numbers, strings, d...

Offer/Ask price: $100.50 Bid price: $99.50 Spread = 100.50 - 99.50 = $1.00

Financial Information eXchange (FIX) is a messaging protocol used to exchange trade related messages between trading systems. FIXatdl (FIX...

1 basis point = 1/100 of a percentage. Used mainly in Finance like changes in interest rate. Example: "The Federal Open Market Commi...

With many unicorn IPOs getting listed in 2019, one question is "what is a unicorn?" Wikipedia states: Unicorn is a privately he...

Stands for Standard & Poor’s Depository Receipt. It is a S&P 500 index based ETF maintained by State Street Global Advisors. Each sh...

Leading indicators  1. Stock market  2. Manufacturing activity  3. Inventory levels 4. Retail sales 5. Building permits 6. Housi...

Ref: Motley Fool youtube. https://www.youtube.com/watch?v=AfT5FaaqNxI&list=PLXIJDn8_-fyEsbjwBto2GzIS1JPq5I2iR&index=8 Objective of...

Suppose if a company is liquidated today i.e. all assets sold off and liabilities paid off, then the amount of money left for the shareholde...

It's available on EDGAR (Electronic Data Gathering, Analysis, and Retrieval) website.

No. Whereas Treasury stocks can be.