Updated 2022-10-26
    select trunc(block_timestamp,'day') as date, count(DISTINCT(ORIGIN_FROM_ADDRESS)) as total_user,
    count(DISTINCT(tx_hash)) as total_bid, sum(amount) as eth_bid, sum(amount_usd) as usd_bid,
    avg(amount) as avg_eth, avg(amount_usd) as avg_usd
    from ethereum.core.ez_eth_transfers
    where origin_to_address = lower('0x55e0f7a3bb39a28bd7bcc458e04b3cf00ad3219e')
    and ETH_FROM_ADDRESS = ORIGIN_FROM_ADDRESS
    group by 1
    Run a query to Download Data