AlexayOpensea fees
Updated 2022-08-12Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
--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