permaryTotal Unique Assets on Stellar
    Updated 2025-02-19
    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;












    QueryRunArchived: QueryRun has been archived