Abbas_ra21Lido market impact 2
Updated 2023-05-21
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 tb AS (select
Date_trunc('Hour',BLOCK_TIMESTAMP) AS Hour,
sum(Amount) AS "Amount $stETH"
from ethereum.core.ez_token_transfers
where
TO_ADDRESS=lower('0x889edC2eDab5f40e902b864aD4d7AdE8E412F9B1')
and CONTRACT_ADDRESS = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
group by 1 ),
tb2 AS (
select
Date_trunc('Hour',BLOCK_TIMESTAMP) AS Hour,
'Buy' AS Action,
sum(AMOUNT_IN_USD) AS "Buy Volume (USD)",
count(DISTINCT ORIGIN_FROM_ADDRESS) AS "Buyers Number"
from ethereum.core.ez_dex_swaps where TOKEN_IN=lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
group by 1
),
tb3 AS (
select
Date_trunc('Hour',BLOCK_TIMESTAMP) AS Hour,
'Sell' AS Action,
-sum(AMOUNT_IN_USD) AS "Sell Volume (USD)",
count(DISTINCT ORIGIN_FROM_ADDRESS) AS "Sellers Number"
from ethereum.core.ez_dex_swaps where TOKEN_Out=lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
group by 1
)
select
tb.Hour,
"Amount $stETH",
"Buy Volume (USD)",
"Sell Volume (USD)",
"Buyers Number",
"Sellers Number"
from tb inner join tb2 on tb.Hour=tb2.Hour
inner join tb3 on tb.Hour=tb3.Hour
Run a query to Download Data