nsa2000ETH staking deposit
Updated 2022-10-02
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
date
, period
, amount
, depositor
, tx_count
, tx_count / depositor tx_per_depositor
from (
select
BLOCK_TIMESTAMP::date date
, case
when date < '2022-09-15' then 'Before'
when date > '2022-09-15' then 'After'
else 'The Merge'
end period
, sum(amount) amount
, count(distinct ORIGIN_FROM_ADDRESS) depositor
, count(tx_hash) tx_count
from ethereum.core.ez_eth_transfers
where 1=1
and ORIGIN_TO_ADDRESS = '0x00000000219ab540356cbb839cbe05303d7705fa'
and ETH_TO_ADDRESS = '0x00000000219ab540356cbb839cbe05303d7705fa'
and date between '2022-09-01' and '2022-10-05'
group by 1,2
)
Run a query to Download Data