olavDeposit daily
Updated 2022-09-07
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
block_timestamp::date as date,
count(distinct(origin_from_address)) as address,
count(distinct(tx_hash)) as tx,
sum(amount) as amount_eth,
sum(amount_usd) as amount_usd
from ethereum.core.ez_token_transfers
where origin_to_address = lower('0x3B968D2D299B895A5Fcf3BBa7A64ad0F566e6F88')
and block_timestamp::date >= current_date - interval '{{ month_number }} months'
and origin_function_signature = '0x36118b52' --withdraw function signature
and symbol = 'WETH'
group by date
Run a query to Download Data