Monitize AIPirate 1 copy copy copy
Updated 2024-10-21
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
›
⌄
select
TO_ADDRESS as users,
sum(amount) as claimed_amount,
sum(amount_usd) as claim_usd_amt
from ethereum.core.ez_token_transfers
where contract_address = lower('0xF944e35f95E819E752f3cCB5Faf40957d311e8c5')
and FROM_ADDRESS = lower('0x9a98e6b60784634ae273f2fb84519c7f1885aed2')
and ORIGIN_FUNCTION_SIGNATURE = '0x2e17de78'
group by 1
order by 2 desc
select
distinct CONTRACT_ADDRESS,
PLATFORM,
count(distinct tx_hash) as txs,
sum(AMOUNT_IN_USD) as amount
from base.defi.ez_dex_swaps
where (token_in = '0xc08cd26474722ce93f4d0c34d16201461c10aa8c' or token_out = '0xc08cd26474722ce93f4d0c34d16201461c10aa8c')
group by 1,2
SELECT
ADDRESS,
ADDRESS_NAME
from base.core.dim_labels
where LABEL_TYPE = 'cex'
QueryRunArchived: QueryRun has been archived