pimi1356-HdnUm3Opensea Fees
Updated 2022-07-31
9
1
2
3
4
5
6
7
8
9
›
⌄
select sum ( case when CONTRACT_ADDRESS='0x8f3cf7ad23cd3cadbd9735aff958023239c6a063' then RAW_AMOUNT/1e18 END) as "Dai Paid as fee to open-sea",
sum(case when CONTRACT_ADDRESS='0x7ceb23fd6bc0add59e62ac25578270cff1b9f619' then RAW_AMOUNT/1e18 END) as "Weth Paid as fee to open-sea",
sum( case when CONTRACT_ADDRESS='0x2791bca1f2de4661ed88a30c99a7a9449aa84174' then RAW_AMOUNT/1e6 END) as "USDC Paid as fee to open-sea" ,
sum(case when CONTRACT_ADDRESS='0x70c006878a5a50ed185ac4c87d837633923de296' then RAW_AMOUNT/1e18 END) as "Revv Paid as fee to open-sea"
from polygon.core.fact_token_transfers
where (TO_ADDRESS='0x8de9c5a032463c561423387a9648c5c7bcc5bc90'
Or TO_ADDRESS='0x5b3256965e7c3cf26e11fcaf296dfc8807c01073')
and FROM_ADDRESS='0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'
Run a query to Download Data