COUNT(DISTINCT da.asset_id) AS unique_assets,

COUNT(CASE WHEN da.asset_type = 'native' THEN 1 END) AS native_assets,

COUNT(CASE WHEN da.asset_type != 'native' THEN 1 END) AS non_native_assets

FROM stellar.core.dim_assets da

LEFT JOIN stellar.price.ez_asset_metadata eam

ON da.asset_id = eam.asset_id

WHERE da.inserted_timestamp <= CURRENT_TIMESTAMP()

AND da.asset_id IS NOT NULL;