Updated 2022-10-13Copy Reference Fork
9
1
2
3
4
5
6
7
8
9
›
⌄
select
SYMBOL as tokens,
sum(RAW_AMOUNT/pow(10,Decimals)) as Volume,
count(distinct ORIGIN_FROM_ADDRESS) as distinct_users,
count(distinct TX_HASH) as count_open
from optimism.core.fact_token_transfers x
join optimism.core.dim_contracts y on x.CONTRACT_ADDRESS=y.ADDRESS
where ORIGIN_TO_ADDRESS='0x059d306a25c4ce8d7437d25743a8b94520536bd5' and ORIGIN_FUNCTION_SIGNATURE='0xded700a6'
group by 1
Run a query to Download Data