mucryptoCurve c liquidity added and removed over the last 30 days
    Updated 2023-06-06
    with addresses as (
    select
    address,
    address_name,
    split(address_name, ' ') as total_array,
    array_size(total_array) as length_array,
    total_array[length_array-1] as address_name_adj
    from ethereum.core.dim_labels
    where label_subtype = 'pool'
    and label = 'curve fi'),

    liquidity_events as (
    select
    tx_hash,
    event_name
    from ethereum.core.ez_decoded_event_logs
    where block_timestamp::date >= current_date() - 30
    and contract_address in (
    select
    address
    from addresses)
    and event_name in
    ('AddLiquidity',
    'RemoveLiquidityOne',
    'RemoveLiquidity',
    'RemoveLiquidityImbalance')),

    add_liquidity as (
    select
    tx_hash,
    block_timestamp,
    from_address,
    to_address as pool_address,
    contract_address as token_sent_to_pool,
    amount,
    amount_usd
    Run a query to Download Data