date_trunc('month', e.block_timestamp) as date,

--sum(e.gas_price/1e9) as gas_price_gw,

--sum(e.gas_used),

sum(e.fee_usd) as gas_fee_paid,

sum(c.liquidation_amount_usd) as liquidation_total

from ethereum.transactions e join compound.liquidations c on (e.tx_id = c.tx_id)

where

e.tx_id in (select tx_id from compound.liquidations where block_timestamp > getdate() - interval'12 months')

group by 1

order by date