SELECT

CAST(block_timestamp AS DATE) Block_date

,origin_function_name

,symbol

,COUNT(DISTINCT from_address) Wallets

,SUM(amount * CASE origin_function_name WHEN 'deposit' THEN 1 ELSE -1 END) amount

,SUM(amount_usd * CASE origin_function_name WHEN 'deposit' THEN 1 ELSE -1 END) amount_usd

FROM ethereum.udm_events

WHERE event_type = 'erc20_transfer'

AND to_address = '0xab8e74017a8cc7c15ffccd726603790d26d7deca' --StakingPools Contract

AND block_timestamp >= getdate() - interval '1 month'

AND origin_function_name IN ('withdraw','deposit')

GROUP BY CAST(block_timestamp AS DATE), origin_function_name, symbol

SELECT Block_date

, origin_function_name

, symbol

, wallets

, amount

, amount_usd

FROM ActivityByDay