0-MIDavg fee poly
Updated 2023-09-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with tab1 as (
select
TX_HASH
from polygon.core.ez_token_transfers
where ORIGIN_TO_ADDRESS='0x88dcdc47d2f83a99cf0000fdf667a468bb958a78'
and ORIGIN_FUNCTION_SIGNATURE in ('0xcdd1b25d','0xa5977fbb')
),
tab2 as (
select
TX_HASH
,TX_FEE
from polygon.core.fact_transactions)
select
avg(TX_FEE) as "TX FEE"
from tab1
left join tab2
on tab1.TX_HASH=tab2.TX_HASH
Run a query to Download Data