mboveiriAverage deposit to BentoBox size per user in 2022 - %
Updated 2022-05-13
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
26
27
28
29
30
31
32
33
›
⌄
with ETH as (select
date_trunc('day',block_timestamp) as date,
origin_address as user_,
avg(AMOUNT_USD) as Amount
from ethereum.udm_events
where
to_address = lower('0xF5BCE5077908a1b7370B9ae04AdC565EBd643966')
and year(block_timestamp)='2022'
and ORIGIN_FUNCTION_SIGNATURE = '0x02b9446c' --Deposite function
and AMOUNT_USD is not NULL
and AMOUNT_USD > 50
group by 1,2
),
POLY as ( select
date_trunc('day',block_timestamp) as date,
origin_address as user_,
avg(AMOUNT_USD) as Amount
from polygon.udm_events
where
to_address = lower('0x0319000133d3ada02600f0875d2cf03d442c3367')
and year(block_timestamp)='2022'
and ORIGIN_FUNCTION_SIGNATURE = '0x02b9446c' --Deposite function
and AMOUNT_USD is not NULL
and AMOUNT_USD > 50
group by 1,2
)
select avg(amount),'Deposit in Ethereum' as network from ETH
union all
select avg(amount),'Deposit in Polygon' as network from POLY
Run a query to Download Data