mattkstewOpensea Fees 4
    Updated 2022-08-01

    select
    --date_trunc('day', block_timestamp) as date1,
    sum(raw_amount) / 1e6 as USDC_Volume

    from polygon.core.fact_token_transfers left outer join polygon.core.dim_labels
    on contract_address = address
    where address_name like 'hop protocol: usdc l2canonicalbridge'
    and to_address like lower('0xF715bEb51EC8F63317d66f491E37e7BB048fCc2d')
    --group by 1
    --
    Run a query to Download Data