hyoeisemanDeFi on Flow 4_bridge
Updated 2022-11-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with tab as (select timestamp::Date as day,token,symbol,token_contract, ifnull(avg (price_usd),0) as USDPrice
from flow.core.fact_prices
where token != 'Blocto'
group by 1,2,3,4)
select direction as type_of_bridge,
count (distinct tx_id) as count_transactions,
count (distinct flow_wallet_address) as count_bridgers,
sum (amount) as token_amount,
sum (amount*usdprice) as USD_amount
from flow.core.ez_bridge_transactions t1 join tab t2 on
t1.block_timestamp::date = t2.day and t1.token_contract = t2.token_contract
where symbol ilike '{{token}}'
group by 1
Run a query to Download Data