rahoThreshold DAO - Funding by Guild1
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 = lower('0x9F6e831c8F8939DC0C830C6e492e7cEf4f9C2F5f')
),
labels as (
select
*,
case
when to_address = lower('0x2ff7aB212cD6FEaE21bAc5300465E149FB6b85a9') then 'Integrations Guild'
when to_address = lower('0xd55c4261145EA1752662faA0485AfBC8C431b0CA') then 'Marketing Guild'
when to_address = lower('0x9F6e831c8F8939DC0C830C6e492e7cEf4f9C2F5f') then 'Threshold Council'
when to_address = lower('0x71E47a4429d35827e0312AA13162197C23287546') then 'Treasury Guild'
end as Guild
from
all_tx
)
select
Guild,
block_timestamp,
symbol,
amount,
token_price,
amount_usd as "Amount ($)",
Run a query to Download Data