SQL Join and Daily Aggregation | Dataford Interview Questions

Alpaca's trading operations team needs a daily summary of executions shown in its brokerage activity reporting. Write a PostgreSQL query against the execution records.

Requirements

Include only rows where execution_status is filled.
Group results by the calendar date of execution_time, returning the number of filled executions and total notional.
Sort the output from the earliest day to the latest day.

Schema

trade_executions

Column	Type	Description
execution_idPK	INT	Unique execution identifier
account_id	VARCHAR(20)	Alpaca brokerage account identifier
execution_time	TIMESTAMP	Timestamp when the execution was recorded
execution_status	VARCHAR(20)	Current execution status
notional	DECIMAL(12,2)	Dollar value of the execution

Your question is SQL Join and Daily Aggregation. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Alpaca's trading operations team needs a daily summary of executions shown in its brokerage activity reporting. Write a PostgreSQL query against the execution records.

Requirements

Include only rows where execution_status is filled.
Group results by the calendar date of execution_time, returning the number of filled executions and total notional.
Sort the output from the earliest day to the latest day.

Schema

trade_executions

Column	Type	Description
execution_idPK	INT	Unique execution identifier
account_id	VARCHAR(20)	Alpaca brokerage account identifier
execution_time	TIMESTAMP	Timestamp when the execution was recorded
execution_status	VARCHAR(20)	Current execution status
notional	DECIMAL(12,2)	Dollar value of the execution

Your question is SQL Join and Daily Aggregation. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.