adambalaUntitled Query
    Updated 2022-10-18
    with
    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
    Run a query to Download Data