CryptoIcicleAbra-2. [Easy] aUST Analysis
Updated 2022-02-10Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
-- 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