MLDZMNgno11
    Updated 2023-03-15
    select
    block_timestamp::date as day,
    case when ADDRESS_NAME='hop protocol: usdc l2canonicaltoken' then 'USDC'
    when ADDRESS_NAME='hop protocol: usdt l2canonicaltoken' then 'USDT' end as token,
    count(tx_hash) as application,
    count(distinct from_address) as users,
    sum(RAW_AMOUNT/1e6) as volume,
    sum(volume) over (partition by token order by day) as cumulative_usage
    from gnosis.core.fact_token_transfers x
    join gnosis.core.dim_labels z on x.CONTRACT_ADDRESS=z.address
    where CONTRACT_ADDRESS in (lower('0x4ecaba5870353805a9f068101a40e0f32ed605c6'),
    lower('0xddafbb505ad214d7b80b1f830fccc89b60fb7a83'),
    lower('0xd586E7F844cEa2F87f50152665BCbc2C279D8d70'))
    -- and STATUS = 'SUCCESS'
    group by 1,2

    Run a query to Download Data