with stable_token_dim as

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 ),

cex_agg_address as

SELECT '0x3f5ce5fbfe3e9af3971dd833d26ba9b5c936f0be' AS address, 'Binance' AS cex_name, 'Binance 1' AS distinct_name UNION ALL SELECT '0xd551234ae421e3bcba99a0da6d736074f22192ff' AS address, 'Binance' AS cex_name, 'Binance 2' AS distinct_name UNION ALL SELECT '0x564286362092d8e7936f0549571a803b203aaced' AS address, 'Binance' AS cex_name, 'Binance 3' AS distinct_name UNION ALL SELECT '0x0681d8db095565fe8a346fa0277bffde9c0edbbf' AS address, 'Binance' AS cex_name, 'Binance 4' AS distinct_name UNION ALL SELECT '0xfe9e8709d3215310075d67e3ed32a380ccf451c8' AS address, 'Binance' AS cex_name, 'Binance 5' AS distinct_name UNION ALL SELECT '0x4e9ce36e442e55ecd9025b9a6e0d88485d628a67' AS address, 'Binance' AS cex_name, 'Binance 6' AS distinct_name UNION ALL SELECT '0xbe0eb53f46cd790cd13851d5eff43d12404d33e8' AS address, 'Binance' AS cex_name, 'Binance 7' AS distinct_name UNION ALL SELECT '0xf977814e90da44bfa03b6295a0616a897441acec' AS address, 'Binance' AS cex_name, 'Binance 8' AS distinct_name UNION ALL SELECT '0x001866ae5b3de6caa5a51543fd9fb64f524f5478' AS address, 'Binance' AS cex_name, 'Binance 9' AS distinct_name UNION ALL SELECT '0x85b931a32a0725be14285b66f1a22178c672d69b' AS address, 'Binance' AS cex_name, 'Binance 10' AS distinct_name UNION ALL SELECT '0x708396f17127c42383e3b9014072679b2f60b82f' AS address, 'Binance' AS cex_name, 'Binance 11' AS distinct_name UNION ALL SELECT '0xe0f0cfde7ee664943906f17f7f14342e76a5cec7' AS address, 'Binance' AS cex_name, 'Binance 12' AS distinct_name UNION ALL SELECT '0x8f22f2063d253846b53609231ed80fa571bc0c8f' AS address, 'Binance' AS cex_name, 'Binance 13' AS distinct_name UNION ALL SELECT '0x28c6c06298d514db089934071355e5743bf21d60' AS address, 'Binance' AS cex_name, 'Binance 14' AS distinct_name UNION ALL SELECT '0x21a31ee1afc51d94c2efccaa2092ad1028285549' AS address, 'Binance' AS cex_name, 'Binance 15' AS distinct_name UNION ALL SELECT '0xdfd5293d8e347dfe59e90efd55b2956a1343963d' AS address, 'Binance' AS cex_name, 'Binance 16' AS distinct_name UNION ALL SELECT '0x56eddb7aa87536c09ccc2793473599fd21a8b17f' AS address, 'Binance' AS cex_name, 'Binance 17' AS distinct_name UNION ALL SELECT '0x9696f59e4d72e237be84ffd425dcad154bf96976' AS address, 'Binance' AS cex_name, 'Binance 18' AS distinct_name U

),

special_address_dim AS

select '0x0000000000000000000000000000000000000007' as address,'Blackhole' as LABEL_TYPE ,'Blackhole' as LABEL_SUBTYPE union all

select '0x0000000000000000000000000000000000000000' as address,'Blackhole' as LABEL_TYPE ,'Blackhole' as LABEL_SUBTYPE union all

select '0x0000000000000000000000000000000000000008' as address,'Blackhole' as LABEL_TYPE ,'Blackhole' as LABEL_SUBTYPE union all