Alexaylido total
Updated 2023-06-08Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT count(distinct tx_hash) as total_deposits,
sum(raw_amount / power(10, 18)) as total_eth_amount,
sum(amount_usd) as total_usd_amount,
count(distinct origin_from_address) as total_depositors,
total_deposits/ total_depositors as avg_deposits_per_user,
total_eth_amount/ total_depositors as avg_eth_staked_per_user
FROM ethereum.core.ez_token_transfers
WHERE contract_address = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
AND from_address = '0x0000000000000000000000000000000000000000'
Run a query to Download Data