freemartianOpenSea Fees On Polygon
Updated 2022-07-29
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select sum(event_inputs:value)/pow(10,18) as collected_fee,
date_trunc('day', block_timestamp::date) as TIME,
sum(collected_fee) over (order by TIME) as cumulative_fee
from polygon.core.fact_event_logs
where event_name = 'Transfer'
and event_inputs:to in ('0x5b3256965e7c3cf26e11fcaf296dfc8807c01073', '0x8de9c5a032463c561423387a9648c5c7bcc5bc90')
and event_inputs:from = '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'
and origin_to_address = '0xf715beb51ec8f63317d66f491e37e7bb048fcc2d'
group by TIME
order by sum(event_inputs:value)/pow(10,18) DESC
Run a query to Download Data