CryptoIcicleERC20 Tokens (zkSync)
Updated 2022-06-14
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
26
›
⌄
-- Payout 0.04 ETH
-- Grand Prize 0.12 ETH
-- Level Intermediate
-- Q2. ZkSync is a scaling solution for Ethereum that is live on mainnet.
-- Some of the main features of ZkSync are the extremely low transaction fees and trustless protocol design. You can read more about ZkSync here.
-- Users can also deposit ERC20 tokens into ZkSync.
-- Which ERC20 tokens have been deposited the most (in $ volume and total count) in the last 60 days? Visualize and explain both findings.
with txns as (
select
l.address_name as token,
*
from ethereum.core.ez_token_transfers t
join ethereum.core.dim_labels l on t.contract_address = l.address
where to_address = '0xabea9132b05a70803a4e85094fd0e1800777fbef' --zkSync
and block_timestamp >= CURRENT_DATE - 60
)
select
block_timestamp::date as date,
token,
count(distinct tx_hash) as n_deposits,
sum(amount_usd) as amount_deposited
from txns
group by date, token
Run a query to Download Data