binhachonLiquidity Activity - CVD
    Updated 2022-03-05
    with BANK_trading as (
    select
    block_timestamp,
    case
    when direction = 'IN' then -amount_usd
    else amount_usd end
    as corrected_amount_usd
    from ethereum.dex_swaps
    where token_address = '0x2d94aa3e47d9d5024503ca8491fce9a2fb4da198'
    ),
    sum_BANK_trading as (
    select
    date_trunc('day', block_timestamp) as blocktime,
    sum(corrected_amount_usd) as trading_volume
    from
    BANK_trading
    group by blocktime
    )
    select
    blocktime,
    sum(trading_volume) over (order by blocktime) as cvd
    from
    sum_BANK_trading