barbodETH
Updated 2022-06-15
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
›
⌄
with st as (SELECT
date_trunc(day,block_timestamp) as day1,
SUM(amount) as amt1
--sum(AMOUNT_USD) as amt_usd_1
FROM ethereum.udm_events
WHERE block_timestamp > CURRENT_DATE - 95 and block_timestamp < CURRENT_DATE - 5
AND to_address = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
and origin_function_signature IN ('0xa1903eab', '0xa9059cbb') and EVENT_NAME = 'transfer'
GROUP BY 1
ORDER BY 1 DESC),
unst as (SELECT
date_trunc(day,block_timestamp) as day2,
SUM(amount) as amt2
--sum(AMOUNT_USD) as amt_usd_2
FROM ethereum.udm_events
WHERE block_timestamp > CURRENT_DATE - 95 and block_timestamp < CURRENT_DATE - 5 and from_address = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
and EVENT_NAME = 'transfer'
GROUP BY 1
ORDER BY 1 DESC)
select
st.day1 as day,
st.amt1 as staked_ETH,
unst.amt2 as unstaked_eth
from st , unst where day1 = day2
order by 1
Run a query to Download Data