hbd1994Bridge Activity || Out of Flow
Updated 2022-07-04Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with asset as (select "Date", "Bridge", case
when "Token1" = 'StarlyToken' then 'STARLY'
when "Token1" = 'ceAVAX' then 'AVAX'
when "Token1" = 'ceWETH' then 'WETH'
when "Token1" = 'ceBUSD' then 'BUSD'
when "Token1" = 'RLY' then 'RLY'
when "Token1" = 'FlowToken' then 'FLOW'
when "Token1" = 'REVV' then 'REVV'
when "Token1" = 'ceBNB' then 'BNB'
when "Token1" = 'ceWBTC' then 'WBTC'
when "Token1" = 'TeleportedSportiumToken' then 'SPRT'
when "Token1" = 'ceMATIC' then 'MATIC'
when "Token1" = 'ceFTM' then 'FTM'
when "Token1" = 'BloctoToken' then 'BLT'
when "Token1" in ('ceUSDT','TeleportedTetherToken') then 'USDT' end as "Token Symbol", "Amount"
from(select
block_timestamp::date as "Date",
bridge as "Bridge",
(select min(contract_name) from flow.core.dim_contract_labels where event_contract =token_contract) as "Token1",
sum(amount) as "Amount"
from flow.core.fact_bridge_transactions
where direction = 'inbound'
group by 1,2,3)),
eth as (select
SYMBOL as "Symbol",
HOUR::date as "Date",
avg(price) as "Day Price"
from ethereum.core.fact_hourly_token_prices
group by 1,2),
flow as (select
SYMBOL as "Symbol",
TIMESTAMP::date as "Date",
avg(price_usd) as "Day Price"
from flow.core.fact_prices
Run a query to Download Data