boomer77polygon eth fees
Updated 2021-09-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with eth as (select date_trunc('day', block_timestamp) as block_day, sum(fee_usd) as ethfees, avg(fee_usd) as Avg_eth, count (distinct tx_id) as Tx_count_eth
from ethereum.transactions
where success = 'TRUE' and block_day >= '2021-06-01'
group by 1),
polygon as (select date_trunc('day', block_timestamp) as block_day, sum(fee_usd) as polygonfees, avg(fee_usd) as avg_polygon, count (distinct tx_id) as Tx_count_Polygon
from polygon.transactions
where success = 'TRUE' and block_day >= '2021-06-01'
group by 1)
select a.block_day, a.ethfees, b.polygonfees, a.avg_eth, b.avg_polygon, a.tx_count_eth, b.tx_count_polygon
from eth a
join polygon b on a.block_day = b.block_day
order by 1 desc
Run a query to Download Data