samtokens sent to eth staking contract
Updated 2022-12-07Copy Reference Fork
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