Robinhood Data Scientist Data Manipulation (SQL/Python) Interview Questions
Master your tech interview with our curated database of real questions from top companies.
List Transactions During Active 'Gold' Membership Period
customer_profile +-------------+----------------+--------------------+-------------------+ | customer_id | membership_type| membership_start_date| mem...
Analyze Transaction Flow and User Engagement Efficiently
transactions +---------------+-------------+------------+--------+ | transaction_id| from_user_id| to_user_id | amount | +---------------+------------...
Identify Transactions During 'Golden' Membership Period
transaction +-----------+---------+------------+---------+ | trans_id | user_id | trans_date | amount | +-----------+---------+------------+--------...
Write SQL to localize trading drop contributors
Use the schema and samples below. Unless stated, treat a user as active on a day if they attempted any order (any status). Dates are inclusive. Schema...
Write SQL and Python for transaction analytics
You are given user and transaction data. Part A (SQL): Use a join and window functions to answer the prompts below using the following schema and samp...
Identify Top Users with Declined Transactions in SQL
Transactions +----------------+---------+--------+----------+---------------------+ | transaction_id | user_id | amount | status | timestamp ...
Create OHLC Aggregates from Tick Data in Python
price_stream +-----------+-------+ | timestamp | price | +-----------+-------+ | 0 | 3 | | 1 | 2 | | 2 | 4 | | 3 ...