0xaimannumber of user in stETH pool
Updated 2021-10-10
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select date_trunc('day', balance_date) as date, count(user_address) --event_name, count(tx_id) --date_trunc('day',block_timestamp) as date ,sum(aMOUNT_in) as amnt_in, sum(amount_out) as amnt_out
from ethereum.erc20_balances
-- where symbol ='stETH' and event_name ='AddLiquidity'
--where contract_address='0xdc24316b9ae028f1497c275eb9192a3ea0f67022' --and event_name = 'Addliquidity' --'RampA' 'RemoveLiquidityOne'
where symbol = 'stETH' and date > '2021-09-01'
group by date order by date
-- where platform = 'curve' and pool_name ='stETH' -- and date > '2021-09-01'
limit 200
Run a query to Download Data