maybeyonascrv_pool_vol
    Updated 2022-01-09
    with
    swap_in as (
    select
    block_timestamp,
    tx_id,
    pool_address,
    pool_name,
    token_address as token_in,
    from_address as user,
    -- address_name as token_in_name
    amount_in,
    amount_usd as amount_usd_in
    from ethereum.dex_swaps
    where platform = 'curve'
    and direction = 'IN'
    ),
    swap_out as (
    select
    tx_id,
    token_address as token_out,
    amount_out,
    amount_usd as amount_usd_out
    from ethereum.dex_swaps
    where platform = 'curve'
    and direction = 'OUT'
    ),
    curve_swaps as (
    select
    block_timestamp,
    i.tx_id,
    user,
    pool_address,
    pool_name,
    token_in,
    amount_in,
    amount_usd_in,
    Run a query to Download Data