ValiMohammadiCount of stETH Transactions
Updated 2022-04-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with table_Seth as
(select date_trunc('day', block_timestamp) as day,
count(case when pool_name='stZEN-stETH SLP' then (pool_name) else null end) as stZEN_pool,
count(case when pool_name='stETH-WETH LP' then (pool_name) else null end) as WETH_pool,
-- count(case when pool_name='WETH-stETH SLP' then (pool_name) else null end) as WETH_pool,
count(case when pool_name='DAI-wstETH SLP' then (pool_name) else null end) as DAI_pool,
count(case when pool_name='ALPHA-stETH SLP' then (pool_name) else null end) as Alpha_pool
from ethereum_core.ez_dex_swaps
-- where symbol_in='stETH'
--where pool_name like '%stETH%'
group by 1
)
select * from table_Seth
Run a query to Download Data