mansaETH-OPTIMISM
Updated 2022-06-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
SELECT
date(block_timestamp) as dates,
count(distinct(ETH_FROM_ADDRESS )) as n_users,
sum (n_users) over (order by dates) as cum_n_users
from ethereum.core.ez_eth_transfers
where
-- tx_hash= '0xa7d433aa5191c0559d23c4f04c1411b8fdeb6359221a7108c6b8768e43da081b'
-- 0xb1a1a882
eth_TO_ADDRESS IN('0x99c9fc46f92e8a1c0dec1b1747d010903e884be1', '0x52ec2F3d7C5977A8E558C8D9C6000B615098E8fC')
and BLOCK_TIMESTAMP >= CURRENT_DATE - 60
group by dates
order by dates desc
Run a query to Download Data