WITH stackers AS (
SELECT TX_FROM_ADDRESS AS wallet, (EVENT_INPUTS:amount/pow(10,18)) AS AMOUNT
FROM ethereum.events_emitted
WHERE TX_TO_ADDRESS = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
AND BLOCK_TIMESTAMP::DATE BETWEEN '2022-04-04' AND '2022-04-08'
AND AMOUNT >= 1
)
SELECT COUNT (DISTINCT wallet) AS "Number of Wallets", 'Wallets Bought stETH' AS label FROM stackers
UNION
SELECT COUNT(DISTINCT USER_ADDRESS), 'Current Wallets' AS label FROM flipside_prod_db.ethereum.erc20_balances b
INNER JOIN stackers s ON USER_ADDRESS = wallet
WHERE CONTRACT_ADDRESS = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
AND balance_date::DATE = '2022-06-15'
AND BALANCE >= AMOUNT