shreexLabels
    Updated 2024-05-19
    with zero_address AS
    (
    SELECT address FROM arbitrum.core.dim_labels WHERE label_type = 'bridge'
    and project_name like '%layerzero%' or project_name like '%layer zero%'
    UNION
    SELECT address FROM avalanche.core.dim_labels WHERE label_type = 'bridge'
    and project_name like '%layerzero%' or project_name like '%layer zero%'
    UNION
    SELECT address FROM bsc.core.dim_labels WHERE label_type = 'bridge'
    and project_name like '%layerzero%' or project_name like '%layer zero%'
    UNION
    SELECT address FROM ethereum.core.dim_labels WHERE label_type = 'bridge'
    and project_name like '%layerzero%' or project_name like '%layer zero%'
    UNION
    SELECT address FROM optimism.core.dim_labels WHERE label_type = 'bridge'
    and project_name like '%layerzero%' or project_name like '%layer zero%'
    UNION
    SELECT address FROM polygon.core.dim_labels WHERE label_type = 'bridge'
    and project_name like '%layerzero%' or project_name like '%layer zero%'
    ),
    cexes AS
    (
    SELECT address FROM arbitrum.core.dim_labels WHERE label_type = 'cex' AND label_subtype = 'hot_wallet'
    UNION
    SELECT address FROM avalanche.core.dim_labels WHERE label_type = 'cex' AND label_subtype = 'hot_wallet'
    UNION
    SELECT address FROM bsc.core.dim_labels WHERE label_type = 'cex' AND label_subtype = 'hot_wallet'
    UNION
    SELECT address FROM ethereum.core.dim_labels WHERE label_type = 'cex' AND label_subtype = 'hot_wallet'
    UNION
    SELECT address FROM optimism.core.dim_labels WHERE label_type = 'cex' AND label_subtype = 'hot_wallet'
    UNION
    SELECT address FROM polygon.core.dim_labels WHERE label_type = 'cex' AND label_subtype = 'hot_wallet'
    ),