CryptoIcicleAbra-2. [Easy] aUST Analysis
    Updated 2022-02-10
    -- Provide an analysis of aUST usage in the past 80 days.
    -- Employ at least two metrics of your choice and at least one data visualization.
    -- What opportunities do you see for aUST to add value to the Terra ecosystem?

    -- https://etherscan.io/token/0xa8de3e3c934e2a1bb08b010104ccabbd4d6293ab
    select
    date_trunc('day',block_timestamp) as date,
    count(tx_id) as transction_frequency,
    count(distinct(origin_address)) as no_of_unique_user,
    sum(amount/pow(10,18)) as transction_volume
    from ethereum.udm_events
    where contract_address = '0xa8de3e3c934e2a1bb08b010104ccabbd4d6293ab'
    and (amount > 0) --and amount < pow(10,20))
    group by date
    Run a query to Download Data