theericstoneStablecoin Percent of Uniswap vs Curve
Updated 2021-02-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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