nsa2000evm11
    Updated 2023-01-14
    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