sinahosseinzadehUntitled Query
Updated 2022-08-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
'stake' as action, sum(AMOUNT_USD) as usd,date_trunc('day',block_timestamp) date
from ethereum.core.ez_token_transfers
where TO_ADDRESS = '0x4da27a545c0c5b758a6ba100e3a049001de870f5'
and ORIGIN_TO_ADDRESS = TO_ADDRESS and from_ADDRESS=lower('{{user}}')
group by 1,3
union
select
'unstaked' as action,
sum(AMOUNT_USD) as usd,
date_trunc('day',block_timestamp) date
from ethereum.core.ez_token_transfers
where FROM_ADDRESS = '0x4da27a545c0c5b758a6ba100e3a049001de870f5'
and ORIGIN_TO_ADDRESS = FROM_ADDRESS and to_address=lower('{{user}}')
group by 1,3
Run a query to Download Data