sinahosseinzadehUntitled Query
Updated 2022-08-16
99
1
2
3
4
5
6
7
8
9
10
›
⌄
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