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