msafadoostUntitled Query
Updated 2022-07-03
99
1
2
3
4
5
6
7
8
9
10
›
⌄
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