SELECT
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;