elsinaUntitled Query
Updated 2022-06-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select
date_trunc('day',block_timestamp) as "day",
sum(iff(ETH_TO_ADDRESS = lower('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419'),amount,0 )) as "daily Deposite Amount",
sum("daily Deposite Amount") over(order by "day") as "total deposit amount",
sum(iff(ETH_FROM_ADDRESS = lower('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419'),amount,0 )) as "daily Withdraw Amount",
sum("daily Withdraw Amount") over(order by "day") as "total withdraw amount",
sum(iff(ETH_TO_ADDRESS = lower('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419'),AMOUNT_USD,0 )) as "daily USD Deposite Amount",
sum("daily USD Deposite Amount") over(order by "day") as "total deposit amount as USD",
sum(iff(ETH_FROM_ADDRESS = lower('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419'),AMOUNT_USD,0 )) as "daily USD Withdraw Amount",
sum("daily USD Withdraw Amount") over(order by "day") as "total withdraw amount as USD"
from ethereum.core.ez_eth_transfers
where
ETH_TO_ADDRESS = lower('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419') or
ETH_FROM_ADDRESS = lower('0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419')
group by "day"
order by "day"
Run a query to Download Data