nsa2000evm11
Updated 2023-01-14Copy Reference Fork
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
›
⌄
select
date
, period
, amount
, depositor
, tx_count
, tx_count / depositor tx_per_depositor
from (
select
BLOCK_TIMESTAMP::date date
, case
when date < '2023-01-01' then 'Before'
when date >= '2023-01-01' then 'After'
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-12-17' and '2023-01-13'
group by 1,2
)
Run a query to Download Data