Updated 2022-10-13
    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