Monitize AIPirate 1 copy copy
Updated 2024-10-22
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
›
⌄
⌄
select
--date_trunc('day', BLOCK_TIMESTAMP) as dates,
distinct FROM_ADDRESS,
ORIGIN_FUNCTION_SIGNATURE,
min(BLOCK_TIMESTAMP::date) as mins,
count(distinct 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('0xc555D625828c4527d477e595fF1Dd5801B4a600e')
--and FROM_ADDRESS = lower('0x543ba3e063197b3025a4b2751e9b4b6a2489fa07')
--and ORIGIN_FUNCTION_SIGNATURE = '0x2e7ba6ef'
group by 1,2
order by 4 desc
/*where "from" = 0x554b49f1595e579ab0841e7a09a4a5654ab73578
and contract_address = 0xAcd2c239012D17BEB128B0944D49015104113650*/
QueryRunArchived: QueryRun has been archived