rahoCryptex DAO - Funding by __
Updated 2023-01-26
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 = '0xa70b638b70154edfcbb8dbbbd04900f328f32c35'
),
labels as (
select
*,
case when to_address = '0xe7636c7ef670a3bcf772d9d57244c9e88ad90437' then 'Writers Guild'
when to_address = '0x31016ffcebff16c20e74a8610f1650dcb5c01df3' then 'Treasury Guild'
when to_address = '0x045a805c83c1d4c9e5a0bdcc5a27efa73d2a3c0b' then 'Translator Guild'
when to_address = '0x2b00fdf9aadafee22cf56eb59ba367f6acd0ce10' then 'Research Guild'
when to_address = '0xc7c712e02b3d99564ae830cec33e5c3ef45d0c8e' then 'Project Management Guild'
when to_address = '0x47f238ef7f6b9e4f8452d77228b101f7c0419733' then 'Operations Guild'
when to_address = '0xe5a64fc0d3396d11eb63d728791577e254ac18ca' then 'Marketing Guild'
when to_address = '0x984ec14dc726b75ca3eb6a94c64d165d37ea823e' then 'Legal Guild'
when to_address = '0xcf8422021b408b32983b525778ce45420715f094' then 'Educational Guild'
when to_address = '0x623a12ca60d378705fd170a47b6d32c74367501d' then 'Developer Guild'
when to_address = '0x8a771e2874b1e8a38cb08ebcb6e1058d27fa64c0' then 'Design Guild'
when to_address = '0xb40f4ce59da4a0b6d10ae605e10fd4e6ca9ed4ae' then 'DAOlationships Guild'
when to_address = '0xe2d721c126150beee3c56a1ad71a2e0e29a411f0' then 'Audio/Visual Guild'
when to_address = '0x28861eeec6ab073a36cc299ef8186978893e21ff' then 'Analytics Guild'
end as Guild
from all_tx
)
Run a query to Download Data