CryptoLionNew Adopters
Updated 2021-11-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
⌄
/*
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