/*
Purpose: Grab the addresses that bought ALCX within the first 3 weeks after Alchemix launch (Feb 27)
*/
SELECT DISTINCT
LOWER(origin_address)
FROM ethereum.udm_events
WHERE
(
LOWER(from_address) = '0xc3f279090a47e80990fe3a9c30d24cb117ef91a8' -- sushiswap ALCX address - event_name = transfer
AND symbol = 'ALCX'
)
AND block_timestamp >= '2021-03-31T00:00:00Z'
-- AND block_timestamp <= '2021-03-20T00:00:00Z'
AND amount_usd > 0 --ALCX amount > 0
ORDER BY 1