KaskoazulAnchor Withdrawals since May 7th - Borrow
    Updated 2022-05-07
    with Anchor_collateral as (
    select sender,
    currency,
    contract_label,
    sum (amount) as currency_withdrawals,
    sum (amount_usd) as USD_withdrawals,
    count (tx_id) as number_txs
    from anchor.collateral where event_type = 'withdraw'
    and block_timestamp > '2022-05-07'
    and amount_usd > 100000
    group by 1,2,3
    order by 5 desc
    ),

    Anchor_redeem as (
    select sender,
    currency,
    contract_label,
    sum (amount) as currency_withdrawals,
    sum (amount_usd) as USD_withdrawals,
    count (tx_id) as number_txs from anchor.redeem
    where block_timestamp >= '2022-05-07'
    and amount > 1000000
    group by 1,2,3
    order by 5 desc
    )

    select *
    from Anchor_collateral
    Run a query to Download Data