rackhaelCopy of ERC-20 tokens sent to eth staking contract
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
--select
--substr(contract_address, 1, 5) as trimmed,
--count(1) as transactions
--from ethereum.core.ez_token_transfers
-- where to_address = lower('0x00000000219ab540356cBB839Cbe05303d7705Fa') -- beacon deposit contract
--group by contract_address
--qualify row_number() over (order by transactions desc ) <= 10
select
from_address,
count(1) as transactions
from ethereum.core.ez_token_transfers
where to_address = lower('0x00000000219ab540356cBB839Cbe05303d7705Fa') -- beacon deposit contract
group by from_address
qualify row_number() over (order by transactions desc ) <= 10
--select *
--from ethereum.core.ez_nft_transfers
where nft_to_address = lower('0x00000000219ab540356cBB839Cbe05303d7705Fa')
Run a query to Download Data