drone-mostafaUntitled Query
Updated 2022-08-25
9
1
2
3
4
5
6
›
⌄
select count( DISTINCT ORIGIN_FROM_ADDRESS) as Users ,sum(EVENT_INPUTS:value/pow(10,decimals)) as volume , count( Tx_hash) as Txn
from optimism.core.fact_event_logs
join optimism.core.dim_contracts d on d.ADDRESS = CONTRACT_ADDRESS where block_timestamp::date >= CURRENT_DATE -14
and ORIGIN_TO_ADDRESS='0x170a5714112daeff20e798b6e92e25b86ea603c1'
and EVENT_INDEX = 0 and EVENT_NAME='Transfer' and TX_STATUS ='SUCCESS'and EVENT_REMOVED = false
Run a query to Download Data