maybeyonasETH vs Poly fees
Updated 2022-11-28
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
27
28
29
30
31
32
›
⌄
with polyfees as(
select
date(block_timestamp) as date,
count(tx_id) as txs,
sum(gas_used) as gas,
sum(fee) as fees,
sum(fee_usd) as fees_usd
from polygon.transactions
group by date(block_timestamp)
),
ethfees as(
select
date(block_timestamp) as date,
count(tx_id) as txs,
sum(gas_used) as gas,
sum(tx_fee) as fees,
sum(fee_usd) as fees_usd
from ethereum.transactions
group by date(block_timestamp)
),
daily as(
select
e.date,
e.txs as e_txs, e.gas as e_gas, e.fees as e_fees, e.fees_usd as e_fees_usd,
p.txs as p_txs, p.gas as p_gas, p.fees as p_fees, p.fees_usd as p_fees_usd
from ethfees e join polyfees p
on e.date = p.date
)
select * from daily
where date >= date_from_parts(2021,6,1)
order by date desc
-- limit 100
Run a query to Download Data