CryptoLiongasfees for deposits - <3
Updated 2021-11-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
date_trunc('week',compound.deposits.block_timestamp) as week,
supplier,
concat(to_char(count(distinct supplied_symbol)),'x asset(s)') as num_assets,
avg(gas_price) as gas,
listagg(DISTINCT supplied_symbol,',') as assets,
count(ethereum.transactions.tx_id) as num_transactions,
avg(fee_usd) as fee
FROM compound.deposits
INNER JOIN ethereum.transactions on compound.deposits.tx_id = ethereum.transactions.tx_id
WHERE ethereum.transactions.block_timestamp >= getdate() - interval '2 months'
AND compound.deposits.block_timestamp >= getdate() - interval '2 months'
GROUP BY week, supplier
ORDER BY week
Run a query to Download Data