select '0xdac17f958d2ee523a2206206994597c13d831ec7' as contract_address,'usdt' as symbol union all

select '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' as contract_address,'usdc' as symbol union all

select '0x6b175474e89094c44da98b954eedeac495271d0f' as contract_address,'dai' as symbol union all

select '0x0000000000085d4780b73119b644ae5ecd22b376' as contract_address,'tusd' as symbol union all

select '0x7b4b0b9b024109d182dcf3831222fbda81369423' as contract_address,'busd' as symbol union all

select '0x0c10bf8fcb7bf5412187a595ab97a3609160b5c6' as contract_address,'usdd' as symbol union all

select '0x853d955acef822db058eb8505911ed77f175b99e' as contract_address,'frax' as symbol union all

select '0x8e870d67f660d95d5be530380d0ec0bd388289e1' as contract_address,'usdp' as symbol union all

select '0xc5f0f7b66764f6ec8c8dff7ba683102295e16409' as contract_address,'fdusd' as symbol union all

select '0x056fd409e1d7a124bd7017459dfea2f387b6d5cd' as contract_address,'gusd' as symbol union all

select '0x5f98805a4e8be255a32880fdec7f6728c6568ba0' as contract_address,'lusd' as symbol

),

contract_address_dim as (SELECT CONTRACT_ADDRESS as address from ethereum.core.fact_event_logs group by 1 ),

pool_address_dim AS ( SELECT POOL_ADDRESS as address FROM ethereum.defi.dim_dex_liquidity_pools GROUP BY 1 ),

special_address_dim AS (

SELECT

ADDRESS, LABEL_TYPE, LABEL_SUBTYPE

FROM

(VALUES

('0xfff52a282c215aed0c4c71786d85519bbcc86464', 'cex', 'EXMO 4'),

('0xffec0067f5a79cff07527f63d83dd5462ccf8ba4', 'cex', 'Nexo 2'),

('0xffd0ecee885fcd2ebce0fec9add69bf1ed03194b', 'cex', 'Fairdesk 1'),

('0xffb3118124cdaebd9095fa9a479895042018cac2', 'cex', 'MEXC 9'),

('0xff6b1cdfd2d3e37977d7938aa06b6d89d6675e27', 'cex', 'Allbit 2'),

('0xff2e0c46c7673ccd00cb5b59dc1686229a483fc8', 'cex', 'AltCoinTrader 2'),

('0xfe80804d2e3ab78a13ce90f45b2803cf9bbd1f51', 'cex', 'Remitano 3'),

('0xfd736faa01073d35c148b61093e6ae562b2f8544', 'cex', 'BiKi Deposit Funder 2'),

('0xfd648cc72f1b4e71cbdda7a0a91fe34d32abd656', 'cex', 'ChainX 1'),

('0xfc3bfe0ecb87c1eea44e5338828149480e8d2b74', 'cex', 'BtcTurk 4'),