mucryptoETH transfers from/to the treasury of BitDAO
Updated 2023-05-29
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 transaction_to as (
select
block_timestamp::date as day,
amount,
amount_usd,
eth_from_address,
tx_hash,
'Inflow' as category
from ethereum.core.ez_eth_transfers
where eth_to_address = '0x78605df79524164911c144801f41e9811b7db73d'), --BitDAO treasury
labels_to as (
select
address,
address_name as sending_address
from ethereum.core.dim_labels),
t_to_total as (
select
day,
case when labels_to.sending_address = 'bitdao: launch partner rewards 2' then 'To BitDAO: Launch partner rewards'
when labels_to.sending_address = 'bitdao: bybit contribution' then 'From Bybit: Contribution'
when labels_to.sending_address = 'tornadocash 0.1eth' then 'From Tornado Cash'
when labels_to.sending_address is null then 'From unknown address'
end as transfer,
amount,
amount_usd,
tx_hash,
category
from transaction_to
left join labels_to
on transaction_to.eth_from_address=labels_to.address
order by amount desc),
transaction_from as (
select