CryptoLionALCX_buy_alltime
Updated 2021-11-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
⌄
/*
Purpose: Grab the addresses that bought ALCX within the first 3 weeks after Alchemix launch (Feb 27)
*/
SELECT
to_address,
from_address,
symbol,
event_name,
event_type,
amount_usd,
block_timestamp
FROM ethereum.udm_events
WHERE
(
LOWER(from_address) = '0xc3f279090a47e80990fe3a9c30d24cb117ef91a8' -- sushiswap ALCX address - event_name = transfer
AND symbol = 'ALCX'
)
-- AND block_timestamp >= '2021-02-27T00:00:00Z'
-- AND block_timestamp <= '2021-03-20T00:00:00Z'
AND amount_usd > 0 --ALCX amount > 0
Run a query to Download Data