rackhaelSTABLECOIN ADOPTION ON AVALANCHE
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
›
⌄
⌄
⌄
-- SELECT creation_time::date as date,
-- count(tx_hash) as txns,
-- platform
-- FROM ethereum.core.dim_dex_liquidity_pools
-- WHERE token0 = '0x808507121b80c02388fad14726482e061b8da827'
-- OR token1 = '0x808507121b80c02388fad14726482e061b8da827'
-- GROUP BY 1, 3
select date_trunc('day', block_timestamp),
sum(amount) as vol,
sum(amount_usd) as usd_vol,
contract_address,
count(from_address) as users,
count(tx_hash) as txns,
case when contract_address = '0x1556e2d8ff76dfbc5946ae18260e78a6ed745fed' then 'euros'
when contract_address = '0xc891eb4cbdeff6e073e859e987815ed1505c2acd' then 'euroc'
when contract_address = '0x820802fa8a99901f52e39acd21177b0be6ee2974' then 'euroe' end as token
from avalanche.core.ez_token_transfers
WHERE block_timestamp::date >= '2023-01-01'
AND contract_address in ('0x1556e2d8ff76dfbc5946ae18260e78a6ed745fed', '0xc891eb4cbdeff6e073e859e987815ed1505c2acd', '0x820802fa8a99901f52e39acd21177b0be6ee2974')
group by 1, 4, 7
order by 1
/*
select distinct(symbol) as token, contract_address
from avalanche.core.ez_token_transfers
where symbol ilike '%euro%'
*/
/* CONTRACT ADDRESS
1 EUROe 0x820802fa8a99901f52e39acd21177b0be6ee2974
2 EUROS 0x1556e2d8ff76dfbc5946ae18260e78a6ed745fed
3 EUROC 0xc891eb4cbdeff6e073e859e987815ed1505c2acd */
Run a query to Download Data