sinahosseinzadehUntitled Query
    Updated 2022-08-16
    select date, sum(raw_amount/power(10,decimals)) as volume_velo, sum(raw_amount/power(10,decimals)*price) as volume_usd
    from optimism.core.fact_token_transfers as tb1
    join(
    select hour::date as date, decimals, avg(price) as price
    from optimism.core.fact_hourly_token_prices
    where token_address = lower('0x3c8B650257cFb5f272f799F5e2b4e65093a11a05')
    group by 1,2
    ) as tb2 on tb1.block_timestamp::date = tb2.date
    where contract_address = lower('0x3c8B650257cFb5f272f799F5e2b4e65093a11a05')
    group by 1
    Run a query to Download Data