flipside

    OpenSea fee second method
    freemartianOpenSea fee second method
    Updated 2022-07-30
    select sum(raw_amount)/pow(10,18)*0.025 as fee, date_trunc('day', block_timestamp::date) as TIME
    from polygon.core.fact_token_transfers
    where contract_address = '0x7ceb23fd6bc0add59e62ac25578270cff1b9f619'
    and origin_to_address = '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'
    and from_address != '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'
    and to_address != '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'
    group by TIME
    Run a query to Download Data