mucryptoTop 5 pools used
    Updated 2023-06-01
    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'),

    token_label as(
    select
    address,
    address_name
    from ethereum.core.dim_labels),

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

    add_liquidity as (
    select
    tx_hash,
    block_timestamp,
    Run a query to Download Data