mucryptoMonthly added and removed usdt volume (tricrypto2 pool)
Updated 2023-06-06
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 added as (select
date_trunc('month', block_timestamp) as month,
decoded_log:token_amounts[0]/1e6 as usdt_amount_adj --https://etherscan.io/token/0xdac17f958d2ee523a2206206994597c13d831ec7
from ethereum.core.ez_decoded_event_logs
where contract_address = '0xd51a44d3fae010294c616388b506acda1bfaae46' --Curve's tricrypto2 pool; https://curve.fi/#/ethereum/pools/tricrypto2/deposit
and event_name = 'AddLiquidity'),
added_vol as (
select
month,
sum(usdt_amount_adj) as added_usdt_vol
from added
group by 1),
rl as (
select
date_trunc('month', block_timestamp) as month,
tx_hash,
decoded_log,
decoded_log:token_amounts[0]/1e6 as usdt_amount_adj
from ethereum.core.ez_decoded_event_logs
where contract_address = '0xd51a44d3fae010294c616388b506acda1bfaae46'
and event_name = 'RemoveLiquidity'
),
usdt as (
select
date_trunc('month', block_timestamp) as month,
decoded_log:coin_amount/1e6::string as one_usdt_amount_adj
from ethereum.core.ez_decoded_event_logs
where contract_address = '0xd51a44d3fae010294c616388b506acda1bfaae46'
and event_name = 'RemoveLiquidityOne'
and decoded_log:coin_index = '0'),
rl_vol as (select
month,
Run a query to Download Data