mucryptoMonthly added and removed usdt volume (tricrypto2 pool)
    Updated 2023-06-06
    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