theericstoneStablecoin Percent of Uniswap vs Curve
    Updated 2021-02-17
    with pools as (
    select project_name, address
    from public.ethereum_address_labels
    where project_name in ('uniswap','curve fi')
    and l2_label NOT IN ('token_contract','chadmin','contract_deployer','swap_contract','token_distribution')
    ),

    stabletvl as (
    select dailes.date, dailes.project_name, sum(dailes.tvl) as tvl from (
    select
    balance_date as date,
    pools.project_name,
    coalesce(amount_usd,balance) as tvl
    from
    gold.ethereum_erc20_balances eeb
    join pools on pools.address = eeb.user_address
    where balance_date > getdate() - interval '2 weeks'
    and contract_address in (
    '0xdac17f958d2ee523a2206206994597c13d831ec7', -- usdt
    '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48', -- usdc
    '0x6b175474e89094c44da98b954eedeac495271d0f', -- dai
    '0x4fabb145d64652a948d72533023f6e7a623c7c53', -- busd
    '0x8e870d67f660d95d5be530380d0ec0bd388289e1', -- paxos
    '0xa47c8bf37f92abed4a126bda807a7b7498661acd', -- ust
    '0x57ab1ec28d129707052df4df418d58a2d46d5f51', -- susd
    '0xdf574c24545e5ffecb9a659c229253d4111d87e1', -- husd
    '0x0000000000085d4780B73119b644AE5ecd22b376', -- tusd
    '0x056fd409e1d7a124bd7017459dfea2f387b6d5cd', -- gusd
    LOWER('0x36F3FD68E7325a35EB768F1AedaAe9EA0689d723'), -- esd
    '0x5d3a536e4d6dbd6114cc1ead35777bab948e3643', --cDAI
    '0x16de59092dae5ccf4a1e6439d611fd0653f0bd01', --yDAI
    '0x83f798e925bcd4017eb265844fddabb448f1707d', --yUSDT
    '0x39aa39c021dfbae8fac545936693ac917d5e7563', --cUSDC
    '0xd6ad7a6750a7593e092a9b218d66c0a814a3436e', --yUSDC
    '0x73a052500105205d34daf004eab301916da8190f' --yTUSD
    )
    Run a query to Download Data