AlexayOpensea fees
    Updated 2022-08-12
    --0xf715beb51ec8f63317d66f491e37e7bb048fcc2d nft opensea main contract
    --0x2953399124f0cbb46d2cbacd8a89cf0599974963 dapp opensea openstore token
    -- 0x00000000006cee72100d161c57ada5bb2be1ca79 dapp opensea: seaport
    -- 0x5b3256965e7c3cf26e11fcaf296dfc8807c01073 dapp opensea wallet
    -- 0x8de9c5a032463c561423387a9648c5c7bcc5bc90 2.5%
    select count(tx_hash) as sales, CASE WHEN contract_address='0x2791bca1f2de4661ed88a30c99a7a9449aa84174' THEN sum(raw_amount)/pow(10,6)
    ELSE sum(raw_amount)/pow(10,18) END as volume,
    contract_address,
    --token value
    CASE WHEN contract_address='0x7ceb23fd6bc0add59e62ac25578270cff1b9f619' THEN 'WETH'
    WHEN contract_address='0x2791bca1f2de4661ed88a30c99a7a9449aa84174' THEN 'USDC'
    WHEN contract_address='0x70c006878a5a50ed185ac4c87d837633923de296' THEN 'REVV'
    WHEN contract_address='0x8f3cf7ad23cd3cadbd9735aff958023239c6a063' THEN 'DAI' END as token,
    -- usd value
    CASE WHEN token = 'REVV' THEN volume*{{revv_price}}
    WHEN token = 'WETH' THEN volume*{{weth_price}}
    ELSE volume END as vol_usd,
    vol_usd/sales as mean_usd_fee_per_txn
    from polygon.core.fact_token_transfers
    where from_address = '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d' -- opensea main contract
    and (to_address = '0x5b3256965e7c3cf26e11fcaf296dfc8807c01073' or to_address = '0x8de9c5a032463c561423387a9648c5c7bcc5bc90' )
    --and block_timestamp >= CURRENT_DATE - 30
    group by contract_address

    Run a query to Download Data