shawnedwardsDEF 8
Updated 2022-11-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with table1 as (select timestamp::Date as day,token,symbol,token_contract, ifnull(avg(price_usd),0) as price_in_USD
from flow.core.fact_prices
where token != 'Blocto'
group by 1,2,3,4)
select direction, count (distinct tx_id) as number_of_transactions,
count (distinct flow_wallet_address) as number_of_users,
number_of_transactions/number_of_users as avg_txn_per_user,
sum (amount) as Total_token_amount,
sum (amount * price_in_USD) as Total_USD_amount,
Total_USD_amount/number_of_transactions as USD_amount_per_user
from flow.core.ez_bridge_transactions,table1 where
flow.core.ez_bridge_transactions.block_timestamp::date = table1.day
and
flow.core.ez_bridge_transactions.token_contract = table1.token_contract
and symbol ilike '{{ticker}}'
group by 1
order by 2 desc
Run a query to Download Data