msafadoostUntitled Query
    Updated 2022-07-03
    WITH coins as (
    SELECT CONTRACT_NAME,
    sum(AMOUNT) as amount
    FROM flow.core.fact_bridge_transactions JOIN flow.core.dim_contract_labels ON TOKEN_CONTRACT = EVENT_CONTRACT
    GROUP by 1
    )
    SELECT SYMBOL
    --amount*PRICE
    FROM coins JOIN ethereum.core.fact_hourly_token_prices ON CONTRACT_NAME = SYMBOL
    GROUP by 1
    Run a query to Download Data