rahoPoolTogether DAO - Funding by Team
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with all_tx as (
select
block_timestamp,
from_address,
to_address,
symbol,
amount,
amount_usd,
token_price,
contract_address,
tx_hash
from ethereum.core.ez_token_transfers
where from_address = '0x42cd8312d2bce04277dd5161832460e95b24262e'
),
labels as (
select
*,
case when to_address = lower('0xF69898B40F0908537a9e93b9f5368C8cf19a23a7') then 'Community Team'
when to_address = lower('0x3927E0642C432A934a4EAA64C79bC8a1D8ac5Fb7') then 'PT Inc. - Protocol Team'
when to_address = lower('0xB74659A1011F6DCA3BA6F6e22a71bA8f414F36A1') then 'Finance Team'
when to_address = lower('0xDa63D70332139E6A8eCA7513f4b6E2E0Dc93b693') then 'Executive Team'
when to_address = lower('0xd5b043Fb903f92b67a9985B771a34E1E9Fd63b3a') then 'Growth Team'
when to_address = lower('0xd605bB8A3DA1f7f777276D3c97c828aAc3Dd4252') then 'Grants Team'
when to_address = lower('0x973Cb5837BFA09F187a148c39b44c9509c55B449') then 'Education Team'
when to_address = lower('0x522CEA7e255BA732a8c514534Bba510eD7B8cB49') then 'Language Advocates Team'
end as Team
from all_tx
)
select
Team,
block_timestamp,
symbol,
amount,
Run a query to Download Data