option transactions on the same day

gistfile1.txt

SELECT aa1.activity,
       aa2.activity,
       aa1.date,
       aa1.account_id
FROM account_activities aa1
RIGHT JOIN account_activities aa2 ON aa1.account_id = aa2.account_id
AND aa1.date = aa2.date
AND aa1.fund_id = aa2.fund_id
AND aa1.activity <> aa2.activity
JOIN funds f ON aa1.fund_id = f.id
WHERE f.symbol LIKE '%|%';