theericstonemt pelerin uniswap pool activity
    Updated 2021-04-10
    select
    date_trunc('month',block_timestamp) as month,
    count(distinct(origin_address)) as n_liquidators,
    sum(amount_usd) as amount_liquidated_usd,
    count(distinct(tx_id)) as n_transactions
    from gold.ethereum_events
    where from_address = '0xcd6f65a972551ffac9b52fa2d4a561d9b7ab4741'
    and contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'
    and block_timestamp > '2020-01-01'
    group by 1
    order by 1;
    Run a query to Download Data