maybeyonasETH vs Poly fees
    Updated 2022-11-28
    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