Example Queries

Since we support a range of common SQL and aggregate queries you can do queries like:

Compute total price of transactions executed by an account on a given date:
SELECT SUM(price) FROM Transaction
WHERE account_id = '5938' AND trade_date = '2025-01-01'

Compute the number of transactions executed within the first quarter:

SELECT COUNT(*) FROM Transaction

WHERE trade_date BETWEEN '2025-01-01' AND '2025-03-31'

Retrieve the transactions whose executed price equals their expected price:

SELECT tx_id, price, expected_price, price = expected_price

FROM Transaction WHERE trade_date = '2025-04-05'