main as (

select

ORIGIN_FROM_ADDRESS as claimer ,

RAW_AMOUNT/pow(10,18) as volume ,

BLOCK_TIMESTAMP ,

TX_HASH

from optimism.core.fact_token_transfers

where

ORIGIN_TO_ADDRESS ='0xfedfaf1a10335448b7fa0268f56d2b44dbd357de' and

CONTRACT_ADDRESS = '0x9029fdfae9a03135846381c7ce16595c3554e10a' and

FROM_ADDRESS ='0xfedfaf1a10335448b7fa0268f56d2b44dbd357de' and

ORIGIN_FUNCTION_SIGNATURE ='0x2e7ba6ef'

select

BLOCK_TIMESTAMP::date as date ,

count(distinct TX_HASH) as trxs ,

count(distinct claimer) as claimers ,

sum(volume) as OP

from main

group by 1