flipside

    OP Sales without the Attacker
    freemartianOP Sales without the Attacker
    Updated 2022-08-03
    select sum(raw_amount)/pow(10,18) as sale_volume,
    count(distinct from_address) as buyers_count,
    count(distinct to_address) as sellers_count,
    date_trunc('day', block_timestamp::date) as TIME
    from optimism.core.fact_token_transfers
    where origin_to_address = '0x065e8a87b8f11aed6facf9447abe5e8c5d7502b6'
    and to_address not in ('0x0a0805082ea0fc8bfdcc6218a986efda6704efe5', '0xec1557a67d4980c948cd473075293204f4d280fd')
    group by TIME
    Run a query to Download Data