adambalaDistinct Wallets (Optimism Bridge)
Updated 2022-06-16
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT date(BLOCK_TIMESTAMP) as date,count(distinct TX_ID)as tx ,count(distinct ORIGIN_ADDRESS)as users ,'deposit'as title
FROM flipside_prod_db.ethereum.udm_events
where lower(to_address)=lower('0x99C9fc46f92E8a1c0deC1b1747d010903E884bE1') and EVENT_NAME='transfer'
and date>'2022-03-01' group by 1,4
UNION
SELECT date(BLOCK_TIMESTAMP) as date,count(distinct TX_ID)as tx ,count(distinct ORIGIN_ADDRESS)as users ,'withraw'as title
FROM flipside_prod_db.ethereum.udm_events
where lower(from_address)=lower('0x99C9fc46f92E8a1c0deC1b1747d010903E884bE1') and EVENT_NAME='transfer'
and date>'2022-03-01' group by 1,4
Run a query to Download Data