cryptoshipDeposits across ETH based protocols
Updated 2024-09-06
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
›
⌄
select 'AAVE' AS TOKEN, extract(year from BLOCK_TIMESTAMP) AS YEAR, count(DISTINCT TX_HASH) AS NO_OF_DEPOSITS, SUM(SUPPLIED_USD) AS DEPOSIT_VALUE_USD, AVG(SUPPLIED_USD) AS AVG_DEPOSIT_USD
FROM ethereum.aave.ez_deposits
GROUP BY 2
UNION ALL
select 'BEACON' AS TOKEN, extract(year from BLOCK_TIMESTAMP) AS YEAR, count(DISTINCT TX_HASH) AS NO_OF_DEPOSITS, SUM(DEPOSIT_AMOUNT) AS DEPOSIT_VALUE_USD, AVG(DEPOSIT_AMOUNT) AS AVG_DEPOSIT_USD
FROM ethereum.beacon_chain.ez_deposits
GROUP BY 2
UNION ALL
select 'COMPOUND' AS TOKEN, extract(year from BLOCK_TIMESTAMP) AS YEAR, count(DISTINCT TX_HASH) AS NO_OF_DEPOSITS, SUM(SUPPLIED_BASE_ASSET_USD) AS DEPOSIT_VALUE_USD, AVG(SUPPLIED_BASE_ASSET_USD) AS AVG_DEPOSIT_USD
FROM ethereum.compound.ez_deposits
GROUP BY 2
UNION ALL
select 'MAKER' AS TOKEN, extract(year from BLOCK_TIMESTAMP) AS YEAR, count(DISTINCT TX_HASH) AS NO_OF_DEPOSITS, SUM(AMOUNT_DEPOSITED) AS DEPOSIT_VALUE_USD, AVG(AMOUNT_DEPOSITED) AS AVG_DEPOSIT_USD
FROM ethereum.maker.ez_deposits
GROUP BY 2
ORDER BY 1, 2
QueryRunArchived: QueryRun has been archived