mucryptoBIT inflow
Updated 2023-05-27
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
›
⌄
with transaction as (
select
block_timestamp::date as day,
amount,
amount_usd,
from_address,
to_address,
tx_hash
from ethereum.core.ez_token_transfers
where to_address = '0x78605df79524164911c144801f41e9811b7db73d'
and contract_address = '0x1a4b46696b2bb4794eb3d4c26f1c55f9170fa4c5'),
labels as (
select
address,
address_name as sending_address
from ethereum.core.dim_labels)
select
day,
case when labels.sending_address = 'bitdao: bybit flexible' then 'BitDAO: Bybit flexible'
when labels.sending_address = 'bitdao: treasury 2' then 'BitDAO treasury 2'
when labels.sending_address = 'bitdao: bybit contribution' then 'Bybit: contribution'
when labels.sending_address is null then 'Unknown'
end as sender,
amount,
amount_usd,
tx_hash
from transaction
left outer join labels
on transaction.from_address=labels.address
order by amount desc
Run a query to Download Data