hbd1994Bridge Activity || Out of Flow
    Updated 2022-07-04
    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