CREATE VIEW insights.pnl_by_asset_sink__rwm_shim AS
SELECT
account_group_id,
dim_balance_date,
position_type AS type,
asset_id,
asset_currency AS asset_currency_code,
currency_code,
total_gain_loss,
unrealized_gain_loss,
realized_gain_loss,
fair_value_total_gain_loss,
fair_value_unrealized_gain_loss,
fair_value_realized_gain_loss,
total_gain_loss_asset_currency,
unrealized_gain_loss_asset_currency,
realized_gain_loss_asset_currency,
fair_value_total_gain_loss_asset_currency,
fair_value_unrealized_gain_loss_asset_currency,
fair_value_realized_gain_loss_asset_currency
FROM insights.pnl_by_asset_mv AS pnl_by_asset_mv_next