SparkSQL

Current available drivers counter

Count the number of drivers available in the given area.

Yesterday’s stock closing prices

Get the previous day's closing price (useful for day-to-day comparisons).

Historical ride duration statistics

Compute the mean and standard deviation of ride durations.

Closing stock price metrics

Analyse closing prices seen over different timespans.

Daily transaction stock statistics

Analyse stock trades made each day.

Today’s stock closing prices

Get the closing price of a stock.

Product popularity metrics

Determine the popularity of a candidate product by analyzing its visit count, cart additions, and purchase frequency.

Product’s aggregate ratings

Statistically capture the popularity of a product.

Standard deviation of user spend

Measure the degree to which a user’s recent transactions differ from their usual behavior.