adambalaETH Deposited or Withdrawn
Updated 2022-06-27
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
34
35
36
›
⌄
with
withdraw as (
select TX_HASH
from ethereum.core.fact_event_logs
where lower(CONTRACT_ADDRESS) = lower('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419') and ORIGIN_FUNCTION_SIGNATURE = '0x00f714ce'
and block_timestamp::date >CURRENT_DATE -80),
total_withdraw as
(
select
date_trunc('day',BLOCK_TIMESTAMP) as date ,'withdraw 'as flag ,
sum (amount_usd) as amount_USD,count (distinct origin_from_address) as address ,
sum (amount) as amount_ETH
from ethereum.core.ez_eth_transfers et inner join withdraw
ON et.TX_HASH = withdraw.TX_HASH
group by 1,2)
,
deposit as (
select TX_HASH
from ethereum.core.fact_event_logs
where lower(CONTRACT_ADDRESS) = lower('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419') and ORIGIN_FUNCTION_SIGNATURE = '0xb6b55f25'
and block_timestamp::date >CURRENT_DATE -80),
total_deposit as
(
select
date_trunc('day',BLOCK_TIMESTAMP) as date ,'deposit 'as flag ,
sum (amount_usd) as amount_USD,count (distinct origin_from_address) as address ,
sum (amount) as amount_ETH
from ethereum.core.ez_eth_transfers et join deposit
ON et.TX_HASH = deposit.TX_HASH
group by 1,2)
select * from total_withdraw
union
select * from total_deposit
Run a query to Download Data